PERSON HELP Table
View of the employee table for use by the IS Help system only.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_ID |
The 6-digit Institute-assigned identification number of a department, school, center, or lab. (Equivalent to the Profit Center ID in financial reports, but without the initial uppercase P.) |
VARCHAR2 |
6 |
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
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 |
KERBEROS_NAME |
The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
MIT_ADDRESS |
The persons MIT building and room number. |
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 |
MIT_PHONE |
The persons MIT telephone number. |
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 |
TITLE_DEGREE |
The students year of degree (or current year), eg.: 1,2,3,4,G,U. |
VARCHAR2 |
50 |