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.