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