| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | The last date any part of this record was updated in the source. Source field: SGRCLSR_ACTIVITY_DATE. |
| Classification Indexed - no
Format - Varchar2 (8)
May be Null? Y |
The classification (i.e. freshman, sophmore etc) associated with the level of the student for which the classification rule applies.
Source field: SGRCLSR_CLAS_CODE. Source validation table: STVCLAS. Warehouse validation table: V_CLASS. |
| Class_Rules_Level Indexed - no
Format - Varchar2 (8)
May be Null? Y | Level of the student associated with the classification rule. Source field: SGRCLSR_LEVL_CODE. Source validation table: STVLEVL. Warehouse validation table: V_STDNT_LEVEL. |
| Class_Rules_Pk Indexed - yes
Format - Varchar2 (28)
May be Null? N | Internal warehouse primary key, based on SGRCLSR_LEVL_CODE, SGRCLSR_CLAS_CODE, and SGRSLSR_SEQ_NO. |
| From_Hours Indexed - no
Format - Number (22)
May be Null? Y | Minimum number of credit hours for the class within the level, expressed in Banner Units. Source field: SGRCLSR_FROM_HOURS. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | The last date the table was refreshed in the warehouse |
| Seq_Num Indexed - no
Format - Number (22)
May be Null? Y | The classification rule sequence number. Source field: SGRCLSR_SEQ_NO. |
| To_Hours Indexed - no
Format - Number (22)
May be Null? Y | Maximum number of credit hours for the class within the level, expressed in Banner Units. Source field: SGRCLSR_TO_HOURS. |
