PERSON SERVICE LOOKUP Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMBINED_DEPT_NAME |
XXX |
VARCHAR2 |
75 |
DIRECTORY_FIRST_NAME |
XXX |
VARCHAR2 |
40 |
DIRECTORY_LAST_NAME |
XXX |
VARCHAR2 |
40 |
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 |
75 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
EMAIL_ADDRESS_SUPPRESSED |
XXX |
VARCHAR2 |
1 |
EMPL_DIRECTORY_SUPPRESS |
XXX |
VARCHAR2 |
1 |
FIRST_LAST_NAME_UPPERCASE |
XXX |
VARCHAR2 |
100 |
HAS_KERBEROS_USERNAME |
XXX |
VARCHAR2 |
1 |
HAS_MIT_ID |
XXX |
VARCHAR2 |
1 |
HR_ORG_NAME |
XXX |
VARCHAR2 |
100 |
HR_ORG_UNIT6_CODE |
XXX |
VARCHAR2 |
8 |
HR_ORG_UNIT8_CODE |
XXX |
VARCHAR2 |
8 |
IS_PRIMARY_PERSON_RECORD |
XXX |
VARCHAR2 |
1 |
IS_PRIMARY_RECORD_FOR_TYPE |
XXX |
VARCHAR2 |
1 |
KERBEROS_USERNAME |
XXX |
VARCHAR2 |
8 |
LAST_FIRST_NAME_UPPERCASE |
XXX |
VARCHAR2 |
100 |
MASTER_DEPT_CODE |
XXX |
VARCHAR2 |
15 |
MASTER_DEPT_NAME |
XXX |
VARCHAR2 |
70 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
OFFICIAL_FIRST_NAME |
XXX |
VARCHAR2 |
40 |
OFFICIAL_LAST_NAME |
XXX |
VARCHAR2 |
40 |
OFFICIAL_MIDDLE_NAME |
XXX |
VARCHAR2 |
40 |
OFFICIAL_SUFFIX |
XXX |
VARCHAR2 |
40 |
PERSON_LOOKUP_KEY |
XXX |
VARCHAR2 |
9 |
PERSON_TYPE_EXTEND |
XXX |
VARCHAR2 |
12 |
PERSON_TYPE_SIMPLE |
XXX |
VARCHAR2 |
8 |
SORT_PERS_TYPE_EXTEND |
XXX |
VARCHAR2 |
1 |
SORT_PERS_TYPE_SIMPLE |
XXX |
VARCHAR2 |
1 |
STUDENT_DEPT_CODE |
XXX |
VARCHAR2 |
8 |
STUDENT_DEPT_NAME |
XXX |
VARCHAR2 |
100 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |