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 |