PERSON SERVICE LOOKUP Table
View exposing service lookup reference values used in person-related reporting and application logic.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMBINED_DEPT_NAME |
Combined dept name associated with the record. |
VARCHAR2 |
75 |
DIRECTORY_FIRST_NAME |
Directory first name associated with the record. |
VARCHAR2 |
40 |
DIRECTORY_LAST_NAME |
Directory last name associated with the record. |
VARCHAR2 |
40 |
DIRECTORY_TITLE |
Directory title associated with the record. |
VARCHAR2 |
75 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
EMAIL_ADDRESS_SUPPRESSED |
Email address suppressed associated with the record. |
VARCHAR2 |
1 |
EMPL_DIRECTORY_SUPPRESS |
Empl directory suppress associated with the record. |
VARCHAR2 |
1 |
FIRST_LAST_NAME_UPPERCASE |
First last name uppercase associated with the record. |
VARCHAR2 |
100 |
HAS_KERBEROS_USERNAME |
Has kerberos username associated with the record. |
VARCHAR2 |
1 |
HAS_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
1 |
HR_ORG_NAME |
Hr org name associated with the record. |
VARCHAR2 |
100 |
HR_ORG_UNIT6_CODE |
Code identifying hr org unit6. |
VARCHAR2 |
8 |
HR_ORG_UNIT8_CODE |
Code identifying hr org unit8. |
VARCHAR2 |
8 |
IS_PRIMARY_PERSON_RECORD |
Indicator identifying whether primary person record (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_RECORD_FOR_TYPE |
Indicator identifying whether primary record for type (Y/N). |
VARCHAR2 |
1 |
KERBEROS_USERNAME |
Kerberos username associated with the record. |
VARCHAR2 |
8 |
LAST_FIRST_NAME_UPPERCASE |
Last first name uppercase associated with the record. |
VARCHAR2 |
100 |
MASTER_DEPT_CODE |
Code identifying master dept. |
VARCHAR2 |
15 |
MASTER_DEPT_NAME |
Master dept name associated with the record. |
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 |
Official first name associated with the record. |
VARCHAR2 |
40 |
OFFICIAL_LAST_NAME |
Official last name associated with the record. |
VARCHAR2 |
40 |
OFFICIAL_MIDDLE_NAME |
Official middle name associated with the record. |
VARCHAR2 |
40 |
OFFICIAL_SUFFIX |
Official suffix associated with the record. |
VARCHAR2 |
40 |
PERSON_LOOKUP_KEY |
Surrogate key identifying the person lookup. |
VARCHAR2 |
9 |
PERSON_TYPE_EXTEND |
Person type extend associated with the record. |
VARCHAR2 |
12 |
PERSON_TYPE_SIMPLE |
Person type simple associated with the record. |
VARCHAR2 |
8 |
SORT_PERS_TYPE_EXTEND |
Sort pers type extend associated with the record. |
VARCHAR2 |
1 |
SORT_PERS_TYPE_SIMPLE |
Sort pers type simple associated with the record. |
VARCHAR2 |
1 |
STUDENT_DEPT_CODE |
Code identifying student dept. |
VARCHAR2 |
8 |
STUDENT_DEPT_NAME |
Student dept name associated with the record. |
VARCHAR2 |
100 |
STUDENT_YEAR |
Student year associated with the record. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |