FPR PEOPLE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMINISTRATIVE_DLC_CODE |
XXX |
VARCHAR2 |
15 |
ADMINISTRATIVE_DLC_NAME |
XXX |
VARCHAR2 |
70 |
ADMIN_JOB_TITLE |
The title of the job of the administrative appointment |
VARCHAR2 |
40 |
ADMIN_POSITION_TITLE |
The title of the position of the administrative appointment |
VARCHAR2 |
50 |
AFFILIATED |
XXX |
VARCHAR2 |
30 |
COUNTRY_OF_CITIZENSHIP |
The country where the person has citizenship. |
VARCHAR2 |
15 |
COUNTRY_OF_CITIZENSHIP_CODE |
The country where the person has citizenship. |
VARCHAR2 |
3 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
|
DATE_TO_FACULTY |
The date on which the person was made a faculty member. |
DATE |
|
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
40 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
40 |
FIRST_NAME_SEARCH |
XXX |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
HAS_ADDITIONAL_APPOINTMENT |
'Y'=the person (instructor) has more than one appointment/position. 'N' otherwise. |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
An indicator that the employee has a dual appointment, Y or N. |
VARCHAR2 |
1 |
HR_VISA_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
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 |
40 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
30 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
40 |
LAST_NAME_SEARCH |
XXX |
VARCHAR2 |
40 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
40 |
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_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 |
PERSONNEL_STATUS |
XXX |
VARCHAR2 |
30 |
POSITION_TITLE |
Specific Position Title tied to the Position ID. This may be more specifc than the official job title. |
VARCHAR2 |
50 |
PRIMARY_DLC_CODE |
XXX |
VARCHAR2 |
15 |
PRIMARY_DLC_NAME |
XXX |
VARCHAR2 |
70 |
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 |
TENURE_DATE |
The date on which the faculty member was granted tenure. |
DATE |
|
VISA_EXPIRATION_DATE |
The expiration date of the person's visa. |
DATE |
|
VISA_ISSUE_DATE |
Date the visa was issued. |
DATE |
|
VISA_TYPE |
A description of the type of visa a person holds. |
VARCHAR2 |
40 |
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 |