Penn Computing

University of Pennsylvania
Penn Computing << go backback
CRSE_SECT_MEETING Table . Pennant Student Records Home . Data Warehouse Home

CRSE_SECT_MEETING Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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_SURROGATE_ID

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.

CRSE_SECT_MEETING Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania