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