CRS_CPSSNVW_LNG

(SQL View)
 Index Back

Search Vw-Complete Trng Sessns

CRSE_CMP_SSN_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 completed (status = 'C'). For example, when you request the Course Evaluation panel, the list of course sessions from which you can select is from this record, because you only want to record evaluation totals for sessions that are complete.

SELECT A.COURSE ,A.SESSION_NBR ,B.LANGUAGE_CD ,B.DESCR ,C.FACILITY_NAME FROM PS_CRSE_SESSN_TBL A , PS_COURSE_TBL_LANG B , PS_CRSE_SESS_DATES C , PS_CRS_1ST_SESS_VW D WHERE A.SESSION_STATUS = 'C' 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 for CRSE_CMP_SSN_VW

  • Parent record: CRSE_SESSN_TBL

    • # 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