KRB PERSON Table
This table contains all people associated with the Institute who have a Kerberos Principal in Moira. Data items in the table include Kerberos Name, directory information, and the person's primary association (Student, Employee, Other) at MIT. This table is refreshed every 3 hours between 10am and 10pm with updated Kerberos information from Moira; and it is refreshed daily around 4 am with updated information from Moira, HR, and MITSIS.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPOINTMENT_TYPE |
In the various APPOINTMENT tables (ie, MIT Employees): For Faculty, identifies whether they have a 9-, 10-, 11-, or 12-month appointment. This information is used to position faculty members with their peers in salary reviews; also determines whether they are eligible to receive summer salary (1, 2, or 3 months). For other MIT employees, specifies whether the appointment is Regular, Term (= has a specified end date), Temporary (normally of more than 2 and less than 12 months duration), or Summer only. In the GRADUATE AWARD tables, specifies the type of Graduate Student Appointment: RA, TA, etc. In the KRB_PERSON table, indicates whether the appointment is Primary or Secondary. |
VARCHAR2 |
30 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
KRB_NAME |
Kerberos Name |
VARCHAR2 |
8 |
KRB_NAME_CREATE_DATE |
XXX |
DATE |
7 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LEGAL_FIRST_NAME |
XXX |
VARCHAR2 |
60 |
LEGAL_LAST_NAME |
XXX |
VARCHAR2 |
60 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |
PERSON_TYPE |
In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member. |
VARCHAR2 |
60 |
PREFERRED_FIRST_NAME |
XXX |
VARCHAR2 |
60 |
PREFERRED_LAST_NAME |
XXX |
VARCHAR2 |
60 |
TITLE |
In the OSP AWARD, COST COLLECTOR, and PROJECT OSP tables, this is the Title of a Research Proposal. In KRB_PERSON, TITLE is the position title of the person. In TIP_MATERIAL view it is a TITLE of the course material. |
VARCHAR2 |
50 |
TYPE |
Identifies the type of person (Employee, Student, Other). |
VARCHAR2 |
8 |
UNIT_ID |
The Institute-assigned identification number of a department, school, center, or lab. |
VARCHAR2 |
6 |
UNIT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
YEAR |
In KRB_PERSON, YEAR is a one-character field identifying the students year of degree (or current year); eg.: 1, 2, 3, 4, G, U. In TIP_MATERIAL YEAR is a Year when a Title was published |
VARCHAR2 |
1 |