Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHST CERT TRIGGER Table


View exposing reference values describing events or conditions that trigger Environment, Health, and Safety certification requirements.


Field Name

Description

Data Type

Length

EHST_CERT_TRIGGER_CODE

Code identifying ehst cert trigger.

VARCHAR2

20

EHST_CERT_TRIGGER_KEY

Surrogate key identifying the ehst cert trigger.

VARCHAR2

21

EHST_CERT_TRIGGER_NAME

Ehst cert trigger name associated with the record.

VARCHAR2

60

EHST_CERT_TRIGGER_SORT

Ehst cert trigger sort associated with the record.

NUMBER

10

EHST_CERT_TRIGGER_STATUS_CODE

Code identifying ehst cert trigger status.

VARCHAR2

1

EHST_CERT_TRIGGER_TYPE_CODE

Code identifying ehst cert trigger type.

VARCHAR2

1

EHST_CERT_TRIGGER_TYPE_NAME

Ehst cert trigger type name associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE