Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


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

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.