STDNT_CH_VWLNG

(SQL View)
 Index Back

Related Language View

STDNT_CH_VWLNG is the language record view related to STDNT_CH_VW

SELECT a.business_unit ,a.item_term ,r.language_cd ,r.descr FROM ps_item_sf a , ps_bus_unit_tbl_sf c , PS_ITEM_TYPE_TBL d , ps_item_type_lng r WHERE a.sa_id_type = 'P' AND a.business_unit = c.business_unit AND a.item_type = d.item_type AND d.item_type_cd IN ('A','C','H','X','B','W') AND d.setid = ( SELECT e.setid FROM ps_set_cntrl_rec e WHERE e.setcntrlvalue = c.institution AND e.recname = 'ITEM_TYPE_TBL') AND d.effdt = ( SELECT MAX(f.effdt) FROM PS_ITEM_TYPE_TBL f WHERE f.setid = d.setid AND f.item_type = d.item_type AND f.effdt <= %CurrentDateIn) AND d.eff_status = 'A' AND d.setid = r.setid AND d.item_type = r.item_type AND d.effdt = r.effdt GROUP BY a.business_unit, a.item_term,r.language_cd,r.descr

  • Related Language Record for STDNT_CH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description