Data Warehouse

ADJUSTED_SERVICE_DATE

Adjusted seniority. An adjustment to the last employment date for reinstated employees. Used in calculating vacation earned and applicable benefits according to the Personnel Policy Manual.

DATE

8

ADMIN_DEPARTMENT_OVERRIDE

If an employee has concurrent appointments, the adminitstrative department is assumed to be that of the appointment with the greater FTE% or, in the case of dual appointments, that of the headcount appointment. This field is used to override the default adminitrative department

VARCHAR2

8

ADMIN_EMPLOYEE_TYPE

This field contains employee type (Faculty, Support Staff, etc.) as defined by their position in their admin department. For people with only one position, this is always the same as EMPLOYEE_TYPE.

VARCHAR2

40

ADMIN_JOB_ID

MIT job Id of the employee's administrative appointment

VARCHAR2

8

ADMIN_JOB_TITLE

The title of the job of the administrative appointment

VARCHAR2

40

ADMIN_ORG_UNIT_ID

The SAP 8-digit object id assigned to the employee's administrative org unit.

VARCHAR2

8

ADMIN_ORG_UNIT_TITLE

The title of employee's administrative org unit.

VARCHAR2

75

ADMIN_POSITION_ID

The SAP 8-digit position id

VARCHAR2

8

ADMIN_POSITION_TITLE

The title of the position of the administrative appointment

VARCHAR2

50

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

AGE_BY_FISCAL_YEAR

The person's age as of June 30, the end of the fiscal year, as calculated by the HR System's aforementioned Device. For example, a person's FY2000 age is the person's age on June 30, 2000.

NUMBER

3

ALT_INTEROFFICE_MAIL_FLAG

Inter-office mail flag for the alternate office address

VARCHAR2

1

ALT_OFFICE_ADDRESS

Employee's alternate office address, for example W92-101, LL-B 341

VARCHAR2

40

ALT_OFFICE_ADDR_BUILDING

The employee's alternate building location, for example, E19

VARCHAR2

15

ALT_OFFICE_ADDR_ROOM

The employee's alternate mail location within the building, for example,. 215

VARCHAR2

15

ALT_OFFICE_ADDR_SITE

The employee's alternate site code, for example, LL (Lincoln Lab), MC (Main Campus), OS (other site)

VARCHAR2

2

ALT_OFFICE_PHONE

The employee's alternate site location, ie. E19

VARCHAR2

15

APPOINTMENT_END_DATE

This field is used in several HR tables. In HR_PERSON_EMPLOYEE and HR_PERSON_EMPLOYEE_LIMITED, it is the latest last date or expected last date of the person's appointments. If there are no appointment records for the person in SAP HR, this date is set to LAST_TERM_DATE (termination date). In HR_APPOINTMENT_DETAIL and HR_APPT_TX_DETAIL, it is the end date of an uninterrupted appointment to a specific MIT position. Changes to the appointment, such as salary increases, one-time payments, changes in effort etc. do not affect this date, but are reflected in appointment transactions: APPT_TX_BEGIN_DATE and APPT_TX_END_DATE in HR_APPT_TX_DETAIL.
In GRADUATE_AWARD_APPOINTMENT, this is the end date of an assigned graduate appointment/award.

DATE

8

CASE_VERIFICATION_NUMBER

XXX

VARCHAR2

20

CELL_PHONE

The employee's cell phone number.

VARCHAR2

15

CONTRACT_CODE

XXX

VARCHAR2

2

CONTRACT_DESCRIPTION

XXX

VARCHAR2

20

COUNTRY_OF_CITIZENSHIP

The country where the person has citizenship.

VARCHAR2

30

COUNTRY_OF_CITIZENSHIP_2

XXX

VARCHAR2

15

COUNTRY_OF_CITIZENSHIP_3

XXX

VARCHAR2

15

COUNTRY_OF_CITIZENSHIP_CODE

The country where the person has citizenship.

VARCHAR2

3

COUNTRY_OF_CITIZENSHIP_CODE_2

XXX

VARCHAR2

3

COUNTRY_OF_CITIZENSHIP_CODE_3

XXX

VARCHAR2

3

CURRENT_EMPLOYMENT_DATE

The employee's most recent date of hire

DATE

8

DATE_OF_APPOINTMENT

XXX

DATE

8

