Table Detail Report

SCD_TERM_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCD Term Data
Definition: Additional term data which is stored with specialized terms types. Activity data.
Table Type: ACTIVITY





Column Detail - SCD_TERM_DATA


Column Name Type Null? Definition
FKEY_ENTITY_NAME VARCHAR(32) Y Entity (table name) for link to another entity
FKEY_ID DOUBLE N key to a foreign table (table identified by FKEY_ENTITY_NAME).
SCD_TERM_DATA_ID DOUBLE N Term Id for the term data, slaved to scr_term_id
SCD_TERM_DATA_KEY VARCHAR(255) Y Term Data Key
SCD_TERM_DATA_TYPE_CD DOUBLE N type/formate/use of the data in this row.
UNITS_CD DOUBLE N units for the term.
VALUE_DT_TM DATETIME Y Date/Time Value of node.
VALUE_DT_TM_OS DOUBLE Y Offset, in fractional days, from VALUE_DT_TM.
VALUE_NUMBER DOUBLE Y Number value of node. If the term contains a number, this column will be populated.
VALUE_TEXT VARCHAR(255) Y Value text of node.
VALUE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - SCD_TERM_DATA


Child Column in SCD_TERM_DATA(FK) Parent Table Name Parent Column Name
Parents: SCD_TERM_DATA_ID SCD_TERM SCD_TERM_ID


SCR_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCR Action
Definition: This table will store term and paragraph actions
Table Type: REFERENCE





Column Detail - SCR_ACTION


Column Name Type Null? Definition
EXPRESSION_ID DOUBLE N The ID of the expression [Auto Generated].
EXPRESSION_OWNER_IND DOUBLE Y Indicates whether it owns expressions or not.
PARENT_ENTITY_ID DOUBLE N Unique identifier of the row in the table defined by Parent Entity Name.
PARENT_ENTITY_NAME VARCHAR(30) N Identifies a table where additional information about this row could be found
SCR_ACTION_CD DOUBLE N scr action code such as Select, Equation, Required.
SCR_ACTION_ID DOUBLE N Primary key of SCR_ACTION. Auto generated
TARGET_ENTITY_ID DOUBLE N FK Reference the SCR_TERM_HIER table
TARGET_ENTITY_NAME VARCHAR(30) N target entity name
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_ACTION


Child Column in SCR_ACTION(FK) Parent Table Name Parent Column Name
Parents: EXPRESSION_ID EXPRESSION EXPRESSION_ID


SCR_PARAGRAPH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Identifies the paragraphs contained within a given pattern.
Definition: This table is essentially a many-to-many relation table, exclusively for connecting patterns to paragraph types
Table Type: REFERENCE





Column Detail - SCR_PARAGRAPH


Column Name Type Null? Definition
SCR_PARAGRAPH_ID DOUBLE N SCR paragraph identifier
SCR_PARAGRAPH_TYPE_ID DOUBLE N Identifies the paragraph belonging to the pattern
SCR_PATTERN_ID DOUBLE N Identifies a pattern
SEQUENCE_NUMBER DOUBLE Y Orders paragraphs within the pattern
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_PARAGRAPH


Child Column in SCR_PARAGRAPH(FK) Parent Table Name Parent Column Name
Parents: SCR_PARAGRAPH_TYPE_ID SCR_PARAGRAPH_TYPE SCR_PARAGRAPH_TYPE_ID
SCR_PATTERN_ID SCR_PATTERN SCR_PATTERN_ID


SCR_PARAGRAPH_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains an entry for each paragraph type.
Definition: Each of these many be included in many patterns.
Table Type: REFERENCE





Column Detail - SCR_PARAGRAPH_TYPE


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.
CANONICAL_PATTERN_ID DOUBLE N Defines a SCR Pattern
CKI_IDENTIFIER VARCHAR(50) Y External identifier for this pattern, used in CKI_SOURCE to form a uniqe external identifier.
CKI_SOURCE CHAR(12) Y External source for this pattern, used in CKI_IDENTIFIER to form a uniqe external identifier.
DEFAULT_CD DOUBLE N Default Code
DESCRIPTION VARCHAR(60) Y Description of paragraph
DISPLAY VARCHAR(40) Y Display Text
DISPLAY_KEY VARCHAR(40) Y KEY value of DISPLAY field
PARAGRAPH_CLASS_CD DOUBLE N paragraph class code
SCR_PARAGRAPH_TYPE_ID DOUBLE N Primary Key
SEQUENCE_NUMBER DOUBLE Y Master Sequence for paragraphs
TEXT_FORMAT_RULE_CD DOUBLE N Text generation rule
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_PARAGRAPH_TYPE


Child Column in SCR_PARAGRAPH_TYPE(FK) Parent Table Name Parent Column Name
Parents: CANONICAL_PATTERN_ID SCR_PATTERN SCR_PATTERN_ID




Parent Column in SCR_PARAGRAPH_TYPE (PK) Child Table Name Child Column Name
Children: SCR_PARAGRAPH_TYPE_ID SCD_PARAGRAPH SCR_PARAGRAPH_TYPE_ID
SCR_PARAGRAPH SCR_PARAGRAPH_TYPE_ID


SCR_PATTERN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains an entry for each defined pattern.
Definition: Patterns include "full" encounter patterns, and small fragments built to be included in other patterns.
Table Type: REFERENCE





Column Detail - SCR_PATTERN


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.
CKI_IDENTIFIER VARCHAR(50) Y External identifier for this pattern, used in CKI_SOURCE to form a uniqe external identifier.
CKI_SOURCE CHAR(12) Y External source for this pattern, used with CKI_IDENTIFIER to form a uniqe external identifier.
DEFINITION VARCHAR(255) Y Long Text
DISPLAY VARCHAR(40) N Short Text
DISPLAY_KEY VARCHAR(40) N Key for Display Lookup
ENTRY_MODE_CD DOUBLE N Indicates the UI mechanism to be used for data entry against this template.
PATTERN_TYPE_CD DOUBLE N Pattern type code
REQUIRED_FIELD_ENFORCEMENT_CD DOUBLE N This field will indicate how a pattern should behave if all of its required elements have not been documented.
SCR_PATTERN_ID DOUBLE N Unique 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_PATTERN




Parent Column in SCR_PATTERN (PK) Child Table Name Child Column Name
Children: SCR_PATTERN_ID AP_CASE_SYNOPTIC_WS SCR_PATTERN_ID
ONC_WORKSHEET SCR_PATTERN_ID
SCD_SENTENCE CANONICAL_SENTENCE_PATTERN_ID
SCD_STORY_PATTERN SCR_PATTERN_ID
SCR_PARAGRAPH SCR_PATTERN_ID
SCR_PARAGRAPH_TYPE CANONICAL_PATTERN_ID
SCR_PATTERN_CONCEPT SCR_PATTERN_ID
SCR_SENTENCE CANONICAL_SENTENCE_PATTERN_ID
SCR_SENTENCE SCR_PATTERN_ID
SCR_TERM_HIER SCR_PATTERN_ID