Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BENEFITS LOOKUP Table


View exposing benefits lookup reference data including lookup type, code, description, and timestamp used for benefits reporting and application logic.


Field Name

Description

Data Type

Length

CODE

Code as provided by the source.

VARCHAR2

12

DESCRIPTION

Description as provided by the source.

VARCHAR2

100

LOOKUP_TYPE

Lookup type as provided by the source.

VARCHAR2

6

TIMESTAMP

Timestamp as provided by the source.

DATE