SACE-98D-FA14 - NEW

EARLY_FA_SUM_VW

(SQL View)

SELECT A.AID_YEAR, A.AID_CATEGORY, A.EARLY_OFFER_STATUS, SUM(A.EARLY_FA_AMOUNT), COUNT(DISTINCT A.EARLY_FA_AMOUNT) FROM PS_EARLY_FA_AID_VW A WHERE A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_EARLY_FA_AID_VW A1 WHERE A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.ADM_APPL_NBR = A1.ADM_APPL_NBR AND A.AID_CATEGORY = A1.AID_CATEGORY AND A.AID_YEAR = A1.AID_YEAR) AND A.EFFSEQ = (SELECT MAX(A2.EFFSEQ) FROM PS_EARLY_FA_AID_VW A2 WHERE A.EMPLID = A2.EMPLID AND A.ACAD_CAREER = A2.ACAD_CAREER AND A.ADM_APPL_NBR = A2.ADM_APPL_NBR AND A.EFFDT = A2.EFFDT AND A.AID_YEAR = A2.AID_YEAR) GROUP BY A.AID_YEAR, A.AID_CATEGORY, A.EARLY_OFFER_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: EARLY_FA_OFFER

2 AID_CATEGORY Character(6) VARCHAR2(6) NOT NULL Aid Category

3 EARLY_OFFER_STATUS Character(1) VARCHAR2(1) NOT NULL Offer Status
A=Accepted
C=Cancelled
D=Declined
O=Offered

4 EARLY_FA_SUM Number(11,2) DECIMAL(10,2) NOT NULL Early Offer Sum

5 EARLY_FA_COUNT Number(3,0) SMALLINT NOT NULL Early FA Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: EARLY_FA_OFFER
2	AID_CATEGORY	Character(6)	VARCHAR2(6) NOT NULL	Aid Category
3	EARLY_OFFER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Offer Status A=Accepted C=Cancelled D=Declined O=Offered
4	EARLY_FA_SUM	Number(11,2)	DECIMAL(10,2) NOT NULL	Early Offer Sum
5	EARLY_FA_COUNT	Number(3,0)	SMALLINT NOT NULL	Early FA Count