OSP PERSON HISTORY Table
View exposing historical personnel records associated with sponsored projects including historical investigator assignments, personnel changes, and date ranges used for project history tracking and complete audit trail maintenance.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_LINE_1 |
Address line 1 associated with the record. |
VARCHAR2 |
80 |
ADDRESS_LINE_2 |
Address line 2 associated with the record. |
VARCHAR2 |
80 |
ADDRESS_LINE_3 |
Address line 3 associated with the record. |
VARCHAR2 |
80 |
AGE |
Age associated with the record. |
NUMBER |
|
AGE_BY_FISCAL_YEAR |
Age by fiscal year associated with the record. |
NUMBER |
|
CITY |
City associated with the record. |
VARCHAR2 |
30 |
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship associated with the record. |
VARCHAR2 |
30 |
COUNTY |
County associated with the record. |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
Date of birth associated with the record. |
DATE |
|
DEGREE |
Degree associated with the record. |
VARCHAR2 |
11 |
DIRECTORY_DEPARTMENT |
Directory department associated with the record. |
VARCHAR2 |
30 |
DIRECTORY_TITLE |
Directory title associated with the record. |
VARCHAR2 |
50 |
EDUCATION_LEVEL |
Education level associated with the record. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
ERA_COMMONS_USER_NAME |
Era commons user name associated with the record. |
VARCHAR2 |
20 |
FAX_NUMBER |
Fax number associated with the record. |
VARCHAR2 |
20 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
90 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
200 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
30 |
HANDICAP_TYPE |
Handicap type associated with the record. |
VARCHAR2 |
30 |
HAS_VISA |
Has visa associated with the record. |
VARCHAR2 |
1 |
HOME_UNIT |
Home unit associated with the record. |
VARCHAR2 |
8 |
ID_PROVIDED |
Id provided associated with the record. |
VARCHAR2 |
30 |
ID_VERIFIED |
Id verified associated with the record. |
VARCHAR2 |
30 |
IS_ACTIVE |
Indicator identifying whether active (Y/N). |
CHAR |
|
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
IS_GRADUATE_STUDENT_STAFF |
Indicator identifying whether graduate student staff (Y/N). |
VARCHAR2 |
1 |
IS_HANDICAPPED |
Indicator identifying whether handicapped (Y/N). |
VARCHAR2 |
1 |
IS_MEDICAL_STAFF |
Indicator identifying whether medical staff (Y/N). |
VARCHAR2 |
1 |
IS_ON_SABBATICAL |
Indicator identifying whether on sabbatical (Y/N). |
VARCHAR2 |
1 |
IS_OTHER_ACCADEMIC_GROUP |
Indicator identifying whether other accademic group (Y/N). |
VARCHAR2 |
1 |
IS_RESEARCH_STAFF |
Indicator identifying whether research staff (Y/N). |
VARCHAR2 |
1 |
IS_SERVICE_STAFF |
Indicator identifying whether service staff (Y/N). |
VARCHAR2 |
1 |
IS_SUPPORT_STAFF |
Indicator identifying whether support staff (Y/N). |
VARCHAR2 |
1 |
IS_VETERAN |
Indicator identifying whether veteran (Y/N). |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
90 |
MAJOR |
Major associated with the record. |
VARCHAR2 |
30 |
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
90 |
MOBILE_PHONE_NUMBER |
Mobile phone number associated with the record. |
VARCHAR2 |
20 |
OFFICE_LOCATION |
Office location associated with the record. |
VARCHAR2 |
30 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
20 |
PAGER_NUMBER |
Pager number associated with the record. |
VARCHAR2 |
20 |
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
POSTAL_CODE |
Code identifying postal. |
VARCHAR2 |
15 |
PRIMARY_TITLE |
Primary title associated with the record. |
VARCHAR2 |
51 |
PRIOR_NAME |
Prior name associated with the record. |
VARCHAR2 |
30 |
RACE |
Race associated with the record. |
VARCHAR2 |
30 |
SALARY_ANNIVERSARY_DATE |
Date associated with salary anniversary. |
DATE |
|
SALUTATION |
Salutation associated with the record. |
VARCHAR2 |
30 |
SCHOOL |
School associated with the record. |
VARCHAR2 |
50 |
SECONDRY_OFFICE_LOCATION |
Secondry office location associated with the record. |
VARCHAR2 |
30 |
SECONDRY_OFFICE_PHONE |
Secondry office phone associated with the record. |
VARCHAR2 |
20 |
SSN |
Ssn associated with the record. |
VARCHAR2 |
9 |
STATE |
State associated with the record. |
VARCHAR2 |
30 |
STATUS |
Status associated with the record. |
VARCHAR2 |
1 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
8 |
USER_NAME |
User name associated with the record. |
VARCHAR2 |
60 |
VACATION_ACCURAL |
Vacation accural associated with the record. |
VARCHAR2 |
1 |
VETERAN_TYPE |
Veteran type associated with the record. |
VARCHAR2 |
30 |
VISA_CODE |
Code identifying visa. |
VARCHAR2 |
20 |
VISA_RENEWAL_DATE |
Date associated with visa renewal. |
DATE |
|
VISA_TYPE |
Visa type associated with the record. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
YEAR_GRADUATED |
Year graduated associated with the record. |
VARCHAR2 |
30 |