ITEM_TYP_INT_VW

(SQL View)
 Index Back

FA Item Type Loan Int Attr Vw

This view shows the Loan Interest Attribute for a Loan Item Type.

select 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 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: ITEMTYPINTVWLNG

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