CAMPUS_EVENT_NBRCAMPUS_MTG_NBRCAMPUS_MTG4_VW(SQL View) |
Index Back |
|---|---|
Campus Meeting Table ViewThe Campus Meeting Table View is used to pluck existing events in the meeting table that would conflict with a class being scheduled. |
| SELECT a.campus_event_nbr , a.campus_mtg_nbr , a.meeting_dt , a.facility_id , a.day_of_wk , a.meeting_time_start , a.meeting_time_end , a.contact_minutes , a.class_mtg_nbr , a.event_mtg_nbr FROM PS_CAMPUS_MTG a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAMPUS_EVENT_NBR |
Character(9) | VARCHAR2(9) NOT NULL | Event ID |
| 2 | CAMPUS_MTG_NBR |
Number(4,0) | SMALLINT NOT NULL | Event Meeting Nbr |
| 3 | MEETING_DT | Date(10) | DATE NOT NULL | Meeting Date |
| 4 | FACILITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Facility ID |
| 5 | DAY_OF_WEEK | Character(9) | VARCHAR2(9) NOT NULL | Day |
| 6 | MEETING_TIME_START | Time(15) | TIMESTAMP NOT NULL | Meeting Start Time |
| 7 | MEETING_TIME_END | Time(15) | TIMESTAMP NOT NULL | Meeting End Time |
| 8 | CONTACT_MINUTES | Number(4,0) | SMALLINT NOT NULL | Contact Minutes |
| 9 | CLASS_MTG_NBR | Number(2,0) | SMALLINT NOT NULL | Class Meeting Pattern Nbr |
| 10 | EVENT_MTG_NBR | Number(4,0) | SMALLINT NOT NULL | Event Meeting Nbr |