TRN_ROOM_SEL_VW (SQL View)	Index Back
Training Room Selection View Administer Training view of active training rooms at a training facility.

TRN_ROOM_SEL_VW

(SQL View)

Training Room Selection View

Administer Training view of active training rooms at a training facility.

SELECT A.FACILITY , B.ROOM_CD , B.ROOM_NBR , B.MAX_STUDENTS FROM PS_TRN_FACIL_TBL A , PS_TRN_ROOM_TBL B WHERE B.FACILITY=A.FACILITY AND B.ROOM_ACTIVE='Y'

Related Language Record: TRN_ROOMSEL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 MAX_STUDENTS Number(3,0) SMALLINT NOT NULL Maximum Nbr of Students

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
2	ROOM_CD	Character(6)	VARCHAR2(6) NOT NULL	Room Code
3	ROOM_NBR	Character(30)	VARCHAR2(30) NOT NULL	Room Number
4	MAX_STUDENTS	Number(3,0)	SMALLINT NOT NULL	Maximum Nbr of Students