| Data element |
Definition |
| Crse_Sect_Sched_With_Grp_Pk Indexed - yes
Format - Varchar2(21)
May be Null? N | internal warehouse primary key: based on TERM_CODE and XLIST_GROUP |
| Group_Enrollment Indexed - no
Format - Number
May be Null? Y | Most recent count of total enrollment this term across all sections in this group. This is the equivalent of the sum of the enrollment count of course sections that share the same group id (Sched_With_Group) in the term. See also CRSE_SECTION.XLIST_ENRLMT
Source field: SSBXLST_ENRL. |
| Group_Max_Enrlmnt Indexed - no
Format - Number
May be Null? Y | Maximum enrollment allowed this term across all sections in this group. Source field: SSBXLST_MAX_ENRL. |
| Group_Seats_Avail Indexed - no
Format - Number
May be Null? Y | Seats available in this term across all sections in this group. Source field: SSBXLST_SEATS_AVAIL. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Sched_With_Group Indexed - yes
Format - Varchar2(15)
May be Null? Y | Scheduled With section group identifier. Sections that share a Scheduled With group are sections that meet on the same days at the same times in the same rooms, taught by the same instructors. These are courses that are cross-listed and/or course sections that are meeting together in the same location taught by the same instructor. All sections meeting together are assigned to a group identifier. See also CRSE_SECT_SCHED_WITH table.
Source field: SSBXLST_XLST_GROUP. |
| Sched_With_Group_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Scheduled With group description. Source field: SSBXLST_DESC. |
| Sect_Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the group information was updated in the source. Source field: SSBXLST_ACTIVITY_DATE. |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | Scheduled With section term. Source field: SSBXLST_TERM_CODE. |
