Table Detail Report

EHI_REF_DATA_CACHE



Column Section Relationship Section Top of Page


Table-level Detail

Description: EHI REFERENCE DATA CACHE
Definition: Store Reference data during EHI processing
Table Type: ACTIVITY





Column Detail - EHI_REF_DATA_CACHE


Column Name Type Null? Definition
EHI_QUEUE_ID DOUBLE N Unique identifier used as a foreign key to the EHI_QUEUE table
EHI_REF_DATA_CACHE_ID DOUBLE N PRIMARY KEY - Unique generated number that identifies a single row
REFERENCE_KEY VARCHAR(80) N Store Reference table name and column_name used to extract Reference data for EHI
REFERENCE_KEY_VALUE VARCHAR(4000) Y Contains value stored in reference key column
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - EHI_REF_DATA_CACHE


Child Column in EHI_REF_DATA_CACHE(FK) Parent Table Name Parent Column Name
Parents: EHI_QUEUE_ID EHI_QUEUE EHI_QUEUE_ID


EHI_TABLE_STMT_GTTP



Column Section Top of Page


Table-level Detail

Description: EHI TABLE STATEMENT GLOBAL TEMPORARY TABLE
Definition: "Used to store parent/child table relationships and the SQL statements that will be used to extract activity data for EHI." ;
Table Type: ACTIVITY





Column Detail - EHI_TABLE_STMT_GTTP


Column Name Type Null? Definition
CHILD_COL_STR VARCHAR(200) N Store Child column name
CHILD_TABLE VARCHAR(30) N The table that is the child table of this record
COL_LIST VARCHAR(2000) Y The list of columns to be queried
DRR_CHILD_TABLE VARCHAR(30) N The table that is the DRR child table of this record
DRR_PARENT_TABLE VARCHAR(30) N The table that is the DRR parent to this record
DUP_IND DOUBLE Y Flag duplicate records
EHI_TABLE_STMT_ID DOUBLE N This is a key column for the global temp table. It is not an official Primary Key.
HIER_LEVEL_NBR DOUBLE N The level within a hierachical structure that this record represents
HIER_PATH VARCHAR(2000) Y The path used to navigate to the level within the hierachical structure that this record represents
INSERT_STMT VARCHAR(4000) Y The sql statement used to insert data for the EHI Extract
INS_ORDER DOUBLE N Indicates table relationships order level
PARENT_TABLE VARCHAR(30) N The table that is the parent to this record
PAR_COL_STR VARCHAR(200) N Store parent column name
SELECT_STMT VARCHAR(4000) Y The sql statement used to select data for the EHI Extract