SFA_ITMSFTOT_VW (SQL View)	Index Back
Financial Aid Item SF Totals Returns total of Financial Aid Item Type entries in the ITEM_SF table.

SFA_ITMSFTOT_VW

(SQL View)

Financial Aid Item SF Totals

Returns total of Financial Aid Item Type entries in the ITEM_SF table.

SELECT B.INSTITUTION , A.AID_YEAR , SUM(A.ITEM_AMT) , A.CURRENCY_CD FROM PS_ITEM_SF A , PS_BUS_UNIT_TBL_SF B WHERE A.SA_ID_TYPE = 'P' AND A.ITEM_TYPE_CD = 'F' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT GROUP BY A.CURRENCY_CD, B.INSTITUTION, A.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 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	ITEM_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Amount
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code