| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The lastest date the section reserved seting information was updated in the source. Sourse field: SSRRESV_ACTIVITY_DATE |
| Admit_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Could potentially be used to reserve seats during course registration for people with a specified admit term. Not currently used at Penn. Source: SSRRESV_TERM_CODE_ADMIT |
| Attribute_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Used to reserve seats during course registration for people with a specified student attribute. Source: SSRRESV_ATTS_CODE |
| Campus Indexed - no
Format - Varchar2(3)
May be Null? Y | Used to reserve seats during course registration for people in a specified campus. Source: SSRRESV_CAMP_CODE |
| Classification Indexed - no
Format - Varchar2(2)
May be Null? Y | Used to reserve seats during course registration for people in a specified classification. Source: SSRRESV_CLAS_CODE |
| Cohort Indexed - no
Format - Varchar2(10)
May be Null? Y | Used to reserve seats during course registration for people in a specified cohort. Source: SSRRESV_CHRT_CODE |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | The Subject area and the Course number concatenated into one field. This column, along with the term, can be used to join to the COURSE table when needed. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Number that along with the Subject Area and Section Number, identifies the Course Section in the term. |
| Course_Ref_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The internal Banner Course Reference Number. Source field: SSRRESV_CRN |
| Crse_Sect_Reserve_Seat_Pk Indexed - yes
Format - Varchar2(51)
May be Null? N | Internal primary key for this warehouse table. |
| Degree_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Used to reserve seats during course registration for people in a specified classification. Source: SSRRESV_DEGC_CODE |
| Department Indexed - no
Format - Varchar2(4)
May be Null? Y | Could potentially be used to reserve seats during course registration for people in a specified department. Not currently used at Penn. Source: SSRRESV_DEPT_CODE |
| Division Indexed - no
Format - Varchar2(2)
May be Null? Y | Used to reserve seats during course registration for people in a specified division. Source: SSRRESV_COLL_CODE |
| Grad_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Could potentially be used to reserve seats during course registration for people with a specified admit term. Not currently used at Penn. Source: SSRRESV_TERM_CODE_GRAD |
| Level_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Used to reserve seats during course registration for people in a specified student level. Source: SSRRESV_LEVL_CODE |
| Major Indexed - no
Format - Varchar2(4)
May be Null? Y | Used to reserve seats during course registration for people in a specified major. Source: SSRRESV_MAJR_CODE |
| Matric_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Could potentially be used to reserve seats during course registration for people with a specified admit term. Not currently used at Penn. Source: SSRRESV_TERM_CODE_MATRIC |
| Max_Seats_For_Section Indexed - no
Format - Number
May be Null? Y | The total number of seats that the CRSE_SECTION record has defined for all enrollments in the section. The sum of the seats in all record types for a section should equal the max seats allowed.
Source: SSBSECT_MAX_ENRL |
| Minor Indexed - no
Format - Varchar2(4)
May be Null? Y | Used to reserve seats during course registration for people in a specified minor. Source: SSRRESV_MINR_CODE |
| Overflow_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | When the Overflow Indicator associated with the Reserved Seating rule is set to 'Y' it means additional students can register, beyond the number set in the Seats field. Source: SSRRESV_OVERFLOW_IND |
| Pri_Sec Indexed - no
Format - Varchar2(1)
May be Null? Y | Could potentially be used to indicate the reserved seating rule should apply to the student's primary or secondary program. Not currently used at Penn. |
| Program_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | Used to reserve seats during course registration for people in a specified program. Source: SSRRESV_PROGRAM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| Reservation_Type Indexed - no
Format - Varchar2(10)
May be Null? Y | Derived field indicating whether the record shows "reserved" seating maximums, or "unreserved" seating maximums. Each course section will have at least two records in this table: one showing the "unreserved" and the other(s) showing the "reserved"
For example, a section might have seats for 20 people. If the deparment wanted to make sure 10 students from a specific division got into the couse, in CRSE_SECTION_RESERVE_SEAT, it could have 10 seats "reserved" for a specific division's students, and the remaining 10 seats would be in the record marked with a reservation type of "unreserved".
Derived from Source field SSRRESV_SEQ_NO |
| Resv_Seq_No Indexed - no
Format - Number
May be Null? Y | See Reservation Type. Source field: SSRRESV_SEQ_NO |
| Resv_Type_Seats_Avail Indexed - no
Format - Number
May be Null? Y | A Banner calculated field, showing the remaining seats available for the reserved category, after registration for the term has begun. The value in this field is typically the Max_Seats_for_Section minus the Resv_Type_Seats_Enrld.
Source: SSRRESV_SEATS_AVAIL |
| Resv_Type_Seats_Enrld Indexed - no
Format - Number
May be Null? Y | A Banner calculated field, showing the number of students enrolled in the course section for the reserved category.
Source: SSRRESV_ENRL |
| Seats Indexed - no
Format - Number
May be Null? Y | The number of seats being reserved for the type of reserved seating identified on this record. For example, if the reserved seating indicates a classification of 'SR' (senior), that means that number of seat are reserved for undergraduate students with classification SR. Source: SSRRESV_MAX_ENRL |
| Section_Id Indexed - no
Format - Varchar2(12)
May be Null? Y | Subject, Course Number, and Sequence number together uniquely identify a course section. |
| Section_Num Indexed - no
Format - Varchar2(3)
May be Null? Y | Number that identifies the section of a course, associated with the Subject/Course Num. |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the Subject Area associated with the course section. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term that the section reserved seating rules will apply. |
