SFA_BRPKG_PERVW

(SQL View)
 Index Back

Batch Repackaging Award Period

Batch Repackaging view by award period.

SELECT A.INSTITUTION ,A.AID_YEAR ,A.BATCH_SEQ_NBR ,A.ACAD_CAREER ,A.PKG_PLAN_ID ,B.PKG_STDNT_COUNT ,A.EMPLID ,A.AWARD_PERIOD ,A.FED_EFC ,A.EFC_STATUS ,A.INST_EFC ,A.FED_NEED_BASE_AID ,A.INST_NEED_BASE_AID ,A.FED_YEAR_COA ,A.INST_YEAR_COA ,A.PELL_YEAR_COA ,A.FED_NEED ,A.INST_NEED ,A.FED_UNMET_NEED ,A.FED_OVRAWD_AMT ,A.INST_UNMET_NEED ,A.INST_OVRAWD_AMT ,A.FED_PARENT_CONTRB ,A.INST_PARENT_CONTRB ,A.FED_STDNT_CONTRB ,A.INST_STDNT_CONTRB ,A.INST_EFC_OVERIDE ,A.BASE_WEEKS ,A.WEEKS_ENROLLED ,A.WEEKLY_PC ,A.WEEKLY_SC ,A.PRORATED_EFC ,A.FED_SPECIAL_AID ,A.INST_SPECIAL_AID ,A.FED_TOTAL_AID ,A.INST_TOTAL_AID ,A.FED_UNMET_COA ,A.INST_UNMET_COA ,A.FED_OVRAWD_COA ,A.INST_OVRAWD_COA ,A.VET_ED_BENEFIT ,A.VET_ED_FAN_PRINT ,A.SFA_PELLYR_COA_LHT FROM PS_PKG_BATCH_PER A , PS_PKG_BATCH_STDNT B , PS_PKG_BATCH_SUMM C WHERE A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.BATCH_SEQ_NBR = B.BATCH_SEQ_NBR AND A.ACAD_CAREER = B.ACAD_CAREER AND A.PKG_PLAN_ID = B.PKG_PLAN_ID AND A.EMPLID = B.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.AID_YEAR = C.AID_YEAR AND A.BATCH_SEQ_NBR = C.BATCH_SEQ_NBR AND C.SFA_BPKG_MODE = 'R'

# 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 BATCH_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL Batch Sequence Number

Prompt Table: PKG_BATCH_SUMM

4 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: ACAD_CAR_TBL

5 SFA_RPKG_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Repackaging Plan ID

Prompt Table: SFA_RPKG_PLAN

6 PKG_STDNT_COUNT Number(5,0) INTEGER NOT NULL Student Packaging Sequence
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

8 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
A=Academic
N=Non Standard
9 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
10 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
O=Official
R=Rejected
U=Unofficial
Z=Provisional
11 INST_EFC Number(6,0) INTEGER NOT NULL Institutional EFC
12 FED_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Fed)
13 INST_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Inst)
14 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
15 INST_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Year COA
16 PELL_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell Year COA
17 FED_NEED Number(9,2) DECIMAL(8,2) NOT NULL Fed Need
18 INST_NEED Number(9,2) DECIMAL(8,2) NOT NULL Inst Need
19 FED_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Fed)
20 FED_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Fed)
21 INST_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Inst)
22 INST_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Inst)
23 FED_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Federal
24 INST_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Inst
25 FED_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Federal
26 INST_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Inst
27 INST_EFC_OVERIDE Character(1) VARCHAR2(1) NOT NULL Override Institutional EFC
28 BASE_WEEKS Number(4,1) DECIMAL(3,1) NOT NULL Base Number of Weeks
29 WEEKS_ENROLLED Number(4,1) DECIMAL(3,1) NOT NULL Number of Weeks Enrolled
30 WEEKLY_PC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Parent Contribution
31 WEEKLY_SC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Stdnt Contribution
32 PRORATED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Prorated EFC
33 FED_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Fed)
34 INST_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Inst)
35 FED_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Fed)
36 INST_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Inst)
37 FED_UNMET_COA Number(9,2) DECIMAL(8,2) NOT NULL Unmet COA(Fed)
38 INST_UNMET_COA Number(9,2) DECIMAL(8,2) NOT NULL Unmet COA(Inst)
39 FED_OVRAWD_COA Number(9,2) DECIMAL(8,2) NOT NULL COA Overaward(Fed)
40 INST_OVRAWD_COA Number(9,2) DECIMAL(8,2) NOT NULL COA Overaward(Inst)
41 VET_ED_BENEFIT Number(5,0) INTEGER NOT NULL Educational Resources
42 VET_ED_FAN_PRINT Character(1) VARCHAR2(1) NOT NULL Print as Other Resource
43 SFA_PELLYR_COA_LHT Number(9,2) DECIMAL(8,2) NOT NULL Used to calculate Less than Half Time Pell Year COA.