ITEM_TP_FA_AGGR

(SQL View)
 Index Back

Aggr Attributes for Item Tps

This view is used to obtain Aggregate Attributes for Item Types on the Award Panels

select A.FIN_AID_TYPE ,A.FA_SOURCE ,A.AID_YEAR ,A.AGGREGATE_AREA ,A.FEDERAL_ID ,A.LOAN_PROGRAM ,A.LOAN_INTEREST_ATTR From PS_AGGR_LIMIT_TBL A where A.EFFDT = ( Select Max(B.EFFDT) From PS_AGGR_LIMIT_TBL B Where A.AGGREGATE_AREA = B.AGGREGATE_AREA and A.AID_YEAR = B.AID_YEAR and B.EFF_STATUS = 'A' and B.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 FA_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
5 FEDERAL_ID Character(4) VARCHAR2(4) NOT NULL Federal ID
ACG=Academic Competitiveness Grant
FWSP=Federal Work Study Program
GAAN=Grad Assistance in Natl Need
GPLS=Graduate PLUS Loan
HEAL=Health Education Assistance Ln
HPSL=Health Profession Student Loan
IASA=Iraq/Afghan Service Award
JVTS=Jacob K Javits Fellowship
LDS=Loans for Disadvantaged Stdnts
NIH=National Institute of Health
NSF=National Science Foundation
NURS=Nursing Loan
OTHR=Other Federal Fund
PCL=Primary Care Loan
PELL=Federal PELL Grant
PERK=Federal Perkins Loan Program
PLUS=Federal Stafford Loan, PLUS
SEOG=Federal SEOG
SMRT=National Smart Grant
STFS=Fed Stafford Loan - Subsidized
STFU=Fed Stafford Loan-Unsubsidized
TCH=TEACH Grant
6 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
7 LOAN_INTEREST_ATTR Character(1) VARCHAR2(1) NOT NULL Loan Interest Attribute
S=Subsidized
U=Unsubsidized