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 |