EHST CERT TRIGGER Table
EHS Training certification trigger
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_CERT_TRIGGER_CODE |
Code for the specific trigger (within the trigger type). For DLCs, this is the DLC code (e.g., D_Biology, D_EECS. Etc.). For other trigger types, this code will probably not be useful to anyone except for systems administrators. |
VARCHAR2 |
20 |
EHST_CERT_TRIGGER_KEY |
Key for a person's Certification Type trigger that should be used for joining with the detail table. (A Certification Type trigger is a self-reported job function, HR job title, DLC, or other factor that indicates that a person needs to fulfill the requirements of a given Certification Type). |
VARCHAR2 |
21 |
EHST_CERT_TRIGGER_NAME |
The name of the trigger, e.g., the job title, self-reported job function, DLC, etc.. |
VARCHAR2 |
60 |
EHST_CERT_TRIGGER_SORT |
Order in which triggers are normally sorted. |
NUMBER |
10 |
EHST_CERT_TRIGGER_STATUS_CODE |
'A' means trigger is 'active' or in use in the system. 'I' means that the trigger is no longer used in the system, but may remain there for historical reasons. |
VARCHAR2 |
1 |
EHST_CERT_TRIGGER_TYPE_CODE |
Code for the type of trigger (e.g., D=DLC, T=job title, etc.). |
VARCHAR2 |
1 |
EHST_CERT_TRIGGER_TYPE_NAME |
Name of the type of trigger. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |