EMPLOYEE LIMITED Table
*Old Personnel Data in CYBORG * - Contains employee data without home address information for all employees.
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 |
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_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 |
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 |
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 |
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 |
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 |
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 |
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 |