Table Detail Report

CMT_IMPORT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Community import log
Definition: Contains log information for CMT Content loads
Table Type: ACTIVITY





Column Detail - CMT_IMPORT_LOG


Column Name Type Null? Definition
BLOCK_SIZE DOUBLE Y Number of blocks to process at a time.
CMT_IMPORT_LOG_ID DOUBLE N Sequence value
END_DT_TM DATETIME N end date and timeColumn
INPUT_FILENAME VARCHAR(255) Y input filenameColumn
LOGFILE_NAME VARCHAR(50) Y log file nameColumn
LOG_LEVEL DOUBLE Y Level of logging when load was run.
LONG_TEXT_ID DOUBLE N Stores a reference to text created by import logs. FK from LONG_TEXT table.
PACKAGE_NBR DOUBLE Y Package from which load was run.
README DOUBLE Y README number for installation
SCRIPT_NAME VARCHAR(35) N Script used to run load.
START_DT_TM DATETIME N Start date and time of load.
START_RECORD DOUBLE Y Starting record in csv file.
STATUS_FLAG DOUBLE N Load Status - 0 - success;1 - warnings;2 - failure
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 - CMT_IMPORT_LOG


Child Column in CMT_IMPORT_LOG(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID




Parent Column in CMT_IMPORT_LOG (PK) Child Table Name Child Column Name
Children: CMT_IMPORT_LOG_ID CMT_IMPORT_LOG_MSG CMT_IMPORT_LOG_ID


CMT_IMPORT_LOG_MSG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Community import log message
Definition: Contains log information for CMT Content loads
Table Type: ACTIVITY





Column Detail - CMT_IMPORT_LOG_MSG


Column Name Type Null? Definition
CMT_IMPORT_LOG_ID DOUBLE N community import log message identifierColumn
CMT_IMPORT_LOG_MSG_ID DOUBLE N community import log message identifierColumn
END_DT_TM DATETIME Y The time the import ended
LOG_INSTANCE DOUBLE N Package from which load was run.
LOG_MESSAGE VARCHAR(250) N log messageColumn
LOG_SEQ DOUBLE N log sequenceColumn
LOG_STATUS_FLAG DOUBLE N Current Status of Import. 0 = unknown; 1 = Running; 2 = Success; 3 = Failed; 4 = Warning.
START_DT_TM DATETIME Y The time the import started
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 - CMT_IMPORT_LOG_MSG


Child Column in CMT_IMPORT_LOG_MSG(FK) Parent Table Name Parent Column Name
Parents: CMT_IMPORT_LOG_ID CMT_IMPORT_LOG CMT_IMPORT_LOG_ID


CMT_SUBSET



Column Section Relationship Section Top of Page


Table-level Detail

Description: CMT SUBSET
Definition: The subset table serves as grouper to concepts to support the needs of different specialties or organizations.
Table Type: REFERENCE





Column Detail - CMT_SUBSET


Column Name Type Null? Definition
SUBSET_ID DOUBLE N The unique identifier for the subset
SUBSET_MEAN VARCHAR(12) Y The unique name that represent the subset.
SUBSET_NAME VARCHAR(255) Y A name that describes the purpose or usage of this subset.
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 - CMT_SUBSET




Parent Column in CMT_SUBSET (PK) Child Table Name Child Column Name
Children: SUBSET_ID CMT_SUBSET_MEMBER CHILD_SUBSET_ID
CMT_SUBSET_MEMBER SUBSET_ID


CMT_SUBSET_MEMBER



Column Section Relationship Section Top of Page


Table-level Detail

Description: CMT SUBSET MEMBER
Definition: This table contains relationships between concepts / CMTIs within a specific subset. This is to support navigation purposes.
Table Type: REFERENCE





Column Detail - CMT_SUBSET_MEMBER


Column Name Type Null? Definition
CHILD_CMTI VARCHAR(255) Y Global unique identifier. Identifies the child item for the list item.
CHILD_CONCEPT_CKI VARCHAR(255) N Child concept_cki from cmt_concept table
CHILD_SUBSET_ID DOUBLE N Unique identifier for the child subset.
LIST_SEQUENCE DOUBLE Y The sequence of the child item with the parent
PARENT_CMTI VARCHAR(255) Y Global unique identifier. Identifies the parent item for the list item.
PARENT_CONCEPT_CKI VARCHAR(255) N Parent concept_cki from cmt_concept table.
SUBSET_ID DOUBLE N Unique identifier from the subset table.
SUBSET_MEMBER_ID DOUBLE N Unique identifier for the CMT Subset member 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 - CMT_SUBSET_MEMBER


Child Column in CMT_SUBSET_MEMBER(FK) Parent Table Name Parent Column Name
Parents: CHILD_CONCEPT_CKI CMT_CONCEPT CONCEPT_CKI
PARENT_CONCEPT_CKI CMT_CONCEPT CONCEPT_CKI
CHILD_SUBSET_ID CMT_SUBSET SUBSET_ID
SUBSET_ID CMT_SUBSET SUBSET_ID


CMT_SUBSET_MEMBER_LOAD



Column Section Top of Page


Table-level Detail

Description: CMT_SUBSET_MEMBER_LOAD
Definition: LOAD TABLE FOR CMT_SUBSET_MEMBER
Table Type: REFERENCE





Column Detail - CMT_SUBSET_MEMBER_LOAD


Column Name Type Null? Definition
CHILD_CMTI VARCHAR(255) Y The child cmti for the relationship
CHILD_CONCEPT_CKI VARCHAR(255) Y The child concept cki for the relationship
CHILD_SUBSET_ID DOUBLE N The subset ID for the child
LIST_SEQUENCE DOUBLE Y The sequence of the relationship
PARENT_CMTI VARCHAR(255) Y The parent CMTI for the relationship
PARENT_CONCEPT_CKI VARCHAR(255) Y The parent concept cki for the relationship
SUBSET_ID DOUBLE N The SUBSET ID for the relationship
SUBSET_MEMBER_LOAD_ID DOUBLE N Unique Value Identifier
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.