ITEMTYPLNVWLNG

(SQL View)
 Index Back

FA Item Type Loan Fee Srch

ITEMTYPLNVWLNG is the related language recordfor the record ITEM_TYP_LN_VW

SELECT A.SETID ,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 A.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 B.SETID = D.SETID AND B.EFFDT <=%CurrentDateIn) AND B.EFF_STATUS='A'

  • Related Language Record for ITEM_TYP_LN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYP_LN_VW

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