SFA_SS_SETUPAWD(SQL Table) |
Index Back |
---|---|
Shopping Sheet SetupShopping Sheet Setup for Award Category grouping. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
3 | SFA_SS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Group |
4 | SFA_SS_AWD_GROUP | Character(2) | VARCHAR2(2) NOT NULL |
Shopping Sheet Award Group
1=Grant/Scholarship from school 2=Grants from your state 3=Other scholarships you can use 4=Work-Study 5=Federal Perkins Loan 6=Federal Subsidized Loan 7=Federal Unsubsidized Loan 8=Federal Pell Grant |
5 | 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 |
6 | FA_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source
F=Federal G=Government I=Institutional O=Other P=Private S=State |
7 | 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 |