Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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