Meeting Times Object

The Meeting Time object is a repeating table that will contain a record for all meeting times including the final exam time. The data comes from the PROD table SSRMEET.

---

CRN

Course reference number assigned to the course section. CRNs are not unique across academic years.

Data Type: 5 Characters

Example: 20986

Source: ssbsect_crn

TERM

Code representing term course is offered. Format YYYYTT, where YYYY = academic year and TT = term or semester, 01 = Fall, 02 = Winter, 03 = Spring, 04 = Summer, 05 = Fall Semester, 06 = Spring Semester, 07 = Summer Semester.

Data Type: 6 Characters

Example: 199502

Source: ssbsect_term

Begin Time

Starting time (of day) of the first day of the week the course section is taught.

Data Type: 4 Characters

Example: 1000

Source: ssrmeet_begin_time

End Time

Ending time (of day) of the first day of the week the course section is taught.

Data Type: 4 Characters

Example: 1050

Source: ssrmeet_end_time

Building Code

Building where the first class meeting of the week will be taught.

Data Type: 6 Characters

Example: CAS

Source: ssrmeet_bldg_code

Val Table: Building

Building Description

Description of building defined by the building code.

Data Type: 30 Characters

Example: Cascade Hall

Source: stvbldg_desc

Val Table: Building

Room Code

Room where the first class meeting of the week will be taught.

Data Type: 5 Characters

Example: 230

Source: ssrmeet_room_code

Room Attr Codes

A concatenation of room attribute codes for a course.

Data Type: 100 Characters

Example: |MCOM|MDVD|

Source: ssrsrat_rdef_code

Room Attr Descs

A concatenation of room attribute descriptions for a course.

Data Type: 300 Characters

Example: |Data Projector|Laserdisc/DVD|

Source: stvrdef_desc

Activity Date

Date of last change.

Data Type: Date

Start Date

The beginning date of the class section.

Data Type: Date

Example: 01/03/95

Source: ssbsect_ptrm_start_date

End Date

The ending date of the class section.

Data Type: Date

Example: 03/11/95

Source: ssbsect_ptrm_end_date

Session Type

Code identifying session type. Regular type is '01'. Final Exam is '99'.

Data Type: 2 Characters

Weekdays

A combined field indicating all of the days a section meets.

Data Type: 7 Characters

Example: MWF

Source: Derived

Monday Flag

Flag (Y/NULL) indicating whether section meets on Monday.

Data Type: 1 Character

Tuesday Flag

Flag (Y/NULL) indicating whether section meets on Tuesday.

Data Type: 1 Character

Wednesday Flag

Flag (Y/NULL) indicating whether section meets on Wednesday.

Data Type: 1 Character

Thursday Flag

Flag (Y/NULL) indicating whether section meets on Thursday.

Data Type: 1 Character

Friday Flag

Flag (Y/NULL) indicating whether section meets on Friday.

Data Type: 1 Character

Saturday Flag

Flag (Y/NULL) indicating whether section meets on Saturday.

Data Type: 1 Character

Sunday Flag

Flag (Y/NULL) indicating whether section meets on Sunday.

Data Type: 1 Character