Table Detail Report
AP_PREFIX
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Prefix |
Definition: | This reference table contains the basic parameters for pathology case prefixes. A prefix is a required component of every pathology case number, and is sequenced immediately following the accession site code value. |
Table Type: | REFERENCE |
Column Detail - AP_PREFIX
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_FORMAT_CD | DOUBLE | N | This field contains the reference to the general (common) parameters associated with the prefix value. |
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
CASE_TYPE_CD | DOUBLE | N | This field contains a flag value documenting the generic categorization of case type (surgical pathology, gyn cytology, non-gyn cytology, autopsy, for example) that is associated with the case prefix value. |
CONSULT_IND | DOUBLE | Y | This field is not used at this time. |
DEFAULT_PROC_CATALOG_CD | DOUBLE | N | This field contains a reference to the order catalog or processing group item that has been designated as the default processing task for the case prefix value. |
DIAG_CODING_VOCABULARY_CD | DOUBLE | N | This field contains the internal code representing the diagnostic coding vocabulary assigned to the pathology accession prefix. One prefix can be associated with only one vocabulary (such as SNOMED International). |
GROSS_TASK_ASSAY_CD | DOUBLE | N | This field is not used at this time. |
GROUP_ID | DOUBLE | N | This field contains the accession group code value that is associated with the case prefix value. The group represents a set of available case numbers. One or more prefixes may be associated with a single group value. |
IMAGING_INTERFACE_IND | DOUBLE | N | This field indicates whether a case will be interfaced to a foreign Imaging system. |
IMAGING_SERVICE_RESOURCE_CD | DOUBLE | N | The service resource code used to interface to an imaging system. |
INITIATE_PROTOCOL_IND | DOUBLE | Y | This field contains a flag value indicating whether or not default processing tasks (based on prefix, specimen, and/or pathologist) should be automatically ordered upon case initiation, or should be defaulted in the task order entry application. |
INTERFACE_FLAG | DOUBLE | N | This field indicates whether a case will be interfaced to a foreign tracking system. 0 - Not interfaced; 1 - Interfaced to Tracking System |
ORDER_CATALOG_CD | DOUBLE | N | This field contains a reference to the order catalog item that has been designated as the prefix order catalog item. This item is automatically ordered once for each specimen received for the case. |
PREFIX_DESC | VARCHAR(40) | Y | This field contains the description of the prefix value. |
PREFIX_ID | DOUBLE | N | This field uniquely defines a row included on the AP_PREFIX table (the prefix). This field would be used to join to other tables, such as the PREFIX_REPORT_R and AP_PREFIX_AUTO_TASK reference tables. |
PREFIX_NAME | CHAR(2) | Y | This field contains the short name (mnemonic) representing the prefix value. |
SERVICE_RESOURCE_CD | DOUBLE | N | The default service resource associated to the prefix. |
SITE_CD | DOUBLE | N | This field contains the foreign key value used to identify the site code value associated with the prefix value. |
SPECIMEN_GROUPING_CD | DOUBLE | N | This field contains the reference to the specimen grouping associated with the prefix value (if present). Specimen groupings are defined on codeset 1312, and the specimens associated with the grouping are stored on the SPECIMEN_GROUPING_R table. |
TRACKING_SERVICE_RESOURCE_CD | DOUBLE | N | The service resource code used to interface to a tracking system |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
WORKSHEET_TEMPLATE_ID | DOUBLE | N | This field contains the internal identification code of the cytology screening worksheet template associated with the accession prefix. This value could be used to join to the WP_TEMPLATE table. |
Relationship Detail - AP_PREFIX
Child Column in AP_PREFIX(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCESSION_FORMAT_CD | ACCESSION_ASSIGN_XREF | ACCESSION_FORMAT_CD |
SITE_CD | ACCESSION_ASSIGN_XREF | SITE_PREFIX_CD | |
ORDER_CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
GROUP_ID | PREFIX_GROUP | GROUP_ID | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD | |
WORKSHEET_TEMPLATE_ID | WP_TEMPLATE | TEMPLATE_ID |
Parent Column in AP_PREFIX (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PREFIX_ID | AP_DIAG_RPT_REVIEW | PREFIX_ID |
AP_INV_RETENTION | PREFIX_ID | ||
AP_PREFIX_ACCN_TEMPLATE_R | PREFIX_ID | ||
AP_PREFIX_AUTO_TASK | PREFIX_ID | ||
AP_PREFIX_DIAG_AXIS | PREFIX_ID | ||
AP_PREFIX_DIAG_SMRY | PREFIX_ID | ||
AP_PREFIX_PROC_GRP_R | PREFIX_ID | ||
AP_PREFIX_STATION_R | PREFIX_ID | ||
AP_PREFIX_TAG_GROUP_R | PREFIX_ID | ||
AP_PREFIX_TASK_R | PREFIX_ID | ||
AP_SYNOPTIC_SPEC_PREFIX_R | PREFIX_ID | ||
PREFIX_REPORT_R | PREFIX_ID | ||
PREFIX_RPT_FONT_INFO | PREFIX_ID |
AP_PREFIX_ACCN_TEMPLATE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Prefix Accessioning Tempate Resolution table |
Definition: | This reference tables contains valid 'accessioning_templates' for a given prefix. |
Table Type: | REFERENCE |
Column Detail - AP_PREFIX_ACCN_TEMPLATE_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DEFAULT_IND | DOUBLE | Y | This field is used to define the 'default' accessioning template for a prefix. |
PREFIX_ID | DOUBLE | N | This field contains the reference to the prefix to which the accessioning template is associated. This field contains the foreign key value used to join to the prefix information stored on the AP_PREFIX table. |
TEMPLATE_CD | DOUBLE | N | This field contains the foreign key value (representing the accessioning template associated with the prefix) used to join to the accessioning template information stored on code_set 16689. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AP_PREFIX_ACCN_TEMPLATE_R
Child Column in AP_PREFIX_ACCN_TEMPLATE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREFIX_ID | AP_PREFIX | PREFIX_ID |
AP_PREFIX_AUTO_TASK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Prefix Auto Task |
Definition: | This reference table contains the report order catalog items that will automatically be ordered when a case is initiated. The relationship between the report order catalog items and cases is at the case prefix level. |
Table Type: | REFERENCE |
Column Detail - AP_PREFIX_AUTO_TASK
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | This field contains the reference to the order catalog report procedures that are automatically ordered when a case associated with the prefix is accessioned. |
PREFIX_ID | DOUBLE | N | This field contains the reference to the prefix value to which the auto order order catalog report procedures are associated. This field contains the foreign key value used to join to the prefix information stored on the AP_PREFIX reference table. |
SPECIMEN_IND | DOUBLE | Y | This field is not used at this time. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AP_PREFIX_AUTO_TASK
Child Column in AP_PREFIX_AUTO_TASK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREFIX_ID | AP_PREFIX | PREFIX_ID |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
AP_PREFIX_DIAG_AXIS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AP Prefix Diagnostic Axis |
Definition: | This reference table lists all of the nomenclature axes which have been designated to be "excluded" from the automatic diagnostic coding process. If no axes are excluded for a prefix, no record will be present on this table. |
Table Type: | REFERENCE |
Column Detail - AP_PREFIX_DIAG_AXIS
Column Name | Type | Null? | Definition |
---|---|---|---|
EXCLUDE_AXIS_CD | DOUBLE | N | This field contains the internal identification code representing a nomenclature axis to be excluded from the automatic diagnostic coding process. Nomenclature axes are stored on code_set 15849. |
PREFIX_ID | DOUBLE | N | This field contains the internal identification code representing the pathology case prefix to which the excluded axes are specified. Information about the prefix can be obtained by viewing or joining to the AP_PREFIX reference table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AP_PREFIX_DIAG_AXIS
Child Column in AP_PREFIX_DIAG_AXIS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREFIX_ID | AP_PREFIX | PREFIX_ID |
AP_PREFIX_DIAG_SMRY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Anatomic Pathology Prefix Diagnosis Summary |
Definition: | Contains a record which stores diagnosis summary information of an AP Prefix. Diagnosis summary is used for non cytology cases only and will allow the user to enter in a description within an alpha response or free text comment. |
Table Type: | REFERENCE |
Column Detail - AP_PREFIX_DIAG_SMRY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
COMMENT_IND | DOUBLE | N | This field contains an indicator documenting whether to allow a free text comment for the summary or not. |
COMMENT_LENGTH_QTY | DOUBLE | N | This field contains the maximum length or characters the free text field will hold. |
PREFIX_DIAG_SMRY_ID | DOUBLE | N | Uniquely identifies diagnosis summary information for an AP Prefix. |
PREFIX_ID | DOUBLE | N | Uniquely identifies the row in the AP_PREFIX table related to this summary record. |
REQUIRED_IND | DOUBLE | N | This field contains an indicator documenting whether the summary report component procedure is required or optional. |
TASK_ASSAY_CD | DOUBLE | N | Uniquely identifies the specific discrete task assay related to this summary record. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - AP_PREFIX_DIAG_SMRY
Child Column in AP_PREFIX_DIAG_SMRY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PREFIX_ID | AP_PREFIX | PREFIX_ID |
TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |