SFA_DSBSFTOTVW2

(SQL View)
 Index Back

Stdnt Disb/Item SF Total View2

Sums the results from SFA_DSBSFTOT_VW

SELECT INSTITUTION , AID_YEAR , SUM(SFA_DISBURSED_AMT) , SUM(ITEM_AMT) , SUM(SFA_DIFFERENCE_AMT) , CURRENCY_CD FROM PS_SFA_DSBSFTOT_VW GROUP BY CURRENCY_CD , INSTITUTION , AID_YEAR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 SFA_DISBURSED_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Disbursed Amount
4 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
5 SFA_DIFFERENCE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Difference Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: INSTALLATION.EXCHNG_TO_CURRENCY