DATE_OF_BIRTH

The person's date of birth.

DATE

8

DATE_OF_DEATH

The date of the employee's death.

DATE

8

DATE_TENURE_RELINQUISHED

XXX

DATE

8

DATE_TO_FACULTY

The date on which the person was made a faculty member.

VARCHAR2

10

DATE_TO_STAFF

Date the employee joined the staff

DATE

8

DIRECTORY_FULL_NAME

XXX

VARCHAR2

85

DIRECTORY_ORG_UNIT_ID

The 8-digit number of the organizational unit to be listed in the MIT directory.

VARCHAR2

8

DIRECTORY_ORG_UNIT_TITLE

This field holds the department title which appears in the directories (e.g., the online directory on the web) in case there is a department override provided by HR. If there is no override, the title of the administrative appointment 's org unit appears in the directory.

VARCHAR2

75

DIRECTORY_SUPPRESS_FLAG

xxx

VARCHAR2

1

DIRECTORY_TITLE

A person's position title as listed in the MIT directory; this will be the person's "preferred" title if they specify a descriptive title that differs from their official MIT title (Primary_Title).

VARCHAR2

50

DIR_LAST_NAME_SUFFIX

XXX

VARCHAR2

40

DISABILITY_STATUS

XXX

VARCHAR2

50

ELIG_PROGRAM_GROUP_1

XXX

VARCHAR2

30

ELIG_PROGRAM_GROUP_2

XXX

VARCHAR2

30

EMAIL_ADDRESS

A person's complete electronic mail address including user name and node name, for example, username@school.edu.

VARCHAR2

60

EMERGENCY_ADDR_CITY

Designated emergency contact's home city.

VARCHAR2

40

EMERGENCY_ADDR_COUNTRY

Designated emergency contact's home country.

VARCHAR2

20

EMERGENCY_ADDR_STATE

Designated emergency contact's home state.

VARCHAR2

10

EMERGENCY_ADDR_STREET1

Designated emergency contact's home address.

VARCHAR2

60

EMERGENCY_ADDR_STREET2

Designated emergency contact's home address line 2.

VARCHAR2

40

EMERGENCY_ADDR_ZIP

Designated emergency contact's zip code.

VARCHAR2

10

EMERGENCY_CELL_PHONE

The emergency contact's cell phone number.

VARCHAR2

20

EMERGENCY_CONTACT_EMAIL

The emergency contact's email address.

VARCHAR2

70

EMERGENCY_CONTACT_NAME

Person's designated contact to be notified in case of emergency.

VARCHAR2

30

EMERGENCY_CONTACT_RELATION

The relation of the person's emergency contact to employee, ie. spouse, or daughter.

VARCHAR2

20

EMERGENCY_HOME_PHONE

Designated emergency contact's telephone number at home.

VARCHAR2

20

EMERGENCY_WORK_PHONE

Designated emergency contact's telephone number at work.

VARCHAR2

20

EMPLOYEE_GROUP

Definition of EMPLOYEE_GROUP_CODE, identifying an employee grouping, e.g., Exempt, Non-Exempt, or External

VARCHAR2

30

EMPLOYEE_GROUP_CODE

Code identifying an employee grouping: E for Exempt, N for Non-Exempt, X for External.

VARCHAR2

1

EMPLOYEE_SUBGROUP

Further classifies employee into classified, monthly, or weekly paid.

VARCHAR2

30

EMPLOYEE_SUBGROUP_CODE

Further classifies employee group into classified, monthly, or weekly paid, EM for exempt monthly.

VARCHAR2

2

EMPLOYEE_TYPE

The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical.

VARCHAR2

30

EMPLOYMENT_STATUS

Identifies the most recent status of an employee, eg, Active, Leave, Retiree, Terminated, Deceased. NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record.

VARCHAR2

30

ETHNICITY_DESCRIPTION

XXX

VARCHAR2

100

ETHNIC_ORIGIN

The employee's ethnicity

VARCHAR2

50

ETHNIC_ORIGIN_INTERNAL

XXX

VARCHAR2

100

ETHNIC_ORIGIN_INTERNAL_CODE

XXX

VARCHAR2

2

FAX_NUMBER

The employee's FAX number.

VARCHAR2

31

FIRST_NAME

The person's first name.

VARCHAR2

30

