SFA_DSBAWITMVW

(SQL View)
Index Back

FA Disb, Item SF View

Unions the results of the SFA_DISBAWD_VW and SFA_ITEM_SF_VW views.

SELECT EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE , SUM(ITEM_AMT) , 0 , SUM(ITEM_AMT) , CURRENCY_CD FROM PS_SFA_ITEM_SF_VW GROUP BY EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE , CURRENCY_CD UNION ALL SELECT EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE , 0 , SUM(SFA_DISBURSED_AMT) , SUM(SFA_DISBURSED_AMT) , CURRENCY_CD FROM PS_SFA_DISBAWD_VW GROUP BY EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE , CURRENCY_CD

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