| # |
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 |
TIV_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pell ID Reporting
Prompt Table:
INST_SCHOOL_CDS
|
| 4 |
ENTITY_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Entity Number
|
| 5 |
ENDING_DT_PERIOD |
Date(10) |
DATE |
Ending date of period
|
| 6 |
INSTITUTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Institution Type
1=Less than 1 year
2=1 year, less than 2years
3=2 years, less than 3 years
4=3 years, less than 4 years
5=4 years(baccalaureate only)
6=5 years or more
|
| 7 |
ACADEMIC_CALENDAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Calendar
1=Credit Hr (non-standard terms)
2=Use standard quarters
3=Use standard semesters
4=Use standard trimesters
5=Academic progress by clock-hrs
6=Credit Hr w/o Terms
|
| 8 |
FINANCIAL_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Control
1=Public
2=Private, Nonprofit
3=Proprietary
|
| 9 |
FT_UGRD_ENROLL |
Number(6,0) |
INTEGER NOT NULL |
Full Time Ugrd Enrollment
|
| 10 |
PT_UGRD_ENROLL |
Number(6,0) |
INTEGER NOT NULL |
Part Time Ugrd Enrollment
|
| 11 |
TG5_NUM |
Character(5) |
VARCHAR2(5) NOT NULL |
TG Number
|
| 12 |
HOURS_CREDITS |
Number(4,0) |
SMALLINT NOT NULL |
Hours/Credits in Acad Year
|
| 13 |
PELL_PAY_FREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Frequency
1=Two Per Year
2=One Per Term (Standards Terms)
3=Two Per Term (Standard Terms )
4=Two Terms Plus Mini-Term
5=Monthly
6=Other
|
| 14 |
NUM_PAY |
Number(2,0) |
SMALLINT NOT NULL |
Pell Number of Payments
|
| 15 |
PEL_TM_PERIOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pell Time Period
MO=Month
MT=Mini-term
QT=Quarter
SM=Semester
TM=Term
TR=Trimester
WK=Week
YR=Year
|
| 16 |
PELL_PMT_METH |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Methodology
1=Formula 1
2=Formula 2
3=Formula 3
4=Formula 4
5=Formula 5
6=Other
|
| 17 |
SERVICER_NUMBER |
Number(2,0) |
SMALLINT NOT NULL |
Servicer Number
|
| 18 |
MAX_EFC |
Number(4,0) |
SMALLINT NOT NULL |
Max EFC
|
| 19 |
FAA_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
FAA Name
|
| 20 |
FAA_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
FAA Phone Number
|
| 21 |
FAA_FAX |
Character(12) |
VARCHAR2(12) NOT NULL |
FAA Fax Number
|
| 22 |
INTERNET_ADDRESS |
Character(50) |
VARCHAR2(50) NOT NULL |
Internet Address
|
| 23 |
PELL_SPEC_DSB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Disbursement Required
Y/N Table Edit
Default Value: N
|
| 24 |
LOW_TUITION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Tuition and Fees Flag
1=Tuition is 0
2=Low Tuition Range 2
3=Low Tuition Range 3
4=Low Tuition Range 4
|
| 25 |
MAX_PELL_AWD |
Number(5,0) |
INTEGER NOT NULL |
Maximum Pell Award
|
| 26 |
PELL_PAY_PERIODS |
Number(1,0) |
SMALLINT NOT NULL |
Pell Payment Periods
|
| 27 |
GRANTEE_DUNS_NBR |
Character(11) |
VARCHAR2(11) NOT NULL |
Grantee DUNS Number
|
| 28 |
SERVICER_DUNS_NO |
Character(9) |
VARCHAR2(9) NOT NULL |
Financial Aid Servicer DUNS No
|
| 29 |
PELL_DISB_OFFSET |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Disbursement Request Offset
|
| 30 |
WEEKS_PROG_ACADYR |
Character(2) |
VARCHAR2(2) NOT NULL |
Weeks in Program Acad Year
|
| 31 |
PELL_HOLD_CORRECTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Corrections
Y/N Table Edit
Default Value: N
|
| 32 |
PELL_FT_ENRLMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Fulltime Enrollment
Y/N Table Edit
Default Value: N
|
| 33 |
PELL_ORIG_OFFERED |
Character(1) |
VARCHAR2(1) NOT NULL |
Originate Offered Awards
Y/N Table Edit
Default Value: N
|
| 34 |
PELL_ORIG_MAX_AWD |
Character(1) |
VARCHAR2(1) NOT NULL |
Originate Max Pell Award
Y/N Table Edit
Default Value: N
|
| 35 |
PELL_DSB_PRIOR_XMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Disb Prior to Transmitting Rec
Y/N Table Edit
Default Value: N
|
| 36 |
PG_OPE_ID_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
OPE ID Number
|
| 37 |
PG_SOFTWARE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Software Provider ID
|
| 38 |
PG_PMT_STRT_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Period Start Date Req
Y/N Table Edit
Default Value: N
|
| 39 |
PELL_JIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Just In Time Institution
Y/N Table Edit
Default Value: INSTALLATION_FA.PELL_JIT
|
| 40 |
SFA_COMMON_SCHL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Common School ID for use with the Department of Education financial aid.
|
| 41 |
COD_PARTICIPANT |
Character(1) |
VARCHAR2(1) NOT NULL |
COD Full Participant
Y/N Table Edit
|