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 |