Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT TUITION ASSESSMENT Table


View exposing student tuition assessment data.


Field Name

Description

Data Type

Length

BASIS_CODE

Code identifying basis.

VARCHAR2

4

BASIS_CODE_DESC

Description of basis code.

VARCHAR2

30

ENROLLMENT_KEY

Surrogate key identifying the enrollment.

VARCHAR2

15

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

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

Surrogate key identifying the student term enrollment.

VARCHAR2

15

TERM_CODE

Term code associated with the record.

VARCHAR2

6

TUITION_ASSESSMENT

Tuition assessment associated with the record.

NUMBER

8,2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE