| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date the meeting informaton for this section was updated in the source. Source field: SSRMEET_ACTIVITY_DATE. |
| Begin_Time Indexed - no
Format - Varchar2(4)
May be Null? Y | The Begin Time of the course section being scheduled, in 24-hour time format. Source field: SSRMEET_BEGIN_TIME. |
| Begin_Time_12_Hr Indexed - no
Format - Varchar2(7)
May be Null? Y | The Begin Time of the course section being scheduled, in 12-hour time format. From source field: SSRMEET_BEGIN_TIME |
| Building Indexed - no
Format - Varchar2(6)
May be Null? Y | The Building code for the building where the course section will be scheduled. Source field: SSRMEET_BLDG_CODE. Source validation table: STVBLDG. Warehouse validation table: V_BUILDING. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Number that identifies the course in the subject. The Subject and Course Number come from the COURSE table, no course section can have a Course Num that is not defined in COURSE. Source field: SSBSECT_CRSE_NUMB. |
| 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. Source fields: SSBSECT_SUBJ_CODE+SSBSECT_CRSE_NUMB. |
| Course_Ref_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The internal Banner Course Reference Number. Source field: SSRMEET_CRN |
| Crse_Sect_Meeting_Pk Indexed - yes
Format - Varchar2(38)
May be Null? N | Internal warehouse primary key. The following source fields concatenated together:
SSRMEET_TERM_CODE || SSRMEET_CRN || SSRMEET_BEGIN_TIME || SSRMEET_MON_DAY || SSRMEET_TUE_DAY || SSRMEET_WED_DAY || SSRMEET_THU_DAY || SSRMEET_FRI_DAY || SSRMEET_SAT_DAY ||
SSRMEET_SUN_DAY||SSRMEET_BLDG_CODE||SSRMEET_ROOM_CODE |
| Day_Code_Alpha Indexed - no
Format - Varchar2(7)
May be Null? Y | A concatenation of the Day code found in MEETS_MONDAY, MEETS_TUESDAY, MEETS_WEDNESDAY, etc. |
| Day_Code_Numb Indexed - no
Format - Number
May be Null? Y | The day number as defined on the STVDAYS Validation Form. Not currently used at Penn. |
| End_Date Indexed - no
Format - Date
May be Null? Y | Section End Date. Note: this can be different from the end date on the Part-of-Term assigned to the course section. The end date on CRSE_SECT_MEETING can override the Part-of-Term dates. (See also CRSE_SECTION.PTRM_END_DATE.) Source field: SSRMEET_END_DATE |
| End_Time Indexed - no
Format - Varchar2(4)
May be Null? Y | The End Time of the course section being scheduled, in 24-hour time format. Source field: SSRMEET_END_TIME. |
| End_Time_12_Hr Indexed - no
Format - Varchar2(7)
May be Null? Y | The End Time of the course section being scheduled, in 12-hour time format. From source field: SSRMEET_END_TIME. |
| Meeting_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | The meeting type code assigned to this meeting time of the section. Source field: SSRMEET_MTYP_CODE. Source validation table: GTVMTYP. Warehouse validation table: V_MEETING_TYPE. |
| Meets_Friday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Friday Indicator. Source field: SSRMEET_FRI_DAY |
| Meets_Monday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Monday Indicator. Source field: SSRMEET_MON_DAY |
| Meets_Saturday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Saturday Indicator. Source field: SSRMEET_SAT_DAY |
| Meets_Sunday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Sunday Indicator. Source field: SSRMEET_SUN_DAY |
| Meets_Thursday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Thrusday Indicator. Source field: SSRMEET_THU_DAY |
| Meets_Tuesday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Tuesday Indicator. Source field: SSRMEET_TUE_DAY |
| Meets_Wednesday Indexed - no
Format - Varchar2(1)
May be Null? Y | Section Meeting Time Wednesday Indicator. Source field: SSRMEET_WED_DAY |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| Room Indexed - no
Format - Varchar2(10)
May be Null? Y | The Room where the course section will be scheduled. Source field: SSRMEET_ROOM_CODE. |
| Schedule_Type Indexed - no
Format - Varchar2(3)
May be Null? Y | Section Schedule Type code. Source field: SSRMEET_SCHD_CODE. Source validation table: STVSCHD. Warehouse validation table: V_SCHED_TYPE. |
| 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. A Section number can only be used once to identify a Subject/Course Num combination in a term. Source field: SSBSECT_SEQ_NUMB. |
| Session_Ind Indexed - no
Format - Varchar2(2)
May be Null? Y | Section Indicator. Source field: SSRMEET_CATAGORY. |
| Start_Date Indexed - no
Format - Date
May be Null? Y | Section Meeting Start Date. Note that this can be different from the start of the Part-of-Term assigned to the course section. The start date on CRSE_SECT_MEETING can override the Part-of-Term dates. (See also CRSE_SECTION.PTRM_START_DATE.) Source field: SSRMEET_START_DATE |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the Subject Area associated with the course section. The Subject and Course Number come from the COURSE table, no course section can have a Subject that is not defined in COURSE. Source field: SSBSECT_SUBJ_CODE . Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | the term the course section is being offered. Source field: SSRMEET_TERM_CODE. Source validation table: STVTERM. Warehouse validation table: V_TERM. |
