SUBJECT REG STATUS Table
View exposing subject registration status reference values used to classify registration conditions for academic subjects.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_FOR_CREDIT |
Indicator identifying whether for credit (Y/N). |
VARCHAR2 |
1 |
IS_INCLUDED_IN_FIFTH_WEEK |
Indicator identifying whether included in fifth week (Y/N). |
VARCHAR2 |
1 |
IS_LISTENER |
Indicator identifying whether listener (Y/N). |
VARCHAR2 |
1 |
IS_REGISTERED |
Indicator identifying whether registered (Y/N). |
VARCHAR2 |
1 |
IS_REG_CURRENT |
Indicator identifying whether reg current (Y/N). |
VARCHAR2 |
1 |
IS_REG_CURRENT_FOR_CREDIT |
Indicator identifying whether reg current for credit (Y/N). |
VARCHAR2 |
1 |
IS_REG_CURRENT_LISTENER |
Indicator identifying whether reg current listener (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK |
Indicator identifying whether reg fifth week (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK_FOR_CREDIT |
Indicator identifying whether reg fifth week for credit (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK_LISTENER |
Indicator identifying whether reg fifth week listener (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK |
Indicator identifying whether reg first week (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK_FOR_CREDIT |
Indicator identifying whether reg first week for credit (Y/N). |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK_LISTENER |
Indicator identifying whether reg first week listener (Y/N). |
VARCHAR2 |
1 |
REG_STATUS |
Reg status associated with the record. |
VARCHAR2 |
40 |
REG_STATUS_CODE |
Code identifying reg status. |
VARCHAR2 |
32 |
SUBJECT_REG_STATUS_KEY |
Surrogate key identifying the subject reg status. |
VARCHAR2 |
32 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |