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 |