EHS CONTACT PERSON Table
EHS Contact 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 |
CONTACT_EMAIL_ADDRESS |
The email address of the contact person, where available. |
VARCHAR2 |
60 |
CONTACT_FIRST_NAME |
The first name of the contact person, all uppercase. |
VARCHAR2 |
30 |
CONTACT_FULL_NAME |
The full name of the contact person. This is all uppercase, in the format "LAST-NAME, FIRST-NAME OPTIONAL-MIDDLE-NAME". |
VARCHAR2 |
100 |
CONTACT_KERBEROS_NAME |
The Kerberos username of the contact 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 |
CONTACT_LAST_NAME |
The last name of the contact person, all uppercase. |
VARCHAR2 |
30 |
CONTACT_MIDDLE_NAME |
The middle name, where available, of the contact person, all uppercase. |
VARCHAR2 |
30 |
CONTACT_PERSON_KEY |
Internal key for the contact person. Use this field to join with ehs_contact_person and detail tables. |
VARCHAR2 |
8 |
EMPLOYEE_TITLE |
The person's job title, from HR. |
VARCHAR2 |
51 |
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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |
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 |