CAMPUS_MTG (SQL Table)	Index Back
Campus Meeting Table Campus Meeting Table consists of daily load information for all campus facilities. It makes the task of finding out what is going on in a facility on any given day trivial. This table should never be directly updated by users. It is populated as rows are updated either in the Event Meeting Table or the Class Meeting Pattern Table.

CAMPUS_MTG

(SQL Table)

Campus Meeting Table

Campus Meeting Table consists of daily load information for all campus facilities. It makes the task of finding out what is going on in a facility on any given day trivial. This table should never be directly updated by users. It is populated as rows are updated either in the Event Meeting Table or the Class Meeting Pattern Table.

Related Language Record: CAMPUS_MTG_LANG

Parent record: CAMPUS_EVENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
Default Value: 0
Prompt Table: CAMPUS_EVENT

2 CAMPUS_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr

3 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
Prompt Table: FACILITY_TBL

4 MEETING_DT Date(10) DATE Meeting Date

5 DAY_OF_WK Character(1) VARCHAR2(1) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday

6 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time

7 MEETING_TIME_END Time(15) TIMESTAMP 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 CAMPUS_MTG_TYPE Character(4) VARCHAR2(4) NOT NULL Campus Meeting Type
CRSE=Course
DISC=Discussion Group
EXAM=Class Examination
FAIR=Recruiting Fair
INFO=Information Session
INTV=Interview
MTG=Meeting
RCPT=Reception
SMNR=Seminar
TOUR=Campus Tour
WRKS=Workshop

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: CAMPUS_MTG.DESCR

13 CAMPUS_MTG_LOC Character(1) VARCHAR2(1) NOT NULL Campus Meeting Location
C=Campus Facility
E=External Org Facility
O=Other Facility
Default Value: C

14 SCHED_CAMPUS_MTG Character(1) VARCHAR2(1) NOT NULL Scheduled Campus Meeting
Y/N Table Edit
Default Value: Y

15 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr

16 CLASS_EXAM_SEQ Number(2,0) SMALLINT NOT NULL Class Exam Sequence Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAMPUS_EVENT_NBR	Character(9)	VARCHAR2(9) NOT NULL	Event ID Default Value: 0 Prompt Table: CAMPUS_EVENT
2	CAMPUS_MTG_NBR	Number(4,0)	SMALLINT NOT NULL	Event Meeting Nbr
3	FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Facility ID Prompt Table: FACILITY_TBL
4	MEETING_DT	Date(10)	DATE	Meeting Date
5	DAY_OF_WK	Character(1)	VARCHAR2(1) NOT NULL	Day of the Week 1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday
6	MEETING_TIME_START	Time(15)	TIMESTAMP	Meeting Start Time
7	MEETING_TIME_END	Time(15)	TIMESTAMP	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	CAMPUS_MTG_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Campus Meeting Type CRSE=Course DISC=Discussion Group EXAM=Class Examination FAIR=Recruiting Fair INFO=Information Session INTV=Interview MTG=Meeting RCPT=Reception SMNR=Seminar TOUR=Campus Tour WRKS=Workshop
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: CAMPUS_MTG.DESCR
13	CAMPUS_MTG_LOC	Character(1)	VARCHAR2(1) NOT NULL	Campus Meeting Location C=Campus Facility E=External Org Facility O=Other Facility Default Value: C
14	SCHED_CAMPUS_MTG	Character(1)	VARCHAR2(1) NOT NULL	Scheduled Campus Meeting Y/N Table Edit Default Value: Y
15	EVENT_MTG_NBR	Number(4,0)	SMALLINT NOT NULL	Event Meeting Nbr
16	CLASS_EXAM_SEQ	Number(2,0)	SMALLINT NOT NULL	Class Exam Sequence Nbr