BENEFITS PERSON EMPLOYEE Table
View exposing employee master and eligibility attributes used for benefits reporting including person identifiers, names, demographics, employment attributes, organizational assignments, contact information, and benefits eligibility dates.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADJUSTED_SERVICE_DATE |
Date associated with adjusted service. |
DATE |
|
ADMIN_DEPARTMENT_OVERRIDE |
Admin department override as provided by the source. |
VARCHAR2 |
8 |
ADMIN_EMPLOYEE_TYPE |
Admin employee type as provided by the source. |
VARCHAR2 |
40 |
ADMIN_JOB_TITLE |
Admin job title as provided by the source. |
VARCHAR2 |
40 |
ADMIN_ORG_UNIT_ID |
Business identifier for the admin org unit. |
VARCHAR2 |
8 |
ADMIN_ORG_UNIT_TITLE |
Admin org unit title as provided by the source. |
VARCHAR2 |
75 |
ADMIN_POSITION_TITLE |
Admin position title as provided by the source. |
VARCHAR2 |
50 |
AGE |
Age as provided by the source. |
NUMBER |
|
AGE_BY_FISCAL_YEAR |
Age by fiscal year as provided by the source. |
NUMBER |
|
ALT_INTEROFFICE_MAIL_FLAG |
Alt interoffice mail flag as provided by the source. |
VARCHAR2 |
1 |
ALT_OFFICE_ADDRESS |
Alt office address as provided by the source. |
VARCHAR2 |
40 |
ALT_OFFICE_ADDR_BUILDING |
Alt office addr building as provided by the source. |
VARCHAR2 |
15 |
ALT_OFFICE_ADDR_ROOM |
Alt office addr room as provided by the source. |
VARCHAR2 |
20 |
ALT_OFFICE_ADDR_SITE |
Alt office addr site as provided by the source. |
VARCHAR2 |
2 |
ALT_OFFICE_PHONE |
Alt office phone as provided by the source. |
VARCHAR2 |
15 |
APPOINTMENT_END_DATE |
Date associated with appointment end. |
DATE |
|
CURRENT_EMPLOYMENT_DATE |
Date associated with current employment. |
DATE |
|
DATE_OF_BIRTH |
Date of birth associated with the person or recipient. |
DATE |
|
DATE_OF_BIRTH_MMYYYY |
Date of birth mmyyyy as provided by the source. |
VARCHAR2 |
43 |
DATE_OF_DEATH |
Date of death as provided by the source. |
DATE |
|
DATE_TO_STAFF |
Date to staff as provided by the source. |
DATE |
|
DIRECTORY_ORG_UNIT_ID |
Business identifier for the directory org unit. |
VARCHAR2 |
8 |
DIRECTORY_ORG_UNIT_TITLE |
Directory org unit title as provided by the source. |
VARCHAR2 |
75 |
DIRECTORY_SUPPRESS_FLAG |
Directory suppress flag as provided by the source. |
VARCHAR2 |
1 |
DIRECTORY_TITLE |
Directory title as provided by the source. |
VARCHAR2 |
50 |
ELIGIBILITY_END_DATE |
Date associated with eligibility end. |
DATE |
|
ELIGIBILITY_START_DATE |
Date associated with eligibility start. |
DATE |
|
ELIG_PROGRAM_GROUP_1 |
Elig program group 1 as provided by the source. |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_1_CODE |
Code identifying elig program group 1. |
VARCHAR2 |
4 |
ELIG_PROGRAM_GROUP_2 |
Elig program group 2 as provided by the source. |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_2_CODE |
Code identifying elig program group 2. |
VARCHAR2 |
4 |
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
100 |
EMPLOYEE_GROUP |
Employee group as provided by the source. |
VARCHAR2 |
40 |
EMPLOYEE_GROUP_CODE |
Code identifying employee group. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Employee subgroup as provided by the source. |
VARCHAR2 |
40 |
EMPLOYEE_SUBGROUP_CODE |
Code identifying employee subgroup. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Employee type as provided by the source. |
VARCHAR2 |
40 |
EMPLOYMENT_STATUS |
Employment status as provided by the source. |
VARCHAR2 |
40 |
ETHNIC_ORIGIN |
Ethnic origin as provided by the source. |
VARCHAR2 |
50 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
40 |
FIRST_NAME_UPPER |
First name upper as provided by the source. |
VARCHAR2 |
40 |
FORM_OF_ADDRESS_SHORT |
Form of address short as provided by the source. |
VARCHAR2 |
5 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
100 |
FULL_NAME_UPPERCASE |
Full name uppercase as provided by the source. |
VARCHAR2 |
100 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
15 |
HOME_ADDRESS_LINE_1 |
Home address line 1 as provided by the source. |
VARCHAR2 |
60 |
HOME_ADDRESS_LINE_2 |
Home address line 2 as provided by the source. |
VARCHAR2 |
40 |
HOME_ADDR_CARE_OF |
Home addr care of as provided by the source. |
VARCHAR2 |
40 |
HOME_CITY |
Home city as provided by the source. |
VARCHAR2 |
40 |
HOME_COUNTRY |
Home country as provided by the source. |
VARCHAR2 |
20 |
HOME_PHONE |
Home phone as provided by the source. |
VARCHAR2 |
15 |
HOME_STATE |
Home state as provided by the source. |
VARCHAR2 |
3 |
HOME_ZIP |
Home zip as provided by the source. |
VARCHAR2 |
10 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Hr org unit title as provided by the source. |
VARCHAR2 |
75 |
INTEROFFICE_MAIL_FLAG |
Interoffice mail flag as provided by the source. |
VARCHAR2 |
1 |
IT1_PERSONNEL_SUBAREA |
It1 personnel subarea as provided by the source. |
VARCHAR2 |
30 |
IT1_PERSONNEL_SUBAREA_CODE |
Code identifying it1 personnel subarea. |
VARCHAR2 |
4 |
JOB_TITLE |
Job title as provided by the source. |
VARCHAR2 |
40 |
KRB_NAME_UPPERCASE |
Krb name uppercase as provided by the source. |
VARCHAR2 |
30 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
40 |
LAST_NAME_UPPER |
Last name upper as provided by the source. |
VARCHAR2 |
40 |
LAST_TERM_DATE |
Date associated with last term. |
DATE |
|
LOA_RETURN_DATE |
Date associated with loa return. |
DATE |
|
LOA_START_DATE |
Date associated with loa start. |
DATE |
|
MIDDLE_NAME |
Middle name as provided by the source. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NAME_KNOWN_BY |
Name known by as provided by the source. |
VARCHAR2 |
40 |
NAME_PREFIX |
Name prefix as provided by the source. |
VARCHAR2 |
15 |
NAME_SUFFIX |
Name suffix as provided by the source. |
VARCHAR2 |
15 |
OFFICE_ADDRESS |
Office address as provided by the source. |
VARCHAR2 |
40 |
OFFICE_ADDR_BUILDING |
Office addr building as provided by the source. |
VARCHAR2 |
15 |
OFFICE_ADDR_ROOM |
Office addr room as provided by the source. |
VARCHAR2 |
15 |
OFFICE_ADDR_SITE |
Office addr site as provided by the source. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Office phone as provided by the source. |
VARCHAR2 |
15 |
ORIGINAL_HIRE_DATE |
Date associated with original hire. |
DATE |
|
PERSONAL_EMAIL_ADDR |
Personal email addr as provided by the source. |
VARCHAR2 |
100 |
PERSONAL_URL |
Personal url as provided by the source. |
VARCHAR2 |
150 |
PERSONNEL_AREA |
Personnel area as provided by the source. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
Code identifying personnel area. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
PERSONNEL_SUBAREA |
Personnel subarea as provided by the source. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
Code identifying personnel subarea. |
VARCHAR2 |
4 |
POSITION_TITLE |
Position title as provided by the source. |
VARCHAR2 |
50 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
|
RETIREMENT_DATE |
Date associated with retirement. |
DATE |
|
SALUTATION |
Salutation as provided by the source. |
VARCHAR2 |
1 |
SAP_STATUS |
Sap status as provided by the source. |
VARCHAR2 |
40 |
SIGNATURE_NAME |
Signature name as provided by the source. |
VARCHAR2 |
80 |
SOCIAL_SECURITY_NUMBER |
Social Security Number associated with the person or recipient. |
VARCHAR2 |
9 |
SUBSCRIBER_ASSOC_PERSONNEL_KEY |
Surrogate key identifying the subscriber assoc personnel. |
VARCHAR2 |
8 |
UNION_SENIORITY_DATE |
Date associated with union seniority. |
DATE |
|
VACATION_ELIG_DATE |
Date associated with vacation elig. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |