Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
RCRAPP2
|
RCRAPP2_ACTIVITY_DATE
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AID_YEAR
|
Financial Aid Year
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_AIDY_CODE
|
AID_YEAR_DESC
|
Financial Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
APPLICATION_NUMBER
|
Application Number
|
Financial aid application unique sequence number.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_SEQ_NO
|
CURRENT_RECORD_IND
|
Current Record Indicator
|
Specifies that this is the current need analysis record.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_CURR_REC_IND
|
EFM_DEPENDENCY_STATUS
|
Efm Dependency Status
|
Calculated Estimated Federal Method dependency status.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_EFM_FORMULA_FOR_CALC
|
EFM_DEPENDENCY_STATUS_DESC
|
Efm Dependency Status Description
|
Estimated Federal Method calculated dependency status description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
FM_ADJUSTED_AVAIL_INCOME
|
Federal Method Adjusted Avail Income
|
Student's calculated adjusted available income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_ADJ_AVAIL_INC
|
FM_ADJUSTED_BUS_NET_WORTH
|
Federal Method Adjusted Bus Net Worth
|
Amount of business and farm net worth used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_ADJ_BF_NET_WTH
|
FM_ADJUSTED_GROSS_INCOME
|
Federal Method Adjusted Gross Income
|
Student's adjusted gross taxable income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AGI_TAX_INC
|
FM_ANALYSIS_TYPE
|
Federal Method Analysis Type
|
Analysis type used to determine the primary Student Calculation.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_1_ANLY_TYPE
|
FM_ANALYSIS_TYPE_DESC
|
Federal Method Analysis Type Description
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_1_ANLY_TYPE) RORMVAL_DESC
|
FM_ASSET_PROTECT_ALLOWANCE
|
Federal Method Asset Protect Allowance
|
Amount of the student's asset protection allowance in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_PROT_ALLOW
|
FM_AVAILABLE_INCOME
|
Federal Method Available Income
|
Student's available discretionary income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AVAIL_DISC_INC
|
FM_AVAILABLE_TAX_INCOME
|
Federal Method Available Tax Income
|
Student's available taxable income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AVAIL_TAX_INC
|
FM_CALC_AVAILABLE_INCOME
|
Federal Method Calculated Available Income
|
Student's calculated available income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CALC_AVAIL_INC
|
FM_CASH_AMOUNT
|
Federal Method Cash Amount
|
Student's amounts in cash, savings and checking accounts used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CASH_AMT
|
FM_CONTRIBUTION_ASSET
|
Federal Method Contribution Asset
|
Student's contribution from assets for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FR_ASSET
|
FM_CONTRIBUTION_INCOME
|
Federal Method Contribution Income
|
Student's contribution from income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FR_INC
|
FM_CONTRIBUTION_OFFICIAL
|
Federal Method Contribution Official
|
Indicates if the student contribution for the primary calculation is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_OFFL_EST
|
FM_CONTRIBUTION_OFFICIAL_AMT
|
Federal Method Contribution Official Amount
|
Official student contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_CTRB_FOR_STDT
|
FM_CONTRIBUTION_OFFICIAL_DESC
|
Federal Method Contribution Official Description
|
Contribution official description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) RORMVAL_DESC
|
FM_CONVERSION_PERCENT
|
Federal Method Conversion Percent
|
Conversion percent used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CONV_PCT
|
FM_DEPENDENCY_STATUS
|
Federal Method Dependency Status
|
Calculated Federal Method dependency status.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FM_FORMULA_FOR_CALC
|
FM_DEPENDENCY_STATUS_DESC
|
Federal Method Dependency Status Description
|
Estimated Federal Method calculated dependency status description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
FM_DISCRET_NET_WORTH
|
Federal Method Discret Net Worth
|
Student's discretionary net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_DISC_NET_WTH
|
FM_EMPLOYMENT_ALLOWANCE
|
Federal Method Employment Allowance
|
Student's employment allowance used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_EMP_ALLOW
|
FM_EST_ADJUSTED_BUS_NET_WORTH
|
Federal Method Est Adjusted Bus Net Worth
|
Student's adjusted business or farm net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_ADJ_BF_NET_WTH
|
FM_EST_AGI
|
Federal Method Est Agi
|
Total estimated adjusted gross income used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_AGI_TAX_INC
|
FM_EST_ASSET_PROT_ALLOWANCE
|
Federal Method Est Asset Prot Allowance
|
Student's estimated asset protection allowance used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_PROT_ALLOW
|
FM_EST_AVAILABLE_INCOME
|
Federal Method Est Available Income
|
Student's estimated available discretionary income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_AVAIL_DISC_INC
|
FM_EST_CASH_AMOUNT
|
Federal Method Est Cash Amount
|
Student's estimated amounts in cash, savings and checking accounts used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CASH_AMT
|
FM_EST_CONTRIBUTION_ASSET
|
Federal Method Est Contribution Asset
|
Portion of the estimated primary parent contribution that came from assets.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FR_ASSET
|
FM_EST_CONTRIBUTION_INCOME
|
Federal Method Est Contribution Income
|
Portion of the estimated primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FR_INC
|
FM_EST_CONTRIBUTION_OFFICIAL
|
Federal Method Est Contribution Official
|
Indicates if the estimated primary parent contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_OFFL_EST
|
FM_EST_CONTRIB_OFFICIAL_DESC
|
Federal Method Est Contribution Official Description
|
Description of the estimated primary parent contribution.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)
|
FM_EST_CONVERSION_PERCENT
|
Federal Method Est Conversion Percent
|
Student's estimated conversion percentage used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CONV_PCT
|
FM_EST_DISCRET_NET_WORTH
|
Federal Method Est Discret Net Worth
|
Student's estimated discretionary net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_DISC_NET_WTH
|
FM_EST_EMPLOYMENT_ALLOWANCE
|
Federal Method Est Employment Allowance
|
Total estimated employment allowance used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_EMP_ALLOW
|
FM_EST_FAMILY_IN_COLLEGE
|
Federal Method Est Family In College
|
Student's estimated family members in college.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_NO_IN_COLL
|
FM_EST_FEDERAL_TAX_PAID
|
Federal Method Est Federal Tax Paid
|
Total estimated federal taxes used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_US_INC_TAX
|
FM_EST_INAS
|
Federal Method Est INAS
|
The student estimated contribution for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FOR_STDT
|
FM_EST_NET_WORTH
|
Federal Method Est Net Worth
|
Student's estimated net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_NET_WTH
|
FM_EST_OTHER_ASSET
|
Federal Method Est Other Asset
|
Amount of the other asset (override) used in the student FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_1_OTH_ASSET
|
FM_EST_REAL_ESTATE_EQ
|
Federal Method Est Real Estate Eq
|
Student's estimated real estate equity used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_RE_INV_VAL
|
FM_EST_STAND_MAINT_ALLOWANCE
|
Federal Method Est Stand Maint Allowance
|
Total estimated standard maintenance allowance used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_MNT_ALLOW
|
FM_EST_STATE_PROV_TAX_PAID
|
Federal Method Est State Province Tax Paid
|
Total estimated state or province taxes used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_ST_OTH_TAX
|
FM_EST_TOTAL_ALLOWANCE
|
Federal Method Est Total Allowance
|
Estimated amount of total allowances used in the student's FM calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_ALLOW
|
FM_EST_TOTAL_CONTRIBUTION
|
Federal Method Est Total Contribution
|
Student's estimated total contribution used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_CTRB
|
FM_EST_TOTAL_INCOME
|
Federal Method Est Total Income
|
Total estimated income used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_INC
|
FM_EST_TOTAL_UNTAX_INCOME
|
Federal Method Est Total Untax Income
|
Total estimated untaxable income used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_UNTAX_INC
|
FM_FAMILY_IN_COLLEGE
|
Federal Method Family In College
|
Number of people in the student's household that will be in college as used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_NO_IN_COLL
|
FM_FAMILY_SIZE
|
Federal Method Family Size
|
Independent student's computed number of family members in the household.
|
NUMBER
|
CALCULATION
|
DECODE(RCRAPP2_MODEL_CDE)
|
FM_FEDERAL_TAX_PAID
|
Federal Method Federal Tax Paid
|
Amount of federal income taxes paid used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_US_INC_TAX
|
FM_FISAP_TOTAL_INCOME
|
Federal Method Fisap Total Income
|
Indicates the person's total FISAP income.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_FISAP_INC
|
FM_FORMULA
|
Federal Method Formula
|
Formula used for the FM calculation.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FORMULA_FOR_CALC
|
FM_FORMULA_DESC
|
Federal Method Formula Description
|
FM formula description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP4_FORMULA_FOR_CALC)
|
FM_HOME_EQUITY
|
Federal Method Home Equity
|
Home equity used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_HME_VAL
|
FM_INAS
|
Federal Method INAS
|
The student contribution for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FOR_STDT
|
FM_INCOME_SUPPLEMENT
|
Federal Method Income Supplement
|
Amount of the income supplement used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_INC_SUPPLEMENT
|
FM_MARITAL_STATUS
|
Federal Method Marital Status
|
Student's computed marital status.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_MRTL_STATUS
|
FM_MARITAL_STATUS_DESC
|
Federal Method Marital Status Description
|
Student marital status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_MRTL_STATUS)
|
FM_MEDICAL_DENTAL_EXPENSE
|
Federal Method Medical Dental Expense
|
Amount of medical and dental expenses used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_MED_DEN_EXP
|
FM_NET_WORTH
|
Federal Method Net Worth
|
Amount of the student's net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_NET_WTH
|
FM_PARENT_ADJUST_GROSS_INCOME
|
Federal Method Parent Adjustment Gross Income
|
The adjusted gross taxable income used in the calculation of the primary parents' contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_AGI_TAX_INC
|
FM_PARENT_ADJ_AVAILABLE_INCOME
|
Federal Method Parent Adjustment Available Income
|
Amount of the adjusted available income that was used in the primary calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_ADJ_AVAIL_INC
|
FM_PARENT_ADJ_BUS_NET_WORTH
|
Federal Method Parent Adjustment Bus Net Worth
|
Adjusted business/farm net worth used in the primary calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH
|
FM_PARENT_ANALYSIS_TYPE
|
Federal Method Parent Analysis Type
|
Analysis type used to determine the primary Parent Calculation.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_1_ANLY_TYPE
|
FM_PARENT_ANALYSIS_TYPE_DESC
|
Federal Method Parent Analysis Type Description
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) RORMVAL_DESC
|
FM_PARENT_ASSET_PROT_ALLOWANCE
|
Federal Method Parent Asset Prot Allowance
|
Asset protection allowance used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_PROT_ALLOW
|
FM_PARENT_AVAILABLE_INCOME
|
Federal Method Parent Available Income
|
Available discretionary income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_AVAIL_DISC_INC
|
FM_PARENT_CASH_AMOUNT
|
Federal Method Parent Cash Amount
|
Amount of parents' cash, savings and checking accounts used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CASH_AMT
|
FM_PARENT_CONTRIBUTION_ASSET
|
Federal Method Parent Contribution Asset
|
Portion of the primary parent contribution that came from assets.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FR_ASSET
|
FM_PARENT_CONTRIBUTION_INCOME
|
Federal Method Parent Contribution Income
|
Portion of the primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FR_INC
|
FM_PARENT_CONTRIB_OFFICIAL
|
Federal Method Parent Contribution Official
|
Indicates if the primary parent contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_OFFL_EST
|
FM_PARENT_CONTRIB_OFFICIAL_AMT
|
Federal Method Parent Contribution Official Amount
|
Official parent contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_CTRB_FOR_STDT
|
FM_PARENT_CONTRIB_OFFICIAL_EST
|
Federal Method Parent Contribution Official Est
|
Indicates if the parental contribution amount is official or estimated.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_CTRB_OFFL_EST
|
FM_PARENT_CONTRIB_OFF_DESC
|
Federal Method Parent Contribution Official Description
|
Description of the primary parent contribution.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
FM_PARENT_CONTRIB_OFF_EST_DESC
|
Federal Method Parent Contribution Off Est Description
|
Parent contribution official/estimate description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST) RORMVAL_DESC
|
FM_PARENT_CONVERSION_PERCENT
|
Federal Method Parent Conversion Percent
|
Discretionary net worth conversion percent used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CONV_PCT
|
FM_PARENT_DATA_AVAILABLE_IND
|
Federal Method Parent Data Available Indicator
|
Indicates whether parent data was available for the FM calculation.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FM_PAR_DATA_AVAIL
|
FM_PARENT_DISCRET_NET_WORTH
|
Federal Method Parent Discret Net Worth
|
Discretionary net worth used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_DISC_NET_WTH
|
FM_PARENT_EMPLOYMENT_ALLOWANCE
|
Federal Method Parent Employment Allowance
|
Employment allowance used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_EMP_ALLOW
|
FM_PARENT_EST_AGI
|
Federal Method Parent Est Agi
|
The estimated adjusted gross taxable income used in the calculation of the primary parents' contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_AGI_TAX_INC
|
FM_PARENT_EST_ANALYSIS_TYPE
|
Federal Method Parent Est Analysis Type
|
Analysis type for the primary system PGI.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_P_ANLY_TYPE
|
FM_PARENT_EST_ANAL_TYPE_DESC
|
Federal Method Parent Est Anal Type Description
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_PELL_P_ANLY_TYPE)
|
FM_PARENT_EST_FEDERAL_TAX_PAID
|
Federal Method Parent Est Federal Tax Paid
|
Amount of estimated federal taxes used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_US_INC_TAX
|
FM_PARENT_EST_INCOME_ADJUST
|
Federal Method Parent Est Income Adjustment
|
Amount of the income adjustment used in the parent FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_PAR_1_INC_ADJ
|
FM_PARENT_EST_OTHER_ASSET
|
Federal Method Parent Est Other Asset
|
Amount of the other asset (override) used in the parent FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_PAR_1_OTH_ASSET
|
FM_PARENT_EST_OTH_INCOME_ALLOW
|
Federal Method Parent Est Oth Income Allow
|
Amount of the other income allowance (override) used in the parent FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_PAR_1_OTH_ALLOW
|
FM_PARENT_EST_STAT_PROV_TAX_PD
|
Federal Method Parent Est State Province Tax Pd
|
Amount of estimated state_province taxes used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_ST_OTH_TAX
|
FM_PARENT_EST_TOTAL_INCOME
|
Federal Method Parent Est Total Income
|
Total estimated income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_TOT_INC
|
FM_PARENT_EST_TOT_UNTAX_INCOME
|
Federal Method Parent Est Total Untax Income
|
The estimated total untaxed income used in the calculation of the primary parent's contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_TOT_UNTAX_INC
|
FM_PARENT_FAMILY_IN_COLLEGE
|
Federal Method Parent Family In College
|
Number of people in the parents household who will be in college as used in the calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_NO_IN_COLL
|
FM_PARENT_FAMILY_SIZE
|
Federal Method Parent Family Size
|
Parent's computed number of family members in the household.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_FAM_MEMB
|
FM_PARENT_FEDERAL_TAX_PAID
|
Federal Method Parent Federal Tax Paid
|
Amount of US income taxes paid used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_US_INC_TAX
|
FM_PARENT_HOME_EQUITY
|
Federal Method Parent Home Equity
|
Home equity used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_HME_VAL
|
FM_PARENT_INAS
|
Federal Method Parent INAS
|
Primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FOR_STDT
|
FM_PARENT_INCOME_SUPPLEMENT
|
Federal Method Parent Income Supplement
|
Income supplement used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_INC_SUPPLEMENT
|
FM_PARENT_MARITAL_STATUS
|
Federal Method Parent Marital Status
|
Parent's computed marital status.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_MRTL_STATUS
|
FM_PARENT_MARITAL_STATUS_DESC
|
Federal Method Parent Marital Status Description
|
Parent marital status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_PAR_MRTL_STATUS)
|
FM_PARENT_MEDICAL_DENTAL_EXP
|
Federal Method Parent Medical Dental Expiration
|
Amount of medical and dental expenses used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_MED_DEN_EXP
|
FM_PARENT_NET_WORTH
|
Federal Method Parent Net Worth
|
Net worth used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_NET_WTH
|
FM_PARENT_REAL_ESTATE_EQUITY
|
Federal Method Parent Real Estate Equity
|
Other real estate and investment equity used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_RE_INV_VAL
|
FM_PARENT_SECONDARY_TUITION_PD
|
Federal Method Parent Secondary Tuition Pd
|
Amount of elementary and secondary school tuition paid used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_SCH_TUIT
|
FM_PARENT_STAND_MAINT_ALLOW
|
Federal Method Parent Stand Maint Allow
|
Standard maintenance allowance used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_MNT_ALLOW
|
FM_PARENT_STATE_PROV_TAX_PAID
|
Federal Method Parent State Province Tax Paid
|
Amount of state and other taxes paid used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_ST_OTH_TAX
|
FM_PARENT_TOTAL_ALLOWANCES
|
Federal Method Parent Total Allowances
|
Total allowances used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_ALLOW
|
FM_PARENT_TOTAL_CONTRIBUTION
|
Federal Method Parent Total Contribution
|
Total primary parent contribution before adjustment for the number of family members in college.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_CTRB
|
FM_PARENT_TOTAL_INCOME
|
Federal Method Parent Total Income
|
Total income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_INC
|
FM_PARENT_TOTAL_UNTAX_INCOME
|
Federal Method Parent Total Untax Income
|
Total untaxed income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_UNTAX_INC
|
FM_PARENT_WAGE_TAX_PAID
|
Federal Method Parent Wage Tax Paid
|
Amount of wage taxes used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_FICA_TAX
|
FM_PARENT_WORKSHEET_A_TOTAL
|
Federal Method Parent Worksheet A Total
|
Parents' Worksheet A untaxed income total.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_PAR_WORKSHEET_A
|
FM_REAL_ESTATE_EQUITY
|
Federal Method Real Estate Equity
|
Amount of other real estate/investment equity used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_RE_INV_VAL
|
FM_SECOND_TUITION_PAID
|
Federal Method Second Tuition Paid
|
Amount of elementary/secondary school tuition paid that was used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_SCH_TUIT
|
FM_STAND_MAINT_ALLOWANCE
|
Federal Method Stand Maint Allowance
|
Standard maintenance allowance used in the calculation of the student's contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_MNT_ALLOW
|
FM_STATE_PROVINCE_TAX_PAID
|
Federal Method State Province Tax Paid
|
Amount of state or province and other taxes used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_ST_OTH_TAX
|
FM_TAXABLE_INCOME_CONTRIBUTION
|
Federal Method Taxable Income Contribution
|
Taxable income contribution for single independent students for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TAX_INC_CTRB
|
FM_TOTAL_ALLOWANCES
|
Federal Method Total Allowances
|
Amount of total allowances used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_ALLOW
|
FM_TOTAL_CONTRIBUTION
|
Federal Method Total Contribution
|
Total student contribution before the number in college adjustment for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_CTRB
|
FM_TOTAL_FAMILY_CONTRIBUTION
|
Federal Method Total Family Contribution
|
Total family contribution for the federal methodology calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_INST_1_TOT_FAM_CTRB
|
FM_TOTAL_INCOME
|
Federal Method Total Income
|
The total income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_INC
|
FM_TOTAL_UNTAX_INCOME
|
Federal Method Total Untax Income
|
Amount of total untaxed income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_UNTAX_INC
|
FM_VETERAN_BENEFITS_IND
|
Federal Method Veteran Benefits Indicator
|
Indicates if VA benefits have been included in the calculation of the student's primary contribution.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP2_C_1_VA_BEN_INCL)
|
FM_WAGE_TAX_PAID
|
Federal Method Wage Tax Paid
|
Amount of wage taxes used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_FICA_TAX
|
FM_WORKSHEET_A_TOTAL
|
Federal Method Worksheet A Total
|
Student's Worksheet A untaxed income total.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_WORKSHEET_A
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
INTERFACE_TAPE_CODE
|
Interface Tape Code
|
Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_INFC_CODE
|
INTERFACE_TAPE_DESC
|
Interface Tape Description
|
Description of the interface tape code.
|
VARCHAR2(255)
|
RTVINFC
|
RTVINFC_DESC
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
PELL_EFC
|
Pell Effective Family Contribution
|
The primary system Pell PGI.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_PGI
|
PELL_EFC_OFFICIAL
|
Pell Effective Family Contribution Official
|
Indicates if the primary system Pell PGI is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_PGI_OFFL_EST
|
PELL_EFC_OFFICIAL_DESC
|
Pell Effective Family Contribution Official Description
|
Pell PGI official description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) RORMVAL_DESC
|
PELL_EFC_OFFICIAL_ESTIMATE
|
Pell Effective Family Contribution Official Estimate
|
Indicates if the Pell parental contribution amount is official or estimated.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_C_NA_1_PELL_OFFL_EST
|
PELL_EFC_OFFICIAL_EST_DESC
|
Pell Effective Family Contribution Official Est Description
|
Pell EFC official/estimate description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) RORMVAL_DESC
|
PELL_EFFECTIVE_FAMILY_CONT
|
Pell Effective Family Contribution
|
Student Pell effective family contribution.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_PELL_PGI
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_USER_ID
|