CRSE_CMP_SSN_VW

(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.DESCR , C.SESSN_START_TIME , C.FACILITY , C.FACILITY_NAME ,A.SESSION_LANGUAGE 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 = '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: CRS_CPSSNVW_LNG

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

    2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

    Default Value: 1

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 SESSN_START_TIME Time(15) TIMESTAMP Start Time
    5 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: TRN_FACIL_TBL

    6 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
    7 SESSION_LANGUAGE Character(8) VARCHAR2(8) NOT NULL Session Langue
    CFR=Canadian French
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    INE=International English
    JPN=Japanese
    POR=Portuguese

    Prompt Table: LANGUAGE_VW