W3HR_CR_WAIT_VW (SQL View)	Index Back
# of Wait Listed by session This view is used in the Training Enrollment self service application. It displays the number of seats for a course session which are either course waitlisted or session waitlisted. Used in Self Service Transactions

W3HR_CR_WAIT_VW

(SQL View)

# of Wait Listed by session

This view is used in the Training Enrollment self service application. It displays the number of seats for a course session which are either course waitlisted or session waitlisted. Used in Self Service Transactions

SELECT A.COURSE, A.SESSION_NBR, COUNT(*) FROM PS_TRAINING A, PS_CRSE_SESSN_TBL B WHERE A.COURSE = B.COURSE AND B.SESSION_NBR = A.SESSION_NBR AND A.ATTENDANCE IN ('W','S') GROUP BY A.COURSE, A.SESSION_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

3 WAITLISTED Signed Number(4,0) DECIMAL(3) NOT NULL Waitlisted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code
2	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr
3	WAITLISTED	Signed Number(4,0)	DECIMAL(3) NOT NULL	Waitlisted