Table Detail Report

DM_PURGE_JOB_TOKEN



Column Section Top of Page


Table-level Detail

Description: DM PURGE JOB TOKEN
Definition: Answers to client question regarding HNAM Purge jobs.
Table Type: REFERENCE





Column Detail - DM_PURGE_JOB_TOKEN


Column Name Type Null? Definition
JOB_ID DOUBLE N Unique id for Purge job.
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.
VALUE VARCHAR(255) Y Value entered for a question asked for a purge job.


DM_PURGE_ROWID_LIST_GTTP



Column Section Top of Page


Table-level Detail

Description: Global Temp Table for PURGE
Definition: Global Temporary Table used for Purge process to track table purges. Temp data will be preserved until session terminates.
Table Type: ACTIVITY





Column Detail - DM_PURGE_ROWID_LIST_GTTP


Column Name Type Null? Definition
PURGE_TABLE_ROWID VARCHAR(10) Y A ROWID value of a table that is purged by the purge process


DM_PURGE_TABLE



Column Section Top of Page


Table-level Detail

Description: DM PURGE TABLE
Definition: Table relationships for purge templates.
Table Type: REFERENCE





Column Detail - DM_PURGE_TABLE


Column Name Type Null? Definition
CHILD_COL1 VARCHAR(30) Y Child join column 1.
CHILD_COL2 VARCHAR(30) Y Child join column 2.
CHILD_COL3 VARCHAR(30) Y Child join column 3.
CHILD_COL4 VARCHAR(30) Y Child join column 4.
CHILD_COL5 VARCHAR(30) Y Child join column 5.
CHILD_TABLE VARCHAR(30) Y Child table.
CHILD_WHERE VARCHAR(255) Y Where clause to attach when performing a purge on the child table.
FEATURE_NBR DOUBLE Y Rev Tool Feature number to which this purge template was promoted.
PARENT_COL1 VARCHAR(30) Y Parent join column 1.
PARENT_COL2 VARCHAR(30) Y Parent join column 2.
PARENT_COL3 VARCHAR(30) Y Parent join column 3.
PARENT_COL4 VARCHAR(30) Y Parent join column 4.
PARENT_COL5 VARCHAR(30) Y Parent join column 5.
PARENT_TABLE VARCHAR(30) Y Parent table.
PURGE_TYPE_FLAG DOUBLE Y Purge Type. 0 - indicative of a root table in a purge template's table hierarchy; 1 - Data will be deleted from child table; 2 - All inherited values on the child table will be set to 0, effectively disassociating the child row from the parent row; 5 - indicative of a root table in an XNT template's table hierarchy; 6 - indicative of a child table in an XNT template's table hierarchy.
SCHEMA_DT_TM DATETIME Y Date/time this purge template modification was promoted in Feature Tracker.
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.


DM_PURGE_TABLE_INDEX



Column Section Top of Page


Table-level Detail

Description: DM_PURGE_TABLE_INDEXES
Definition: Store indexes and the columns used in those indexes by tables that participate as parent tables in the purge process
Table Type: REFERENCE





Column Detail - DM_PURGE_TABLE_INDEX


Column Name Type Null? Definition
ADMIN_TABLE_IND DOUBLE N An indicator of whether or not the given table is an admin table
COLUMN_NAME VARCHAR(31) N The name of a column used in an index
DATA_TYPE VARCHAR(31) N The data type of the column
INDEX_NAME VARCHAR(31) N The name of the index that is being used on the table
LAST_DDL_DT_TM DATETIME N The last date and time recorded that the table has been modified
PRECEDENCE_NBR DOUBLE N The order in which the column appears in the index
TABLE_INDEX_ID DOUBLE N A non-intelligent key for each row; populated from the DM_CLINICAL_SEQ sequence
TABLE_NAME VARCHAR(31) N The name of a table
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_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: DM PURGE TEMPLATE
Definition: HNAM purge job template information.
Table Type: REFERENCE





Column Detail - DM_PURGE_TEMPLATE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
FEATURE_NBR DOUBLE N Rev Tool Feature number to which this purge template was promoted.
NAME VARCHAR(255) Y Name of the purge template. This will be displayed to the client.
PROGRAM_STR VARCHAR(255) Y Name of CCL program which needs to be run to get the top-level table's rowids.
SCHEMA_DT_TM DATETIME Y Date/time this purge template modification was promoted in Feature Tracker.
TEMPLATE_NBR DOUBLE N 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.