EHI_ACT_TABLE_GTTD



Column Section Top of Page


Table-level Detail

Description: EHI ACTIVITY TABLE GLOBAL TEMP TABLE DATA
Definition: Global temporary table used to hold a list of activity table names that are to have data extracted from it during an EHI extract
Table Type: ACTIVITY





Column Detail - EHI_ACT_TABLE_GTTD


Column Name Type Null? Definition
TABLE_NAME VARCHAR(30) N A Table Name from the list of Activity tables being processed


EHI_COL_EXCEPTION



Column Section Top of Page


Table-level Detail

Description: EHI COLUMN EXCEPTION
Definition: Holds the list of table columns that will not be extracted from during an EHI Export.
Table Type: ACTIVITY





Column Detail - EHI_COL_EXCEPTION


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N Name of the column being excluded
EHI_COL_EXCEPTION_ID DOUBLE N PRIMARY KEY - Unique generated number that identifies a single row
TABLE_NAME VARCHAR(30) N Name of the table being excluded
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.


EHI_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EHI PLAN
Definition: Contains predefined EHI tasks for each request
Table Type: ACTIVITY





Column Detail - EHI_PLAN


Column Name Type Null? Definition
EHI_EXTRACT_SIZE_BYTES DOUBLE Y The size of the extract file in bytes
EHI_PLAN_ID DOUBLE N PRIMARY KEY - Unique generated number that identifies a single row
EHI_QUEUE_ID DOUBLE N Request from EHI_QUEUE table.
PLAN_END_TS DATETIME(6) Y The time that the task ended
PLAN_NAME VARCHAR(50) N Plan name for the task
PLAN_START_TS DATETIME(6) Y The time that the task started
PLAN_STATUS_DETAIL_TXT VARCHAR(4000) Y Detailed description of the status
PLAN_STATUS_TFLG VARCHAR(16) Y Current status of the plan
PLAN_STATUS_TS DATETIME(6) Y Date and time that the status was updated
RETRY_CNT DOUBLE Y The number of times the plan has been tried
STATUS_DETAIL_EXT_CLOB LONGTEXT Y Extended space for detail description of the status
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_PLAN


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


EHI_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: EHI QUEUE
Definition: Holds the list of EHI Export requests
Table Type: ACTIVITY





Column Detail - EHI_QUEUE


Column Name Type Null? Definition
AUTHORIZATION_RECEIVED_IND DOUBLE Y Indicator that specifies if an authorization was given for the extract
COMMENTS_TXT VARCHAR(100) Y Comments associated with this extract
DESTINATION_TXT VARCHAR(50) Y The location of where the extract files will be stored
EHI_QUEUE_ID DOUBLE N PRIMARY KEY - Unique generated number that identifies a single row
EXTRACT_STATUS_DETAIL_TXT VARCHAR(4000) Y Expanded description of the status of the EHI Extract request
EXTRACT_STATUS_TS DATETIME(6) Y Date and time that the satus of the request for the EHI Extract was updated
EXTRACT_STATUS_TXT VARCHAR(16) Y Status of the EHI Extract request
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PRSNL_ID DOUBLE Y Identifier for person that is being extracted
PURPOSE_NBR DOUBLE Y The reason for the extract
REQUESTER_TXT VARCHAR(80) Y Name of the person/orginzation that requested the extract
REQUEST_DT_TM DATETIME Y Date and time that the request for the EHI Extract was made
REQUEST_TYPE_TFLG VARCHAR(50) Y The type of EHI Export that has been requested
RESULTS_TXT VARCHAR(500) Y Text that indicates the final status of the request
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_QUEUE


Child Column in EHI_QUEUE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in EHI_QUEUE (PK) Child Table Name Child Column Name
Children: EHI_QUEUE_ID EHI_PLAN EHI_QUEUE_ID
EHI_QUEUE_PERSON_RELTN EHI_QUEUE_ID
EHI_REF_DATA_CACHE EHI_QUEUE_ID


EHI_QUEUE_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: EHI QUEUE PERSON MAP
Definition: Store list of person_id for each EHI request
Table Type: ACTIVITY





Column Detail - EHI_QUEUE_PERSON_RELTN


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.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
EHI_QUEUE_ID DOUBLE N Unique identifier for an EHI Queue
EHI_QUEUE_PERSON_RELTN_ID DOUBLE N PRIMARY KEY - Unique generated number that identifies a single row
PERSON_ID DOUBLE N Unique identifier for a person
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_QUEUE_PERSON_RELTN


Child Column in EHI_QUEUE_PERSON_RELTN(FK) Parent Table Name Parent Column Name
Parents: EHI_QUEUE_ID EHI_QUEUE EHI_QUEUE_ID
PERSON_ID PERSON PERSON_ID