GM_PRESPEND2_VW

(SQL View)
Index Back

PreSpend Sum view

PreSpend Sum view

SELECT OPRID , TRANS_AGE , SUM(RESOURCE_AMOUNT) , CURRENCY_CD FROM PS_GM_PRESPEND_VW GROUP BY OPRID , TRANS_AGE , CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 TRANS_AGE Character(5) VARCHAR2(5) NOT NULL Transaction Age
3 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code