STDNT_CH_VW

(SQL View)
 Index Back

SELECT a.common_id ,a.business_unit ,a.item_term ,a.last_activity_date ,d.descr ,a.currency_cd ,SUM(a.item_amt) FROM ps_item_sf a , ps_bus_unit_tbl_sf c , PS_ITEM_TYPE_TBL d 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' GROUP BY a.common_id, a.common_id, a.business_unit, a.item_term, a.last_activity_date, d.descr, a.currency_cd

  • Related Language Record: STDNT_CH_VWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
    4 POSTED_DATE Date(10) DATE Date Posted
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    7 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount