Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS ROLES FUNCTION Table


EHS Roles function


Field Name

Description

Data Type

Length

EHS_ROLES_FUNCTION_CATEGORY

The category of this Roles DB function. In this table, it will always be 'EHS'.

VARCHAR2

30

EHS_ROLES_FUNCTION_DESC

A longer description of the Roles DB function.

VARCHAR2

50

EHS_ROLES_FUNCTION_KEY

Key field used to join to the EHS_ROLES_FUNCTION table. This field should only be used for joining data, NOT for reporting

NUMBER

6

EHS_ROLES_FUNCTION_NAME

The name of the Roles DB function.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8