OSP PERSON HISTORY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_LINE_1 |
XXX |
VARCHAR2 |
80 |
ADDRESS_LINE_2 |
XXX |
VARCHAR2 |
80 |
ADDRESS_LINE_3 |
XXX |
VARCHAR2 |
80 |
AGE |
*** In HR tables, this field contains the person's age in years as calculated by the HR System's Age Calculating Device. *** In STUDENT tables, this field contains the age of the person. |
NUMBER |
|
AGE_BY_FISCAL_YEAR |
The person's age as of June 30, the end of the fiscal year, as calculated by the HR System's aforementioned Device. For example, a person's FY2000 age is the person's age on June 30, 2000. |
NUMBER |
|
CITY |
City. |
VARCHAR2 |
30 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
COUNTRY_OF_CITIZENSHIP |
The country where the person has citizenship. |
VARCHAR2 |
30 |
COUNTY |
XXX |
VARCHAR2 |
30 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
|
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_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 |
ERA_COMMONS_USER_NAME |
XXX |
VARCHAR2 |
20 |
FAX_NUMBER |
The employee's FAX number. |
VARCHAR2 |
20 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
90 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
200 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HANDICAP_TYPE |
XXX |
VARCHAR2 |
30 |
HAS_VISA |
An indicator that the person has a visa (yes or no). |
VARCHAR2 |
1 |
HOME_UNIT |
The persons primary department. |
VARCHAR2 |
8 |
ID_PROVIDED |
The type of identification document produced for I-9 verification. |
VARCHAR2 |
30 |
ID_VERIFIED |
The identification procedure status. Indicates whether the procedure has started and if the identification documentation was produced: Yes or No. |
VARCHAR2 |
30 |
IS_ACTIVE |
XXX |
CHAR |
|
IS_FACULTY |
The indicator that the person is a member of the faculty (YES, NO). |
VARCHAR2 |
1 |
IS_GRADUATE_STUDENT_STAFF |
The indicator that the person is a graduate student (YES, NO). |
VARCHAR2 |
1 |
IS_HANDICAPPED |
Is this person hadicapped? Y or N. |
VARCHAR2 |
1 |
IS_MEDICAL_STAFF |
The indicator that the person is a member of the medical staff (YES, NO). |
VARCHAR2 |
1 |
IS_ON_SABBATICAL |
XXX |
VARCHAR2 |
1 |
IS_OTHER_ACCADEMIC_GROUP |
XXX |
VARCHAR2 |
1 |
IS_RESEARCH_STAFF |
XXX |
VARCHAR2 |
1 |
IS_SERVICE_STAFF |
The indicator that the person is a member of the service staff (YES, NO). |
VARCHAR2 |
1 |
IS_SUPPORT_STAFF |
The indicator that the person is a member of the Support staff (YES, NO). |
VARCHAR2 |
1 |
IS_VETERAN |
An indicator that the person is a veteran (yes or no). |
VARCHAR2 |
1 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
90 |
MAJOR |
Field of major degree, for example, chemistry, biology, computer science. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
90 |
MOBILE_PHONE_NUMBER |
XXX |
VARCHAR2 |
20 |
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 |
PAGER_NUMBER |
The person's MIT pager number, if any |
VARCHAR2 |
20 |
PERSON_ID |
XXX |
VARCHAR2 |
9 |
POSTAL_CODE |
Postal Code (part of an address) |
VARCHAR2 |
15 |
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 |
SALARY_ANNIVERSARY_DATE |
XXX |
DATE |
|
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 |
SECONDRY_OFFICE_LOCATION |
XXX |
VARCHAR2 |
30 |
SECONDRY_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
SSN |
The person's social security number. |
VARCHAR2 |
9 |
STATE |
State. |
VARCHAR2 |
30 |
STATUS |
In the GRADUATE APPOINTMENT TYPE table, this field indicates the status of the appointment: whether Cancelled or Actual. In the ALUMNI BY COURSE table, this field carries one of these statuses: "Active", "Lost", "Purgable" regarding the MIT alumnus/alumnae. |
VARCHAR2 |
1 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
8 |
USER_NAME |
Kerberos ID of the person who entered the purchasing financial detail record in SAP, usually the purchasing agent |
VARCHAR2 |
60 |
VACATION_ACCURAL |
XXX |
VARCHAR2 |
1 |
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 |
|
VISA_TYPE |
A description of the type of visa a person holds. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
YEAR_GRADUATED |
The year the person graduated. |
VARCHAR2 |
30 |