Table Detail Report
DM_XNT_JOB_LOG_CNT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Data Management Extract and Transform Log Counts |
Definition: | Child table of DM_XNT_LOG_DTL. Used to store table level details for the extract (counts) |
Table Type: | ACTIVITY |
Column Detail - DM_XNT_JOB_LOG_CNT
Column Name | Type | Null? | Definition |
---|---|---|---|
DM_XNT_JOB_LOG_CNT_ID | DOUBLE | N | Primary key for the logging count table. |
DM_XNT_JOB_LOG_DTL_ID | DOUBLE | N | Contains primary key from parent table |
EXTRACT_DT_TM | DATETIME | N | Contains the system date when the extract was performed |
PARENT_TABLE_NAME | VARCHAR(30) | N | Contains parent table name for table being extracted |
ROWS_DELETED | DOUBLE | N | Keeps total deleted for the DM_XNT_LOG_ID/table_name combination |
ROWS_EXTRACTED | DOUBLE | N | Keeps total extracted for the DM_XNT_LOG_ID/table_name combination |
TABLE_NAME | VARCHAR(30) | N | Contains table name being extracted |
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 - DM_XNT_JOB_LOG_CNT
Child Column in DM_XNT_JOB_LOG_CNT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DM_XNT_JOB_LOG_DTL_ID | DM_XNT_JOB_LOG_DTL | DM_XNT_JOB_LOG_DTL_ID |
DM_XNT_JOB_LOG_DTL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Data Management Extract and Transform Job Log |
Definition: | Logging table for the Extract and Transform process, 1 row should exist in this table for each JOB_ID,DM_XNT_JOB_LOG_ID, PERSON_ID, EXTRACT_DATE_START |
Table Type: | ACTIVITY |
Column Detail - DM_XNT_JOB_LOG_DTL
Column Name | Type | Null? | Definition |
---|---|---|---|
AUDIT_SID | VARCHAR(255) | Y | Auditing Session Id |
DM_XNT_JOB_LOG_DTL_ID | DOUBLE | N | Primary key for the logging table |
DM_XNT_JOB_LOG_ID | DOUBLE | N | Primary key from DM_XNT_JOB_LOG table. |
END_UPDT_DT_TM | DATETIME | Y | Used to store the maximum UPDT_DT_TM value for the rows affected by this extract |
ERROR_MSG | VARCHAR(1000) | Y | Contains error message info if errors are reported, otherwise NULL |
EXTRACT_END_DT_TM | DATETIME | Y | Used to store the date/time that the extract was started for this JOB_ID and PERSON_ID |
EXTRACT_START_DT_TM | DATETIME | N | Used to store the date/time that the extract was started for this JOB_ID and PERSON_ID |
EXTRACT_STATUS | VARCHAR(30) | N | Indicates the current status of this extract process |
FILE_LABEL | VARCHAR(100) | Y | Stores the label assigned to this extract |
FILE_UUID | VARCHAR(200) | Y | UUID returned from MMF when extract is saved |
JOB_ID | DOUBLE | N | Primary key from DM_PURGE_JOB table used to describe the template and parameters used for this extract |
PERSON_ID | DOUBLE | N | PERSON_ID for the transform being processed |
START_UPDT_DT_TM | DATETIME | Y | Used to store the minimum UPDT_DT_TM value for the rows affected by this extract |
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 - DM_XNT_JOB_LOG_DTL
Child Column in DM_XNT_JOB_LOG_DTL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | JOB_ID | DM_PURGE_JOB | JOB_ID |
DM_XNT_JOB_LOG_ID | DM_XNT_JOB_LOG | DM_XNT_JOB_LOG_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in DM_XNT_JOB_LOG_DTL (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DM_XNT_JOB_LOG_DTL_ID | DM_XNT_JOB_LOG_CNT | DM_XNT_JOB_LOG_DTL_ID |
DM_XNT_ROW_GTTD
Column Section | Top of Page |
Table-level Detail
Description: | DB ARCH EXTRACT/TRANSFORM Global Temp Table |
Definition: | Global Temporary Table. Stores information during the retrieve proces about the datga that was extracted |
Table Type: | ACTIVITY |
Column Detail - DM_XNT_ROW_GTTD
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_NAME | VARCHAR(30) | Y | Holds Column name of retrieved data |
COLUMN_VALUE | VARCHAR(4000) | Y | Holds Column value of retrieved data |
COL_SEQ | DOUBLE | Y | Holds column order of retrieved data |
FILE_ID | DOUBLE | N | Relation to DM_XNTR_EXTRACT_ID that represents each media file retrieved |
ROW_SEQ | DOUBLE | Y | Holds order of rows of retrieved data |
TABLE_NAME | VARCHAR(30) | Y | Holds Table name of retrieved data |
DM_XNT_XML_GTTD
Column Section | Top of Page |
Table-level Detail
Description: | Data Management Extract and Transform XML Global Temporary Table |
Definition: | Global Temporary Table used for Extract and Transform Archive process to store person related data to be extracted into an XML source. |
Table Type: | ACTIVITY |
Column Detail - DM_XNT_XML_GTTD
Column Name | Type | Null? | Definition |
---|---|---|---|
XML_SEQ | DOUBLE | Y | Used to order the output, contains value from DM_CLINICAL_SEQ. |
XML_STR | VARCHAR(4000) | Y | Used to store the XML output. |