SPACT PERSON Table
View exposing sponsored-access person reference data keyed by source GUID including MIT ID, Kerberos username, first name, date of birth, organization, email, phone number, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
Email associated with the record. |
VARCHAR2 |
765 |
|
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
765 |
KRB_NAME |
Krb name associated with the record. |
VARCHAR2 |
24 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
27 |
ORGANIZATION |
Organization associated with the record. |
VARCHAR2 |
765 |
PHONE_NUMBER |
Phone number associated with the record. |
VARCHAR2 |
45 |
VCS_GUID |
Vcs guid associated with the record. |
VARCHAR2 |
150 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |