TRN_CRS_ROOM_VW (SQL View)	Index Back
Training Rooms for Courses A view that shows compares the capacity of training rooms against the maximum capacity of a training course (i.e. max students), and lists valid training course / training room combinations.

TRN_CRS_ROOM_VW

(SQL View)

Training Rooms for Courses

A view that shows compares the capacity of training rooms against the maximum capacity of a training course (i.e. max students), and lists valid training course / training room combinations.

SELECT B.COURSE , A.FACILITY , A.ROOM_CD , A.ROOM_NBR FROM PS_TRN_ROOM_TBL A , PS_COURSE_TBL B WHERE A.MAX_STUDENTS >=B.MAX_STUDENTS OR A.MAX_STUDENTS = 0

Related Language Record: TRN_CRSROOM_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

2 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

3 ROOM_CD Character(6) VARCHAR2(6) NOT NULL Room Code

4 ROOM_NBR Character(30) VARCHAR2(30) NOT NULL Room Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code
2	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
3	ROOM_CD	Character(6)	VARCHAR2(6) NOT NULL	Room Code
4	ROOM_NBR	Character(30)	VARCHAR2(30) NOT NULL	Room Number