CRSE_INSESSN_VW (SQL View)	Index Back
Prompt/Srch-Active TrngCourses This record is a search view that selects only those courses thant have active 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.

CRSE_INSESSN_VW

(SQL View)

Prompt/Srch-Active TrngCourses

This record is a search view that selects only those courses thant have active 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 DISTINCT A.COURSE , B.DESCR FROM PS_CRSE_SESSN_TBL A , PS_COURSE_TBL B , PS_CRSE_SESS_DATES C , PS_CRS_1ST_SESS_VW D WHERE A.SESSION_STATUS = 'A' AND A.SESSN_ORGANIZER = 'Y' AND A.COURSE = B.COURSE AND A.COURSE = C.COURSE AND A.SESSION_NBR = C.SESSION_NBR AND A.COURSE_START_DT = C.SESSN_START_DT AND C.COURSE = D.COURSE AND C.SESSION_NBR = D.SESSION_NBR AND C.SESSN_START_DT = D.SESSN_START_DT AND C.SESSN_START_TIME = D.SESSN_START_TIME

Related Language Record: CRSE_INSESSN_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_SRCH_VW
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description