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 |