SPACT PERSON Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
|
XXX |
VARCHAR2 |
765 |
|
FIRST_NAME |
The person's first name. |
VARCHAR2 |
765 |
KRB_NAME |
Kerberos Name |
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 |
XXX |
VARCHAR2 |
765 |
PHONE_NUMBER |
Phone number of the credit card holder or verifier. |
VARCHAR2 |
45 |
VCS_GUID |
XXX |
VARCHAR2 |
150 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |