STUDENT WITHDRAWN Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
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 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PIDM |
XXX |
VARCHAR2 |
8 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WITHDRAWN_DATE |
XXX |
DATE |