| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AGGREGATE_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
Aggregate Area
|
| 2 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
FED_AID_YR_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
UNDRGRAD_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Undergrad Lifetime
|
| 7 |
GRADUATE_LIMIT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Graduate Lifetime
|
| 8 |
MAX_TERMS |
Number(2,0) |
SMALLINT NOT NULL |
Max Terms
|
| 9 |
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
|
| 10 |
PELL_GRANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pell Grant
Y/N Table Edit
Default Value: N
|
| 11 |
FA_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
F=Federal
G=Government
I=Institutional
O=Other
P=Private
S=State
|
| 12 |
LOAN_PROGRAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Program
A=Alternative
D=Direct Lending
F=FFELP
H=Health Professions
P=Perkins
S=State
U=University
|
| 13 |
LOAN_INTEREST_ATTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan Interest Attribute
S=Subsidized
U=Unsubsidized
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 16 |
AGGREGATE_PROGRAM |
Character(4) |
VARCHAR2(4) NOT NULL |
Aggregate Program
DLHL=DIRECT - HEAL
DSTF=DIRECT - STAFFORD
FLHL=FFELP - HEAL
FSTF=FFELP - STAFFORD
Prompt Table:
AGGR_PROG_TBL
|
| 17 |
GRAD_LIMIT_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduate Limit Rule
C=Cumulative
D=Distinct
Default Value: D
|
| 18 |
FEDERAL_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Federal ID
ACG=Academic Competitiveness Grant
FWSP=Federal Work Study Program
GAAN=Grad Assistance in Natl Need
GPLS=Graduate PLUS Loan
HEAL=Health Education Assistance Ln
HPSL=Health Profession Student Loan
IASA=Iraq/Afghan Service Award
JVTS=Jacob K Javits Fellowship
LDS=Loans for Disadvantaged Stdnts
NIH=National Institute of Health
NSF=National Science Foundation
NURS=Nursing Loan
OTHR=Other Federal Fund
PCL=Primary Care Loan
PELL=Federal PELL Grant
PERK=Federal Perkins Loan Program
PLUS=Federal Stafford Loan, PLUS
SEOG=Federal SEOG
SMRT=National Smart Grant
STFS=Fed Stafford Loan - Subsidized
STFU=Fed Stafford Loan-Unsubsidized
TCH=TEACH Grant
|
| 19 |
SFA_AGGR_MP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
FA-Aggregates: Multi-Pass Processing for mid-year level change (Y/N).
Y/N Table Edit
Default Value: N
|
| 20 |
SFA_AGGR_DEP_LMT |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Dep Undergrad Lifetime
|
| 21 |
SFA_PRCNT_PELL_ONE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
First Pell Percentage
Default Value: 100
|
| 22 |
SFA_PRCNT_PELL_TWO |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Second Pell Percentage
Default Value: 150
|
| 23 |
SFA_LIFETM_ELG_MAX |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Lifetime Eligibility Maximum
|
| 24 |
MAX_PELL_SCHED_AWD |
Number(6,0) |
INTEGER NOT NULL |
Maximum Pell Scheduled Award
|
| 25 |
MIN_PELL_SCHED_AWD |
Number(6,0) |
INTEGER NOT NULL |
Minimum Pell Scheduled Award
|