SESSN_ALL_VW

(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. Dependent on CRS_1ST_SESS_VW

SELECT A.COURSE , A.SESSION_NBR , B.DESCR , A.COURSE_START_DT , 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.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: CRS_SESSNVW_LNG

    • # 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 COURSE_START_DT Date(10) DATE NOT NULL Course Start Date
    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