Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSE STUDENT REG STATUS MAP Table


XXX


Field Name

Description

Data Type

Length

OSE_STUDENT_REG_STATUS_KEY

XXX

VARCHAR2

8

SUBJECT_REG_STATUS_CODE

Subject registration code. Eg. RE (Registered), RL (Registered Listener), DE (Dropped Early, Not recorded), DR (Dropped after 5th week, on record), ET (Early thesis), AP (Advanced Placement), etc. You may query the SUBJECT_REG_STATUS table for more information about subject registration status.

VARCHAR2

2

WAREHOUSE_LOAD_DATE

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

DATE