SFA_STD_AWDALL

(SQL View)
 Index Back

Select Awards for Self Service

View used to select Student Award Data available for Self Service Awarding when awards are viewd by Aid Year..

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,'Y' ,A.ITEM_TYPE ,A.ACAD_CAREER ,D.AWARD_STATUS ,D.SETID ,D.FIN_AID_TYPE ,D.AWARD_MSG_CD ,A.CURRENCY_CD ,D.CANCEL_DECLINE_AMT ,D.PKG_STATUS_CD ,SUM(A.OFFER_BALANCE) ,SUM(A.ACCEPT_BALANCE) ,SUM(A.DISBURSED_BALANCE) ,SUM(A.NET_DISB_BALANCE) ,SUM(A.OFFER_BAL_LN_FEE) ,SUM(A.ACCEPT_BAL_LN_FEE) ,SUM(A.OFFER_BAL_REBATE) ,SUM(A.ACCEPT_BAL_REBATE) FROM PS_STDNT_AWRD_DISB A , PS_DISB_ID_TBL B , PS_STDNT_AWARDS D WHERE B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.ACAD_CAREER = A.ACAD_CAREER AND B.DISBURSEMENT_ID = A.DISBURSEMENT_ID AND B.DISBURSEMENT_PLAN = D.DISBURSEMENT_PLAN AND D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.ACAD_CAREER = A.ACAD_CAREER AND D.ITEM_TYPE = A.ITEM_TYPE AND A.EMPLID IN ( SELECT E.EMPLID FROM PS_SFA_STD_AWDSRCH E WHERE E.INSTITUTION = A.INSTITUTION AND E.AID_YEAR = A.AID_YEAR AND E.ACAD_CAREER = A.ACAD_CAREER AND E.ITEM_TYPE = A.ITEM_TYPE ) GROUP BY A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.ACAD_CAREER, A.ITEM_TYPE, D.AWARD_STATUS ,D.SETID, D.FIN_AID_TYPE, D.AWARD_MSG_CD ,A.CURRENCY_CD ,D.CANCEL_DECLINE_AMT ,D.PKG_STATUS_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

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

Prompt Table: AID_YEAR_TBL

4 SFA_AWARD_PER Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
Y=Aid Year
5 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: %EDITTABLE

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

Prompt Table: STDNT_CR_TRM_VW

7 SFA_AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
A=Accepted
B=Disbursed
C=Cancelled
D=Declined
F=Fully Disbursed
O=Offered
P=Partially Disbursed
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 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
10 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 CANCEL_DECLINE_AMT Number(12,2) DECIMAL(11,2) NOT NULL Cancel/Decline Amount
13 PKG_STATUS_CD Number(5,0) INTEGER NOT NULL Package Status
14 OFFER_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Offer Balance
15 ACCEPT_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Accept Balance
16 DISBURSED_BALANCE Signed Number(13,2) DECIMAL(11,2) NOT NULL Disbursed Balance
17 NET_DISB_BALANCE Number(12,2) DECIMAL(11,2) NOT NULL Net Disb Balance
18 OFFER_BAL_LN_FEE Number(7,2) DECIMAL(6,2) NOT NULL Offer Balance Loan Fee
19 ACCEPT_BAL_LN_FEE Number(7,2) DECIMAL(6,2) NOT NULL Accept Balance Loan Fee
20 OFFER_BAL_REBATE Number(7,2) DECIMAL(6,2) NOT NULL Offer Balance Rebate
21 ACCEPT_BAL_REBATE Number(7,2) DECIMAL(6,2) NOT NULL Accept Balance Rebate