EHST PI Table
EHS Training PI data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_PI_MIT_ID |
The MIT ID number of a trainee's PI or supervisor. |
VARCHAR2 |
9 |
PI_APPOINTMENT_TYPE |
XXX |
VARCHAR2 |
30 |
PI_EMAIL_ADDRESS |
The Email address of the PI or supervisor, where available |
VARCHAR2 |
60 |
PI_EMPLOYEE_TITLE |
The PI or supervisor's job title, from HR. |
VARCHAR2 |
51 |
PI_EMPLOYEE_UNIT_ID |
The 6-digit HR org unit number (sometimes matches the profit center number) of the department where the PI or supervisor works. |
VARCHAR2 |
6 |
PI_EMPLOYEE_UNIT_NAME |
The name of the DLC where the PI or supervisor works, according to HR. |
VARCHAR2 |
50 |
PI_FIRST_NAME |
The first name of the PI or supervisor, all upper-case. |
VARCHAR2 |
30 |
PI_FULL_NAME |
The full name of the PI or supervisor. This is all upper-case, in the format "LAST-NAME, FIRST-NAME OPTIONAL MIDDLE-NAME". |
VARCHAR2 |
100 |
PI_KERBEROS_NAME |
The Kerberos username of the PI or supervisor. 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 |
PI_LAST_NAME |
The last name of the PI or supervisor, all uppercase. |
VARCHAR2 |
30 |
PI_MIDDLE_NAME |
The middle name, where available, of the PI or supervisor, all upper-case. |
VARCHAR2 |
30 |
PI_PRIMARY_OFFICE_LOCATION |
The primary office building-room number of the PI or supervisor. |
VARCHAR2 |
30 |
PI_PRIMARY_OFFICE_PHONE |
The primary office phone number of the PI or supervisor. |
VARCHAR2 |
20 |
PI_SECONDARY_OFFICE_LOCATION |
The secondary office building-room number of the PI or supervisor, where listed. |
VARCHAR2 |
30 |
PI_SECONDARY_OFFICE_PHONE |
The secondary office phone of the PI or supervisor, where listed. |
VARCHAR2 |
20 |
PI_STATUS_CODE |
This field represents the status of the PI or supervisor'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 PI or supervisor is still listed for some trainees, then this field is 'I' (Inactive). |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |