CRSECATVWLNG

(SQL View)
 Index Back

Rel Lang Course Catalog View

CRSECATVWLNG is the language record related to CRSE_CAT_VW A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT B.INSTITUTION ,A.CRSE_ID ,C.LANGUAGE_CD ,C.DESCR FROM PS_CRSE_CATALOG A , PS_CRSE_OFFER B , PS_CRSE_CATLG_LNG C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_CRSE_CATLG_LNG A_ED WHERE C.CRSE_ID = A_ED.CRSE_ID AND A_ED.EFFDT <= %CurrentDateIn ) AND C.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_CRSE_OFFER B_ED WHERE B.CRSE_ID = B_ED.CRSE_ID AND B_ED.EFFDT <= A.EFFDT) AND EFF_STATUS = 'A' AND A.CRSE_ID=C.CRSE_ID AND A.EFFDT=C.EFFDT

  • Related Language Record for CRSE_CAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description