Table Detail Report

AP_SYS_CORR_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Selected Correlation Parameters
Definition: This reference table includes the trigger and lookback parameters established for system selected correlation events.
Table Type: REFERENCE





Column Detail - AP_SYS_CORR_DETAIL


Column Name Type Null? Definition
LOOKBACK_IND DOUBLE N This indicator field is used to determine whether this parameter is a look back parameter or a trigger parameter.
PARAM_NAME VARCHAR(20) N This field contains the name of system correlation parameter.
PARAM_SEQUENCE DOUBLE N This field in used in conjunction with the PARAM_NAME column in order to identify a single correlation parameter.
PARENT_ENTITY_ID DOUBLE N This field contains the internal identification code of the parameter. For example, if the PARAM_NAME is SPECIMEN then the PARENT_ENTITY_NAME would be CODE_VALUE and the PARENT_ENTITY_ID column would contain a code value from the specimen code set.
PARENT_ENTITY_NAME VARCHAR(32) N This field indicates the name of table to which the PARENT_ENTITY_ID value is from.
SYS_CORR_DETAIL_ID DOUBLE N This field contains the internal identification code that uniquely identifies a row on this table.
SYS_CORR_ID DOUBLE N This field contains the internal identification code to the AP_SYS_CORR 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_SYS_CORR_DETAIL


Child Column in AP_SYS_CORR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: SYS_CORR_ID AP_SYS_CORR SYS_CORR_ID


AP_TAG



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Tag
Definition: This reference table contains the individual specimen, block/cassette, and slide identification scheme values. For example, the values 1, 2, and 3 would be included on this table if a numeric scheme has been defined for association with a prefix.
Table Type: REFERENCE





Column Detail - AP_TAG


Column Name Type Null? Definition
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.
TAG_DISP CHAR(7) Y This field contains the tag display value. The display name is the value presented to the user viewing or ordering processing tasks. Tag display values of 1, 2, 3, etc., would be included (as separate tag values) for a numeric ID scheme.
TAG_GROUP_ID DOUBLE N This field contains the foreign key value (representing the identification scheme) that is associated with the individual tag value. Identification schemes are defined on the AP_TAG_GROUP reference table.
TAG_ID DOUBLE N This field uniquely defines a row (a single tag identification code value) in the AP_TAG table.
TAG_SEQUENCE DOUBLE Y This field contains the tag display sequence. The display sequence is used to organize the various tags associated with a single scheme. For example, the display sequence would dictate that 1 displays before 2 in a numeric scheme.
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_TAG


Child Column in AP_TAG(FK) Parent Table Name Parent Column Name
Parents: TAG_GROUP_ID AP_TAG_GROUP TAG_GROUP_ID




Parent Column in AP_TAG (PK) Child Table Name Child Column Name
Children: TAG_ID CASE_SPECIMEN SPECIMEN_TAG_ID
CASSETTE CASSETTE_TAG_ID
SLIDE TAG_ID


AP_TAG_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Tag Group
Definition: This reference table contains the various identification code schemes (the consolidation of multiple tag values) that have been defined for association with a prefix. Examples of schemes might include numeric, alphabetic, and Roman numerals.
Table Type: REFERENCE





Column Detail - AP_TAG_GROUP


Column Name Type Null? Definition
TAG_DESC VARCHAR(50) Y This field contains the description associated with the identification scheme.
TAG_GROUP_ID DOUBLE N This field uniquely identifies the row (the identification scheme) included on the AP_TAG_GROUP table. This field would be used to join to other tables (as a foreign key) such as the AP_TAG 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_TAG_GROUP




Parent Column in AP_TAG_GROUP (PK) Child Table Name Child Column Name
Children: TAG_GROUP_ID AP_PREFIX_TAG_GROUP_R TAG_GROUP_ID
AP_TAG TAG_GROUP_ID


