FA_DFLT_RUL_SET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FA_DFLT_RULE_SET Character(4) VARCHAR2(4) NOT NULL Aid Processing Rule Set
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 BASE_WEEKS_ACAD Number(4,1) DECIMAL(3,1) NOT NULL Academic Base Weeks
5 BASE_WEEKS_NSTD Number(4,1) DECIMAL(3,1) NOT NULL Non-Standard Base Weeks
6 LOAN_DISB_DELAY Character(1) VARCHAR2(1) NOT NULL Freshman Loan 30 Day Delay

Y/N Table Edit

Default Value: Y

7 FA_GAP_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL GAP Item Type

Prompt Table: ITEM_TYPE_FA_VW

8 PKG_DATA_SOURCE Character(1) VARCHAR2(1) NOT NULL Packaging Data Source tells the Packaging Controller to use Federal Application vs. Institutional Application data for packaging awards.
1=Federal Data Only
2=Institutional Data Only
3=Federal 1st, Institutional 2nd
4=Institutional 1st, Federal 2nd

Default Value: 1

9 INST_APP_SOURCE Character(1) VARCHAR2(1) NOT NULL Application Source
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Renewal Application
3=Electronic Correction
4=FAFSA Express
5=ACT
6=I-NET
7=NCS
8=Profile
9=Institutional Application
O=FT Canada Student Loan
P=PT Canada Student Loan

Default Value: 8

10 PELL_CALC_START Character(1) VARCHAR2(1) NOT NULL Pell Calculation Start
1=Formula 1 - FA Load
2=Formula 1 - Full-time
3=Formula 3 - FA Load
4=Formula 3 - Current Load
5=Formula 3 - Full-time
C=Enrollment Current Load
E=Enrollment FA Load
F=Full Time
H=Half Time

Default Value: E

11 PELL_CALC_MIDTERM Character(1) VARCHAR2(1) NOT NULL Pell Calculation Midterm
1=Formula 1 - FA Load
2=Formula 1 - Full-time
3=Formula 3 - FA Load
4=Formula 3 - Current Load
5=Formula 3 - Full-time
C=Enrollment Current Load
E=Enrollment FA Load
F=Full Time
H=Half Time

Default Value: E

12 PELL_CALC_CENSUS Character(1) VARCHAR2(1) NOT NULL Pell Calculation Census
1=Formula 1 - FA Load
2=Formula 1 - Full-time
3=Formula 3 - FA Load
4=Formula 3 - Current Load
5=Formula 3 - Full-time
C=Enrollment Current Load
E=Enrollment FA Load
F=Full Time
H=Half Time

Default Value: E

13 PELL_NBR_TERMS Number(2,0) SMALLINT NOT NULL Pell Number of Terms
14 SFA_ACAD_WEEK_ONLY Character(1) VARCHAR2(1) NOT NULL Pell 3 Academic Weeks Only

Y/N Table Edit

Default Value: N

15 SFA_PELL_USE_XOVR Character(1) VARCHAR2(1) NOT NULL Use PELL Cross Over Logic
N=Do Not Use PELL XOver Logic
Y=Use PELL XOver Logic

Default Value: N