Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BENEFITS RECIPIENT Table


A record exists in this table for each person who receives health, insurance, or flexible spending account benefits at MIT. Therefore, there are records not just for employees, but for their dependents.


Field Name

Description

Data Type

Length

AGE

*** In HR tables, this field contains the person's age in years as calculated by the HR System's Age Calculating Device. *** In STUDENT tables, this field contains the age of the person.

NUMBER

3

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

DATE_OF_BIRTH

The person's date of birth.

DATE

8

DEPENDENT_DOCS_REQUIRED_FLAG

XXX

VARCHAR2

1

FAMILY_RELATIONSHIP

Relationship between employee and the recipient under the same health plan. E.g.: Child, Spouse, Self, Spousal Equivalent, Divorced spouse.

VARCHAR2

40

FIRST_NAME

The person's first name.

VARCHAR2

30

FULL_NAME

The full name of the person.

VARCHAR2

90

GENDER

The person's gender.

VARCHAR2

30

GENDER_CODE

Gender code.

VARCHAR2

1

HEALTH_INSURANCE_CLAIM_NUMBER

XXX

VARCHAR2

20

INITIAL_PCP_ID

Used by some medical plans: primary care provider ID number at the time of the enrollment in the plan

VARCHAR2

20

INITIAL_PCP_NAME

Used by some medical plans: primary care provider name at the time of the enrollment in the plan

VARCHAR2

30

IS_DISABLED_DEPENDENT

XXX

VARCHAR2

1

IS_STUDENT

In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period).

VARCHAR2

1

LAST_NAME

The person's last name.

VARCHAR2

30

LAST_UPDATE_DATE

Date the description was created or last altered.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

RECORD_COUNTER

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

NUMBER

1

SOCIAL_SECURITY_NUMBER

The person's Social Security Number

VARCHAR2

15

SUFFIX

Name suffix (e.g., "III", "Jr.", "Sr", etc.

VARCHAR2

15

WAREHOUSE_LOAD_DATE

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

DATE

8