CRSEEQUIVVWLNG

(SQL View)
 Index Back

Rel Lang Course Catalog Equ Vw

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

SELECT a.equiv_crse_id ,C.LANGUAGE_CD , C.descr FROM ps_crse_catalog a , PS_CRSE_OFFER b , PS_CRSE_CATLG_LNG C WHERE a.crse_id = b.crse_id AND a.effdt = b.effdt AND b.crse_offer_nbr = ( SELECT MAX(c.crse_offer_nbr) FROM PS_CRSE_OFFER c WHERE c.crse_id = b.crse_id AND c.effdt = b.effdt) AND A.CRSE_ID=C.CRSE_ID AND A.EFFDT=C.EFFDT

  • Related Language Record for CRSE_EQUIV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Default Value: CRSE_EQUIV_TBL.EQUIV_CRSE_ID

    Prompt Table: CRSE_EQUIV_TBL

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description