EL PI DLC AFF HISTORY Table
View exposing historical principal investigator and DLC affiliation records used in EHS training and compliance assignment processes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFILIATION_START_DATE |
Date associated with affiliation start. |
DATE |
|
AFFILIATION_STATUS |
Affiliation status associated with the record. |
VARCHAR2 |
9 |
DLC_CODE |
Code identifying dlc. |
VARCHAR2 |
20 |
DLC_NAME |
Dlc name associated with the record. |
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 |
PI_ALT_OFFICE_LOC |
Pi alt office loc associated with the record. |
VARCHAR2 |
40 |
PI_ALT_OFFICE_PHONE |
Pi alt office phone associated with the record. |
VARCHAR2 |
20 |
PI_EMAIL |
Pi email associated with the record. |
VARCHAR2 |
100 |
PI_FULL_NAME |
Pi full name associated with the record. |
VARCHAR2 |
100 |
PI_KERBEROS_NAME |
Pi kerberos name associated with the record. |
VARCHAR2 |
30 |
PI_MIT_ID |
Business identifier for the pi mit. |
VARCHAR2 |
9 |
PI_OFFICE_LOC |
Pi office loc associated with the record. |
VARCHAR2 |
40 |
PI_OFFICE_PHONE |
Pi office phone associated with the record. |
VARCHAR2 |
20 |
PI_TITLE |
Pi title associated with the record. |
VARCHAR2 |
75 |
SCHOOL_AREA_NAME |
School area name associated with the record. |
VARCHAR2 |
50 |
STATUS_END_DATE |
Date associated with status end. |
DATE |
|
STATUS_START_DATE |
Date associated with status start. |
DATE |