EL PI DLC AFF HISTORY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AFFILIATION_START_DATE |
XXX |
DATE |
|
AFFILIATION_STATUS |
XXX |
VARCHAR2 |
9 |
DLC_CODE |
The code for the DLC associated with this room set, e.g., D_BIOLOGY. |
VARCHAR2 |
20 |
DLC_NAME |
The name of the DLC associated with this room set. |
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 |
XXX |
VARCHAR2 |
40 |
PI_ALT_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
PI_EMAIL |
XXX |
VARCHAR2 |
100 |
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 |
30 |
PI_MIT_ID |
XXX |
VARCHAR2 |
9 |
PI_OFFICE_LOC |
XXX |
VARCHAR2 |
40 |
PI_OFFICE_PHONE |
XXX |
VARCHAR2 |
20 |
PI_TITLE |
XXX |
VARCHAR2 |
75 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
50 |
STATUS_END_DATE |
XXX |
DATE |
|
STATUS_START_DATE |
XXX |
DATE |