SSR_REQS_MTG_VW (SQL View)	Index Back
Requisite Student Meetings This view is used for writing XML data for students for the Post Enrollment Requistie Checking report.

SSR_REQS_MTG_VW

(SQL View)

Requisite Student Meetings

This view is used for writing XML data for students for the Post Enrollment Requistie Checking report.

SELECT B.INSTITUTION , B.STRM , B.CLASS_NBR , A.CLASS_MTG_NBR , A.CRSE_ID , A.CRSE_OFFER_NBR , A.SESSION_CODE , A.CLASS_SECTION , A.FACILITY_ID , A.MEETING_TIME_START , A.MEETING_TIME_END , A.MON , A.TUES , A.WED , A.THURS , A.FRI , A.SAT , A.SUN , A.START_DT , A.END_DT , A.CRS_TOPIC_ID , A.DESCR , A.STND_MTG_PAT , A.PRINT_TOPIC_ON_XCR , ' ' , ' ' , ' ' , ' ' , %TextIn(' ') FROM PS_CLASS_MTG_PAT A , PS_CLASS_TBL B WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term
Default Value: OPR_DEF_TBL_CS.STRM
Prompt Table: TERM_VAL_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

4 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr

5 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

6 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

7 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2

8 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section

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

10 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time

11 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time

12 MON Character(1) VARCHAR2(1) NOT NULL Monday
Y/N Table Edit
Default Value: N

13 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday
Y/N Table Edit
Default Value: N

14 WED Character(1) VARCHAR2(1) NOT NULL Wednesday
Y/N Table Edit
Default Value: N

15 THURS Character(1) VARCHAR2(1) NOT NULL Thursday
Y/N Table Edit
Default Value: N

16 FRI Character(1) VARCHAR2(1) NOT NULL Friday
Y/N Table Edit
Default Value: N

17 SAT Character(1) VARCHAR2(1) NOT NULL Saturday
Y/N Table Edit
Default Value: N

18 SUN Character(1) VARCHAR2(1) NOT NULL Sunday
Y/N Table Edit
Default Value: N

19 START_DT Date(10) DATE NOT NULL Start Date
Default Value: CLASS_TBL.START_DT

20 END_DT Date(10) DATE NOT NULL end date
Default Value: CLASS_TBL.END_DT

21 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
Prompt Table: CRSE_TOPICS_VW2

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

23 STND_MTG_PAT Character(4) VARCHAR2(4) NOT NULL Standard Meeting Pattern
Prompt Table: STND_MTGPAT_TBL

24 PRINT_TOPIC_ON_XCR Character(1) VARCHAR2(1) NOT NULL Print Topic On Transcript
Y/N Table Edit
Default Value: N

25 SSR_MTG_SCHD_DESCR Character(254) VARCHAR2(254) NOT NULL This field is used for holding the meeting schedule description used in the xml file for post enrollment requisite check reports.

26 SSR_MTG_LOC_DESCR Character(254) VARCHAR2(254) NOT NULL This field is used for holding the room location for the xml file used in the post enrollment requisite check report.

27 SSR_MTG_DT_DESCR Character(254) VARCHAR2(254) NOT NULL This field is used to hold the date string for the xml file for the post enrollment requisite check report.

28 SSR_CLSTOPIC_DESCR Character(254) VARCHAR2(254) NOT NULL This field is used to hold the class topic to be used in the xml file used to create the post enrollment requisite check report.

29 SSR_INSTR_DESCR Long Character CLOB This field is used to hold a list of instructors to be used in the xml file for the post enrollment requisite check report.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Default Value: OPR_DEF_TBL_CS.STRM Prompt Table: TERM_VAL_TBL
3	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr
4	CLASS_MTG_NBR	Number(2,0)	SMALLINT NOT NULL	Class Meeting Pattern Nbr
5	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
6	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
7	SESSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Session 1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2
8	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section
9	FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Facility ID Prompt Table: FACILITY_TBL
10	MEETING_TIME_START	Time(15)	TIMESTAMP	Meeting Start Time
11	MEETING_TIME_END	Time(15)	TIMESTAMP	Meeting End Time
12	MON	Character(1)	VARCHAR2(1) NOT NULL	Monday Y/N Table Edit Default Value: N
13	TUES	Character(1)	VARCHAR2(1) NOT NULL	Tuesday Y/N Table Edit Default Value: N
14	WED	Character(1)	VARCHAR2(1) NOT NULL	Wednesday Y/N Table Edit Default Value: N
15	THURS	Character(1)	VARCHAR2(1) NOT NULL	Thursday Y/N Table Edit Default Value: N
16	FRI	Character(1)	VARCHAR2(1) NOT NULL	Friday Y/N Table Edit Default Value: N
17	SAT	Character(1)	VARCHAR2(1) NOT NULL	Saturday Y/N Table Edit Default Value: N
18	SUN	Character(1)	VARCHAR2(1) NOT NULL	Sunday Y/N Table Edit Default Value: N
19	START_DT	Date(10)	DATE NOT NULL	Start Date Default Value: CLASS_TBL.START_DT
20	END_DT	Date(10)	DATE NOT NULL	end date Default Value: CLASS_TBL.END_DT
21	CRS_TOPIC_ID	Number(3,0)	SMALLINT NOT NULL	Course Topic ID Prompt Table: CRSE_TOPICS_VW2
22	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
23	STND_MTG_PAT	Character(4)	VARCHAR2(4) NOT NULL	Standard Meeting Pattern Prompt Table: STND_MTGPAT_TBL
24	PRINT_TOPIC_ON_XCR	Character(1)	VARCHAR2(1) NOT NULL	Print Topic On Transcript Y/N Table Edit Default Value: N
25	SSR_MTG_SCHD_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is used for holding the meeting schedule description used in the xml file for post enrollment requisite check reports.
26	SSR_MTG_LOC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is used for holding the room location for the xml file used in the post enrollment requisite check report.
27	SSR_MTG_DT_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is used to hold the date string for the xml file for the post enrollment requisite check report.
28	SSR_CLSTOPIC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	This field is used to hold the class topic to be used in the xml file used to create the post enrollment requisite check report.
29	SSR_INSTR_DESCR	Long Character	CLOB	This field is used to hold a list of instructors to be used in the xml file for the post enrollment requisite check report.