| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table:
AID_YEAR_TBL
|
| 4 |
INAS_RULE_SET |
Character(4) |
VARCHAR2(4) NOT NULL |
Option Rule Set
BASE=CSS Rules/Values
HLTH=Health Professional
STD=Undergrad/Graduate
|
| 5 |
DEPENDENCY_OVERIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Override
I=Independent - Prof Judgement
N=No - Suppress
|
| 6 |
PE_BDGT_DUR |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration
|
| 7 |
CALC_PC_IND_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc PC For Independent
Y/N Table Edit
|
| 8 |
USE_PY_INC_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 9 |
USE_PY_INC_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
Y/N Table Edit
|
| 10 |
ALWNC_TUIT_S |
Character(5) |
VARCHAR2(5) NOT NULL |
Tuition
|
| 11 |
ALWNC_TUIT_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition
|
| 12 |
ALWNC_MED_DENT_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Medical/Dental
|
| 13 |
ALWNC_MED_DENT_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Medical/Dental
|
| 14 |
ALWNC_EMPL_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Employment
|
| 15 |
ALWNC_EMPL_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Employment
|
| 16 |
ALWNC_FICA_S |
Character(10) |
VARCHAR2(10) NOT NULL |
FICA
|
| 17 |
ALWNC_FICA_P |
Character(10) |
VARCHAR2(10) NOT NULL |
FICA
|
| 18 |
ALWNC_INC_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Income
|
| 19 |
ALWNC_INC_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Income
|
| 20 |
COLA_INDEX_S |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
COLA Index
|
| 21 |
COLA_INDEX_P |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
COLA Index
|
| 22 |
IPA_S |
Character(5) |
VARCHAR2(5) NOT NULL |
IPA
|
| 23 |
IPA_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Income Protection Allowance
|
| 24 |
TAX_PD_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Paid
|
| 25 |
TAX_PD_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Paid
|
| 26 |
CALC_US_TAX_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc US Tax
1=Follow CSS Rules
2=Use Calculated Tax
3=Use Reported Tax-Compltd Retn
4=Use Reported Tax
|
| 27 |
CALC_US_TAX_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc US Tax
1=Follow CSS Rules
2=Use Calculated Tax
3=Use Reported Tax-Compltd Retn
4=Use Reported Tax
|
| 28 |
EST_TAX_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Tax
|
| 29 |
EST_TAX_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Tax
|
| 30 |
LCL_TAX_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Local Tax
|
| 31 |
LCL_TAX_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Local Tax
|
| 32 |
LCL_TAX_PCT_S |
Number(3,2) |
DECIMAL(2,2) NOT NULL |
Local Tax - Percent
|
| 33 |
LCL_TAX_PCT_P |
Number(3,2) |
DECIMAL(2,2) NOT NULL |
Local Tax - Percent
|
| 34 |
INC_ASSESS_PCT_S |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Income Assesment - Percent
|
| 35 |
ZL_BUS_FARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Business/Farm
Y/N Table Edit
|
| 36 |
ZL_OTHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Other
Y/N Table Edit
|
| 37 |
ZL_ADJUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust
Y/N Table Edit
|
| 38 |
USE_AAI_TBL_S |
Character(1) |
VARCHAR2(1) NOT NULL |
AAI Table
A=Alternate
S=Standard
|
| 39 |
USE_AAI_TBL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
AAI Table
A=Alternate
S=Standard
|
| 40 |
OTH_ASSET_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Asset
|
| 41 |
OTH_ASSET_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Asset
|
| 42 |
ASSET_ALWNC_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Allowance
|
| 43 |
ASSET_ALWNC_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset
|
| 44 |
PJCT_HSG_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Home
1=Reported
2=Projected
3=Projected If Significant
4=Use Highest
|
| 45 |
PJCT_HSG_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Home
1=Reported
2=Projected
3=Projected If Significant
4=Use Highest
|
| 46 |
CAP_HSG_S |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Cap Housing Value
|
| 47 |
CAP_HSG_P |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Cap Housing Value
|
| 48 |
PJCT_AST_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Assets
C=Project Combined
N=No Projection
|
| 49 |
PJCT_AST_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Assets
C=Project Combined Assets
I=Project Assets Separately
N=No Projection
|
| 50 |
PCT_ADD_IRA |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Add % Of IRA/KEOGH
|
| 51 |
ALLOW_NEG_SUPP_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Neg Income Supplement
Y/N Table Edit
|
| 52 |
ALLOW_NEG_SUPP_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Neg Income Supplement
Y/N Table Edit
|
| 53 |
ASSET_RATE_S |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset Assessment %
|
| 54 |
ASSET_RATE_P |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Asset Assessment %
|
| 55 |
ELIM_APA_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Eliminate APA
Y/N Table Edit
|
| 56 |
ELIM_APA_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Eliminate APA
Y/N Table Edit
|
| 57 |
NUM_COLLEGE_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Number In College
|
| 58 |
NUM_COLLEGE_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Number In College
|
| 59 |
MIN_INC_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Income
|
| 60 |
MIN_INC_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Income
|
| 61 |
MIN_ASSET_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Asset
|
| 62 |
MIN_ASSET_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Asset
|
| 63 |
PRIOR_SC |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Prior SC
|
| 64 |
PRIOR_PC |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Prior PC
|
| 65 |
INDEX_PCT_S |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
% Diff SC Against Prev SC
|
| 66 |
INDEX_PCT_P |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
% Diff PC Against Prev PC
|
| 67 |
MAX_PC_SIBLINGS |
Character(5) |
VARCHAR2(5) NOT NULL |
Max PC To Other Siblings
|
| 68 |
FM_MIN_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Can IM Be Less Than FM
Y/N Table Edit
|
| 69 |
FM_MIN_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Can IM Be Less Than FM
Y/N Table Edit
|
| 70 |
NON_CUST_PC |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
PC From Non-custodial Parent
|
| 71 |
SFA_NON_CUST_PC |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
PC From Non-Custodial Parent
|
| 72 |
EFC_USE_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Which EFC
F=Estimated Federal
G=Greatest
I=Institutional
O=Institutional W/Opt
|
| 73 |
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
|
| 74 |
SKIP_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Fmly Membr Exclsn
Y/N Table Edit
|
| 75 |
USE_BDGT |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Share of PC
1=Sum of their Budget
2=Ratio of Budgt to Total Budgt
3=Highest PC from Sum or Ratio
N=No
|
| 76 |
ADJ_EFC_AMT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Adjust EFC
|
| 77 |
SCA_NON_STD |
Character(1) |
VARCHAR2(1) NOT NULL |
SCA-Non Standard Award Period
Y/N Table Edit
|
| 78 |
HOPE_LTL_OPT_S |
Character(1) |
VARCHAR2(1) NOT NULL |
10/23/98 Created for INAS 1999 - 2000.
Y/N Table Edit
|
| 79 |
HOPE_LTL_OPT_P |
Character(1) |
VARCHAR2(1) NOT NULL |
10/23/98 Created for INAS 1999 - 2000.
Y/N Table Edit
|
| 80 |
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
|
| 81 |
ADJ_PC_AMT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Adjust PC
|
| 82 |
ADJ_SC_AMT |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Adjust SC
|
| 83 |
ASSET_RATE_P_X |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Rate Par Alpha
|
| 84 |
ASSET_RATE_S_X |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Rate Stu Alpha
|
| 85 |
COLA_INDEX_P_X |
Character(3) |
VARCHAR2(3) NOT NULL |
COLA Index Par Alpha
|
| 86 |
COLA_INDEX_S_X |
Character(3) |
VARCHAR2(3) NOT NULL |
COLA Index Stu Alpha
|
| 87 |
INC_ASSESS_PCT_S_X |
Character(3) |
VARCHAR2(3) NOT NULL |
Income Assessment Pct Stu Alph
|
| 88 |
LCL_TAX_PCT_P_X |
Character(2) |
VARCHAR2(2) NOT NULL |
Local Tax Pct Par Alpha
|
| 89 |
LCL_TAX_PCT_S_X |
Character(2) |
VARCHAR2(2) NOT NULL |
Local Tax Pct Stu Alpha
|
| 90 |
CAP_HSG_P_X |
Character(3) |
VARCHAR2(3) NOT NULL |
Cap Housing Value
|
| 91 |
CAP_HSG_S_X |
Character(3) |
VARCHAR2(3) NOT NULL |
Cap Housing Value
|
| 92 |
INDEX_PCT_P_X |
Character(3) |
VARCHAR2(3) NOT NULL |
% Diff PC Against Prev PC
|
| 93 |
INDEX_PCT_S_X |
Character(3) |
VARCHAR2(3) NOT NULL |
% Diff SC Against Prev SC
|
| 94 |
USE_PY_INC_S_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
N=No
Y=Yes
|
| 95 |
USE_PY_INC_P_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
N=No
Y=Yes
|
| 96 |
NUM_COLL_S_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Number In College
|
| 97 |
NUM_COLL_P_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Number In College
|
| 98 |
NUM_HSLD_S_EFM |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Number In Household
|
| 99 |
NUM_HSLD_P_EFM |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Number In Household
|
| 100 |
BDGT |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's total budget amount. Used in IM Need Analysis processing to limit the PC for other members in the family to their precentage of total budget. If left blank, the global budget will be used.
|
| 101 |
AGI_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Student AGI
|
| 102 |
AGI_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Parent AGI
|
| 103 |
UNTX_INC_S |
Character(11) |
VARCHAR2(11) NOT NULL |
Student Untaxed Income
|
| 104 |
UNTX_INC_P |
Character(11) |
VARCHAR2(11) NOT NULL |
Parent Untaxed Income
|
| 105 |
CALC_US_TAX_S_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc US Tax
1=Follow CSS Rules
2=Calculated Tax - If Estim Retn
3=Reported Tax - If Estim Retn
4=Lower of Rpt/Calc-If Comp Retn
|
| 106 |
CALC_US_TAX_P_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc US Tax
1=Follow CSS Rules
2=Calculated Tax - If Estim Retn
3=Reported Tax - If Estim Retn
4=Lower of Rpt/Calc-If Comp Retn
|
| 107 |
ALLOW_PAR_INCOL_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Parent(s) In College
Y/N Table Edit
|
| 108 |
ALLW_PAR_INCOL_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Parent(s) In College
Y/N Table Edit
|
| 109 |
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
|
| 110 |
PE_BDGT_DUR_A |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration Acad Per
|
| 111 |
PE_BDGT_DUR_N |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration NStd Per
|
| 112 |
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
|
| 113 |
OVRD_SC_AMT_A |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Student Contribution Override for the Academic Award Period.
|
| 114 |
OVRD_SC_AMT_N |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Student Contribution Override for the Non-Standard Award Period.
|
| 115 |
OVRD_SC_AMT |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Student Contribution Override for the Aid Year.
|
| 116 |
OVRD_PC_AMT_A |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Parent Contribution Override for the Academic Award Period.
|
| 117 |
OVRD_PC_AMT_N |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Parent Contribution Override for the Non-Standard Award Period.
|
| 118 |
OVRD_PC_AMT |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Parent Contribution Override for the Aid Year.
|
| 119 |
OVRD_EFC_AMT_A |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Estimated Family Contribution Override for the Academic Award Period.
|
| 120 |
OVRD_EFC_AMT_N |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Estimated Family Contribution Override for the Non-Standard Award Period.
|
| 121 |
OVRD_EFC_AMT |
Signed Number(8,0) |
DECIMAL(7) NOT NULL |
Estimated Family Contribution Override for the Aid Year.
|
| 122 |
USE_EFC_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that triggers usage of EFC Override values in Need Analysis calculations.
Y/N Table Edit
Default Value: N
|
| 123 |
PJCT_HSG_S_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Home
1=Reported
2=Projected
3=Projected If Significant
4=Use Highest
5=Use Alt Home Value Calculation
|
| 124 |
PJCT_HSG_P_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Home
1=Reported
2=Projected
3=Projected If Significant
4=Use Highest
5=Use Alt Home Value Calculation
|
| 125 |
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%
|
| 126 |
CAP_HOME_EQUITY_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 127 |
EXCL_TUIT_DED_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Tuition/Fee Deduction
Y/N Table Edit
Default Value: N
|
| 128 |
CAP_HOME_EQTY_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 129 |
CAP_HOME_EQTY_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Cap Home Equity
Y/N Table Edit
Default Value: N
|
| 130 |
CAP_HOME_EQT_FCT_S |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Home Equity Cap Factor
|
| 131 |
CAP_HOME_EQT_FCT_P |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Home Equity Cap Factor
|
| 132 |
SFA_EXC_WS_INC_EXC |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to exclude student's Work Study earnings from income exclusion calculation.
Y/N Table Edit
|
| 133 |
MIN_SC_FRM_INC_CLC |
Character(1) |
VARCHAR2(1) NOT NULL |
Alt Min SC from Income Calc
Y/N Table Edit
|
| 134 |
SFA_CAP_INTL_S_IPA |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to limit an international student's IPA (Income Protection Allowance) to an amount greater than or equal to 25% of the parental income. This option is not applicable to domestic students.
Y/N Table Edit
|
| 135 |
SFA_CALC_TCA_W_CC |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to calculate an optional contribution from assets (TCA) by applying the country coefficient to the percentage used to caclulate the step increment. This is option is only applicable for international (non-domestic) students.
Y/N Table Edit
|
| 136 |
USE_NCPC |
Character(1) |
VARCHAR2(1) NOT NULL |
Add Non Cust PC to PC
Y/N Table Edit
Default Value: N
|
| 137 |
SFA_HSG_MULT_OVR_S |
Character(4) |
VARCHAR2(4) NOT NULL |
Housing Multiplier Override
|
| 138 |
SFA_HSG_MULT_OVR_P |
Character(4) |
VARCHAR2(4) NOT NULL |
Housing Multiplier Override
|
| 139 |
SFA_INCL_FSA_HC_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Health Care.
Y/N Table Edit
|
| 140 |
SFA_INCL_FSA_DC_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 141 |
SFA_INCL_HSA_PRETX |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 142 |
SFA_INCR_PY_SC_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Increase Last Year SC
|
| 143 |
SFA_INCR_PY_PC_IM |
Character(3) |
VARCHAR2(3) NOT NULL |
Increase Last Year PC
|
| 144 |
SFA_ANT_TAX_S |
Character(10) |
VARCHAR2(10) NOT NULL |
Anticipated Tax
|
| 145 |
SFA_ANT_TAX_P |
Character(10) |
VARCHAR2(10) NOT NULL |
Anticipated Tax
|
| 146 |
SFA_USE_AYI_S_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 147 |
SFA_USE_AYI_P_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 148 |
SFA_USE_AYI_S_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 149 |
SFA_USE_AYI_P_EFM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 150 |
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
|
| 151 |
SFA_ALL_INC_EXCL_S |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow All Income Exclusions
|
| 152 |
SFA_ALL_INC_EXCL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow All Income Exclusions
|
| 153 |
SFA_CAP_HM_EQ_FC_S |
Character(3) |
VARCHAR2(3) NOT NULL |
Student Home Equity Cap Factor
|
| 154 |
SFA_CAP_HM_EQ_FC_P |
Character(3) |
VARCHAR2(3) NOT NULL |
Parent Home Equity Cap Factor
|
| 155 |
SFA_NCP_DEP_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dependency Override
I=Independent - Prof Judgement
N=No - Suppress
|
| 156 |
SFA_NCP_BDGT_DUR |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration
|
| 157 |
SFA_NCP_USE_PY_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
|
| 158 |
SFA_NCP_ALWNC_TUIT |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition
|
| 159 |
SFA_NCP_ALW_MD_DEN |
Character(10) |
VARCHAR2(10) NOT NULL |
Medical/Dental
|
| 160 |
SFA_NCP_ALWNC_EMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Employment
|
| 161 |
SFA_NCP_ALWNC_FICA |
Character(10) |
VARCHAR2(10) NOT NULL |
FICA
|
| 162 |
SFA_NCP_ALWNC_INC |
Character(10) |
VARCHAR2(10) NOT NULL |
Income
|
| 163 |
SFA_NCP_COLA_INDEX |
Character(3) |
VARCHAR2(3) NOT NULL |
COLA Index Par Alpha
|
| 164 |
SFA_NCP_IPA |
Character(10) |
VARCHAR2(10) NOT NULL |
Income Protection Allowance
|
| 165 |
SFA_NCP_TAX_PD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Paid
|
| 166 |
SFA_NCP_EST_TAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Estimated Tax
|
| 167 |
SFA_NCP_LCL_TAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Local Tax
|
| 168 |
SFA_NCP_LCL_TX_PCT |
Character(2) |
VARCHAR2(2) NOT NULL |
Local Tax Pct Par Alpha
|
| 169 |
SFA_NCP_BUS_FARM |
Character(1) |
VARCHAR2(1) NOT NULL |
Business/Farm
Y/N Table Edit
|
| 170 |
SFA_NCP_OTHR_LOSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Other
Y/N Table Edit
|
| 171 |
SFA_NCP_OTH_ASSET |
Character(10) |
VARCHAR2(10) NOT NULL |
Other Asset
|
| 172 |
SFA_NCP_ASSET_ALWC |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset
|
| 173 |
SFA_NCP_PJCT_AST |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Assets
C=Project Combined Assets
I=Project Assets Separately
N=No Projection
|
| 174 |
SFA_NCP_PCT_ADDIRA |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Add % Of IRA/KEOGH
|
| 175 |
SFA_NCP_NUM_COLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Number In College
|
| 176 |
SFA_NCP_MIN_INC |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Income
|
| 177 |
SFA_NCP_MIN_ASSET |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Asset
|
| 178 |
SFA_NCP_PRIOR_PC |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Prior PC
|
| 179 |
SFA_NCP_FM_MIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Can IM Be Less Than FM
Y/N Table Edit
|
| 180 |
SFA_NCP_EFC_USE_IM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Which EFC
F=Estimated Federal
G=Greatest
I=Institutional
O=Institutional W/Opt
|
| 181 |
SFA_NCP_IM_APP_SRC |
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
|
| 182 |
SFA_NCP_SKIP_AGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Fmly Membr Exclsn
Y/N Table Edit
|
| 183 |
SFA_NCP_USE_BDGT |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Share of PC
1=Sum of their Budget
2=Ratio of Bdgt to Total Bdgt
3=Lowest of 1 or 2
N=No
|
| 184 |
SFA_NCP_HOPE_LTL |
Character(1) |
VARCHAR2(1) NOT NULL |
10/23/98 Created for INAS 1999 - 2000.
Y/N Table Edit
|
| 185 |
SFA_NCP_USE_P_AGI |
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
|
| 186 |
SFA_NCP_ASSET_RATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Rate Par Alpha
|
| 187 |
SFA_NCP_CAP_HSG |
Character(3) |
VARCHAR2(3) NOT NULL |
Cap Housing Value
|
| 188 |
SFA_NCP_USE_PYI_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Projected Year Income
N=No
Y=Yes
|
| 189 |
SFA_NCP_NUM_COL_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Number In College
|
| 190 |
SFA_NCP_NO_HSLD_FM |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Number In Household
|
| 191 |
SFA_NCP_BDGT |
Character(10) |
VARCHAR2(10) NOT NULL |
Student's total budget amount. Used in IM Need Analysis processing to limit the PC for other members in the family to their precentage of total budget. If left blank, the global budget will be used.
|
| 192 |
SFA_NCP_AGI |
Character(10) |
VARCHAR2(10) NOT NULL |
Parent AGI
|
| 193 |
SFA_NCP_UNTX_INC |
Character(11) |
VARCHAR2(11) NOT NULL |
Parent Untaxed Income
|
| 194 |
SFA_NCP_CLC_US_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Calc US Tax
1=Follow CSS Rules
2=Calculated Tax - If Estim Retn
3=Reported Tax - If Estim Retn
4=Lower of Rpt/Calc-If Comp Retn
|
| 195 |
SFA_NCP_PA_STX_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.
|
| 196 |
SFA_NCP_BDGT_DUR_A |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration Acad Per
|
| 197 |
SFA_NCP_BDGT_DUR_N |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Budget Duration NStd Per
|
| 198 |
SFA_NCP_PJCT_HSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Imputation Of Home
1=Reported
2=Projected
3=Projected If Significant
4=Use Highest
5=Use Alt Home Value Calculation
|
| 199 |
SFA_NCP_S_AST_FAM |
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%
|
| 200 |
SFA_NCP_EXC_TF_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Tuition/Fee Deduction
Y/N Table Edit
|
| 201 |
SFA_NCP_CAP_HM_EQT |
Character(2) |
VARCHAR2(2) NOT NULL |
Parent Home Equity Cap Factor
|
| 202 |
SFA_NCP_CLC_TCA_CC |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to calculate an optional contribution from assets (TCA) by applying the country coefficient to the percentage used to caclulate the step increment. This is option is only applicable for international (non-domestic) students.
Y/N Table Edit
|
| 203 |
SFA_NCP_HSG_MULT |
Character(4) |
VARCHAR2(4) NOT NULL |
Housing Multiplier Override
|
| 204 |
SFA_NCP_INC_FSA_HC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Health Care.
Y/N Table Edit
|
| 205 |
SFA_NCP_INC_FSA_DC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 206 |
SFA_NCP_INC_HSA_PT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Flexible Spending Accounts for Dependent Care.
Y/N Table Edit
|
| 207 |
SFA_NCP_INC_PY_PC |
Character(3) |
VARCHAR2(3) NOT NULL |
Increase Last Year PC
|
| 208 |
SFA_NCP_ANT_TAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Anticipated Tax
|
| 209 |
SFA_NCP_USE_AY_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 210 |
SFA_NCP_USE_AYI_FM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Anticipated Year Income
Y/N Table Edit
|
| 211 |
SFA_NCP_CP_IS_IPA |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to limit an international student's IPA (Income Protection Allowance) to an amount greater than or equal to 25% of the parental income. This option is not applicable to domestic students.
Y/N Table Edit
|
| 212 |
SFA_NCP_CP_ITL_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
|
| 213 |
SFA_NCP_CAP_EQ_F_P |
Character(3) |
VARCHAR2(3) NOT NULL |
Parent Home Equity Cap Factor
|
| 214 |
SFA_NCP_INC_EXCL_P |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow All Income Exclusions
|
| 215 |
SFA_NCP_IM_SEL_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Which Non-Custodial Parent AGI/Income indicator
1=Use Base Year Income
2=Use Anticipated Year Income
3=Use Calculated AGI/Income
|
| 216 |
SFA_NCP_FED_TX_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Federal Tax Used
Y=Calculate U.S. Taxes
|
| 217 |
SFA_NCP_INTL_APA |
Character(1) |
VARCHAR2(1) NOT NULL |
IM Option to calculate an Asset Protection Allowance for International Students.
Y/N Table Edit
|
| 218 |
SFA_NCP_HVCAP_OFF |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to turn off the Global Home Value Cap for the student.
Y/N Table Edit
|
| 219 |
SFA_NCP_HECAP_OFF |
Character(1) |
VARCHAR2(1) NOT NULL |
IM option to turn off the Global Home Value Cap for the student.
Y/N Table Edit
|
| 220 |
SFA_NCP_EFM_INC |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent IM Income Used for EFM calculation.
1=Use IM Income
2=Use IM Reported Income
3=Use IM Anticipated Income
4=Use IM Income Overrides
|
| 221 |
SFA_NCP_EFM_PRJAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Student Asset Value,
Y/N Table Edit
|
| 222 |
SFA_NCP_EFM_CLC_TX |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Student Asset Value,
Y=Calculate U.S. Taxes
|
| 223 |
SFA_NCP_SEL_AI_TBL |
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
|
| 224 |
SFA_NCP_SEL_AI_T23 |
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
|
| 225 |
SFA_NCP_PJCT_HSG23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Option Student
1=Use Reported
2=Use Projected
3=Use Highest of Projctd/Reptd
|
| 226 |
SFA_NCP_PJCT_AST23 |
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
|