Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PENSION MIT MEDICAL DETAIL Table


MIT Medical health plan enrollment records of Pension Annuitants


Field Name

Description

Data Type

Length

ALTERNATE_PLAN_ID

XXX

VARCHAR2

20

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_PLAN_KEY

Key field used to join to the BENEFITS_PLAN table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

BENEFITS_RECIPIENT_KEY

Key field used to join to the BENEFITS_RECIPIENT table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

14

EFFECTIVE_DATE

In the COST COLLECTOR table: this represents the effective date or starting date of the fund cost collector. In the ASA OFFICER DETAIL table this is the starting date of the tenure of the officer.

DATE

8

EXPIRATION_DATE

In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires.

DATE

8

FSA_AMOUNT

The amount set-aside in the Flexible Spending Account

NUMBER

22

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PERSONNEL_KEY

Key field used to join to the PERSONNEL table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

8

PLAN_ENROLLMENT_TYPE

XXX

VARCHAR2

30

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

WAREHOUSE_LOAD_DATE

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

DATE

8