Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EL REQUIREMENT TRIGGER AUTH Table


View exposing authorized requirement trigger reference values used in EHS training and compliance assignment logic.


Field Name

Description

Data Type

Length

AUTH_FLAG

Auth flag associated with the record.

CHAR

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

WAREUSER_LOAD_DATE

Date associated with wareuser load.

TIMESTAMP(6)