CRSE_ATV_SSN_VW

(SQL View)
 Index Back

Prompt/Srch Training Sessions

CRSE_ALL_SSN_VW belongs to the Training Administration application. This record is a search view that selects all course sessions from CRSE_SESSN_TBL.

SELECT A.COURSE , A.SESSION_NBR , A.SESSION_STATUS , A.COURSE_START_DT , A.COURSE_END_DT , B.SESSN_START_TIME , B.SESSN_END_TIME , B.FACILITY , B.FACILITY_NAME , A.SESSION_LANGUAGE FROM PS_CRSE_SESSN_TBL A , PS_CRSE_SESS_DATES B , PS_CRS_1ST_SESS_VW C WHERE A.COURSE = B.COURSE AND A.SESSION_STATUS = 'A' AND A.SESSION_NBR = B.SESSION_NBR AND A.COURSE_START_DT = B.SESSN_START_DT AND B.COURSE = C.COURSE AND B.SESSION_NBR = C.SESSION_NBR AND B.SESSN_START_DT = C.SESSN_START_DT AND B.SESSN_START_TIME = C.SESSN_START_TIME AND A.SESSN_ORGANIZER = 'Y'

  • Related Language Record: CRS_ALL_SSN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: CRSE_SESSN_SRCH

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

    Default Value: 1

    3 SESSION_STATUS Character(1) VARCHAR2(1) NOT NULL Session Status
    A=Active
    C=Complete
    N=Cancelled
    4 COURSE_START_DT Date(10) DATE NOT NULL Course Start Date
    5 COURSE_END_DT Date(10) DATE Course End Date
    6 SESSN_START_TIME Time(15) TIMESTAMP Start Time
    7 SESSN_END_TIME Time(15) TIMESTAMP End Time
    8 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: TRN_FACIL_TBL

    9 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
    10 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