Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EMPLOYEE Table


*Old Personnel Data in CYBORG * - Contains personal information about all employees.


Field Name

Description

Data Type

Length

ACTIVITY_DATE

The date of the last major change in the employment status. The date records only hires, leaves, terminations, retirements, and deaths.

DATE

8

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

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

BENEFITS_ELIGIBILITY

Text for BENEFITS_ELIGIBILITY_CODE. One of the factors for determining an employee?s benefits eligibility is the percent of effort an employee is working. Employee?s working 50% or more satisfy that eligibility factor. At the Institute, employees can have multiple positions, which may or may not add up to over 50% effort. These positions need to be analyzed to determine the total percent of effort the employee is working. Example: Example: Ineligible (1), Partial (2), All (4), or N/A (N/A).

VARCHAR2

30

CHAIR_END_DATE

The end date of the chair appointment.

DATE

8

CHAIR_START_DATE

The start date of the chair appointment.

DATE

8

CHAIR_TITLE

The title that the chair endower set when he or she established the fund to support the chair appointment.

VARCHAR2

51

COUNTRY_OF_CITIZENSHIP

The country where the person has citizenship.

VARCHAR2

30

DATE_LAST_UPDATED

The date on which the warehouse data was last updated.

DATE

8

DATE_OF_BIRTH

The person's date of birth.

DATE

8

DATE_TO_FACULTY

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

VARCHAR2

10

DEGREE

Type of educational degree this person holds: PHD, MBA, BS, etc.

VARCHAR2

11

DIRECTORY_DEPARTMENT

The person's department as listed in the MIT directory.

VARCHAR2

30

DIRECTORY_SUPPRESSION

An indicator for whether a person's home address and phone number are listed in the MIT directory: Yes or No.

VARCHAR2

30

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

EDUCATION_LEVEL

The highest level of education a person has completed: high school, B.A. or B.S. degree, MBA, Ph.D.

VARCHAR2

30

EIGHT_YEARS_OF_SERVICE

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

VARCHAR2

4

EMAIL_ADDRESS

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

VARCHAR2

60

EMERGENCY_CONTACT_HOME_PHONE

Designated emergency contact's telephone number at home.

VARCHAR2

20

EMERGENCY_CONTACT_NAME

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

VARCHAR2

30

EMERGENCY_CONTACT_WORK_PHONE

Designated emergency contact's telephone number at work.

VARCHAR2

20

EMPLOYEE_STAFF_DATE

The date on which the person was appointed to staff. The date appears on the administrative staff review sheet.

DATE

8

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

HAS_VISA

An indicator that the person has a visa (yes or no).

VARCHAR2

5

HIRE_DATE

The date on which the person was last hired.

DATE

8

HOME_ADDRESS1

Street number and street name.

VARCHAR2

30

HOME_ADDRESS2

Additional address information.

VARCHAR2

30

HOME_CITY

The person's home city.

VARCHAR2

30

HOME_COUNTRY

The person's home country.

VARCHAR2

30

HOME_PHONE

The person's home telephone number.

VARCHAR2

20

HOME_STATE

The person's home state.

VARCHAR2

2

HOME_ZIP_CODE

The person's home zip code.

VARCHAR2

9

ID_PROVIDED

The type of identification document produced for I-9 verification.

VARCHAR2

30

ID_VERIFIED

The identification procedure status. Indicates whether the procedure has started and if the identification documentation was produced: Yes or No.

VARCHAR2

30

IS_ACTIVE_NON_RETIRED

An indicator that the person is currently working and is not retired: Yes or No.

VARCHAR2

5

IS_ACTIVE_RETIRED

An indicator that the person is retired and is not currently working: Yes or No.

VARCHAR2

5

IS_CURRENT_TODAY

An indicator that the person is active: Yes or No.

VARCHAR2

5

IS_DECEASED

An indicator that the person is deceased: Yes or No.

VARCHAR2

5

IS_DISABLED

Obsolete field. Contains "N" in all records

VARCHAR2

5

IS_LAID_OFF

An indicator that tells if the person has been laid off: Yes or No.

VARCHAR2

5

