CRS_1ST_SESS_VW

(SQL View)
Index Back

Course Session Start Info

This view contains the start date & time of all course sessions, and is used in other views to obtain the name of the training facility where the first session is to be held.

SELECT A.COURSE ,A.SESSION_NBR ,A.SESSN_START_DT ,MIN(A.SESSN_START_TIME) FROM PS_CRSE_SESS_DATES A WHERE A.SESSN_START_DT = ( SELECT MIN(B.SESSN_START_DT) FROM PS_CRSE_SESS_DATES B WHERE B.COURSE=A.COURSE AND B.SESSION_NBR=A.SESSION_NBR) GROUP BY A.COURSE,A.SESSION_NBR,A.SESSN_START_DT

# 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 SESSN_START_DT Date(10) DATE Session Start Date
4 SESSN_START_TIME Time(15) TIMESTAMP Start Time