SPACE SUPERVISOR SNAPSHOT Table
View exposing monthly snapshot records of supervisor reference data used in space reporting including MIT identifiers, DLC, usernames, names, titles, email addresses, personnel subarea, and person type.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
EMPLOYEE_TITLE |
Employee title associated with the record. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
KRB_NAME_UPPERCASE |
Krb name uppercase associated with the record. |
VARCHAR2 |
30 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
40 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the record. |
VARCHAR2 |
40 |
PERSON_TYPE |
Person type associated with the record. |
VARCHAR2 |
30 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
TIMESTAMP(6) |