FACIL_EQUIP_VW (SQL View)	Index Back
Booked Facility Equipment View This view details all equipment booked for course sessions that is not available as fixed equipment in the training room itself, i.e. is needed from the equipment available at the training facility.

FACIL_EQUIP_VW

(SQL View)

Booked Facility Equipment View

This view details all equipment booked for course sessions that is not available as fixed equipment in the training room itself, i.e. is needed from the equipment available at the training facility.

SELECT B.FACILITY ,A.EQUIP_CD , A.QUANTITY , B.SESSN_START_DT , B.SESSN_END_DT , B.SESSN_START_TIME , B.SESSN_END_TIME FROM PS_CRSE_SESS_EQUIP A , PS_CRSE_SESS_DATES B WHERE A.COURSE=B.COURSE AND A.SESSION_NBR=B.SESSION_NBR AND A.EQUIP_CD NOT IN ( SELECT C.EQUIP_CD FROM PS_TRN_ROOM_EQUIP C , PS_TRN_ROOM_TBL D WHERE C.FACILITY=B.FACILITY AND C.ROOM_CD=B.ROOM_CD AND C.FACILITY=D.FACILITY AND C.ROOM_CD=D.ROOM_CD AND D.MAX_STUDENTS <= C.QUANTITY )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EQUIP_CD Character(4) VARCHAR2(4) NOT NULL Equipment/Materials Code

3 QUANTITY Number(3,0) SMALLINT NOT NULL Quantity

4 SESSN_START_DT Date(10) DATE Session Start Date

5 SESSN_END_DT Date(10) DATE Session End Date

6 SESSN_START_TIME Time(15) TIMESTAMP Start Time

7 SESSN_END_TIME Time(15) TIMESTAMP End Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
2	EQUIP_CD	Character(4)	VARCHAR2(4) NOT NULL	Equipment/Materials Code
3	QUANTITY	Number(3,0)	SMALLINT NOT NULL	Quantity
4	SESSN_START_DT	Date(10)	DATE	Session Start Date
5	SESSN_END_DT	Date(10)	DATE	Session End Date
6	SESSN_START_TIME	Time(15)	TIMESTAMP	Start Time
7	SESSN_END_TIME	Time(15)	TIMESTAMP	End Time