CRS_SESSNVW_LNG (SQL View)	Index Back
Prompt/Srch-Active Trng Sessns CRSE_SESSN_VW belongs to the Training Administration application. This record is a search view that selects only those course sessions from CRSE_SESSN_TBL that are active (session status = 'A'). For example, when you request the Auto Enrollment panel, the list of course sessions from which you can select is from this record, because you only want to enroll students in sessions that are active.

CRS_SESSNVW_LNG

(SQL View)

Prompt/Srch-Active Trng Sessns

CRSE_SESSN_VW belongs to the Training Administration application. This record is a search view that selects only those course sessions from CRSE_SESSN_TBL that are active (session status = 'A'). For example, when you request the Auto Enrollment panel, the list of course sessions from which you can select is from this record, because you only want to enroll students in sessions that are active.

SELECT A.COURSE ,A.SESSION_NBR ,B.LANGUAGE_CD ,B.DESCR ,D.FACILITY_NAME FROM PS_CRSE_SESSN_TBL A , PS_COURSE_TBL_LANG B , PS_CRSE_SESS_DATES D , PS_CRS_1ST_SESS_VW E WHERE A.COURSE = B.COURSE AND A.COURSE = D.COURSE AND A.SESSION_NBR = D.SESSION_NBR AND A.COURSE_START_DT = D.SESSN_START_DT AND D.COURSE = E.COURSE AND D.SESSION_NBR = E.SESSION_NBR AND D.SESSN_START_DT = E.SESSN_START_DT AND D.SESSN_START_TIME = E.SESSN_START_TIME AND NOT EXISTS( SELECT 'X' FROM PS_CRS_SESSDTS_LNG F WHERE F.COURSE = D.COURSE AND F.SESSION_NBR = D.SESSION_NBR AND F.CUT_SESSION_NBR = D.CUT_SESSION_NBR AND F.LANGUAGE_CD = B.LANGUAGE_CD) UNION SELECT A.COURSE ,A.SESSION_NBR ,F.LANGUAGE_CD ,B.DESCR ,F.FACILITY_NAME FROM PS_CRSE_SESSN_TBL A , PS_COURSE_TBL B , PS_CRSE_SESS_DATES D , PS_CRS_SESSDTS_LNG F , PS_CRS_1ST_SESS_VW E WHERE A.COURSE = B.COURSE AND A.COURSE = D.COURSE AND A.SESSION_NBR = D.SESSION_NBR AND A.COURSE_START_DT = D.SESSN_START_DT AND D.COURSE = E.COURSE AND D.SESSION_NBR = E.SESSION_NBR AND D.SESSN_START_DT = E.SESSN_START_DT AND D.SESSN_START_TIME = E.SESSN_START_TIME AND F.COURSE = D.COURSE AND F.SESSION_NBR = D.SESSION_NBR AND F.CUT_SESSION_NBR = D.CUT_SESSION_NBR AND NOT EXISTS ( SELECT 'Y' FROM PS_COURSE_TBL_LANG B1 WHERE B1.COURSE = A.COURSE AND B1.LANGUAGE_CD = F.LANGUAGE_CD) UNION SELECT A.COURSE ,A.SESSION_NBR ,F.LANGUAGE_CD ,B.DESCR ,F.FACILITY_NAME FROM PS_CRSE_SESSN_TBL A , PS_COURSE_TBL_LANG B , PS_CRSE_SESS_DATES D , PS_CRS_SESSDTS_LNG F , PS_CRS_1ST_SESS_VW E WHERE A.COURSE = B.COURSE AND A.COURSE = D.COURSE AND A.SESSION_NBR = D.SESSION_NBR AND A.COURSE_START_DT = D.SESSN_START_DT AND D.COURSE = E.COURSE AND D.SESSION_NBR = E.SESSION_NBR AND D.SESSN_START_DT = E.SESSN_START_DT AND D.SESSN_START_TIME = E.SESSN_START_TIME AND F.COURSE = D.COURSE AND F.SESSION_NBR = D.SESSION_NBR AND F.CUT_SESSION_NBR = D.CUT_SESSION_NBR AND F.LANGUAGE_CD = B.LANGUAGE_CD

Related Language Record for CRSE_SESSN_AEVW CRSE_SESSN_A_VW CRSE_SESSN_VW SESSN_ALL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
Prompt Table: COURSE_TBL

2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
Default Value: 1

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_TBL
2	SESSION_NBR	Character(4)	VARCHAR2(4) NOT NULL	Course Session Nbr Default Value: 1
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	FACILITY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Facility Name