Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHSIN INJURY DETAIL Table


View exposing EHS incident injury detail including injury descriptions, injured body parts, and audit attributes.


Field Name

Description

Data Type

Length

CREATE_DATE

Date associated with create.

DATE

CREATE_USER

Create user associated with the record.

VARCHAR2

12

EHSIN_INCIDENT_KEY

Surrogate key identifying the ehsin incident.

VARCHAR2

20

EHSIN_INJURY_SEQ

Ehsin injury seq associated with the record.

NUMBER

19

INJURED_BODY_PART

Injured body part associated with the record.

VARCHAR2

132

INJURED_BODY_PART_ADDL

Injured body part addl associated with the record.

VARCHAR2

132

INJURY_DESCRIPTION

Description of injury.

VARCHAR2

132

INJURY_DESCRIPTION_ADDL

Injury description addl associated with the record.

VARCHAR2

132

UPDATE_DATE

Date associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE