DM_PURGE_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM Purge History |
Definition: | Holds changes made to purge jobs like when it was activated and when answers to questions were changed. |
Table Type: | ACTIVITY |
Column Detail - DM_PURGE_HISTORY
Column Name | Type | Null? | Definition |
---|---|---|---|
CHANGE_TYPE | VARCHAR(12) | N | Which value changed regarding the purge job. Must be one of the following: 'ACTIVE_FLAG', 'PURGE_FLAG', 'MAX_ROWS', or 'TOKEN'. |
DM_PURGE_HISTORY_ID | DOUBLE | N | Primary Key from sequence DM_CLINICAL_SEQ |
JOB_ID | DOUBLE | N | The purge job ID that his change was made to. FK from DM_PURGE_JOB |
NEW_TOKEN_STRING_VALUE | VARCHAR(255) | N | The value of a character token after it was changed in Purge Job Manager. |
NEW_VALUE | DOUBLE | N | The value of a numeric token after it was changed in Purge Job Manager |
OLD_TOKEN_STRING_VALUE | VARCHAR(255) | N | The value of a character token before it was changed in Purge Job Manager. |
OLD_VALUE | DOUBLE | N | The value of a numeric token before it was changed in Purge Job Manager |
TOKEN_STR | VARCHAR(255) | Y | If the change type is 'TOKEN' this will be filled out with the token_str from DM_PURGE_JOB_TOKEN that is changing. |
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_PURGE_HISTORY
Child Column in DM_PURGE_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | JOB_ID | DM_PURGE_JOB | JOB_ID |
DM_PURGE_JOB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Purge Job |
Definition: | This table holds the list of purge jobs that have been defined. |
Table Type: | REFERENCE |
Column Detail - DM_PURGE_JOB
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_FLAG | DOUBLE | Y | Defines the active status of the job - e.g. active, inactive, changed. 1 - Active; 2 - Inactive; 4 - Template Changed |
JOB_ID | DOUBLE | N | Unique identified for purge jobs. |
LAST_RUN_DT_TM | DATETIME | Y | Last time this job was run whether successful or not. |
LAST_RUN_STATUS_FLAG | DOUBLE | Y | Status - e.g. success, failure - of the last time this job was run. 1 - Success; 2 - Failure |
MAX_ROWS | DOUBLE | Y | Maximum number of top-level rows which should be deleted during any run of this job. |
PURGE_FLAG | DOUBLE | Y | Mode to run the purge job in - e.g. audit, purge with high or low level logging. 1 - Job-level purging; 2 - Table-level purging; 3 - Audit mode |
TEMPLATE_NBR | DOUBLE | Y | Number (id) of the purge template that this job uses. |
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_PURGE_JOB
Parent Column in DM_PURGE_JOB (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | JOB_ID | DM_PURGE_HISTORY | JOB_ID |
DM_PURGE_JOB_LOG | JOB_ID | ||
DM_XNT_JOB_LOG | JOB_ID | ||
DM_XNT_JOB_LOG_DTL | JOB_ID |
DM_PURGE_JOB_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Purge Job Log |
Definition: | Shows the execution log of purge jobs in the client's environment. |
Table Type: | ACTIVITY |
Column Detail - DM_PURGE_JOB_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_ROWS | DOUBLE | Y | Number of child rows purged. |
END_DT_TM | DATETIME | Y | Date/time the job ended. |
ERR_CODE | DOUBLE | Y | Error code for job failures. |
ERR_MSG | VARCHAR(255) | Y | Error message for job failures. |
JOB_ID | DOUBLE | N | Identifies the purge job that ran. |
LOG_ID | DOUBLE | N | Unique id for this run of this job. |
PARENT_ROWS | DOUBLE | Y | Number of parent rows purged. |
PARENT_TABLE | VARCHAR(30) | Y | Top-level table which is being purged. |
PURGE_FLAG | DOUBLE | Y | Mode to run the purge job in - e.g. audit, purge with high or low level logging. |
START_DT_TM | DATETIME | Y | Time the purge job started. |
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_PURGE_JOB_LOG
Child Column in DM_PURGE_JOB_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | JOB_ID | DM_PURGE_JOB | JOB_ID |
Parent Column in DM_PURGE_JOB_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LOG_ID | DM_PURGE_JOB_LOG_TIMING | LOG_ID |
DM_PURGE_JOB_LOG_TAB
Column Section | Top of Page |
Table-level Detail
Description: | DM PURGE JOB LOG TAB |
Definition: | Table level logging information for purge job runs. |
Table Type: | ACTIVITY |
Column Detail - DM_PURGE_JOB_LOG_TAB
Column Name | Type | Null? | Definition |
---|---|---|---|
JOB_ID | DOUBLE | N | Unique id for this purge job. |
LOG_ID | DOUBLE | N | Unique id for purge job log. |
NUM_ROWS | DOUBLE | Y | Number of rows purged in this table. |
PURGE_FLAG | DOUBLE | Y | Mode to run the purge job in - e.g. audit, purge with high or low level logging. |
TABLE_NAME | VARCHAR(30) | N | Name of table which was purged. |
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_PURGE_JOB_LOG_TIMING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM_PURGE_JOB_LOG_TIMINGS |
Definition: | A table to store the timings of individual runs of purge templates |
Table Type: | ACTIVITY |
Column Detail - DM_PURGE_JOB_LOG_TIMING
Column Name | Type | Null? | Definition |
---|---|---|---|
JOB_LOG_TIMING_ID | DOUBLE | N | A non-intelligent key for each row; populated from DM_CLINICAL_SEQ sequence |
LOG_ID | DOUBLE | N | Foreign key referencing DM_PURGE_JOB_LOG |
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. |
VALUE_KEY | VARCHAR(40) | N | The text key which, in conjunction with the LOG_ID, can be used to determine a value stored for a particular purge template run |
VALUE_NBR | DOUBLE | N | A value corresponding to the value key. |
Relationship Detail - DM_PURGE_JOB_LOG_TIMING
Child Column in DM_PURGE_JOB_LOG_TIMING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOG_ID | DM_PURGE_JOB_LOG | LOG_ID |