SPACE PERSON SNAPSHOT Table
View exposing monthly snapshot records of person reference data used in space reporting including MIT identifiers, usernames, names, titles, email addresses, organizational assignments, active and paid indicators, and HQA flags.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
HQA_FLAG |
Indicator identifying whether hqa (Y/N). |
VARCHAR2 |
10 |
IS_ACTIVE |
Indicator identifying whether active (Y/N). |
VARCHAR2 |
1 |
IS_PAID |
Indicator identifying whether paid (Y/N). |
VARCHAR2 |
1 |
KRB_NAME_UPPERCASE |
Krb name uppercase associated with the record. |
VARCHAR2 |
50 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
60 |
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 |
ORGANIZATION |
Organization associated with the record. |
VARCHAR2 |
75 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the record. |
VARCHAR2 |
40 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_INSERT_TIMESTAMP |
Warehouse insert timestamp associated with the warehouse record. |
TIMESTAMP(6) |