Table Detail Report

DM_XNTR_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Tranform Retrieve Job
Definition: Stores information about what persons are being retrieved
Table Type: ACTIVITY





Column Detail - DM_XNTR_JOB


Column Name Type Null? Definition
AUDIT_SID VARCHAR(255) Y Audit SID
DM_XNTR_JOB_ID DOUBLE N Non-intelligent PK of table
FILE_NAME VARCHAR(30) Y Holds the name of the file containing the list of persons
JOB_END_DT_TM DATETIME Y Holds the time the job was ended
JOB_START_DT_TM DATETIME Y Holds the time the job was started
LOG_FILE VARCHAR(80) Y Log File
PERSON_ID DOUBLE N Holds person to retrieve data on
STATUS VARCHAR(20) N Holds status of person being retrieved
STATUS_MSG VARCHAR(250) Y Holds information about status
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_XNTR_JOB


Child Column in DM_XNTR_JOB(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in DM_XNTR_JOB (PK) Child Table Name Child Column Name
Children: DM_XNTR_JOB_ID DM_XNTR_EXTRACT DM_XNTR_JOB_ID


DM_XNTR_README_DATA



Column Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Transform Retrieve readme data
Definition: Stores readme information from admin during package install that is necessary for the XnTR process
Table Type: REFERENCE





Column Detail - DM_XNTR_README_DATA


Column Name Type Null? Definition
DM_XNTR_README_DATA_ID DOUBLE N Non-intelligent PK of table
EXECUTE_DT_TM DATETIME N Holds the most recent date time that the readme instance was executed for the environment
PARENT_README_ID DOUBLE N Holds the Parent readme id of the readme from DM_README.PARENT_README_ID
README_ID DOUBLE N Value from admin table = DM_README.README_ID
README_INSTANCE DOUBLE N Holds the instance of readme from DM_README.INSTANCE
SCRIPT VARCHAR(100) N Holds the Script associated with the README from DM_README.SCRIPT
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.


DM_XNTR_README_TABLE



Column Section Top of Page


Table-level Detail

Description: Database Architecture Readme Extract and Transform Retrieve Tables
Definition: Stores metadata that relates readme instances to their related Extract and Transform tables
Table Type: REFERENCE





Column Detail - DM_XNTR_README_TABLE


Column Name Type Null? Definition
DM_XNTR_README_TABLE_ID DOUBLE N Non-intelligent PK of table
README_ID DOUBLE N Holds readme identifier from DM_README.README_ID
README_INSTANCE DOUBLE N Holds the instance of readme from DM_README.INSTANCE
TABLE_NAME VARCHAR(30) N Holds table name of table related to the readme
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.


DM_XNT_IDS_GTTD



Column Section Top of Page


Table-level Detail

Description: Data Management Extract and Transform Ids Global Temporary Table
Definition: An ID value of a table that is being processed by the Extract and Transform archive process
Table Type: ACTIVITY





Column Detail - DM_XNT_IDS_GTTD


Column Name Type Null? Definition
TABLE_NAME VARCHAR(30) N Table associated to ID value.
XNT_ID DOUBLE N Id to be processed in Extract and Transform


DM_XNT_JOB_LOG



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 execution of JOB_ID.
Table Type: ACTIVITY





Column Detail - DM_XNT_JOB_LOG


Column Name Type Null? Definition
AUDIT_SID VARCHAR(255) N Auditing Session Id
DM_XNT_JOB_LOG_ID DOUBLE N Primary key for the job logging table
END_DT_TM DATETIME Y Used to store the date/time that the job was ended for this JOB_ID
ERROR_MSG VARCHAR(1000) Y Contains error message info if errors are reported, otherwise NULL
JOB_ID DOUBLE N Primary key from DM_PURGE_JOB table used to describe the template and parameters used for this extract
START_DT_TM DATETIME N Used to store the date/time that the job was started for this JOB_ID
STATUS VARCHAR(30) N Indicates the current status of this extract job
TOTAL_ROWS DOUBLE N Keeps total extracted for the DM_XNT_JOB_LOG_ID
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


Child Column in DM_XNT_JOB_LOG(FK) Parent Table Name Parent Column Name
Parents: JOB_ID DM_PURGE_JOB JOB_ID




Parent Column in DM_XNT_JOB_LOG (PK) Child Table Name Child Column Name
Children: DM_XNT_JOB_LOG_ID DM_XNT_JOB_LOG_DTL DM_XNT_JOB_LOG_ID