Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS_FEDERAL_METHOD

Description Contains information specific to the federal methodology for computing applicant need.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.
Recommended Search Columns AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND

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



Ver: 9.2