Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BENEFITS ADJUSTMENT REASON Table


This table contains benefits adjustment reason codes and descriptions.


Field Name

Description

Data Type

Length

BENEFITS_ADJUSTMENT_REASON_KEY

Use this field to join the BENEFITS_ADJUSTMENT_REASON table to fact tables that also have this field. It should be not used to display in reports.

VARCHAR2

4

BENEFITS_ADJ_REASON

The description of the benefits adjustment reason.

VARCHAR2

20

BENEFITS_ADJ_REASON_CODE

The code identifying the benefits adjustment reason.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE

8