Table Detail Report
SCD_STORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Structured Clinical Doc Story (NOTE) table |
Definition: | Contains an entry for each structured note. |
Table Type: | ACTIVITY |
Column Detail - SCD_STORY
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_ID | DOUBLE | N | Author Id |
ENCOUNTER_ID | DOUBLE | N | Encounter Id |
ENTRY_MODE_CD | DOUBLE | N | Indicates the UI mechanism to be used for data entry against this template. |
EVENT_ID | DOUBLE | N | tbd |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
SCD_STORY_ID | DOUBLE | N | SCD Story Unique Id |
SCD_TERM_DATA_ID | DOUBLE | N | Used to associate term data to a document. |
STORY_COMPLETION_STATUS_CD | DOUBLE | N | story completion status |
STORY_TYPE_CD | DOUBLE | N | story type code |
TITLE | VARCHAR(255) | Y | Title for note |
UPDATE_LOCK_DT_TM | DATETIME | Y | update lock date/time |
UPDATE_LOCK_USER_ID | DOUBLE | N | lock holder user id |
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 - SCD_STORY
Child Column in SCD_STORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCOUNTER_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID | |
AUTHOR_ID | PRSNL | PERSON_ID | |
UPDATE_LOCK_USER_ID | PRSNL | PERSON_ID |
Parent Column in SCD_STORY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCD_STORY_ID | AP_CASE_SYNOPTIC_WS | SCD_STORY_ID |
RAD_REPORT | SCD_STORY_ID | ||
SCD_PARAGRAPH | SCD_STORY_ID | ||
SCD_SENTENCE | SCD_STORY_ID | ||
SCD_STORY_CONCEPT | SCD_STORY_ID | ||
SCD_STORY_ORG_RELTN | SCD_STORY_ID | ||
SCD_STORY_PATTERN | SCD_STORY_ID | ||
SCD_TERM | SCD_STORY_ID | ||
UCM_CASE_INTEGRATION | STORY_ID |
SCD_STORY_CONCEPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Story - Concept relation table |
Definition: | Relation table used to associate a story with concepts. |
Table Type: | ACTIVITY |
Column Detail - SCD_STORY_CONCEPT
Column Name | Type | Null? | Definition |
---|---|---|---|
CONCEPT_CKI | VARCHAR(255) | N | The cki of the concept associated to a story. |
CONCEPT_DISPLAY | VARCHAR(255) | Y | Display to be used for the concept |
CONCEPT_TYPE_FLAG | DOUBLE | N | Stores the classification of the concept and is a bit-wise indicator to distinguish multiple classifications. |
DIAGNOSIS_GROUP_ID | DOUBLE | N | Stores the Diagnosis ID from the DIAGNOSIS table so that the concept can be identified if inactivated. |
SCD_STORY_CONCEPT_ID | DOUBLE | N | Primary key for the table From SCD Sequence |
SCD_STORY_ID | DOUBLE | N | The story to be associated to a concept. |
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 - SCD_STORY_CONCEPT
Child Column in SCD_STORY_CONCEPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DIAGNOSIS_GROUP_ID | DIAGNOSIS | DIAGNOSIS_ID |
SCD_STORY_ID | SCD_STORY | SCD_STORY_ID |
SCD_STORY_ORG_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | SCD story Organization relation |
Definition: | Relates organizations to scd story rows |
Table Type: | ACTIVITY |
Column Detail - SCD_STORY_ORG_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ORGANIZATION_ID | DOUBLE | N | primary key of organization table |
SCD_STORY_ID | DOUBLE | N | primary key to the scd_story table |
SCD_STORY_ORG_ID | DOUBLE | N | primary key of 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 - SCD_STORY_ORG_RELTN
Child Column in SCD_STORY_ORG_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
SCD_STORY_ID | SCD_STORY | SCD_STORY_ID |
SCD_STORY_PATTERN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Identifies the patterns that were used to to construct the story. |
Definition: | Activty Data, Pattern/Story relation table. |
Table Type: | ACTIVITY |
Column Detail - SCD_STORY_PATTERN
Column Name | Type | Null? | Definition |
---|---|---|---|
PATTERN_TYPE_CD | DOUBLE | N | SCR Pattern Type |
SCD_STORY_ID | DOUBLE | N | Unique Story Id |
SCR_PARAGRAPH_TYPE_ID | DOUBLE | N | Unique id to paragraph type |
SCR_PATTERN_ID | DOUBLE | N | A pattern that was used to construct the story. |
Relationship Detail - SCD_STORY_PATTERN
Child Column in SCD_STORY_PATTERN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCD_STORY_ID | SCD_STORY | SCD_STORY_ID |
SCR_PATTERN_ID | SCR_PATTERN | SCR_PATTERN_ID |
SCD_TERM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Hier of terms, which form sentences. |
Definition: | Activity Data, terms of the sentence. |
Table Type: | ACTIVITY |
Column Detail - SCD_TERM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | 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 | N | 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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BEG_EFFECTIVE_TZ | DOUBLE | Y | begin effective time zone |
CONCEPT_CKI | VARCHAR(255) | Y | The merging of the concept_identifier and concept_source_cd into one string column |
CONCEPT_IDENTIFIER | CHAR(18) | Y | Obsolete/no longer used. |
CONCEPT_SOURCE_CD | DOUBLE | N | associated concept source code |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EVENT_ID | DOUBLE | N | event_identifier |
MODIFY_PRSNL_ID | DOUBLE | N | This is a foreign key to prsnl which contains the id of the person that made the modification |
PARENT_SCD_TERM_ID | DOUBLE | N | parent term id, null if this term is the start of the sentenfe. |
SCD_PHRASE_TYPE_ID | DOUBLE | N | link to phrase type table |
SCD_SENTENCE_ID | DOUBLE | N | The sentence which contains this term |
SCD_STORY_ID | DOUBLE | N | The story this term is included in. Used for retrieval performance. |
SCD_TERM_DATA_ID | DOUBLE | N | Term_DATA_Id, 0 if no term_data, else = SCR_TERM_ID |
SCD_TERM_ID | DOUBLE | N | Unique Identifier for this term. |
SCR_PHRASE_ID | DOUBLE | N | Phrase Id of phrase that is associated with this term |
SCR_TERM_HIER_ID | DOUBLE | N | Identifies node in reference canonical from which this node generated. |
SCR_TERM_ID | DOUBLE | N | Identifies term in reference canonical from which this term was generated. |
SEQUENCE_NUMBER | DOUBLE | Y | orders all terms |
SUCCESSOR_TERM_ID | DOUBLE | N | This field will be used as a pointer to the instance of the scd_term that succeeded this one. |
TRUTH_STATE_CD | DOUBLE | N | truth state code |
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 - SCD_TERM
Child Column in SCD_TERM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCD_SENTENCE_ID | SCD_SENTENCE | SCD_SENTENCE_ID |
SCD_STORY_ID | SCD_STORY | SCD_STORY_ID | |
PARENT_SCD_TERM_ID | SCD_TERM | SCD_TERM_ID | |
SUCCESSOR_TERM_ID | SCD_TERM | SCD_TERM_ID | |
SCR_PHRASE_ID | SCR_PHRASE | SCR_PHRASE_ID | |
SCR_TERM_ID | SCR_TERM | SCR_TERM_ID | |
SCR_TERM_HIER_ID | SCR_TERM_HIER | SCR_TERM_HIER_ID |
Parent Column in SCD_TERM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCD_TERM_ID | MAMMO_FIND | SCD_TERM_ID |
SCD_TERM | PARENT_SCD_TERM_ID | ||
SCD_TERM | SUCCESSOR_TERM_ID | ||
SCD_TERM_DATA | SCD_TERM_DATA_ID |