SFA_SS_OA_FATVW

(SQL View)
 Index Back

Outside Aid FIN_AID_TYPE view

Prompt view for Outside Aid FIN_AID_TYPE

SELECT DISTINCT B.INSTITUTION , B.AID_YEAR , A.FIN_AID_TYPE FROM PS_SFA_EA_ITM_XREF B , PS_ITEM_TYPE_FA A WHERE A.SETID = B.SETID AND A.AID_YEAR=B.AID_YEAR AND A.ITEM_TYPE = B.ITEM_TYPE AND B.SFA_EA_SS_VISIBLE = 'Y' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_FA A1 WHERE A1.SETID=A.SETID AND A1.ITEM_TYPE=A.ITEM_TYPE AND A1.AID_YEAR=A.AID_YEAR AND A1.EFFDT<=%CurrentDateIn ) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

3 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
A=Athletic
B=Bursary
F=Fellowship
G=Grant
L=Loan
S=Scholarship
V=Waiver
W=Work/Study