PRE REG SUBJECT Table
View exposing pre-registration subject records including subject identifiers and related attributes used in pre-registration processing.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
PRE_REG_SUBJECT_KEY |
Surrogate key identifying the pre reg subject. |
VARCHAR2 |
15 |
SUBJECT_CODE |
Code identifying subject. |
VARCHAR2 |
3 |
SUBJECT_CODE_SORT |
Subject code sort associated with the record. |
VARCHAR2 |
3 |
SUBJECT_ID |
Business identifier for the subject. |
VARCHAR2 |
8 |
SUBJECT_NUMBER |
Subject number associated with the record. |
VARCHAR2 |
4 |
SUBJECT_OFFERED_STATUS |
Subject offered status associated with the record. |
VARCHAR2 |
100 |
SUBJECT_OFFERED_STATUS_CODE |
Code identifying subject offered status. |
VARCHAR2 |
2 |
SUBJECT_TITLE |
Subject title associated with the record. |
VARCHAR2 |
60 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |