Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS FUNCTION Table


Information about people Functions within an EHS system


Field Name

Description

Data Type

Length

EHS_FUNCTION_DESCRIPTION

A longer description of a person's function within a Room Set.

VARCHAR2

255

EHS_FUNCTION_KEY

The internal key for a function within a Room Set. Use this for joining with ehs_function and detail tables.

NUMBER

22

EHS_FUNCTION_NAME

The name of a person's function within a Room Set.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8