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. |