CRS_SESSPLAN_VW

(SQL View)
 Index Back

Course Session Dates View

This view shows all dates ( and times ) for course sessions including facility and training room, and is used with the Course Session Planner.

SELECT A.FACILITY , A.FACILITY_NAME ,A.ROOM_CD , B.ROOM_NBR ,A.COURSE , A.SESSION_NBR , A.CUT_SESSION_NBR , A.SESSN_START_DT , A.SESSN_END_DT , A.SESSN_START_TIME , A.SESSN_END_TIME , B.MAX_STUDENTS FROM PS_CRSE_SESS_DATES A ,PS_TRN_ROOM_TBL B , PS_CRSE_SESSN_TBL C WHERE A.FACILITY = B.FACILITY AND A.ROOM_CD = B.ROOM_CD AND A.COURSE = C.COURSE AND A.SESSION_NBR = C.SESSION_NBR AND C.SESSION_STATUS <> 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility
2 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
3 ROOM_CD Character(6) VARCHAR2(6) NOT NULL Room Code
4 ROOM_NBR Character(30) VARCHAR2(30) NOT NULL Room Number
5 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
6 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
7 CUT_SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Cut Session Nbr
8 SESSN_START_DT Date(10) DATE Session Start Date
9 SESSN_END_DT Date(10) DATE Session End Date
10 SESSN_START_TIME Time(15) TIMESTAMP Start Time
11 SESSN_END_TIME Time(15) TIMESTAMP End Time
12 MAX_STUDENTS Number(3,0) SMALLINT NOT NULL Maximum Nbr of Students