RTRN_TIV_SET_VW

(SQL View)
 Index Back

Student Charge View

View used to auto populate PS_RTRN_TIV_SETUP

SELECT B.INSTITUTION, A.AID_YEAR, A.ITEM_TYPE, A.DESCR, A.DESCRSHORT, A.FEDERAL_ID, A.LOAN_PROGRAM FROM PS_ITEM_TYPE_FA A, PS_AID_YEAR_TBL B WHERE A.AID_YEAR = B.AID_YEAR AND A.SETID = (SELECT D1.SETID FROM PS_SET_CNTRL_REC D1 WHERE D1.SETCNTRLVALUE = B.INSTITUTION AND D1.RECNAME = 'ITEM_TYPE_FA') AND A.EFFDT= (SELECT MAX(D2.EFFDT) FROM PS_ITEM_TYPE_FA D2 WHERE A.SETID = D2.SETID AND A.AID_YEAR = D2.AID_YEAR AND A.ITEM_TYPE = D2.ITEM_TYPE AND D2.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 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 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
7 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