EHS PERSON Table
Ehs ROLE person information
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 |
DIRECTORY_DLC |
XXX |
VARCHAR2 |
15 |
EHS_PERSON_KEY |
The internal key for a person who performs a given function within a Room Set. Use this for joining with person-related fields in the ehs_room_set_detail and ehs_room_set_contact_detail tables. |
VARCHAR2 |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
EMPLOYEE_TITLE |
The person's job title, from HR. |
VARCHAR2 |
51 |
EMPLOYEE_TYPE |
The categorization of MIT employees based on PERSONNEL_SUBAREA, but not as specific. Examples: Faculty, Other Academics, or Medical. |
VARCHAR2 |
30 |
EMPLOYEE_UNIT_ID |
The 6-digit HR org unit number (sometimes matches the profit center number) of the department where the trainee works. |
VARCHAR2 |
6 |
EMPLOYEE_UNIT_NAME |
The name of the DLC where the contact person works, according to HR. |
VARCHAR2 |
50 |
EXTENDED_TYPE |
XXX |
VARCHAR2 |
12 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
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_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PRIMARY_OFFICE_LOCATION |
The primary office building-room number of the person. |
VARCHAR2 |
30 |
PRIMARY_OFFICE_PHONE |
The primary office phone number of the person. |
VARCHAR2 |
20 |
SECONDARY_OFFICE_LOCATION |
The secondary office building-room number of the person, where listed. |
VARCHAR2 |
30 |
SECONDARY_OFFICE_PHONE |
The secondary office phone of the person, where listed. |
VARCHAR2 |
20 |
STATUS_CODE |
This field represents the status of the trainee's Kerberos username according to the Athena user accounts system. Normally, the field is set to 'A' (Active). If the username has been marked for deletion, but the trainee has not yet been moved from current tables to the archive tables, then this field is 'I' (Inactive). |
VARCHAR2 |
1 |
STUDENT_DEPARTMENT |
For students, the course number of the student's major. |
VARCHAR2 |
4 |
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 |
TNA_FIRST_REGISTER_DATE |
XXX |
DATE |
8 |
TYPE |
Identifies the type of person (Employee, Student, Other). |
VARCHAR2 |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |