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