IS_NOT_CURRENT_TODAY

An indicator that the person is terminated, on long term disability, deceased, laid off, or retired and not working: Yes or No.

VARCHAR2

5

IS_ON_LEAVE

An indicator that the person is on leave: Yes or No.

VARCHAR2

5

IS_ON_LTD

An indicator that the person is on long term disability.

VARCHAR2

5

IS_ON_PAID_LEAVE

An indicator that the person is on a paid leave: Yes or No.

VARCHAR2

5

IS_ON_UNPAID_LEAVE

An indicator that the person is on an unpaid leave.

VARCHAR2

5

IS_RETIRED

An indicator that tells if the person has retired: Yes or No.

VARCHAR2

5

IS_RETIRED_NON_ACTIVE

An indicator that the person is retired, collecting a pension, and not active: Yes or No.

VARCHAR2

5

IS_TERMINATED

An indicator that the person has been terminated: Yes or No.

VARCHAR2

5

IS_UNDEFINED

An indicator that the person's affiliation with the Institute has not yet been classified: Yes or No.

VARCHAR2

5

IS_VETERAN

An indicator that the person is a veteran (yes or no).

VARCHAR2

5

LAST_NAME

The person's last name.

VARCHAR2

30

LAST_PROMOTION_DATE

The date of the employee's last promotion.

DATE

8

LAST_TRANSFER_DATE

The date on which the employee transferred to another department.

DATE

8

LAST_YEAR

The last year in which a faculty member is eligible to receive tenure.

VARCHAR2

4

LENGTH_OF_SERVICE

The number of years of employment at MIT. This field is not an official record of the number of years served. Reporting should be at the user's discretion.

NUMBER

3

MAJOR

Field of major degree, for example, chemistry, biology, computer science.

VARCHAR2

30

MIDDLE_NAME

The person's middle name (where available).

VARCHAR2

30

MIT_ID

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

VARCHAR2

9

OFFICE_LOCATION

The person's primary office address at MIT.

VARCHAR2

30

OFFICE_PHONE

The person's primary office telephone number at MIT.

VARCHAR2

20

ORIGINAL_HIRE_DATE

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

DATE

8

PRIMARY_TITLE

A person's primary appointment title.

VARCHAR2

51

PRIOR_NAME

The person's prior name, for example, maiden name.

VARCHAR2

30

RACE

The person's race.

VARCHAR2

30

RETIRE_DATE_AT_65

The July 1 date following the person's 65th birthday.

DATE

8

RETIRE_DATE_AT_70

The July 1 date following the person's 70th birthday.

DATE

8

SALARY_REVIEW_COMMENTS

Additional qualifying information that appears on the salary review sheet.

VARCHAR2

30

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

SCHOOL

The name of the school from which the person earned the highest or most recent degree.

VARCHAR2

50

SECONDARY_OFFICE_LOCATION

The secondary office building-room number of the person, where listed.

VARCHAR2

30

SECONDARY_OFFICE_PHONE

The secondary office phone of the person, where listed.

VARCHAR2

20

SEPARATION_DATE

The date of the most recent separation occurrence (termination, layoff, etc.) in a person's record.

DATE

8

SOURCE

Tells where the information about the person was obtained.

VARCHAR2

30

SSN

The person's social security number.

VARCHAR2

9

TENURE_DATE

The date on which the faculty member was granted tenure.

DATE

8

TERMINATION_DATE

The date on which the person was terminated.

DATE

8

UNION_SENIORITY

A union member's seniority date, which may differ from the last employment date.

DATE

8

USER_NAME

Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent

VARCHAR2

12

VETERAN_TYPE

Type of veteran.

VARCHAR2

30

VISA_CODE

The code relating to Visa Type. Example: (J1, H1, etc.)

VARCHAR2

20

VISA_RENEWAL_DATE

The renewal date of the person's visa.

DATE

8

VISA_TYPE

A description of the type of visa a person holds.

VARCHAR2

30

YEAR_35

The fiscal year in which a faculty member turns 35. Used for tenure/promotion purposes.

VARCHAR2

4

YEAR_GRADUATED

The year the person graduated.

VARCHAR2

30