Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SSM STUDENT REVENUE Table


View exposing student-revenue classification reference data for SSM reporting including revenue type and revenue group.


Field Name

Description

Data Type

Length

SSM_STUDENT_REVENUE_KEY

Surrogate key identifying the ssm student revenue.

VARCHAR2

19

STUDENT_REVENUE_GROUP

Student revenue group associated with the record.

VARCHAR2

35

STUDENT_REVENUE_TYPE

Student revenue type associated with the record.

VARCHAR2

20

STUDENT_TYPE

Student type associated with the record.

VARCHAR2

5

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE