EHST PI Table
View exposing principal investigator records used in Environment, Health, and Safety compliance tracking and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_PI_MIT_ID |
Business identifier for the ehst pi mit. |
VARCHAR2 |
9 |
PI_APPOINTMENT_TYPE |
Pi appointment type associated with the record. |
VARCHAR2 |
30 |
PI_EMAIL_ADDRESS |
Pi email address associated with the record. |
VARCHAR2 |
60 |
PI_EMPLOYEE_TITLE |
Pi employee title associated with the record. |
VARCHAR2 |
51 |
PI_EMPLOYEE_UNIT_ID |
Business identifier for the pi employee unit. |
VARCHAR2 |
6 |
PI_EMPLOYEE_UNIT_NAME |
Pi employee unit name associated with the record. |
VARCHAR2 |
50 |
PI_FIRST_NAME |
Pi first name associated with the record. |
VARCHAR2 |
30 |
PI_FULL_NAME |
Pi full name associated with the record. |
VARCHAR2 |
100 |
PI_KERBEROS_NAME |
Pi kerberos name associated with the record. |
VARCHAR2 |
8 |
PI_LAST_NAME |
Pi last name associated with the record. |
VARCHAR2 |
30 |
PI_MIDDLE_NAME |
Pi middle name associated with the record. |
VARCHAR2 |
30 |
PI_PRIMARY_OFFICE_LOCATION |
Pi primary office location associated with the record. |
VARCHAR2 |
30 |
PI_PRIMARY_OFFICE_PHONE |
Pi primary office phone associated with the record. |
VARCHAR2 |
20 |
PI_SECONDARY_OFFICE_LOCATION |
Pi secondary office location associated with the record. |
VARCHAR2 |
30 |
PI_SECONDARY_OFFICE_PHONE |
Pi secondary office phone associated with the record. |
VARCHAR2 |
20 |
PI_STATUS_CODE |
Code identifying pi status. |
CHAR |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |