STUDENT PROCUREMENT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CURRENT_TERM_CODE |
Term code (eg. 2002FA, 2003SP) of the current academic term. |
VARCHAR2 |
6 |
IS_ELIGIBLE_TO_REGISTER |
XXX |
VARCHAR2 |
1 |
LATEST_TERM_CODE |
According to the Registrar's Office, the latest possible academic term that the student is eligible to register |
VARCHAR2 |
6 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
STUDENT_YEAR |
The student's primary year of degree for the current term. Values include 1,2,3,4 (for freshman through senior), G for Graduate, and U for Special Undergraduate. If the student is in the graduate school and also is still an undergraduate student, then this field should always contain a "G". The undergraduate year is then stored in the Undergraduate Year (UG YEAR) field, if applicable. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |