CRS_ALL_SSN_LNG

(SQL View)
 Index Back

Prompt/Srch Training Sessions

Related language record for CRSE_ALL_SSN_VW.

SELECT A.COURSE , A.SESSION_NBR , B.LANGUAGE_CD , B.FACILITY_NAME FROM PS_CRSE_SESSN_TBL A , PS_CRS_SESSDTS_LNG B , PS_CRSE_SESS_DATES C , PS_CRS_1ST_SESS_VW D WHERE 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 AND B.COURSE = C.COURSE AND B.SESSION_NBR = C.SESSION_NBR AND B.CUT_SESSION_NBR = C.CUT_SESSION_NBR

  • Related Language Record for CRSE_ALL_SSN_VW CRSE_ATV_SSN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name