SUBJECT REG STATUS Table
Subject registration status codes and descriptions
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_FOR_CREDIT |
XXX |
VARCHAR2 |
1 |
IS_INCLUDED_IN_FIFTH_WEEK |
'Y' indicates that this registration status should be included in the count of Fifth week enrollment. |
VARCHAR2 |
1 |
IS_LISTENER |
'Y' indicates that this is a "listener" registration status. |
VARCHAR2 |
1 |
IS_REGISTERED |
"Y" indicates that the student is currently registered. "N" indicates that the student is not currently registered. In the FINAID AID APPLICANT and FINAID APPLICANT tables, a "Y" in this field indicates that the student has registered for any one of the terms (in this order: Spring, Fall, Summer) of the aid year. "N" indicates that the student has not registered in any one of the three terms of the aid year. |
VARCHAR2 |
1 |
IS_REG_CURRENT |
XXX |
VARCHAR2 |
1 |
IS_REG_CURRENT_FOR_CREDIT |
XXX |
VARCHAR2 |
1 |
IS_REG_CURRENT_LISTENER |
XXX |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK |
XXX |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK_FOR_CREDIT |
XXX |
VARCHAR2 |
1 |
IS_REG_FIFTH_WEEK_LISTENER |
XXX |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK |
XXX |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK_FOR_CREDIT |
XXX |
VARCHAR2 |
1 |
IS_REG_FIRST_WEEK_LISTENER |
XXX |
VARCHAR2 |
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_CODE |
Subject registration status code. |
VARCHAR2 |
2 |
SUBJECT_REG_STATUS_KEY |
Key field used to join to the SUBJECT_REG_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |