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 |