STDNT_AWD_PELL

(SQL Table)
 Index Back

Student Award - PELL

Table used to track Year Round Pell awards determination from either the current or forward year PELL schedule. Record is created or updated by the Controller (FAPPKCTL) and is updated by Posting (FAPPKPST).

# 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: STUDENT_AID

4 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: %EDITTABLE

5 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

6 PKG_USE_PELL_FWD Character(1) VARCHAR2(1) NOT NULL Captures value of PKG_USE_PELL_FWD field at the time the award is packaged or re-packaged. This field is inserted or updated by FAPPKCTL.cbl.

Default Value: N

7 PELL_FWD_POSTED Character(1) VARCHAR2(1) NOT NULL Captures value of PKG_USE_PELL_FWD field at the time the award is posted. This field is updated by FAPPKPST.cbl.

Default Value: N