| # |
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 |
INAS_RULE_SET |
Character(4) |
VARCHAR2(4) NOT NULL |
Option Rule Set
BASE=CSS Rules/Values
HLTH=Health Professional
STD=Undergrad/Graduate
|
| 4 |
SFA_OPTN_SET_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Option Set ID
|
| 5 |
PRINT_INAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print INAR
Y/N Table Edit
|
| 6 |
LOCAL_RTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Local Routine via INAS41
0=Bypass Local Routine
1=Yes-At Input Time
2=Yes-At Output Time
3=Yes-At Input/Output
|
| 7 |
INAS_DATA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Source
B=Both Federal & Institutional
F=Federal Data
I=Institutional Data
|
| 8 |
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
|
| 9 |
INAS_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Type
B=Both FM & IM
F=Federal Methodology
I=Institutional Methodology
|
| 10 |
CALC_FED_TAX_S_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Fed Tax
Y/N Table Edit
|
| 11 |
CALC_FED_TAX_P_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc Fed Tax
Y/N Table Edit
|
| 12 |
IND_BDGT_DUR_FM |
Number(2,0) |
SMALLINT NOT NULL |
FM Budget Duration - Ind
|
| 13 |
DEP_BDGT_DUR_FM |
Number(2,0) |
SMALLINT NOT NULL |
FM Budget Duration - Dep
|
| 14 |
CALC_PC_IND_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc PC For Independent - FM
Y/N Table Edit
|
| 15 |
IMPUTED_AST_S_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use IM Imputed Asset Value
Y/N Table Edit
|
| 16 |
IMPUTED_AST_P_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use IM Imputed Asset Value
Y/N Table Edit
|
| 17 |
USE_PY_INC_S_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 18 |
USE_PY_INC_P_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 19 |
IM_INC_OVR_S_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use IM Income Override
Y/N Table Edit
|
| 20 |
IM_INC_OVR_P_FMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use IM Income Override
Y/N Table Edit
|
| 21 |
IND_BDGT_DUR_IM |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Budget Duration - Ind
|
| 22 |
DEP_BDGT_DUR_IM |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Budget Duration - Dep
|
| 23 |
CALC_PC_IND_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc PC For Independent
Y/N Table Edit
|
| 24 |
USE_PY_INC_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 25 |
USE_PY_INC_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 26 |
MAX_TUIT_ALWNC_IM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Max Tuit Allowance Per Child
|
| 27 |
INCOME_PCT_S_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
% Unreimbursed Med/Dent Exp
|
| 28 |
INCOME_PCT_P_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
% Unreimbursed Med/Dent Exp
|
| 29 |
EA_PCT_S_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
% Employment Allowance
|
| 30 |
EA_PCT_P_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
% Employment Allowance
|
| 31 |
EA_MAX_S_IM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Max Employment Allowance
|
| 32 |
EA_MAX_P_IM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Max Employment Allowance
|
| 33 |
FED_TAX_AI_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Fed Tax Allwnc Against Income
1=Follow CSS Rules
2=Use Calculated Tax
3=Reported Tax - If Cmpltd Retn
4=Reported Tax
|
| 34 |
FED_TAX_AI_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Fed Tax Allwnc Against Income
1=Follow CSS Rules
2=Use Calculated Tax
3=Reported Tax - If Cmpltd Retn
4=Reported Tax
|
| 35 |
USE_FM_TAXTBL_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use FM Tx Tbl For State/Lcl Tx
Y/N Table Edit
|
| 36 |
USE_FM_TAXTBL_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use FM Tx Tbl For State/Lcl Tx
Y/N Table Edit
|
| 37 |
ASSET_RT_IND_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use 70/90% Instead 50% Inc Asm
1=Yes
2=Yes - If Married
N=No
|
| 38 |
USE_ALT_AAI_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Alternate AAI Table
Y/N Table Edit
|
| 39 |
USE_ALT_AAI_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Alternate AAI Table
Y/N Table Edit
|
| 40 |
ADJ_IPA_REG_COL_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust IPA Regional COL
B=Both Student & Parent
N=No
P=Yes For Parent
S=Yes For Student
|
| 41 |
ADJ_PAR_BF_LOSS_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adj Parent Bus/Farm Loss
Y/N Table Edit
|
| 42 |
ADJ_PAR_OT_LOSS_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adj Parent Other Loss
Y/N Table Edit
|
| 43 |
ADJ_PAR_IC_LOSS_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Adj Parent Income Loss
Y/N Table Edit
|
| 44 |
PCT_IRA_INC_S_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Pct of Stu Retrmt Assets in NW
|
| 45 |
ELIM_APA_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Eliminate APA
Y/N Table Edit
|
| 46 |
ELIM_APA_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Eliminate APA
Y/N Table Edit
|
| 47 |
NEG_INC_SUPP_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Neg Inc Supplement
Y/N Table Edit
|
| 48 |
NEG_INC_SUPP_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Neg Inc Supplement
Y/N Table Edit
|
| 49 |
ASSET_D_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset % Dep
|
| 50 |
ASSET_I_WO_SGL_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset % Ind No Dep-Single
|
| 51 |
ASSET_I_WO_MAR_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset % Ind No Dep-Married
|
| 52 |
ASSET_I_WITH_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset % Ind W/Dep
|
| 53 |
ASSET_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset % Parent
|
| 54 |
ASSET_CNTRB_S_IM |
Number(4,0) |
SMALLINT NOT NULL |
Min Contribution From Asset
|
| 55 |
ASSET_CNTRB_P_IM |
Number(4,0) |
SMALLINT NOT NULL |
Min Contribution From Asset
|
| 56 |
HMOPT_PAR_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Parent
1=Use Reported
2=Use Projected
3=Use Projected If Signifcnt Dif
4=Use Highest
|
| 57 |
HMOPT_I_WD_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Ind W/Dep
1=Use Reported
2=Use Projected
3=Use Projected If Signifcnt Dif
4=Use Highest
|
| 58 |
HMOPT_I_WO_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Ind WO/Dep
1=Use Reported
2=Use Projected
3=Use Projected If Signifcnt Dif
4=Use Highest
|
| 59 |
HMTOL_PAR_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Home Tolerance Parent
|
| 60 |
HMTOL_I_WD_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Home Tolerance Ind W/Dep
|
| 61 |
HMTOL_I_WO_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Home Tolerance Ind WO/Dep
|
| 62 |
HMCAP_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Home Cap Parent
|
| 63 |
HMCAP_I_WD_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Home Cap Ind W/Dep
|
| 64 |
HMCAP_I_WO_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Home Cap Ind WO/Dep
|
| 65 |
ASSET_OPT_PAR_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Option Parent
C=Combined Projection
I=Individual Projection
N=No Asset Projection
|
| 66 |
ASSET_OPT_I_WD_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Option Ind W/Dep
C=Combined Projection
N=No Asset Projection
|
| 67 |
ASSET_OPT_I_WO_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Option Ind WO/Dep
C=Combined Projection
N=No Asset Projection
|
| 68 |
C_YLD1_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld1
|
| 69 |
C_LIM_PAR_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash/Int Limit
|
| 70 |
C_YLD2_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld2
|
| 71 |
C_TOL_PAR_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Cash/Int Tolerance
|
| 72 |
I_YLD1_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld1
|
| 73 |
I_LIM_PAR_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Int/Dvd Limit
|
| 74 |
I_YLD2_PAR_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld2
|
| 75 |
I_TOL_PAR_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Int/Dvd Tolerance
|
| 76 |
C_YLD1_IWD_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld1
|
| 77 |
C_LIM_IWD_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash/Int Limit
|
| 78 |
C_YLD2_IWD_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld2
|
| 79 |
C_TOL_IWD_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Cash/Int Tolerance
|
| 80 |
I_YLD1_IWD_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld1
|
| 81 |
I_LIM_IWD_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Int/Dvd Limit
|
| 82 |
I_YLD2_IWD_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld2
|
| 83 |
I_TOL_IWD_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Int/Dvd Tolerance
|
| 84 |
C_YLD1_IWO_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld1
|
| 85 |
C_LIM_IWO_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Cash/Int Limit
|
| 86 |
C_YLD2_IWO_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Cash/Int Yld2
|
| 87 |
C_TOL_IWO_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Cash/Int Tolerance
|
| 88 |
I_YLD1_IWO_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld1
|
| 89 |
I_LIM_IWO_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Int/Dvd Limit
|
| 90 |
I_YLD2_IWO_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Int/Dvd Yld2
|
| 91 |
I_TOL_IWO_IM |
Character(5) |
VARCHAR2(5) NOT NULL |
Int/Dvd Tolerance
|
| 92 |
DEP_1YR_UG_NOPRIOR |
Character(10) |
VARCHAR2(10) NOT NULL |
1YR
|
| 93 |
DEP_1YR_UG_PREV |
Character(10) |
VARCHAR2(10) NOT NULL |
1Prv
|
| 94 |
DEP_2YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
2YR
|
| 95 |
DEP_3YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
3YR
|
| 96 |
DEP_4YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
4YR
|
| 97 |
DEP_5YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
5+YR
|
| 98 |
DEP_1YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
1YR
|
| 99 |
DEP_2YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
2YR
|
| 100 |
DEP_3YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
3YR
|
| 101 |
DEP_4YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
4YR
|
| 102 |
IND_WD_1YR_UG_NOPR |
Character(4) |
VARCHAR2(4) NOT NULL |
1YR
|
| 103 |
IND_WD_1YR_UG_PREV |
Character(4) |
VARCHAR2(4) NOT NULL |
1Prv
|
| 104 |
IND_WD_2YR_UG |
Character(4) |
VARCHAR2(4) NOT NULL |
2YR
|
| 105 |
IND_WD_3YR_UG |
Character(4) |
VARCHAR2(4) NOT NULL |
3YR
|
| 106 |
IND_WD_4YR_UG |
Character(4) |
VARCHAR2(4) NOT NULL |
4YR
|
| 107 |
IND_WD_5YR_UG |
Character(4) |
VARCHAR2(4) NOT NULL |
5+YR
|
| 108 |
IND_WD_1YR_PROF |
Character(4) |
VARCHAR2(4) NOT NULL |
1YR
|
| 109 |
IND_WD_2YR_PROF |
Character(4) |
VARCHAR2(4) NOT NULL |
2YR
|
| 110 |
IND_WD_3YR_PROF |
Character(4) |
VARCHAR2(4) NOT NULL |
3YR
|
| 111 |
IND_WD_4YR_PROF |
Character(4) |
VARCHAR2(4) NOT NULL |
4YR
|
| 112 |
IND_WO_1YR_UG_NOPR |
Character(10) |
VARCHAR2(10) NOT NULL |
1YR
|
| 113 |
IND_WO_1YR_UG_PREV |
Character(10) |
VARCHAR2(10) NOT NULL |
1Prv
|
| 114 |
IND_WO_2YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
2YR
|
| 115 |
IND_WO_3YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
3YR
|
| 116 |
IND_WO_4YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
4YR
|
| 117 |
IND_WO_5YR_UG |
Character(10) |
VARCHAR2(10) NOT NULL |
5+YR
|
| 118 |
IND_WO_1YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
1YR
|
| 119 |
IND_WO_2YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
2YR
|
| 120 |
IND_WO_3YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
3YR
|
| 121 |
IND_WO_4YR_PROF |
Character(10) |
VARCHAR2(10) NOT NULL |
4YR
|
| 122 |
MIN_PC_R1_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 1
|
| 123 |
MIN_PC_R2_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 2
|
| 124 |
MIN_PC_R3_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 3
|
| 125 |
MIN_PC_R4_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 4
|
| 126 |
MIN_PC_R5_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 5
|
| 127 |
MIN_PC_R6_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 6
|
| 128 |
MIN_PC_R7_INC_IM |
Character(11) |
VARCHAR2(11) NOT NULL |
Range 7
|
| 129 |
MIN_PC_R1_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 1
|
| 130 |
MIN_PC_R2_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 2
|
| 131 |
MIN_PC_R3_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 3
|
| 132 |
MIN_PC_R4_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 4
|
| 133 |
MIN_PC_R5_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 5
|
| 134 |
MIN_PC_R6_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 6
|
| 135 |
MIN_PC_R7_IM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range 7
|
| 136 |
ELIM_PAR_IN_COL_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Eliminate Parent(s) In College
Y/N Table Edit
|
| 137 |
PCT_INC_PREV_SC_IM |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Increase Last Year SC
|
| 138 |
PCT_INC_PREV_PC_IM |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Increase Last Year PC
|
| 139 |
NM2_IN_COL_IM |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
2 In College
|
| 140 |
NM3_IN_COL_IM |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
3 In College
|
| 141 |
NM4_IN_COL_IM |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
4 In College
|
| 142 |
NM5_IN_COL_IM |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
5 In College
|
| 143 |
NM6_IN_COL_IM |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
6 In College
|
| 144 |
CAN_IM_BE_LT_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Parent IM Be Less Than FM
Y/N Table Edit
|
| 145 |
USE_PAR_RPTD_PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Parent Reported PC
Y/N Table Edit
|
| 146 |
EFC_USE_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Which EFC
F=Estimated Federal
G=Greatest
I=Institutional
O=Institutional W/Opt
|
| 147 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
ST_NAMES_FA_VW
|
| 148 |
USE_PROF_ASM_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Profile Assumptions
Y/N Table Edit
|
| 149 |
MAX_AGE_HSLD |
Number(2,0) |
SMALLINT NOT NULL |
Rstrct # Household - Max Age
|
| 150 |
MAX_AGE_CLGE |
Number(2,0) |
SMALLINT NOT NULL |
Rstrct # in College - Max Age
|
| 151 |
USE_NCPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Non Cust PC to PC
Y/N Table Edit
|
| 152 |
BDGT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Other Family Share of PC
1=Yes; Sum of Budget
2=Yes; % of Total Budget
3=Yes; Highest PC from Sum and %
N=No
|
| 153 |
BDGT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
2yr Public Institution
|
| 154 |
BDGT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
2yr Private Institution
|
| 155 |
BDGT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
4yr Public Institution
|
| 156 |
BDGT4 |
Number(10,0) |
DECIMAL(10) NOT NULL |
4yr Private Institution
|
| 157 |
BDGT5 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Grad/Prof Institution
|
| 158 |
BDGT6 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Proprietary Institution
|
| 159 |
PCT_TOT_BDGT |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
% of Total Budget for 1/2 time
|
| 160 |
INST_BDGT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
In State Undergrad
|
| 161 |
INST_BDGT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Out of State Undergrad
|
| 162 |
INST_BDGT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
In State Graduate
|
| 163 |
INST_BDGT4 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Out of State Graduate
|
| 164 |
GLB_98IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Dont Know Yet
|
| 165 |
FORM_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Same as above
|
| 166 |
SCA_NON_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
SCA-Non Standard Award Period
Y/N Table Edit
|
| 167 |
HOPE_LTL_OPT_S |
Character(1) |
VARCHAR2(1) NOT NULL |
10/23/98 Created for INAS 1999 - 2000.
Y/N Table Edit
|
| 168 |
HOPE_LTL_OPT_P |
Character(1) |
VARCHAR2(1) NOT NULL |
10/23/98 Created for INAS 1999 - 2000.
|
| 169 |
USE_PAR_AGI_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Parent AGI
1=CSS Default (Max rptd/cmptd)
2=Always use Reported
3=Use Rptd-Tax Return
4=Always use Computed
|
| 170 |
INC_ASSET_PCT_IM |
Number(3,2) |
DECIMAL(2,2) NOT NULL |
Income Asset Protection %
|
| 171 |
ADJ_ERA_REG_COL_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option to apply regional Cost-of-Living adjustment to the Emergency Reserve Allowance.
B=Yes for Parent & Ind w/dep
N=No
P=Yes for Parents
S=Yes for Ind students w/dep
|
| 172 |
ALT_INC_ASMT_RT_IM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Alternate Income Assessment Percentage for IM
|
| 173 |
ALW_NEG_PAR_AI_AST |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Income Asset Allowance Option for IM
N=Don't allow neg AI
Y=Allow neg AI against assets
|
| 174 |
ASG_INC_PCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.09%
2=1.2%
Y=1.5%
|
| 175 |
MULT_COLL_PC_ALLOC |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option to use standard or alternate PC allocation percentage tables in INAS calculation.
O=Use Alternate PC Allocation %
S=Use Standard PC Allocation %
|
| 176 |
NM_IN_COL_ALT_GLVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Year in School at and beyond which the second alternate MCPA user-supplied table percentages will be used.
01=1st yr Never Attended
02=1st yr Attended Before
03=2nd yr Sophomore
04=3rd yr Junior
05=4th yr Senior
06=5th yr other UG
07=1st yr Grad/Prof
08=2nd yr Grad/Prof
09=3rd yr Grad/Prof
10=Beyond 3rd yr Grad/Prof
|
| 177 |
NM2_IN_COL_ALT1 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
2 in College Alt-1
|
| 178 |
NM2_IN_COL_ALT2 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
2 in College Alt-2
|
| 179 |
NM3_IN_COL_ALT1 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
3 in College Alt-1
|
| 180 |
NM3_IN_COL_ALT2 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
3 in College Alt-2
|
| 181 |
NM4_IN_COL_ALT1 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
4 in College Alt-1
|
| 182 |
NM4_IN_COL_ALT2 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
4 in College Alt-2
|
| 183 |
ASMNT_RT_IND_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use 70% Income Assmnt
1=Yes
N=No
|
| 184 |
USE_DFLT_MIN_SC |
Character(1) |
VARCHAR2(1) NOT NULL |
This is an indicator that gives the user the ability to use pre-defined default or user-specified values for the global 'Minimum SC from Income' LPO fields.
N=No
Y=Yes
Default Value: Y
|
| 185 |
CAN_IM_LT_FM_STU |
Character(1) |
VARCHAR2(1) NOT NULL |
Can Student IM Be Less Than FM
Y/N Table Edit
|
| 186 |
DEP_BDGT_DUR_FM_A |
Number(2,0) |
SMALLINT NOT NULL |
FM Dep Budget Duration - Acad
|
| 187 |
DEP_BDGT_DUR_FM_N |
Number(2,0) |
SMALLINT NOT NULL |
FM Dep Budget Duration - NStd
|
| 188 |
IND_BDGT_DUR_FM_A |
Number(2,0) |
SMALLINT NOT NULL |
FM Ind Budget Duration - Acad
|
| 189 |
IND_BDGT_DUR_FM_N |
Number(2,0) |
SMALLINT NOT NULL |
FM Ind Budget Duration - NStd
|
| 190 |
ASG_INC_PCT_OPT02 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.13%
2=1.3%
Y=1.52%
|
| 191 |
IND_PAR_ST_TAX_ALW |
Character(1) |
VARCHAR2(1) NOT NULL |
INAS Local Policy Option that provides the ability for Independent students (without Dependents) to use the Parent State Tax Allowance table.
Y/N Table Edit
|
| 192 |
FED_TX_AI_S_IM_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Fed Tax Allwnc Against Income
1=Follow CSS Rules
2=Calculated Tax - If Estim Retn
3=Reported Tax - If Estim Retn
|
| 193 |
FED_TX_AI_P_IM_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Fed Tax Allwnc Against Income
1=Follow CSS Rules
2=Calculated Tax - If Estim Retn
3=Reported Tax - If Estim Retn
|
| 194 |
DEP_BDGT_DUR_IM_A |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Dep Budget Duration - Acad
|
| 195 |
DEP_BDGT_DUR_IM_N |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Dep Budget Duration - NStd
|
| 196 |
IND_BDGT_DUR_IM_A |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Ind Budget Duration - Acad
|
| 197 |
IND_BDGT_DUR_IM_N |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
IM Ind Budget Duration - NStd
|
| 198 |
STU_ASSETS_TO_FMLY |
Character(1) |
VARCHAR2(1) NOT NULL |
INAS option used to transfer a dependent student's assets to the parents' side. When activated, the student's assets are added to the parents' assets and subtracted from the student's total (i.e. the student total is zeroed out).
1=Keep separate
2=All but Trusts
3=All Student Assets
Default Value: 1
|
| 199 |
INCOME_PCT_S_IM_04 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
% Unreimbursed Med/Dent Exp
|
| 200 |
INCOME_PCT_P_IM_04 |
Number(4,3) |
DECIMAL(3,3) NOT NULL |
% Unreimbursed Med/Dent Exp
|
| 201 |
HMOPT_PAR_IM_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Parent
1=Use Reported
2=Use Projected
3=Use Projected If Signifcnt Dif
4=Use Highest
5=Use Alt Home Value Calculation
|
| 202 |
HMOPT_I_WD_IM_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Ind W/Dep
1=Use Reported
2=Use Projected
3=Use Projected If Signifcnt Dif
4=Use Highest
5=Use Alt Home Value Calculation
|
| 203 |
FM_EFC_PRORTN_ACAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Academic Proration Method
1=Use Monthly EFCs
2=Adjust Based on Total EFC
3=Proportion Monthly Share
Default Value: 2
|
| 204 |
FM_EFC_PRORTN_NSTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Standard Proration Method
1=Leading Months
2=Trailing Months
3=FA Term Based
Default Value: 3
|
| 205 |
STU_ASSETS_TO_FM05 |
Character(1) |
VARCHAR2(1) NOT NULL |
INAS option used to transfer a dependent student's assets to the parents' side. When activated, the student's assets are added to the parents' assets and subtracted from the student's total (i.e. the student total is zeroed out).
1=Keep separate
2=All but Trusts
3=All Student Assets
4=Stu Assets 5% and Trusts 25%
Default Value: 1
|
| 206 |
CAP_HOME_EQUITY_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 207 |
EXCL_TUIT_DED_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Tuition/Fee Deduction
Y/N Table Edit
Default Value: N
|
| 208 |
CAP_HOME_EQTY_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 209 |
CAP_HOME_EQTY_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 210 |
CAP_HOME_EQT_FCT_S |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Home Equity Cap Factor
|
| 211 |
CAP_HOME_EQT_FCT_P |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Home Equity Cap Factor
|
| 212 |
ASG_INC_PCT_OPT08 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.13%
2=1.32%
Y=1.52%
|
| 213 |
MIN_SC_FRM_INC_CLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Alt Min SC from Income Calc
Y/N Table Edit
|
| 214 |
SFA_AI_TBL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Global option to select old or new Available Income (AI) Assessment Rate Table.
N=Use New Table
O=Use Old Table
Default Value: N
|
| 215 |
ASG_INC_PCT_OPT11 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.14%
2=1.35%
Y=1.52%
Default Value: Y
|
| 216 |
ASG_INC_PCT_OPT12 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.13%
2=1.30%
Y=1.52%
|
| 217 |
SFA_INCL_FSA_HC_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Health Care.
Y/N Table Edit
|
| 218 |
SFA_INCL_FSA_DC_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 219 |
ASG_INC_PCT_OPT14 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.21%
2=1.35%
Y=1.54%
|
| 220 |
SFA_INCL_HSA_PRETX |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 221 |
ASG_INC_PCT_OPT15 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=1.20%
2=1.34%
Y=1.52%
|
| 222 |
SFA_INCR_PY_SC_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Increase Last Year SC
|
| 223 |
SFA_INCR_PY_PC_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Increase Last Year PC
|
| 224 |
SFA_NM2_IN_COL_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
2 In College
|
| 225 |
SFA_NM3_IN_COL_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
3 In College
|
| 226 |
SFA_NM4_IN_COL_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
4 In College
|
| 227 |
SFA_AI_TBL_SEL_16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Global option to select old or new Available Income (AI) Assessment Rate Table.
N=Use Standard AI Table
Y=Use Alternate AI Table
Default Value: N
|
| 228 |
SFA_EXC_LO_INC_APA |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Income Asset Allowance Option for IM
N=Allow neg AI against assets
Y=Exclude neg AI against assets
|
| 229 |
SFA_INC_AST_PCT_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Income Asset Protection %
|
| 230 |
ASG_INC_PCT_OPT16 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=Use Public School rate
2=Use Public/Private School rate
Y=Use Private School rate
|
| 231 |
SFA_USE_AY_INC_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 232 |
SFA_USE_AY_INC_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 233 |
SFA_MMA_MARRIED |
Character(4) |
VARCHAR2(4) NOT NULL |
MMA - Married
|
| 234 |
SFA_MMA_SINGLE |
Character(4) |
VARCHAR2(4) NOT NULL |
MMA - Single
|
| 235 |
SFA_MMA_CHILD |
Character(4) |
VARCHAR2(4) NOT NULL |
MMA - Child
|
| 236 |
SFA_STU_CMP_INT_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Intl Student Contrib
Y/N Table Edit
|
| 237 |
SFA_CAP_INTL_IPA |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to limit an international Parent IPA (Income Protection Allowance) to an amount greater than or equal to 25% of the parental income.
Y/N Table Edit
Default Value: N
|
| 238 |
ASSET_I_WITH_IM_N |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset % Ind W/Dep
|
| 239 |
SFA_CAP_HM_EQ_FC_S |
Character(3) |
VARCHAR2(3) NOT NULL |
Student Home Equity Cap Factor
|
| 240 |
SFA_CAP_HM_EQ_FC_P |
Character(3) |
VARCHAR2(3) NOT NULL |
Parent Home Equity Cap Factor
|
| 241 |
SFA_EFM_SEL_INC_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Student IM Income used in EFM.
1=Use IM Income Fields
2=Use IM Reported Income
Default Value: 1
|
| 242 |
SFA_EFM_SEL_INC_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IM Income used in EFM.
1=Use IM Income Fields
2=Use IM Reported Income
Default Value: 1
|
| 243 |
SFA_IM_APLY_COL_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Student AGI used in IM.
N=Do Not Apply COLA Factor
Y=Apply COLA Factor
|
| 244 |
SFA_IM_APLY_COL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply COLA Factor for Parent.
N=Do Not Apply COLA Factor
Y=Apply COLA Factor
|
| 245 |
SFA_IM_SEL_INC_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Which Student AGI/Income indicator
1=Use Base Year Income
2=Use Anticipated Year Income
|
| 246 |
SFA_AI_TBL_SEL_22 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select old or expanded Available Income (AI) Assessment Rate Table.
N=Use Legacy AI Table
Y=Use Expanded AI Table
Default Value: N
|
| 247 |
SFA_AI_TBL_SEL_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
N=Use Expanded AI Table
Y=Use Legacy AI Table
Default Value: N
|
| 248 |
ASG_INC_PCT_OPT23 |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Local Policy Option for percentage of Total Income to be used in the Annual Savings Goal.
1=Use Public School rate
2=Use Public/Private School rate
N=Use Private School rate
|
| 249 |
HMOPT_STU_IM_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Student
1=Use Reported
2=Use Projected
3=Use Highest of Projctd/Reptd
|
| 250 |
HMOPT_PAR_IM_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Parent
1=Use Reported
2=Use Projected
3=Use Highest of Projctd/Reptd
|
| 251 |
SFA_AST_OPT_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
N=Do not project assets
Y=Project assets
|
| 252 |
SFA_AST_YLD_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
1=One Percent
2=Two Percent
3=Three Percent
4=Four Percent
5=Five Percent
6=Six Percent
7=Seven Percent
8=Eight Percent
9=Nine Percent
|
| 253 |
SFA_AST_TOL_DEP |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Tolerance Dependent
|
| 254 |
SFA_AST_OPT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
N=Do not project assets
Y=Project assets
|
| 255 |
SFA_AST_YLD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
1=One Percent
2=Two Percent
3=Three Percent
4=Four Percent
5=Five Percent
6=Six Percent
7=Seven Percent
8=Eight Percent
9=Nine Percent
|
| 256 |
SFA_AST_TOL_IND |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Tolerance Independent
|
| 257 |
SFA_AST_OPT_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
N=Do not project assets
Y=Project assets
|
| 258 |
SFA_AST_YLD_PAR |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to select legacy or expanded Available Income (AI) Assessment Rate Table.
1=One Percent
2=Two Percent
3=Three Percent
4=Four Percent
5=Five Percent
6=Six Percent
7=Seven Percent
8=Eight Percent
9=Nine Percent
|
| 259 |
SFA_AST_TOL_PAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Tolerance Parent
|
| 260 |
SFA_IM_COLL_CD |
Character(100) |
VARCHAR2(100) NOT NULL |
College Code
|