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 |