STUDENT UAC ADVISORS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
The date of the last major change in the employment status. The date records only hires, leaves, terminations, retirements, and deaths. |
DATE |
|
ADVISOR_FULL_NAME |
Full name of the advisor (corresponding to ADVISOR_MIT_ID) to the student. |
VARCHAR2 |
77 |
ADVISOR_ID |
XXX |
VARCHAR2 |
9 |
ADVISOR_PIDM |
XXX |
VARCHAR2 |
8 |
ASSIGN_DATE |
XXX |
DATE |
|
FIRST_NAME |
The person's first name. |
VARCHAR2 |
15 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
93 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
60 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
15 |
STUDENT_MIT_ID |
The student's MIT ID |
VARCHAR2 |
9 |
STUDENT_PIDM |
XXX |
VARCHAR2 |
8 |
USER_ID |
In the Commitment History and Current Commitments tables, the kerberos ID of the person who entered the commitment. |
VARCHAR2 |
20 |
WAREHOUSE_INSERT_TIMESTAMP |
XXX |
DATE |
|
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WAREHOUSE_UPDATE_TIMESTAMP |
XXX |
DATE |