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. |