FPR PEOPLE Table
View exposing person records used in Faculty Professional Record reporting and review processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMINISTRATIVE_DLC_CODE |
Code identifying administrative dlc. |
VARCHAR2 |
15 |
ADMINISTRATIVE_DLC_NAME |
Administrative dlc name associated with the record. |
VARCHAR2 |
70 |
ADMIN_JOB_TITLE |
Admin job title associated with the record. |
VARCHAR2 |
40 |
ADMIN_POSITION_TITLE |
Admin position title associated with the record. |
VARCHAR2 |
50 |
AFFILIATED |
Affiliated associated with the record. |
VARCHAR2 |
30 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship associated with the record. |
VARCHAR2 |
15 |
COUNTRY_OF_CITIZENSHIP_CODE |
Code identifying country of citizenship. |
VARCHAR2 |
3 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DATE_TO_FACULTY |
Date to faculty associated with the record. |
DATE |
|
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
EMPLOYEE_TYPE |
Employee type associated with the record. |
VARCHAR2 |
40 |
FIRST_NAME |
First name associated with the person. |
VARCHAR2 |
40 |
FIRST_NAME_SEARCH |
First name search associated with the record. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person. |
VARCHAR2 |
100 |
HAS_ADDITIONAL_APPOINTMENT |
Indicator identifying whether additional appointment (Y/N). |
VARCHAR2 |
1 |
HAS_DUAL_APPOINTMENT |
Indicator identifying whether dual appointment (Y/N). |
VARCHAR2 |
1 |
HR_VISA_TYPE_CODE |
Code identifying hr visa type. |
VARCHAR2 |
4 |
JOB_TITLE |
Job title associated with the record. |
VARCHAR2 |
40 |
KRB_NAME_UPPERCASE |
Krb name uppercase associated with the record. |
VARCHAR2 |
30 |
LAST_NAME |
Last name associated with the person. |
VARCHAR2 |
40 |
LAST_NAME_SEARCH |
Last name search associated with the record. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the person. |
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 |
Name suffix associated with the record. |
VARCHAR2 |
15 |
OFFICE_ADDRESS |
Office address associated with the record. |
VARCHAR2 |
40 |
PERSONNEL_STATUS |
Personnel status associated with the record. |
VARCHAR2 |
30 |
POSITION_TITLE |
Position title associated with the record. |
VARCHAR2 |
50 |
PRIMARY_DLC_CODE |
Code identifying primary dlc. |
VARCHAR2 |
15 |
PRIMARY_DLC_NAME |
Primary dlc name associated with the record. |
VARCHAR2 |
70 |
RESIDENCY_STATUS |
Residency status associated with the record. |
VARCHAR2 |
30 |
RESIDENCY_STATUS_CODE |
Code identifying residency status. |
VARCHAR2 |
1 |
TENURE_DATE |
Date associated with tenure. |
DATE |
|
VISA_EXPIRATION_DATE |
Date associated with visa expiration. |
DATE |
|
VISA_ISSUE_DATE |
Date associated with visa issue. |
DATE |
|
VISA_TYPE |
Visa type associated with the record. |
VARCHAR2 |
40 |
VISA_TYPE_CODE |
Code identifying visa type. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |