|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
-
This page was last updated on June 21, 2007.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