FIRST_NAME_UPPER

The uppercase version of the employee's first name. Convenient for placing limits.

VARCHAR2

40

FORM_OF_ADDRESS_LONG

The long form of the honorific used to address the person, e.g., Doctor, Mr, Ms, Professor, Sir

VARCHAR2

15

FORM_OF_ADDRESS_SHORT

The short form of the honorific used to address the person, e.g., Dr.,Mr., Prof., Sir

VARCHAR2

5

FULL_NAME

The full name of the person.

VARCHAR2

90

FULL_NAME_UPPERCASE

The full name of the person. This is all uppercase, in the format "LAST-NAME, FIRST-NAME OPTIONAL-MIDDLE-NAME

VARCHAR2

100

FULL_RACE_DESCRIPTION

XXX

VARCHAR2

300

GENDER

The person's gender.

VARCHAR2

30

HAS_ADDL_APPOINTMENT

An indication that the employee has an additional appointment, Y or N.

VARCHAR2

1

HAS_CYBORG_HISTORY

XXX

VARCHAR2

1

HAS_DUAL_APPOINTMENT

An indicator that the employee has a dual appointment, Y or N.

VARCHAR2

1

HAS_FUTURE_APPT

XXX

VARCHAR2

1

HAS_MULTIPLE_APPTS

XXX

VARCHAR2

1

HAS_NO_POSITION_SUPPLEMENTS

XXX

VARCHAR2

1

HIGHEST_DEGREE_TYPE

Highest type of degree earned: bachelor's, master, doctorate, 2 year technical.

VARCHAR2

20

HIGHEST_DEGREE_TYPE_CODE

Highest degree code for the area of a major specialization.

VARCHAR2

2

HIGHEST_DEGREE_YEAR

XXX

VARCHAR2

4

HOME_ADDR_CARE_OF

"Care of" in the person's home address

VARCHAR2

40

HOME_ADDR_CITY

The city of the person's home address.

VARCHAR2

40

HOME_ADDR_COUNTRY

The country of the person's home address.

VARCHAR2

30

HOME_ADDR_STATE

The U.S. state code of the student's home address.

VARCHAR2

2

HOME_ADDR_STREET1

Home address, street line 1.

VARCHAR2

60

HOME_ADDR_STREET2

Home address, street line 2.

VARCHAR2

40

HOME_ADDR_ZIP

Zip code in home address

VARCHAR2

10

HOME_PHONE

The person's home telephone number.

VARCHAR2

20

HR_ORG_UNIT_ID

8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID.

VARCHAR2

8

HR_ORG_UNIT_TITLE

Name of the department, school, center, or lab. (Known as Org Units in SAP.)

VARCHAR2

75

HR_REMARKS

XXX

VARCHAR2

30

I9_FORM_EXPIRATION_DATE

XXX

DATE

7

I9_FORM_LOCATION

XXX

VARCHAR2

30

I9_FORM_LOCATION_CODE

XXX

VARCHAR2

1

INCLUDE_HOME_ADDR_IN_DIR

XXX

VARCHAR2

1

INTEROFFICE_MAIL_FLAG

XXX

VARCHAR2

1

IS_ACTIVE_WAR_CAMPGN_BADGE_VET

XXX

VARCHAR2

1

IS_ALT_OFFICE_PHONE_TTY

If the alternate office phone is TTY (telephone typewriter or text telephone), this field contains "Y", otherwise it contains "N"

VARCHAR2

1

IS_AMERICAN_INDIAN_ALASKA_NATV

If the employee has identified herself as American Indian or Alaska Native, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_ASIAN

If the employee has identified herself as Asian, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_A_F_SERVICE_MEDAL_VETERAN

If the person was serving on active duty in the U.S. Military and was awarded a service medal pursuant to Executive Order 12985, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_BLACK_OR_AFRICAN_AMERICAN

If the employee has identified herself as Black or African American, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_CURRENTLY_PAID_EMPLOYEE

XXX

VARCHAR2

1

IS_DISABLED

Obsolete field. Contains "N" in all records

VARCHAR2

5

IS_DISABLED_VETERAN

XXX

VARCHAR2

1

IS_FORMER_EMP_CURRENT_STU

If the person used to be an MIT employee or is currently an MIT student, this field is set to "Y", otherwise it contains "N"

VARCHAR2

