Table Detail Report

TAG_FOUNDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tag Foundation
Definition: This reference table contains Cerner-provided starter data that can be used to create identification schemes which can be associated with specimen, block/cassette, and slides. This starter table contains individual identification code values.
Table Type: REFERENCE





Column Detail - TAG_FOUNDATION


Column Name Type Null? Definition
TAG_DISPLAY CHAR(7) Y This field contains the individual tag display value. For example, individual tag values associated with a numeric grouping might include 1, 2 and 3.
TAG_GROUP_ID DOUBLE N This field contains the foreign key value (representing the tag grouping) used to join to information stored on the TAG_GROUP_FOUNDATION reference table.
TAG_SEQUENCE DOUBLE N This field contains a sequence documenting the individual tag value's location in the group scheme. The tag associated with the lowest sequence number displays first; the tag with the highest sequence number displays last.
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 - TAG_FOUNDATION


Child Column in TAG_FOUNDATION(FK) Parent Table Name Parent Column Name
Parents: TAG_GROUP_ID TAG_GROUP_FOUNDATION TAG_GROUP_ID


TAG_GROUP_FOUNDATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tag Group Foundation
Definition: This reference table contains Cerner-provided starter data that can be used to create identification schemes which can be associated with specimen, block/cassette, and slides. This starter table contains schemes -- groupings of tag values.
Table Type: REFERENCE





Column Detail - TAG_GROUP_FOUNDATION


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y This field contains the description of the tag grouping.
TAG_GROUP_ID DOUBLE N This field uniquely identifies a row included on the TAG_GROUP_FOUNDATION table. This value could be used to join to other tables, such as the TAG_FOUNDATION 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 - TAG_GROUP_FOUNDATION




Parent Column in TAG_GROUP_FOUNDATION (PK) Child Table Name Child Column Name
Children: TAG_GROUP_ID TAG_FOUNDATION TAG_GROUP_ID


TASK_INSTRMT_PROTCL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Task Instrument Protocol Relation
Definition: Stores the staining protocols performed on an instrument for processing a task order.
Table Type: ACTIVITY





Column Detail - TASK_INSTRMT_PROTCL_R


Column Name Type Null? Definition
INSTRUMENT_PROTOCOL_ID DOUBLE N Uniquely identifies the instrument protocol for this relationship.
PROCESSING_TASK_ID DOUBLE N Uniquely identifies the processing task related to this relationship.
STATUS_FLAG DOUBLE N The status of the sending protocol to instrument: 0 - Pending; 1 - Sent
TASK_INSTRMT_PROTCL_R_ID DOUBLE N Uniquely identifies a relationship between the instrument protocol and the processing task.
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 - TASK_INSTRMT_PROTCL_R


Child Column in TASK_INSTRMT_PROTCL_R(FK) Parent Table Name Parent Column Name
Parents: INSTRUMENT_PROTOCOL_ID INSTRUMENT_PROTOCOL INSTRUMENT_PROTOCOL_ID
PROCESSING_TASK_ID PROCESSING_TASK PROCESSING_TASK_ID


WP_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Word Processing Template
Definition: This reference table contains parameters associated with word processing templates. The template name, description, active/inactive indicator, template type (template versus letter, for example), activity type, and person ID are included.
Table Type: REFERENCE





Column Detail - WP_TEMPLATE


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.
ACTIVITY_TYPE_CD DOUBLE N This field contains the internal identification code associated with the activity type value for which the template was created. Activity types are stored on codeset 106.
DESCRIPTION VARCHAR(60) Y This field contains the description of the word processing template.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RESULT_LAYOUT_EXISTS_IND DOUBLE N Indicates whether the result layout exists.
SHORT_DESC VARCHAR(25) Y This field contains the short description (mnemonic) of the word processing template.
TEMPLATE_ID DOUBLE N This field uniquely defines a row (a word processing template) included on the WP_TEMPLATE table. This field would be used to join to other tables (as a foreign key) such as the WP_TEMPLATE_TEXT reference table.
TEMPLATE_TYPE_CD DOUBLE N This field contains the internal identification code associated with the template type. Template types include options such as templates and letters, for example. Template type parameters are stored on codeset 1303.
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 - WP_TEMPLATE


Child Column in WP_TEMPLATE(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID




Parent Column in WP_TEMPLATE (PK) Child Table Name Child Column Name
Children: TEMPLATE_ID AP_FT_TYPE DOCTOR_FINAL_TEMPLATE_ID
AP_FT_TYPE DOCTOR_FIRST_TEMPLATE_ID
AP_FT_TYPE DOCTOR_NOTIF_TEMPLATE_ID
AP_FT_TYPE PATIENT_FINAL_TEMPLATE_ID
AP_FT_TYPE PATIENT_FIRST_TEMPLATE_ID
AP_FT_TYPE PATIENT_NOTIF_TEMPLATE_ID
AP_PREFIX WORKSHEET_TEMPLATE_ID
ASSAY_PROCESSING_R DEFAULT_RESULT_TEMPLATE_ID
CSM_CAT_SUB_XREF REQ_TEMPL_ID
CSM_CAT_SUB_XREF RESL_TEMPL_ID
HIM_REQUEST_TEMPLATE_R TEMPLATE_ID
MAMMO_FOL_UP_LETTER_SECT TEMPLATE_ID
MAMMO_LETTER_DETAIL TEMPLATE_ID
MAMMO_NOTIFICATION TEMPLATE_ID
MAMMO_NOTIFICATION_HIST TEMPLATE_ID
RAD_FOLLOW_UP_DEFAULT TEMPLATE_ID
RAD_REPORT_DETAIL TEMPLATE_ID
RAD_TEMPLATE_ASSOC TEMPLATE_ID
STATION EOT_TEMPLATE_ID
STATION TEMPLATE_ID
UCMR_KARYOTYPE_WP_TMPLT_R WP_TEMPLATE_ID
UCMR_LAYOUT_FIELD_TMPLT_R TEMPLATE_ID
WP_TEMPLATE_TEXT TEMPLATE_ID


WP_TEMPLATE_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Word Processing Template Text
Definition: This reference table contains the text associated with an individual template. The associated template parameters are stored on the WP_TEMPLATE table.
Table Type: REFERENCE





Column Detail - WP_TEMPLATE_TEXT


Column Name Type Null? Definition
LONG_TEXT_ID DOUBLE N This field contains the foreign key value used to join to the Rich Text Format (RTF) template text stored on the LONG_TEXT table.
PCS_RSLT_FRMT_VRSN_ID DOUBLE N Unique identifier for a result format version within the template at the text position
PCS_RSLT_LAYOUT_ID DOUBLE N Unique identifier for a result layout placed within the template at the text position
SEQUENCE DOUBLE N This field contains a sequence value which is used when the associated template has more than one template text record included on the LONG_TEXT reference table.
TEMPLATE_ID DOUBLE N This field contains the foreign key value (identifying the template) that is used to join to template information stored on the WP_TEMPLATE 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 - WP_TEMPLATE_TEXT


Child Column in WP_TEMPLATE_TEXT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PCS_RSLT_FRMT_VRSN_ID PCS_RSLT_FRMT_VRSN PCS_RSLT_FRMT_VRSN_ID
PCS_RSLT_LAYOUT_ID PCS_RSLT_LAYOUT PCS_RSLT_LAYOUT_ID
TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID