Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SSM SUBJECT ENROLLMENT DETAIL Table


This version of the Subject Enrollment table is specifically built for the Sloan School of Management.


Field Name

Description

Data Type

Length

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

FULL_NAME

The full name of the person.

VARCHAR2

90

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

NUMBER_OF_UNITS

For LIBRARY data: Number of individual items (units) being ordered; usually the number of copies. This number is multiplied by UNIT_PRICE to get LIBRARY_ORDER_AMOUNT. For Serial orders, this number is always 1. (Z68-NO-UNITS) For SUBJECT ENROLLMENT Data, this represent the number of units the student registered for the subject.

NUMBER

2

REGISTRANT_COUNT

Used to count registrant/student on a report. Always contains a value of 1.

NUMBER

1

REG_STATUS

The student's status of registration in the subject. Possible values are: Registered, Registered Listener, Early Thesis, and UROP

VARCHAR2

30

REG_STATUS_DATE

The effective date of the registration status.

DATE

8

SSM_STUDENT_REVENUE_KEY

Key field used to join to the SSM_STUDENT_REVENUE table. This field should be used only for joining data, NOT for reporting.

VARCHAR2

19

SSM_UNIQID_REVENUE_KEY

Key field used to join to the SSM_UNIQID_REVENUE table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

14

STUDENT_TERM_ENROLLMENT_KEY

Use this field to join to the STUDENT TERM ENROLLMENT table

VARCHAR2

15

SUBJECT_KEY

Key identifying an entry in the SUBJECT OFFERED table. This field should only be used for linking tables together, NOT for reporting.

VARCHAR2

16

UNIQID_COUNT

Used to count a unique registrant/student on a report.

NUMBER

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8