SFA_SLC_AWDGPVW

(SQL View)
Index Back

FA Award Item Group View

Financial Aid Award Item Group View. Joins STDNT_AWARDS to the ITEM_GROUP_TBL to allow searching for awards by ITEM_TYPE_GROUP.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,C.ITEM_TYPE_GROUP ,A.ITEM_TYPE ,A.ACAD_CAREER ,A.DISBURSEMENT_PLAN ,A.SPLIT_CODE ,A.SETID ,A.AWARD_STATUS ,A.AWARD_MSG_CD ,A.OFFER_AMOUNT ,A.ACCEPT_AMOUNT ,A.DISBURSED_AMOUNT ,A.AUTHORIZED_AMOUNT ,A.CURRENCY_CD ,A.NET_AWARD_AMT ,A.CANCEL_DECLINE_AMT ,A.OFFER_ACTIVITY_IND ,A.FIN_AID_TYPE ,A.AWARD_PERIOD FROM PS_STDNT_AWARDS A ,PS_ITEM_GROUP_TBL C ,PS_ITEM_GROUP_DTL D ,PSTREEDEFN E ,PSTREENODE F ,PSTREELEAF G WHERE C.SETID = A.SETID AND C.EFFDT = ( SELECT MAX (CC.EFFDT) FROM PS_ITEM_GROUP_TBL CC WHERE CC.SETID = C.SETID AND CC.ITEM_TYPE_GROUP = C.ITEM_TYPE_GROUP AND CC.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND D.SETID = C.SETID AND D.ITEM_TYPE_GROUP = C.ITEM_TYPE_GROUP AND D.EFFDT = C.EFFDT AND E.TREE_NAME = C.TREE_NAME AND E.EFFDT = ( SELECT MAX (EE.EFFDT) FROM PSTREEDEFN EE WHERE EE.SETID = E.SETID AND EE.TREE_NAME = E.TREE_NAME AND EE.EFFDT <= %CurrentDateIn) AND E.VALID_TREE = 'Y' AND F.SETID = E.SETID AND F.TREE_NAME = E.TREE_NAME AND F.EFFDT = E.EFFDT AND G.SETID = E.SETID AND G.TREE_NAME = E.TREE_NAME AND G.EFFDT = E.EFFDT AND E.SETID = C.TREE_NAME_SETID AND F.TREE_NODE = D.TREE_NODE AND G.TREE_NODE_NUM = F.TREE_NODE_NUM AND A.ITEM_TYPE >= G.RANGE_FROM AND A.ITEM_TYPE <= G.RANGE_TO

# 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

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

4 ITEM_TYPE_GROUP Character(10) VARCHAR2(10) NOT NULL Item Type Group
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 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan

Prompt Table: DISB_PLAN_VW

8 SPLIT_CODE Character(2) VARCHAR2(2) NOT NULL Split Code

Prompt Table: DISB_SPLIT_VW

9 SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 AWARD_STATUS Character(1) VARCHAR2(1) NOT NULL Award Status
A=Accepted
C=Cancelled
D=Declined
O=Offered
11 AWARD_MSG_CD Character(4) VARCHAR2(4) NOT NULL Award Message
12 OFFER_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Offer Amount
13 ACCEPT_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Accept Amount
14 DISBURSED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Disbursed Amount
15 AUTHORIZED_AMOUNT Number(12,2) DECIMAL(11,2) NOT NULL Authorized Amount
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

17 NET_AWARD_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Net Award Amount
18 CANCEL_DECLINE_AMT Number(12,2) DECIMAL(11,2) NOT NULL Cancel/Decline Amount
19 OFFER_ACTIVITY_IND Character(1) VARCHAR2(1) NOT NULL Offer Activity
A=Adjustment
O=Originated
U=Unoriginated

Default Value: U

20 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

Default Value: ITM_TP_FA_AWRDS.FIN_AID_TYPE

21 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard

Default Value: A