SPACE SUPERVISOR SNAPSHOT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
50 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
EMPLOYEE_TITLE |
The person's job title, from HR. |
VARCHAR2 |
100 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
KRB_NAME_UPPERCASE |
The Kerberos username of a person, in uppercase. |
VARCHAR2 |
30 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
40 |
MIDDLE_NAME |
The person's middle name (where available). |
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 |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
40 |
PERSON_TYPE |
In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member. |
VARCHAR2 |
30 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
TIMESTAMP(6) |