PRE REG SECTION Table
This is a dimension table for the Pre Registration Data. It contains all the possible sections for Lecture, Lab, Recitation, and Design that a student has pre-registered for.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
ASSIGNED_DESIGN_SECTION |
The scheduled or assigned design section for the subject. |
VARCHAR2 |
3 |
ASSIGNED_LAB_SECTION |
The scheduled or assigned lab section for the subject. |
VARCHAR2 |
3 |
ASSIGNED_LECTURE_SECTION |
The scheduled or assigned lecture section for the subject. |
VARCHAR2 |
3 |
ASSIGNED_RECITATION_SECTION |
The scheduled or assigned recitation section for the subject. |
VARCHAR2 |
3 |
PRE_REG_SECTION_KEY |
Use this field to join between the PRE REG DETAIL and the PRE REG SECTION tables. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |