Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS PI LIST Table


XXX


Field Name

Description

Data Type

Length

ARCHIVE_END_DATE

XXX

DATE

ARCHIVE_START_DATE

XXX

DATE

EHS_SOURCE

XXX

VARCHAR2

10

KERBEROS_NAME

The Kerberos username of the 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

MAIN_PI

XXX

VARCHAR2

1

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