Table Detail Report

SCR_PATTERN_CONCEPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: The relationship table between tables scr_pattern and concept.
Definition: This table relates patterns to concepts. It contains a row for each concept of each pattern.
Table Type: REFERENCE





Column Detail - SCR_PATTERN_CONCEPT


Column Name Type Null? Definition
CONCEPT_CKI VARCHAR(255) N The cki of the concept associated to a pattern. This is a merge of concept_identifier and concept_source_cd columns into one column.
CONCEPT_IDENTIFIER VARCHAR(242) N A member of the concept table's primary key
CONCEPT_SOURCE_CD DOUBLE N A member of the concept table's primary key.
SCR_PATTERN_ID DOUBLE N A member of the scr_pattern table's 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 - SCR_PATTERN_CONCEPT


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


SCR_PHRASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the concept cki hierarchy of a term.
Definition: This table contains Phrases. A Phrase is made of concatenated concept ckis of the term's hierarchy
Table Type: REFERENCE





Column Detail - SCR_PHRASE


Column Name Type Null? Definition
PHRASE_STRING VARCHAR(2000) Y contains the concatenated concept ckis of the term's hierarchy.
PHRASE_STRING_INDEX VARCHAR(255) N phrase_string_index
SCR_PHRASE_ID DOUBLE N primary key



Relationship Detail - SCR_PHRASE




Parent Column in SCR_PHRASE (PK) Child Table Name Child Column Name
Children: SCR_PHRASE_ID SCD_TERM SCR_PHRASE_ID


SCR_SENTENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Identifies the sentences within a given pattern.
Definition: Contains an entry for each high-level selection within a paragraph.
Table Type: REFERENCE





Column Detail - SCR_SENTENCE


Column Name Type Null? Definition
CANONICAL_SENTENCE_PATTERN_ID DOUBLE N Sentences of the pattern
DEFAULT_CD DOUBLE N default code
RECOMMENDED_CD DOUBLE N recommneded code
SCR_PARAGRAPH_TYPE_ID DOUBLE N paragraph type id
SCR_PATTERN_ID DOUBLE N Pattern Id
SCR_SENTENCE_ID DOUBLE N Unique Identifier (PK)
SENTENCE_CLASS_CD DOUBLE N sentence class
SENTENCE_TOPIC_CD DOUBLE N Sentence topic code
SEQUENCE_NUMBER DOUBLE Y sequence number
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 - SCR_SENTENCE


Child Column in SCR_SENTENCE(FK) Parent Table Name Parent Column Name
Parents: CANONICAL_SENTENCE_PATTERN_ID SCR_PATTERN SCR_PATTERN_ID
SCR_PATTERN_ID SCR_PATTERN SCR_PATTERN_ID




Parent Column in SCR_SENTENCE (PK) Child Table Name Child Column Name
Children: SCR_SENTENCE_ID ONC_NOMEN_TERM_RELTN SCR_SENTENCE_ID
SCR_TERM_HIER SCR_SENTENCE_ID


SCR_TERM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains an entry for each term in a sentence
Definition: The standard entry will be a text term which may be set to true,false or undetermined. Data Required for more complex and unusual terms is stored in subtables to conserve space.
Table Type: REFERENCE





Column Detail - SCR_TERM


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.
CONCEPT_CKI VARCHAR(255) Y The default concept that the term relates to. (The merging of concept_identifier and concept_source_cd columns into one column)
CONCEPT_IDENTIFIER CHAR(18) Y Concept identifier
CONCEPT_SOURCE_CD DOUBLE N Concept Source Code
ELIGIBILITY_CHECK_CD DOUBLE N eligibilty check code
OLDEST_AGE DOUBLE Y Oldest Age comparsion field.
REPEAT_CD DOUBLE N repeat code
RESTRICT_TO_SEX CHAR(12) Y restrict to sec
SCR_TERM_DEF_ID DOUBLE N Term Def Id -
SCR_TERM_ID DOUBLE N Unique ID (PK)
STATE_LOGIC_CD DOUBLE N State logic Code
STORE_CD DOUBLE N store Code
TERM_TYPE_CD DOUBLE N term type 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.
VISIBLE_CD DOUBLE N Visible_cd
YOUNGEST_AGE DOUBLE Y Youngst Age



Relationship Detail - SCR_TERM




Parent Column in SCR_TERM (PK) Child Table Name Child Column Name
Children: SCR_TERM_ID ONC_NOMEN_TERM_RELTN SCR_TERM_ID
SCD_TERM SCR_TERM_ID
SCR_TERM_DEFINITION SCR_TERM_DEF_ID
SCR_TERM_HIER SCR_TERM_ID
SCR_TERM_TEXT SCR_TERM_ID


SCR_TERM_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: For specialized terms. Most terms will not have a data definition
Definition: Used for further details on how to collect and store data associated with the term.
Table Type: REFERENCE





Column Detail - SCR_TERM_DEFINITION


Column Name Type Null? Definition
DEF_TEXT VARCHAR(255) Y Term Data Definition Text
FKEY_ENTITY_NAME VARCHAR(32) Y fkey_entity_name
FKEY_ID DOUBLE N fkey_id
SCR_TERM_DEF_ID DOUBLE N ScrTermId from ScrTermTable
SCR_TERM_DEF_KEY VARCHAR(255) Y term definition key
SCR_TERM_DEF_TYPE_CD DOUBLE N term type



Relationship Detail - SCR_TERM_DEFINITION


Child Column in SCR_TERM_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: SCR_TERM_DEF_ID SCR_TERM SCR_TERM_ID