ITEMTYPINTVWLNG

(SQL View)
 Index Back

FA Itm Type Ln Int Attr Vw

ITEMTYPINTVWLNG is the related language recordfor the record ITEM_TYP_INT_VW

SELECT a.item_type ,e.language_cd ,e.descr FROM ps_item_type_fa a ,PS_ITEM_TYPE_TBL b ,ps_item_type_lng e WHERE a.setid=e.setid AND a.item_type=e.item_type AND a.effdt=e.effdt AND a.setid=b.setid AND a.item_type=b.item_type AND a.fin_aid_type = 'L' AND a.effdt=( SELECT MAX(effdt) FROM ps_item_type_fa c WHERE a.setid = c.setid AND a.aid_year = c.aid_year AND a.item_type = c.item_type AND c.effdt<=%CurrentDateIn AND c.eff_status='A') AND b.effdt=( SELECT MAX(effdt) FROM PS_ITEM_TYPE_TBL d WHERE b.setid=d.setid AND b.item_type=d.item_type AND d.eff_status='A' )

  • Related Language Record for ITEM_TYP_INT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYP_LN_VW

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