Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EL REQUIREMENT TRIGGER Table


View exposing requirement trigger reference values used to identify events or conditions that create EHS training and compliance requirements.


Field Name

Description

Data Type

Length

EL_REQUIREMENT_TRIGGER_KEY

Surrogate key identifying the el requirement trigger.

VARCHAR2

50

TRIGGER_DESCRIPTION

Description of trigger.

VARCHAR2

100

TRIGGER_ID

Business identifier for the trigger.

VARCHAR2

45

TRIGGER_TYPE

Trigger type associated with the record.

VARCHAR2

40

TRIGGER_TYPE_CODE

Code identifying trigger type.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

TIMESTAMP(6)