BENEFITS ADJUSTMENT REASON Table
View exposing benefits adjustment reason reference data including reason codes and descriptions used for benefits reporting and administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFITS_ADJUSTMENT_REASON_KEY |
Surrogate key identifying the benefits adjustment reason. |
VARCHAR2 |
4 |
BENEFITS_ADJ_REASON |
Benefits adj reason as provided by the source. |
VARCHAR2 |
20 |
BENEFITS_ADJ_REASON_CODE |
Code identifying benefits adj reason. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |