Table Detail Report

SCR_TERM_HIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Defines a parent-child hierachy.
Definition: This table defines the parent-child hierarchy which forms the terms within a pattern.
Table Type: REFERENCE





Column Detail - SCR_TERM_HIER


Column Name Type Null? Definition
CKI_IDENTIFIER VARCHAR(50) Y Cerner Knowledge Index, Identifier
CKI_SOURCE CHAR(12) Y Cerner Knowledge Index, Source
CONCEPT_CKI VARCHAR(255) Y This relates the term in the context of the current hierarchy and it's concept.
DEFAULT_CD DOUBLE N default code
DEPENDENCY_CD DOUBLE N dependency code
DEPENDENCY_GROUP DOUBLE Y dependency group
PARENT_TERM_HIER_ID DOUBLE N parent term hierachy Id
RECOMMENDED_CD DOUBLE N recommened code
SCR_PATTERN_ID DOUBLE N Pattern Identifier
SCR_SENTENCE_ID DOUBLE N Sentence Identifier
SCR_TERM_HIER_ID DOUBLE N Term Hierarchy Identifier
SCR_TERM_ID DOUBLE N Term Identifier
SEQUENCE_NUMBER DOUBLE Y sequence number
SOURCE_TERM_HIER_ID DOUBLE N source term hierarch id
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 - SCR_TERM_HIER


Child Column in SCR_TERM_HIER(FK) Parent Table Name Parent Column Name
Parents: SCR_PATTERN_ID SCR_PATTERN SCR_PATTERN_ID
SCR_SENTENCE_ID SCR_SENTENCE SCR_SENTENCE_ID
SCR_TERM_ID SCR_TERM SCR_TERM_ID




Parent Column in SCR_TERM_HIER (PK) Child Table Name Child Column Name
Children: SCR_TERM_HIER_ID ONC_NOMEN_TERM_RELTN SCR_TERM_HIER_ID
SCD_SENTENCE SCR_TERM_HIER_ID
SCD_TERM SCR_TERM_HIER_ID


SCR_TERM_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the text associated with the term.
Definition: The text used to generate text from the term. Can be in many different languages.
Table Type: REFERENCE





Column Detail - SCR_TERM_TEXT


Column Name Type Null? Definition
DEFINITION VARCHAR(255) Y Long Text
DISPLAY VARCHAR(255) N Short Name
EXTERNAL_REFERENCE_INFO VARCHAR(255) Y External text info
LANGUAGE_CD DOUBLE N language code
SCR_TERM_ID DOUBLE N Term Identifier
TEXT_FORMAT_RULE_CD DOUBLE N Text format rule code
TEXT_NEGATION_RULE_CD DOUBLE N text negation rule code
TEXT_REPRESENTATION VARCHAR(255) Y text representation



Relationship Detail - SCR_TERM_TEXT


Child Column in SCR_TERM_TEXT(FK) Parent Table Name Parent Column Name
Parents: SCR_TERM_ID SCR_TERM SCR_TERM_ID