SFA_DSBSFTOT_VW

(SQL View)
 Index Back

Stdnt Disb/SF Item Total View

Unions the results from SFA_DISBTOT_VW and SFA_ITMSFTOT_VW

SELECT D.INSTITUTION , D.AID_YEAR , D.SFA_DISBURSED_AMT , 0 , D.SFA_DISBURSED_AMT , D.CURRENCY_CD FROM PS_SFA_DISBTOT_VW D UNION ALL SELECT I.INSTITUTION , I.AID_YEAR ,0 , I.ITEM_AMT , I.ITEM_AMT , I.CURRENCY_CD FROM PS_SFA_ITMSFTOT_VW I

# 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