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