4

IS_HISPANIC_OR_LATINO

If the employee has identified herself as Hispanic or Latino on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_MORE_THAN_ONE_RACE_REPORTED

If the employee has identified herself as having more than one Race, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_NATIVE_HAWAIIAN_PACIFIC_ISL

If the employee has identified herself as a Native Hawaiian or Other Pacific Islander, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_NEWLY_SEPARATED_VETERAN

An indicator that the person is a newly separated veteran (Y or N).

VARCHAR2

1

IS_NOT_A_VETERAN

If the person has not identified herself as Veteran, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_NO_ETHNICITY_ON_RECORD

If the employee has not specified any ethnicity on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_NO_RACE_ON_RECORD

If the employee has not specified any race on the Employee Self Service web page, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_NO_VETERAN_STATUS_ON_RECORD

XXX

VARCHAR2

1

IS_OFFICE_PHONE_TTY

If the office phone is TTY (telephone typewriter or text telephone), this field contains "Y", otherwise it contains "N"

VARCHAR2

1

IS_OFF_CAMPUS_WORK_PHONE_TTY

If the off-campus work phone is TTY (telephone typewriter or text telephone), this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

IS_OTHER

XXX

CHAR

1

IS_PROTECTED_VETERAN

XXX

VARCHAR2

1

IS_PROTECTED_VET_NO_CATEGORY

XXX

VARCHAR2

1

IS_RECENTLY_SEPARATED_VETERAN

XXX

VARCHAR2

1

IS_SIGNED_UP_FOR_MIT_ALERT

XXX

VARCHAR2

1

IS_SPECIAL_DISABLED_VETERAN

An indicator tha the person is a special disabled veteran (Y or N).

VARCHAR2

1

IS_VETERAN_BUT_NOT_PROTECTED

XXX

VARCHAR2

1

IS_VIETNAM_VETERAN

An indicator that the person is a Vietnam veteran (Y or N)

VARCHAR2

1

IS_WHITE

If the employee has identified herself as White, this field is set to "Y", otherwise it contains "N"

VARCHAR2

1

JOB_ID

The SAP 8-digit object id assigned to the job.

VARCHAR2

8

JOB_TITLE

In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office.

VARCHAR2

50

KRB_NAME_UPPERCASE

The Kerberos username of a person, in uppercase.

VARCHAR2

8

LAST_ESS_ACCESS_DATE

XXX

DATE

8

LAST_NAME

The person's last name.

VARCHAR2

30

LAST_NAME_UPPER

The uppercase version of the employee's last name. Convenient for placing limits.

VARCHAR2

40

LAST_TERM_DATE

Date on which the employee most recently became an ex-employee.

DATE

8

LAST_YEAR_TENURE_ELIGIBLE

XXX

VARCHAR2

4

LINCOLN_PERSONNEL_KEY

XXX

VARCHAR2

8

LOA_RETURN_DATE

Date the employee is expected back from a leave.

DATE

8

LOA_START_DATE

Leave of absence start date

DATE

8

MIDDLE_INITIAL

XXX

VARCHAR2

1

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

MILITARY_STATUS

XXX

VARCHAR2

30

MILITARY_STATUS_CODE

XXX

VARCHAR2

2

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

Nickname

VARCHAR2

30

NAME_PREFIX

Name prefix

VARCHAR2

15

NAME_SUFFIX

Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc.

VARCHAR2

15

OFFICE_ADDRESS

Employee's primary office address, for example, W92-101, LL-B 341

VARCHAR2

40

OFFICE_ADDR_BUILDING

The employee's office address building, for example, E19

VARCHAR2

15

OFFICE_ADDR_ROOM

The employee's room within the building, for example, 215

VARCHAR2

15

OFFICE_ADDR_SITE

The employee's site code, for example, LL (Lincoln Lab), MC (Main Campus), OS (other site)

VARCHAR2

2

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20

OFF_CAMPUS_WORK_ADDR_CARE_OF

Off-campus work address: "Care of" designation

VARCHAR2

40

OFF_CAMPUS_WORK_ADDR_CITY

Off-campus work address: City

VARCHAR2

40

OFF_CAMPUS_WORK_ADDR_COUNTRY

Off-campus work address: Country

VARCHAR2

20

OFF_CAMPUS_WORK_ADDR_STATE

