STUDENT TUITION ASSESSMENT Table
This table contains the tuition assessment for students by academic term.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
BASIS_CODE |
Tuition assessment basis code. Eg: GREG, UREG, REAS, X, ZERO, HST, GNDC, COOP, etc. |
VARCHAR2 |
4 |
BASIS_CODE_DESC |
Description for the tuition assessment basis code. Eg. "Graduate, Regular" for GREG, "Undergraduate, Regular" for UREG, "Graduate Research" for REAS, "Cross Reg or Exchange Student" for X, "Not Eligible" for ZERO, "HST Special" for HST, "Graduate, Non-res Doctorate" for GNDC, "Undergrad Fall/Spring Co-op" for COOP, etc. |
VARCHAR2 |
30 |
ENROLLMENT_KEY |
Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting. |
VARCHAR2 |
15 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
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_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
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 |
TUITION_ASSESSMENT |
Assessment of tuition for the academic term and the basis code. |
NUMBER |
8.2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |