SFA_DSBAWITMVW3

(SQL View)
 Index Back

Financial Aid Item SF View

Unions the results of PS_SFA_DISBAWDG_VW and PS_SFA_ITEM_SFG_VW

SELECT EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE_GROUP , ITEM_TYPE , SUM(ITEM_AMT) , 0 , SUM(ITEM_AMT) , CURRENCY_CD FROM PS_SFA_ITEM_SFG_VW GROUP BY EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE_GROUP , ITEM_TYPE , CURRENCY_CD UNION ALL SELECT EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE_GROUP , ITEM_TYPE , 0 , SUM(SFA_DISBURSED_AMT) , SUM(SFA_DISBURSED_AMT) , CURRENCY_CD FROM PS_SFA_DISBAWDG_VW GROUP BY EMPLID , INSTITUTION , AID_YEAR , ITEM_TYPE_GROUP , 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_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
6 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
7 SFA_DISBURSED_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Disbursed Amount
8 SFA_DIFFERENCE_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Difference Amount
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code