Off-campus work address: State

VARCHAR2

3

OFF_CAMPUS_WORK_ADDR_STREET1

Off-campus work address: Street address

VARCHAR2

60

OFF_CAMPUS_WORK_ADDR_STREET2

Off-campus work address: Street address, 2nd line

VARCHAR2

40

OFF_CAMPUS_WORK_ADDR_ZIP

Off-campus work address: Zip code

VARCHAR2

10

OFF_CAMPUS_WORK_PHONE

Off-campus work address: Phone number

VARCHAR2

15

ORIGINAL_HIRE_DATE

The date on which the person was first employed by MIT.

DATE

8

PAGER_NUMBER

The person's MIT pager number, if any

VARCHAR2

30

PERSONAL_EMAIL_ADDR

XXX

VARCHAR2

100

PERSONAL_URL

The employee's personal URL.

VARCHAR2

241

PERSONNEL_AREA

Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab.

VARCHAR2

30

PERSONNEL_AREA_CODE

4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab.

VARCHAR2

4

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

PERSONNEL_SUBAREA

Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values.

VARCHAR2

30

PERSONNEL_SUBAREA_CODE

4 character code to further identify the personnel area, e.g., CFAC for faculty.

VARCHAR2

4

POSITION_ID

This is an 8-digit unique number generated by SAP and is specific to each position.

VARCHAR2

8

POSITION_TITLE

Specific Position Title tied to the Position ID. This may be more specifc than the official job title.

VARCHAR2

50

PREFERRED_FIRST_NAME_UPPER

XXX

VARCHAR2

40

PREFERRED_LAST_NAME_UPPER

XXX

VARCHAR2

40

PRIOR_LAST_NAME

Previous last name

VARCHAR2

40

RECORD_COUNTER

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

NUMBER

1

RESIDENCY_STATUS

Shows the person's residency status - e.g., citizen,non-citizen permanent resident, non-resident.

VARCHAR2

30

RESIDENCY_STATUS_CODE

A one character cod indicating the person's residency status.

VARCHAR2

1

RETIREMENT_DATE

XXX

DATE

7

SALUTATION

In HR tables, this field is used for salary review letters only, a person's salutation may appear as Mary, Fred, etc. In ALUMNI tables, this field contains the salutation of the alumnus/alumnae, eg. "The Rev MacCormick", "Dr Smith", "Ms Wood", "Prof Walker", "Mary Jones".

VARCHAR2

30

SAP_STATUS

Identifies the status within SAP, active for people being paid, withdrawn from ex-employees and ex-people (deceased). NOTE: In cases where an employee was terminated on their student appoinment, use IS_FORMER_EMP_CURRENT_STU and/or APPOINTMENT_END_DATE to determine if they are still active. Employees that become students are not always terminated in SAP on their Employee record.

VARCHAR2

30

SEIU

XXX

VARCHAR2

100

SIGNATURE_NAME

XXX

VARCHAR2

80

SOCIAL_SECURITY_NUMBER

The person's Social Security Number

VARCHAR2

15

TENURE_COMMENTS

XXX

VARCHAR2

50

TENURE_DATE

The date on which the faculty member was granted tenure.

DATE

8

UNION_SENIORITY_DATE

Date the employee joined the union

DATE

8

VACATION_ELIG_DATE

Date when the employee is eligible to take vacation time.

DATE

8

VETERAN_DATE_OF_DISCHARGE

XXX

DATE

8

VISA_EXPIRATION_DATE

The expiration date of the person's visa.

DATE

8

VISA_ISSUE_DATE

Date the visa was issued.

DATE

8

VISA_TYPE

A description of the type of visa a person holds.

VARCHAR2

30

VISA_TYPE_CODE

The code relating to Visa Type.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

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

DATE

8

WI_GENOME_HIRE_DATE

XXX

DATE

8

YEAR_8_OF_FACULTY_SERVICE

Records the eighth year following the date of a tenure track.

VARCHAR2

4

YEAR_OF_APPOINTMENT

XXX

VARCHAR2

4

YEAR_TURNING_35

The calendar year (YYYY) when the person is turning 35 years old.

VARCHAR2

4

YRS_OF_SERVICE

XXX

NUMBER

22

YRS_OF_SERVICE_FROM_LAST_HIRE

XXX

NUMBER

22