FAN_AWARD_VW

(SQL View)
 Index Back

SELECT AWD.EMPLID ,AWD.INSTITUTION ,AWD.AID_YEAR ,DSB.STRM ,ITM.ITEM_TYPE ,ADS.ACAD_CAREER ,AWD.SETID ,TRM.DESCR ,TRM.DESCRSHORT ,ITM.DESCR ,ADS.OFFER_BALANCE ,ADS.CURRENCY_CD ,ITM.AWARD_MSG_CD ,ITM.AWARD_LETTER_PRINT ,ITM.PRINT_LTR_OPTION ,ITM.FAN_PRINT_SPECS ,AWD.AWARD_STATUS ,ACT.AWARD_PERIOD ,AWP.FANLTR_STATUS FROM PS_STDNT_AWARDS AWD , PS_ITEM_TYPE_FA ITM , PS_STDNT_AWRD_DISB ADS , PS_DISB_ID_TBL DSB , PS_AID_YR_CAR_TERM ACT , PS_TERM_VAL_TBL TRM , PS_STDNT_AWD_PER AWP WHERE ITM.SETID = AWD.SETID AND ITM.ITEM_TYPE = AWD.ITEM_TYPE AND ITM.AID_YEAR = AWD.AID_YEAR AND ITM.EFFDT = ( SELECT MAX(ITM2.EFFDT) FROM PS_ITEM_TYPE_FA ITM2 WHERE ITM2.SETID = ITM.SETID AND ITM2.ITEM_TYPE = ITM.ITEM_TYPE AND ITM2.AID_YEAR = ITM.AID_YEAR AND ITM2.EFFDT <= %CurrentDateIn ) AND ADS.EMPLID = AWD.EMPLID AND ADS.INSTITUTION = AWD.INSTITUTION AND ADS.AID_YEAR = ITM.AID_YEAR AND ADS.ITEM_TYPE = ITM.ITEM_TYPE AND DSB.INSTITUTION = ADS.INSTITUTION AND DSB.AID_YEAR = ADS.AID_YEAR AND DSB.ACAD_CAREER = ADS.ACAD_CAREER AND DSB.DISBURSEMENT_PLAN = AWD.DISBURSEMENT_PLAN AND DSB.DISBURSEMENT_ID = ADS.DISBURSEMENT_ID AND ACT.INSTITUTION = DSB.INSTITUTION AND ACT.AID_YEAR = DSB.AID_YEAR AND ACT.ACAD_CAREER = DSB.ACAD_CAREER AND ACT.STRM = DSB.STRM AND TRM.STRM = ACT.STRM AND AWP.EMPLID = ADS.EMPLID AND AWP.INSTITUTION = ACT.INSTITUTION AND AWP.AID_YEAR = ACT.AID_YEAR AND AWP.AWARD_PERIOD = ACT.AWARD_PERIOD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
4 STRM Character(4) VARCHAR2(4) NOT NULL Term
5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
6 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID
8 STRM_DESCR Character(30) VARCHAR2(30) NOT NULL Term Description
9 STRM_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short description of student term.
10 ITEM_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Item Type Description
11 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
14 AWARD_LETTER_PRINT Character(3) VARCHAR2(3) NOT NULL Award Letter Print
15 PRINT_LTR_OPTION Character(1) VARCHAR2(1) NOT NULL Print Letter Option
C=Print on Custom Letter
N=Never print on letter
P=Print on Award Letter
16 FAN_PRINT_SPECS Character(1) VARCHAR2(1) NOT NULL FAN Print Specification
A=Print as Award Item
O=Print as Other Resource
17 AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
A=Accepted
C=Cancelled
D=Declined
O=Offered
18 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
19 FANLTR_STATUS Character(4) VARCHAR2(4) NOT NULL Fin Aid Award Notification Letter (FANLTR) Status
HOLD=Hold
INIT=Initial
PRTD=Printed
REV=Revised