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