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