AP_TASK_ASSAY_ADDL



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Task Assay Additional Info
Definition: This reference table contains parameters defined for pathology processing tasks that relate to inventory (specimen, cassette, and/or slide) and identification code associations (the identification codes to prompt for when the task is ordered).
Table Type: REFERENCE





Column Detail - AP_TASK_ASSAY_ADDL


Column Name Type Null? Definition
AUTOVERIFY_WORKFLOW_CD DOUBLE N Contains the value representing the workflow step for auto verification should be.
CREATE_INVENTORY_FLAG DOUBLE Y This field contains a numeric flag value indicating whether or not the completion of the associated processing task (discrete task) causes one or more pathology inventory records to be created.
DATE_OF_SERVICE_CD DOUBLE N This column defines the date of service value(case collection date, current date, case received date, charge task order date) for ap billing tasks.
HALF_SLIDE_IND DOUBLE Y This field contains a flag value indicating whether or not slides created from the associated processing task (discrete task) are considered half slide or full slide for the purposes of calculating cytology screening slide counts.
PRINT_LABEL_IND DOUBLE Y This field contains a flag value indicating whether or not the associated processing task (discrete task) should cause a slide label to print if the task qualifies for selection parameters entered by the user in the label print application.
PRINT_WORKLIST_IND DOUBLE Y This field contains a flag value indicating whether or not the associated processing task (discrete task) should cause an entry to be included on a worklist if the task qualifies for selection parameters entered by the user in the worklist application.
SLIDE_ORIGIN_FLAG DOUBLE Y This field contains a numeric flag value indicating whether a task that creates slide inventory represents a slide created directly from a specimen, or a slide created from a block.
STAIN_IND DOUBLE Y This field contains a flag value indicating whether or not the processing task is associated with the creation of a stained slide (or the staining of a previously-created slide).
TASK_ASSAY_CD DOUBLE N This field contains the reference to the processing task (discrete task) for which inventory and identification associations have been established on the AP_TASK_ASSAY_ADDL reference table.
TASK_ASSAY_TYPE_CD DOUBLE Y Defines the Category Type of the Processing Task. Ex: Special Stain, IHC Stain.
TASK_TYPE_FLAG DOUBLE Y This field contains a numeric flag value documenting the most specific level of inventory association that is associated with the processing task identified in the TASK_ASSAY_CD field.
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.



Relationship Detail - AP_TASK_ASSAY_ADDL


Child Column in AP_TASK_ASSAY_ADDL(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


AP_TRANS_STAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP TRANS STAT
Definition: This activity table contains entries for all transcription events if a site chooses to record transcription activity. This captures the number of characters and words that are added to a report in each transcription event.
Table Type: ACTIVITY





Column Detail - AP_TRANS_STAT


Column Name Type Null? Definition
AP_TRANS_STAT_ID DOUBLE N This field uniquely defines a row included on the AP_TRANS_STAT table. This field represents a specific transcription event.
CASE_TYPE_CD DOUBLE N This field contains the case type code value associated with the transcription event.
NBR_CHARACTERS DOUBLE Y This field contains the total number of additional characters that were added during this transcription event.
NBR_WORDS DOUBLE Y This field contains the total number of additional words that were added during this transcription event.
PATHOLOGIST_ID DOUBLE N This field contains the id of the responsible pathologist for the case corresponding to this transcription event.
REPORT_ID DOUBLE N This field identifies the unique report to which this transcription event is associated.
TRANSCRIBED_DT_TM DATETIME Y The field contains the date and time at which this transcription event occurred.
TRANSCRIPTIONIST_ID DOUBLE N This field contains the unique id of the individual who transcribed this particular transcription event.
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_TRANS_STAT


Child Column in AP_TRANS_STAT(FK) Parent Table Name Parent Column Name
Parents: REPORT_ID CASE_REPORT REPORT_ID
PATHOLOGIST_ID PRSNL PERSON_ID
TRANSCRIPTIONIST_ID PRSNL PERSON_ID