SSF_SS_SUM_FA2

(SQL View)
Index Back

Pending Financial Aid View

Copy of SSF_SS_SUM_FA view used in Fluid Account Balance. View is used for SFF which summarizes aid by term.

SELECT EMPLID ,'ALLBU' ,INSTITUTION_SET ,STRM ,SUM(ITEM_AMT) FROM PS_SSF_SS_PEND_AID GROUP BY EMPLID , INSTITUTION_SET , STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set
4 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
5 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount