Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHSIN CHARACTERISTIC DETAIL Table


View exposing EHS incident characteristic detail by incident and characteristic including characteristic value, record counter, and warehouse load date.


Field Name

Description

Data Type

Length

EHSIN_CHARACTERISTIC_KEY

Surrogate key identifying the ehsin characteristic.

NUMBER

10

EHSIN_INCIDENT_KEY

Surrogate key identifying the ehsin incident.

NUMBER

20

INCIDENT_CHARACTERISTIC_VALUE

Incident characteristic value associated with the record.

VARCHAR2

132

RECORD_COUNTER

Record counter associated with the record.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE