EXPRESSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Expression |
Definition: | Information pertaining to an expression that can be evaluated. |
Table Type: | REFERENCE |
Column Detail - EXPRESSION
Column Name | Type | Null? | Definition |
---|---|---|---|
EXPRESSION_CKI | CHAR(255) | N | Globally unique identifier |
EXPRESSION_DISPLAY | CHAR(512) | N | Text representation of the expression |
EXPRESSION_ID | DOUBLE | N | Primary key |
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 - EXPRESSION
Parent Column in EXPRESSION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EXPRESSION_ID | EXPRESSION_COMP | EXPRESSION_ID |
SCR_ACTION | EXPRESSION_ID |
EXPRESSION_COMP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Expression Component |
Definition: | Contains an entry for each component (operators and operands) of an expression that can be evaluated |
Table Type: | REFERENCE |
Column Detail - EXPRESSION_COMP
Column Name | Type | Null? | Definition |
---|---|---|---|
EXPRESSION_COMP_ID | DOUBLE | N | Primary key of this table (Auto Generated) |
EXPRESSION_COMP_ROLE_CD | DOUBLE | N | The role of this expression component such as constant, value, operator, etc. |
EXPRESSION_ID | DOUBLE | N | Foreign key from table Expression. It is the Primary ID of the Expression table |
PARENT_EXPRESSION_COMP_ID | DOUBLE | N | Identifier of the parent of the expression component |
SEQUENCE_NUMBER | DOUBLE | Y | The sequence number of the expression comp |
UNITS_CD | DOUBLE | N | Code that identifies what type of units are in this table. Examples are Day, Foot, Dose, etc. |
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. |
VALUE_DT_TM | DATETIME | Y | Used if the expression has a date or time in it. |
VALUE_FKEY_ENTITY_NAME | VARCHAR(255) | N | Foreign key entity name the row is pointing back to. |
VALUE_FKEY_ID | DOUBLE | N | The value foreign key identifier |
VALUE_NUMBER | DOUBLE | Y | Number values for the expression |
VALUE_TEXT | VARCHAR(512) | Y | Expression strings or CKI's of other existing terms. CKI stands for Cerner Knowledge Index. |
Relationship Detail - EXPRESSION_COMP
Child Column in EXPRESSION_COMP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EXPRESSION_ID | EXPRESSION | EXPRESSION_ID |
PARENT_EXPRESSION_COMP_ID | EXPRESSION_COMP | EXPRESSION_COMP_ID |
Parent Column in EXPRESSION_COMP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EXPRESSION_COMP_ID | EXPRESSION_COMP | PARENT_EXPRESSION_COMP_ID |
SCD_BLOB
Column Section | Top of Page |
Table-level Detail
Description: | SCD BLOB TABLE |
Definition: | Relation Table used to group a series of blobs in the LONG_BLOB_TABLE |
Table Type: | ACTIVITY |
Column Detail - SCD_BLOB
Column Name | Type | Null? | Definition |
---|---|---|---|
FORMAT_CD | DOUBLE | N | Format Code Value |
SCD_BLOB_ID | DOUBLE | N | SCD Blob Unique Id |
SCD_PARAGRAPH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contains an entry for each paragraph of each note. |
Definition: | Activity Data, paragrah table. |
Table Type: | ACTIVITY |
Column Detail - SCD_PARAGRAPH
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_ID | DOUBLE | N | event_identifier |
PARAGRAPH_CLASS_CD | DOUBLE | N | Identifiers behavior of a paragraph |
SCD_PARAGRAPH_ID | DOUBLE | N | Unique Identifier for this paragraph |
SCD_STORY_ID | DOUBLE | N | The story of which this paragraph is part of. |
SCD_TERM_DATA_ID | DOUBLE | N | scd term data identifier |
SCR_PARAGRAPH_TYPE_ID | DOUBLE | N | Unique Identifier for this table |
SEQUENCE_NUMBER | DOUBLE | Y | Sequence of this paragraph amongst all other paragraphs |
TRUTH_STATE_CD | DOUBLE | N | State of the paragraph term |
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 - SCD_PARAGRAPH
Child Column in SCD_PARAGRAPH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCD_STORY_ID | SCD_STORY | SCD_STORY_ID |
SCR_PARAGRAPH_TYPE_ID | SCR_PARAGRAPH_TYPE | SCR_PARAGRAPH_TYPE_ID |
Parent Column in SCD_PARAGRAPH (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCD_PARAGRAPH_ID | SCD_SENTENCE | SCD_PARAGRAPH_ID |
SCD_SENTENCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Contains an entry for each sentence. |
Definition: | Activty Data, Sentence |
Table Type: | ACTIVITY |
Column Detail - SCD_SENTENCE
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. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
AUTHOR_PERSNL_ID | DOUBLE | N | Author Unique Id |
CANONICAL_SENTENCE_PATTERN_ID | DOUBLE | N | scr_pattern_id |
CAN_SENT_PAT_CKI_IDENTIFIER | VARCHAR(50) | Y | canonical sentence pattern cki identifier |
CAN_SENT_PAT_CKI_SOURCE | CHAR(12) | Y | canonical sentence pattern cki identifier |
EVENT_ID | DOUBLE | N | event_identifier |
SCD_PARAGRAPH_ID | DOUBLE | N | Identifies the paragraph which contains this sentence. |
SCD_SENTENCE_ID | DOUBLE | N | Unique Sentence Id |
SCD_STORY_ID | DOUBLE | N | Identifies the story which contains this sentence. |
SCR_TERM_HIER_ID | DOUBLE | N | The entry in the reference hier which corresponds to the first saved term in the sentence. |
SENTENCE_CLASS_CD | DOUBLE | N | Categorizes sentences with similar behavior and organization |
SENTENCE_TOPIC_CD | DOUBLE | N | Topic of sentence, for grouping, text generation |
SEQUENCE_NUMBER | DOUBLE | Y | The sequence number of this sentence within the paragraph. |
TEXT_FORMAT_RULE_CD | DOUBLE | N | Text format rule code |
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 - SCD_SENTENCE
Child Column in SCD_SENTENCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHOR_PERSNL_ID | PRSNL | PERSON_ID |
SCD_PARAGRAPH_ID | SCD_PARAGRAPH | SCD_PARAGRAPH_ID | |
SCD_STORY_ID | SCD_STORY | SCD_STORY_ID | |
CANONICAL_SENTENCE_PATTERN_ID | SCR_PATTERN | SCR_PATTERN_ID | |
SCR_TERM_HIER_ID | SCR_TERM_HIER | SCR_TERM_HIER_ID |
Parent Column in SCD_SENTENCE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCD_SENTENCE_ID | SCD_TERM | SCD_SENTENCE_ID |