W3HR_CR_TAKN_VW (SQL View)	Index Back
# of taken seats 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 enrolled, currently attending or incomplete." Used in Self Service Transactions

W3HR_CR_TAKN_VW

(SQL View)

# of taken seats 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 enrolled, currently attending or incomplete." Used in Self Service Transactions

SELECT B.COURSE, B.SESSION_NBR, COUNT(*) FROM PS_TRAINING A, PS_CRSE_SESSN_TBL B WHERE A.COURSE = B.COURSE AND A.SESSION_NBR = B.SESSION_NBR AND A.ATTENDANCE IN ('A','E','I') GROUP BY B.COURSE, B.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 TAKEN_SEATS Number(3,0) SMALLINT NOT NULL Taken Seats

#	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	TAKEN_SEATS	Number(3,0)	SMALLINT NOT NULL	Taken Seats