Table Detail Report

DM_PURGE_TOKEN



Column Section Top of Page


Table-level Detail

Description: DM PURGE TOKEN
Definition: Questions to ask clients regarding HNAM Purge jobs.
Table Type: REFERENCE





Column Detail - DM_PURGE_TOKEN


Column Name Type Null? Definition
DATA_TYPE_FLAG DOUBLE Y Data type of this column. 1 - Numeric data type 2 - Date data type 3 - String data type
FEATURE_NBR DOUBLE N Rev Tool Feature number to which this purge template was promoted.
PROMPT_STR VARCHAR(255) Y Question to ask client about this purge job.
SCHEMA_DT_TM DATETIME Y Date/time this purge template modification was promoted in Feature Tracker.
TEMPLATE_NBR DOUBLE N Rev Tool Feature number to which this purge template was promoted.
TOKEN_STR VARCHAR(255) N Unique string name for this job's question.
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_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Transform Retrieve Detail
Definition: Stores information about wht processes get ran against the retrieved data
Table Type: ACTIVITY





Column Detail - DM_XNTR_DETAIL


Column Name Type Null? Definition
DM_XNTR_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the DM_XNTR_DETAIL table.
DM_XNTR_EXTRACT_ID DOUBLE N Foreign Key to DM_XNTR_EXTRACT table. Holds the pointer to each extract for a given job.
END_DT_TM DATETIME Y Holds the time the detail row completed
INSTANCE_NBR DOUBLE N Holds the instance of the TASK_ENTITY_ID where applicable
SEQUENCE_NBR DOUBLE N Holds the order inwhich tasks should be ran
START_DT_TM DATETIME Y Holds the time the detail row started
STATUS VARCHAR(20) Y Holds Status of detail data
STATUS_MSG VARCHAR(250) Y Holds message about status
TASK_ENTITY_ID DOUBLE N Holds the Identifier of the task that needs to be re-ran on retrieved data
TASK_ENTITY_NAME VARCHAR(30) Y Holds the type of task that needs to be re-ran (README, PERSON COMBINE, etc.)
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_DETAIL


Child Column in DM_XNTR_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DM_XNTR_EXTRACT_ID DM_XNTR_EXTRACT DM_XNTR_EXTRACT_ID


DM_XNTR_EXTRACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Transform Retrieve Extract
Definition: Stores information about data getting retrieved at the file extract level
Table Type: ACTIVITY





Column Detail - DM_XNTR_EXTRACT


Column Name Type Null? Definition
DM_XNTR_EXTRACT_ID DOUBLE N Non-intelligent PK of table
DM_XNTR_JOB_ID DOUBLE N Foreign Key to the DM_XNTR_JOB table
EXTRACT_NAME VARCHAR(100) Y Holds the name of the extract file
EXTRACT_PERSON_ID DOUBLE N Holds the person identifier the extract file is related to. Different from PERSON_ID on parent table, because of combines
EXTRACT_START_DT_TM DATETIME Y Holds the time, this extract file started being worked on
EXTRACT_STOP_DT_TM DATETIME Y Holds the time this extract file stopped being worked on
EXTRACT_UUID VARCHAR(200) Y Holds the UUID of the file in the CAMM database
EXTRACT_VERSION DOUBLE Y Holds the version number of the extract file in the CAMM database
STATUS VARCHAR(20) Y Holds status of extract file
STATUS_MSG VARCHAR(250) Y Holds detailed 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.
XNT_END_DT_TM DATETIME Y The date and time the Retrieve Process ended
XNT_START_DT_TM DATETIME Y The date and time the Retrieve Process started



Relationship Detail - DM_XNTR_EXTRACT


Child Column in DM_XNTR_EXTRACT(FK) Parent Table Name Parent Column Name
Parents: DM_XNTR_JOB_ID DM_XNTR_JOB DM_XNTR_JOB_ID




Parent Column in DM_XNTR_EXTRACT (PK) Child Table Name Child Column Name
Children: DM_XNTR_EXTRACT_ID DM_XNTR_DETAIL DM_XNTR_EXTRACT_ID
DM_XNTR_EXTRACT_CNT DM_XNTR_EXTRACT_ID


DM_XNTR_EXTRACT_CNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Tranform Retrieve Extract Count
Definition: Stores information about the row counts retrieve for each extract file
Table Type: ACTIVITY





Column Detail - DM_XNTR_EXTRACT_CNT


Column Name Type Null? Definition
DELETED_ROW_CNT DOUBLE Y Holds the number of rows deleted from the Live table in case of an error
DM_XNTR_EXTRACT_CNT_ID DOUBLE N Non-intelligent PK of table
DM_XNTR_EXTRACT_ID DOUBLE N Foreign Key to DM_XNTR_EXTRACT table, which holds pointer to each extract for a given job
RETRIEVED_ROW_CNT DOUBLE Y Holds the number of rows inserted back into the live table
TABLE_NAME VARCHAR(30) Y Holds the table name of the data retrieved
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_EXTRACT_CNT


Child Column in DM_XNTR_EXTRACT_CNT(FK) Parent Table Name Parent Column Name
Parents: DM_XNTR_EXTRACT_ID DM_XNTR_EXTRACT DM_XNTR_EXTRACT_ID


DM_XNTR_EXTRACT_ROW_DATA



Column Section Top of Page


Table-level Detail

Description: Database Architecture Extract and Transform - Retrive Extract Row Data
Definition: Stores rowids for eachextract that was retrieved using the XnTR process
Table Type: ACTIVITY





Column Detail - DM_XNTR_EXTRACT_ROW_DATA


Column Name Type Null? Definition
DM_XNTR_EXTRACT_ROW_DATA_ID DOUBLE N Non-intelligent PK of table
EXTRACT_ID DOUBLE N Foreign Key to DM_XNTR_EXTRACT.DM_XNTR_EXTRACT_ID
NEW_ROWID VARCHAR(10) Y Holds the rowid of the row that was inserted into the table
TABLE_NAME VARCHAR(100) N Holds the table_name of the row that was inserted
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.