ITEM_TYP_LN_VW

(SQL View)
 Index Back

FA Item Type Loan Fee Srch

This view shows the description of Item Type from the Item Type table.

SELECT A.SETID ,A.ITEM_TYPE ,A.LOAN_INTEREST_ATTR ,B.DESCR FROM PS_ITEM_TYPE_FA A ,PS_ITEM_TYPE_TBL B WHERE 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: ITEMTYPLNVWLNG

    • # 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 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
    S=Subsidized
    U=Unsubsidized
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description