Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EMPLOYEE BASIC PLUS Table


*Old Personnel Data in CYBORG * - Directory data plus service, tenure, chair data and ethnicity


Field Name

Description

Data Type

Length

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

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

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_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

EMAIL_ADDRESS

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

VARCHAR2

60

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

HIRE_DATE

The date on which the person was last hired.

DATE

8

IS_CURRENT_TODAY

An indicator that the person is active: 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

LAST_NAME

The person's last name.

VARCHAR2

30

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

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

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

USER_NAME

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

VARCHAR2

12

YEAR_GRADUATED

The year the person graduated.

VARCHAR2

30