ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACTIVITY_DATE	Date record was inserted or updated			RCRAPP2	RCRAPP2_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).			RCRAPP2	RCRAPP2_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.			FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	Financial aid application unique sequence number.			RCRAPP2	RCRAPP2_SEQ_NO
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.			RCRAPP1	RCRAPP1_CURR_REC_IND
FM_ADJUSTED_AVAIL_INCOME	Student's calculated adjusted available income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_ADJ_AVAIL_INC
FM_ADJUSTED_BUS_NET_WORTH	Amount of business and farm net worth used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_C_1_ADJ_BF_NET_WTH
FM_ADJUSTED_GROSS_INCOME	Student's adjusted gross taxable income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_AGI_TAX_INC
FM_ANALYSIS_TYPE	Analysis type used to determine the primary Student Calculation.			RCRAPP2	RCRAPP2_C_1_ANLY_TYPE
FM_ANALYSIS_TYPE_DESC	Analysis type description.			CALCULATION	DECODE(RCRAPP2_C_1_ANLY_TYPE)
FM_ASSET_PROTECT_ALLOWANCE	Amount of the student's asset protection allowance in the primary calculation.			RCRAPP2	RCRAPP2_C_1_PROT_ALLOW
FM_AVAILABLE_INCOME	Student's available discretionary income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_AVAIL_DISC_INC
FM_AVAILABLE_TAX_INCOME	Student's available taxable income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_AVAIL_TAX_INC
FM_CALC_AVAILABLE_INCOME	Student's calculated available income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_CALC_AVAIL_INC
FM_CASH_AMOUNT	Student's amounts in cash, savings and checking accounts used in the primary calculation.			RCRAPP2	RCRAPP2_C_1_CASH_AMT
FM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.			RCRAPP2	RCRAPP2_C_1_CTRB_FR_ASSET
FM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.			RCRAPP2	RCRAPP2_C_1_CTRB_FR_INC
FM_CONTRIBUTION_OFFICIAL	Indicates if the student contribution for the primary calculation is official or estimated.			RCRAPP2	RCRAPP2_C_1_CTRB_OFFL_EST
FM_CONTRIBUTION_OFFICIAL_AMT	Official student contribution amount.			RCRAPP4	RCRAPP4_C_NA_1_CTRB_FOR_STDT
FM_CONTRIBUTION_OFFICIAL_DESC	Contribution official description.			CALCULATION	DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)
FM_CONVERSION_PERCENT	Conversion percent used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_CONV_PCT
FM_DISCRET_NET_WORTH	Student's discretionary net worth used in the primary calculation.			RCRAPP2	RCRAPP2_C_1_DISC_NET_WTH
FM_EMPLOYMENT_ALLOWANCE	Student's employment allowance used in the primary calculation.			RCRAPP2	RCRAPP2_C_1_EMP_ALLOW
FM_EST_ADJUSTED_BUS_NET_WORTH	Student's adjusted business or farm net worth used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_ADJ_BF_NET_WTH
FM_EST_AGI	Total estimated adjusted gross income used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_AGI_TAX_INC
FM_EST_ASSET_PROT_ALLOWANCE	Student's estimated asset protection allowance used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_PROT_ALLOW
FM_EST_AVAILABLE_INCOME	Student's estimated available discretionary income used in the student's primary calculation.			RCRAPP2	RCRAPP2_PELL_AVAIL_DISC_INC
FM_EST_CASH_AMOUNT	Student's estimated amounts in cash, savings and checking accounts used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_CASH_AMT
FM_EST_CONTRIBUTION_ASSET	Portion of the estimated primary parent contribution that came from assets.			RCRAPP2	RCRAPP2_PELL_CTRB_FR_ASSET
FM_EST_CONTRIBUTION_INCOME	Portion of the estimated primary parent contribution that came from income.			RCRAPP2	RCRAPP2_PELL_CTRB_FR_INC
FM_EST_CONTRIBUTION_OFFICIAL	Indicates if the estimated primary parent contribution is official or estimated.			RCRAPP2	RCRAPP2_PELL_CTRB_OFFL_EST
FM_EST_CONTRIB_OFFICIAL_DESC	Description of the estimated primary parent contribution.			CALCULATION	DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)
FM_EST_CONVERSION_PERCENT	Student's estimated conversion percentage used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_CONV_PCT
FM_EST_DISCRET_NET_WORTH	Student's estimated discretionary net worth used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_DISC_NET_WTH
FM_EST_EMPLOYMENT_ALLOWANCE	Total estimated employment allowance used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_EMP_ALLOW
FM_EST_FAMILY_IN_COLLEGE	Student's estimated family members in college.			RCRAPP2	RCRAPP2_PELL_NO_IN_COLL
FM_EST_FEDERAL_TAX_PAID	Total estimated federal taxes used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_US_INC_TAX
FM_EST_INAS	The student estimated contribution for the primary calculation.			RCRAPP2	RCRAPP2_PELL_CTRB_FOR_STDT
FM_EST_NET_WORTH	Student's estimated net worth used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_NET_WTH
FM_EST_OTHER_ASSET	Amount of the other asset (override) used in the student FM calculation.			RCRAPP4	RCRAPP4_C_1_OTH_ASSET
FM_EST_REAL_ESTATE_EQ	Student's estimated real estate equity used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_RE_INV_VAL
FM_EST_STAND_MAINT_ALLOWANCE	Total estimated standard maintenance allowance used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_MNT_ALLOW
FM_EST_STATE_PROV_TAX_PAID	Total estimated state or province taxes used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_ST_OTH_TAX
FM_EST_TOTAL_ALLOWANCE	Estimated amount of total allowances used in the student's FM calculation.			RCRAPP2	RCRAPP2_PELL_TOT_ALLOW
FM_EST_TOTAL_CONTRIBUTION	Student's estimated total contribution used in the primary calculation.			RCRAPP2	RCRAPP2_PELL_TOT_CTRB
FM_EST_TOTAL_INCOME	Total estimated income used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_TOT_INC
FM_EST_TOTAL_UNTAX_INCOME	Total estimated untaxable income used in the calculation of the primary student contribution.			RCRAPP2	RCRAPP2_PELL_TOT_UNTAX_INC
FM_FAMILY_IN_COLLEGE	Number of people in the student's household that will be in college as used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_NO_IN_COLL
FM_FEDERAL_TAX_PAID	Amount of federal income taxes paid used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_US_INC_TAX
FM_FORMULA	Formula used for the FM calculation.			RCRAPP4	RCRAPP4_FORMULA_FOR_CALC
FM_FORMULA_DESC	FM formula description.			CALCULATION	DECODE(RCRAPP4_FORMULA_FOR_CALC)
FM_HOME_EQUITY	Home equity used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_HME_VAL
FM_INAS	The student contribution for the primary calculation.			RCRAPP2	RCRAPP2_C_1_CTRB_FOR_STDT
FM_INCOME_SUPPLEMENT	Amount of the income supplement used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_INC_SUPPLEMENT
FM_MEDICAL_DENTAL_EXPENSE	Amount of medical and dental expenses used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_MED_DEN_EXP
FM_NET_WORTH	Amount of the student's net worth used in the primary calculation.			RCRAPP2	RCRAPP2_C_1_NET_WTH
FM_PARENT_ADJUST_GROSS_INCOME	The adjusted gross taxable income used in the calculation of the primary parents' contribution.			RCRAPP2	RCRAPP2_C_PAR_1_AGI_TAX_INC
FM_PARENT_ADJ_AVAILABLE_INCOME	Amount of the adjusted available income that was used in the primary calculation of the parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_ADJ_AVAIL_INC
FM_PARENT_ADJ_BUS_NET_WORTH	Adjusted business/farm net worth used in the primary calculation of the parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH
FM_PARENT_ANALYSIS_TYPE	Analysis type used to determine the primary Parent Calculation.			RCRAPP2	RCRAPP2_C_PAR_1_ANLY_TYPE
FM_PARENT_ANALYSIS_TYPE_DESC	Analysis type description.			CALCULATION	DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)
FM_PARENT_ASSET_PROT_ALLOWANCE	Asset protection allowance used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_PROT_ALLOW
FM_PARENT_AVAILABLE_INCOME	Available discretionary income used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_AVAIL_DISC_INC
FM_PARENT_CASH_AMOUNT	Amount of parents' cash, savings and checking accounts used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_CASH_AMT
FM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parent contribution that came from assets.			RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_ASSET
FM_PARENT_CONTRIBUTION_INCOME	Portion of the primary parent contribution that came from income.			RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_INC
FM_PARENT_CONTRIB_OFFICIAL	Indicates if the primary parent contribution is official or estimated.			RCRAPP2	RCRAPP2_C_PAR_1_CTRB_OFFL_EST
FM_PARENT_CONTRIB_OFFICIAL_AMT	Official parent contribution amount.			RCRAPP4	RCRAPP4_C_NA_1_P_CTRB_FOR_STDT
FM_PARENT_CONTRIB_OFFICIAL_EST	Indicates if the parental contribution amount is official or estimated.			RCRAPP4	RCRAPP4_C_NA_1_P_CTRB_OFFL_EST
FM_PARENT_CONTRIB_OFF_DESC	Description of the primary parent contribution.			CALCULATION	DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)
FM_PARENT_CONTRIB_OFF_EST_DESC	Parent contribution official/estimate description.			CALCULATION	DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)
FM_PARENT_CONVERSION_PERCENT	Discretionary net worth conversion percent used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_CONV_PCT
FM_PARENT_DATA_AVAILABLE_IND	Indicates whether parent data was available for the FM calculation.			RCRAPP4	RCRAPP4_FM_PAR_DATA_AVAIL
FM_PARENT_DISCRET_NET_WORTH	Discretionary net worth used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_DISC_NET_WTH
FM_PARENT_EMPLOYMENT_ALLOWANCE	Employment allowance used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_EMP_ALLOW
FM_PARENT_EST_AGI	The estimated adjusted gross taxable income used in the calculation of the primary parents' contribution.			RCRAPP2	RCRAPP2_PELL_P_AGI_TAX_INC
FM_PARENT_EST_ANALYSIS_TYPE	Analysis type for the primary system PGI.			RCRAPP2	RCRAPP2_PELL_P_ANLY_TYPE
FM_PARENT_EST_ANAL_TYPE_DESC	Analysis type description.			CALCULATION	DECODE(RCRAPP2_PELL_P_ANLY_TYPE)
FM_PARENT_EST_FEDERAL_TAX_PAID	Amount of estimated federal taxes used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_PELL_P_US_INC_TAX
FM_PARENT_EST_INCOME_ADJUST	Amount of the income adjustment used in the parent FM calculation.			RCRAPP4	RCRAPP4_C_PAR_1_INC_ADJ
FM_PARENT_EST_OTHER_ASSET	Amount of the other asset (override) used in the parent FM calculation.			RCRAPP4	RCRAPP4_C_PAR_1_OTH_ASSET
FM_PARENT_EST_OTH_INCOME_ALLOW	Amount of the other income allowance (override) used in the parent FM calculation.			RCRAPP4	RCRAPP4_C_PAR_1_OTH_ALLOW
FM_PARENT_EST_STAT_PROV_TAX_PD	Amount of estimated state_province taxes used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_PELL_P_ST_OTH_TAX
FM_PARENT_EST_TOTAL_INCOME	Total estimated income used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_PELL_P_TOT_INC
FM_PARENT_EST_TOT_UNTAX_INCOME	The estimated total untaxed income used in the calculation of the primary parent's contribution.			RCRAPP2	RCRAPP2_PELL_P_TOT_UNTAX_INC
FM_PARENT_FEDERAL_TAX_PAID	Amount of US income taxes paid used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_US_INC_TAX
FM_PARENT_HOME_EQUITY	Home equity used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_HME_VAL
FM_PARENT_INAS	Primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FOR_STDT
FM_PARENT_INCOME_SUPPLEMENT	Income supplement used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_INC_SUPPLEMENT
FM_PARENT_MEDICAL_DENTAL_EXP	Amount of medical and dental expenses used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_MED_DEN_EXP
FM_PARENT_NET_WORTH	Net worth used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_NET_WTH
FM_PARENT_REAL_ESTATE_EQUITY	Other real estate and investment equity used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_RE_INV_VAL
FM_PARENT_SECONDARY_TUITION_PD	Amount of elementary and secondary school tuition paid used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_SCH_TUIT
FM_PARENT_STAND_MAINT_ALLOW	Standard maintenance allowance used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_MNT_ALLOW
FM_PARENT_STATE_PROV_TAX_PAID	Amount of state and other taxes paid used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_ST_OTH_TAX
FM_PARENT_TOTAL_ALLOWANCES	Total allowances used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_TOT_ALLOW
FM_PARENT_TOTAL_CONTRIBUTION	Total primary parent contribution before adjustment for the number of family members in college.			RCRAPP2	RCRAPP2_C_PAR_1_TOT_CTRB
FM_PARENT_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_TOT_INC
FM_PARENT_TOTAL_UNTAX_INCOME	Total untaxed income used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_TOT_UNTAX_INC
FM_PARENT_WAGE_TAX_PAID	Amount of wage taxes used in the calculation of the primary parent contribution.			RCRAPP2	RCRAPP2_C_PAR_1_FICA_TAX
FM_PARENT_WORKSHEET_A_TOTAL	Parents' Worksheet A untaxed income total.			RCRAPP4	RCRAPP4_PAR_WORKSHEET_A
FM_REAL_ESTATE_EQUITY	Amount of other real estate/investment equity used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_RE_INV_VAL
FM_SECOND_TUITION_PAID	Amount of elementary/secondary school tuition paid that was used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_SCH_TUIT
FM_STAND_MAINT_ALLOWANCE	Standard maintenance allowance used in the calculation of the student's contribution.			RCRAPP2	RCRAPP2_C_1_MNT_ALLOW
FM_STATE_PROVINCE_TAX_PAID	Amount of state or province and other taxes used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_ST_OTH_TAX
FM_TAXABLE_INCOME_CONTRIBUTION	Taxable income contribution for single independent students for the primary calculation.			RCRAPP2	RCRAPP2_C_1_TAX_INC_CTRB
FM_TOTAL_ALLOWANCES	Amount of total allowances used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_TOT_ALLOW
FM_TOTAL_CONTRIBUTION	Total student contribution before the number in college adjustment for the primary calculation.			RCRAPP2	RCRAPP2_C_1_TOT_CTRB
FM_TOTAL_FAMILY_CONTRIBUTION	Total family contribution for the federal methodology calculation.			RCRAPP4	RCRAPP4_C_INST_1_TOT_FAM_CTRB
FM_TOTAL_INCOME	The total income used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_TOT_INC
FM_TOTAL_UNTAX_INCOME	Amount of total untaxed income used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_TOT_UNTAX_INC
FM_VETERAN_BENEFITS_IND	Indicates if VA benefits have been included in the calculation of the student's primary contribution.			CALCULATION	DECODE(RCRAPP2_C_1_VA_BEN_INCL)
FM_WAGE_TAX_PAID	Amount of wage taxes used in the student's primary calculation.			RCRAPP2	RCRAPP2_C_1_FICA_TAX
FM_WORKSHEET_A_TOTAL	Student's Worksheet A untaxed income total.			RCRAPP4	RCRAPP4_WORKSHEET_A
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).			RCRAPP2	RCRAPP2_INFC_CODE
INTERFACE_TAPE_DESC	Description of the interface tape code.			RTVINFC	RTVINFC_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PELL_EFC	The primary system Pell PGI.			RCRAPP2	RCRAPP2_PELL_PGI
PELL_EFC_OFFICIAL	Indicates if the primary system Pell PGI is official or estimated.			RCRAPP2	RCRAPP2_PELL_PGI_OFFL_EST
PELL_EFC_OFFICIAL_DESC	Pell PGI official description.			CALCULATION	DECODE(RCRAPP2_PELL_PGI_OFFL_EST)
PELL_EFC_OFFICIAL_ESTIMATE	Indicates if the Pell parental contribution amount is official or estimated.			RCRAPP4	RCRAPP4_C_NA_1_PELL_OFFL_EST
PELL_EFC_OFFICIAL_EST_DESC	Pell EFC official/estimate description.			CALCULATION	DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)
PELL_EFFECTIVE_FAMILY_CONT	Student Pell effective family contribution.			RCRAPP4	RCRAPP4_C_NA_1_PELL_PGI
PERSON_UID	System generated, unique, internal identification number assigned to this person.			RCRAPP2	RCRAPP2_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
USER_ID	Unique identification code of the user who entered or last touched the transaction.			RCRAPP2	RCRAPP2_USER_ID

Ver: 8.3