KRB PERSON Table
View exposing enterprise person directory records keyed by Kerberos username including MIT identifiers, names, contact information, and organizational attributes used for identity and integration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_TYPE |
Appointment classification describing the type of affiliation or role held by the person. |
VARCHAR2 |
30 |
DLC_KEY |
Department, laboratory, or center key associated with the person used for organizational mapping. |
VARCHAR2 |
30 |
DLC_NAME |
Department, laboratory, or center name associated with the person used for organizational mapping. |
VARCHAR2 |
60 |
EMAIL_ADDRESS |
Primary email address associated with the person used for communication and directory lookup. |
VARCHAR2 |
50 |
FIRST_NAME |
Person first name used for display and directory purposes. |
VARCHAR2 |
30 |
KRB_NAME |
Kerberos username associated with the person used for authentication and system access. |
VARCHAR2 |
8 |
KRB_NAME_CREATE_DATE |
Date the Kerberos username was created or first recorded in the system. |
DATE |
|
KRB_NAME_UPPERCASE |
Uppercase representation of the Kerberos username used for case-insensitive matching and integration. |
VARCHAR2 |
8 |
LAST_NAME |
Person last name used for display and directory purposes. |
VARCHAR2 |
30 |
LEGAL_FIRST_NAME |
Legal first name of the person used for official and compliance purposes. |
VARCHAR2 |
60 |
LEGAL_LAST_NAME |
Legal last name of the person used for official and compliance purposes. |
VARCHAR2 |
60 |
LEGAL_MIDDLE_NAME |
Legal middle name of the person used for official and compliance purposes. |
VARCHAR2 |
30 |
MIDDLE_NAME |
Person middle name used for display and directory purposes. |
VARCHAR2 |
50 |
MIT_ID |
Unique MIT identifier assigned to a person used as the primary enterprise identity key. |
VARCHAR2 |
9 |
OFFICE_LOCATION |
Office location description associated with the person including building and room information. |
VARCHAR2 |
30 |
OFFICE_PHONE |
Office phone number associated with the person used for directory and contact purposes. |
VARCHAR2 |
20 |
PERSON_TYPE |
Detailed classification of the person indicating role category such as employee, student, affiliate, or other. |
VARCHAR2 |
30 |
PREFERRED_FIRST_NAME |
Preferred first name used by the person for display and communication purposes. |
VARCHAR2 |
40 |
PREFERRED_LAST_NAME |
Preferred last name used by the person for display and communication purposes. |
VARCHAR2 |
60 |
PREFERRED_MIDDLE_NAME |
Preferred middle name used by the person for display and communication purposes. |
VARCHAR2 |
50 |
TITLE |
Job title or role description associated with the person for directory and reporting purposes. |
VARCHAR2 |
50 |
TYPE |
General classification of the person used for grouping and reporting purposes. |
VARCHAR2 |
20 |
UNIT_ID |
Organizational unit identifier associated with the person representing department, lab, or center assignment. |
VARCHAR2 |
6 |
UNIT_NAME |
Organizational unit name associated with the person representing department, lab, or center assignment. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse used for data freshness and audit tracking. |
DATE |
|
YEAR |
Academic or reporting year associated with the person where applicable. |
VARCHAR2 |
4 |