Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RCRAPP2	RCRAPP2_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP2	RCRAPP2_SEQ_NO	NO	NO
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND	NO	NO
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	NO	NO
IM_ADJUSTED_AVAILABLE_INCOME	Amount of the adjusted available income that was used in the Institutional Method calculation of the student contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_ADJ_AVAIL_INC	NO	NO
IM_ADJUSTED_BUS_NET_WORTH	Amount of business and farm net worth used in the calculation of the Institutional Method student contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_ADJ_BF_NET_WTH	NO	NO
IM_ADJUSTED_GROSS_INCOME	Adjusted gross taxable income used in the calculation of the Institutional Method student contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_AGI_TAX_INC	NO	NO
IM_ANALYSIS_TYPE	Analysis type used for the Institutional Method student contribution.	VARCHAR2(63)	RCRAPP2	RCRAPP2_IM_1_ANLY_TYPE	NO	NO
IM_ANALYSIS_TYPE_DESC	Analysis type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IM_ASSET_PROTECT_ALLOWANCE	Asset protection allowance used in the calculation of the student Institutional Method contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_PROT_ALLOW	NO	NO
IM_AVAILABLE_INCOME	Student's available discretionary income for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_AVAIL_DISC_INC	NO	NO
IM_AVAILABLE_TAX_INCOME	Student's available taxable income for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_AVAIL_TAX_INC	NO	NO
IM_BUDGET_DURATION	Budget duration used for the Institutional Method calculation.	NUMBER	RCRAPP4	RCRAPP4_IM_BUDG_DUR_FOR_CALC	NO	NO
IM_CALC_AVAILABLE_INCOME	Student's calculated available income for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CALC_AVAIL_INC	NO	NO
IM_CASH_AMOUNT	Student's amounts in cash, savings and checking accounts used in the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CASH_AMT	NO	NO
IM_CONTRIBUTION	Primary institutional methodology student contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_SC	NO	NO
IM_CONTRIBUTION_AMOUNT	Student Institutional Method contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_IM_CTRB_STDT	NO	NO
IM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_ASSET	NO	NO
IM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_INC	NO	NO
IM_CONTRIBUTION_OFFICIAL	Indicates if the Institutional Method student contribution is official or estimated.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_2_CTRB_OFFL_EST	NO	NO
IM_CONTRIBUTION_OFFICIAL_DESC	Description of the Institutional Method student contribution.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)	NO	NO
IM_CONVERSION_PERCENT	Conversion percent used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CONV_PCT	NO	NO
IM_CUSTODIAL_PARENT	Custodial parent used for Institutional Method only calculation of custodial parent's adjustment contribution.	VARCHAR2(63)	RCRAPP4	RCRAPP4_CUSTODIAL_PARENT	NO	NO
IM_CUSTODIAL_PARENT_DESC	Institutional Method custodial parent description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_CUSTODIAL_PARENT)	NO	NO
IM_DEPENDENCY_STATUS	Calculated Institutional Method dependency status. This may be different than the EFM or Federal Method values.	VARCHAR2(63)	RCRAPP4	RCRAPP4_IM_FORMULA_FOR_CALC	NO	NO
IM_DEPENDENCY_STATUS_DESC	Institutional Method calculated dependency status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IM_DISCRET_NET_WORTH	Student's discretionary net worth used in the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_DISC_NET_WTH	NO	NO
IM_EMPLOYMENT_ALLOWANCE	Employment allowance used in the calculation of the student Institutional Method contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_EMP_ALLOW	NO	NO
IM_FEDERAL_TAX_PAID	Amount of federal income taxes paid used in the calculation of the Institutional Method student contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_US_INC_TAX	NO	NO
IM_HOME_EQUITY	Home equity used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_HME_VAL	NO	NO
IM_INAS	The student contribution for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FOR_STDT	NO	NO
IM_INCOME_SUPPLEMENT	Amount of the income supplement used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_INC_SUPPLEMENT	NO	NO
IM_MEDICAL_DENTAL_EXPENSE	Amount of medical or dental expenses used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_MED_DEN_EXP	NO	NO
IM_MONTHLY_OTHER_VET_AMOUNT	Amount per month from other veteran educational benefit programs.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_AMT	NO	NO
IM_MULTI_ENROLL_ADJUSTED	Percentage of adjustment to the student contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC.	NUMBER	RCRAPP2	RCRAPP2_C_2_NO_IN_COLL	NO	NO
IM_NET_WORTH	Amount of the student's net worth used in the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_NET_WTH	NO	NO
IM_OTHER_ASSET_ALLOW_OVR	Amount of the other asset allowance (override) used in the student Institutional Method calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_OTH_ASSET_ALLOW	NO	NO
IM_OTHER_ASSET_OVR	Amount of the other asset (override) used in the student Institutional Method calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_OTH_ASSET	NO	NO
IM_OTHER_VET_NUMBER_OF_MONTHS	Number of months that the other veteran educational benefits will be received during the award year.	NUMBER	RCRAPP1	RCRAPP1_OTH_VA_MTH	NO	NO
IM_PARENT_ADJUST_GROSS_INCOME	Adjusted gross taxable income used in the calculation of the secondary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_AGI_TAX_INC	NO	NO
IM_PARENT_ADJ_AVAILABLE_INCOME	Adjusted available income used in the calculation of the Institutional Method parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_ADJ_AVAIL_INC	NO	NO
IM_PARENT_ADJ_BUS_NET_WORTH	Amount of business and farm net worth used in the calculation of the secondary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH	NO	NO
IM_PARENT_ANALYSIS_TYPE	Analysis type used for the Institutional Method parent contribution.	VARCHAR2(63)	RCRAPP2	RCRAPP2_IM_1_PAR_ANLY_TYPE	NO	NO
IM_PARENT_ANALYSIS_TYPE_DESC	Analysis type description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
IM_PARENT_ASSET_PROT_ALLOWANCE	Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_PROT_ALLOW	NO	NO
IM_PARENT_AVAILABLE_INCOME	Parent's available discretionary income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_AVAIL_DISC_INC	NO	NO
IM_PARENT_CASH_AMOUNT	Parent's estimated amounts in cash, savings and checking accounts used in the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CASH_AMT	NO	NO
IM_PARENT_CONTRIBUTION	Primary institutional methodology parent contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_PC	NO	NO
IM_PARENT_CONTRIBUTION_AMOUNT	Parent Institutional Method contribution amount.	NUMBER	RCRAPP4	RCRAPP4_C_NA_1_P_IM_CTRB_STDT	NO	NO
IM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_ASSET	NO	NO
IM_PARENT_CONTRIBUTION_INCOME	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_INC	NO	NO
IM_PARENT_CONTRIB_OFFICIAL	Indicates if the Institutional Method parent contribution is official or estimated.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_OFFL_EST	NO	NO
IM_PARENT_CONTRIB_OFF_DESC	Description of the Institutional Method parent contribution.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)	NO	NO
IM_PARENT_CONVERSION_PERCENT	Conversion percent used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CONV_PCT	NO	NO
IM_PARENT_DATA_AVAILABLE_IND	Indicates whether parent data was available for the Institutional Method calculation.	VARCHAR2(63)	RCRAPP4	RCRAPP4_IM_PAR_DATA_AVAIL	NO	NO
IM_PARENT_DISCRET_NET_WORTH	Parent's discretionary net worth used in the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_DISC_NET_WTH	NO	NO
IM_PARENT_EMPLOYMENT_ALLOWANCE	Employment allowance used in the Institutional Method calculation of the parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_EMP_ALLOW	NO	NO
IM_PARENT_FEDERAL_INCOME_TAX	Amount of federal income tax paid by the parent.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_US_INC_TAX	NO	NO
IM_PARENT_HOME_EQUITY	Home equity used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_HME_VAL	NO	NO
IM_PARENT_INAS	The parent contribution for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FOR_STDT	NO	NO
IM_PARENT_INCOME_SUPPLEMENT	Amount of the income supplement used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_INC_SUPPLEMENT	NO	NO
IM_PARENT_MEDICAL_DENTAL_EXP	Amount of medical and dental expenses used in the Institutional Method calculation of the parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_MED_DEN_EXP	NO	NO
IM_PARENT_MULTI_ENROLLMENT_ADJ	Percentage of adjustment to the parent contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_NO_IN_COLL	NO	NO
IM_PARENT_NET_WORTH	Amount of the parent's net worth used in the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_NET_WTH	NO	NO
IM_PARENT_OTH_ASSET_ALLOW_OVR	Amount of the other asset allowance (override) used in the parent Institutional Method calculation.	NUMBER	RCRAPP4	RCRAPP4_C_PAR_2_OTH_ASSET_ALLW	NO	NO
IM_PARENT_REAL_ESTATE_EQUITY	Amount of other real estate/investment equity used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_RE_INV_VAL	NO	NO
IM_PARENT_SECONDARY_TUITION_PD	The amount of elementary, jr. high, and high school tuition paid by the student's secondary parent contributor in the base year.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_SCH_TUIT	NO	NO
IM_PARENT_STAND_MAINT_ALLOW	Standard maintenance allownace used in the Institutional Method calculation of the parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_MNT_ALLOW	NO	NO
IM_PARENT_STATE_PROV_TAX_PAID	Amount of state and other taxes paid used in the Institutional Method calculation of the parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_ST_OTH_TAX	NO	NO
IM_PARENT_TOTAL_ALLOWANCE	Estimated amount of total allowances used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_ALLOW	NO	NO
IM_PARENT_TOTAL_CONTRIBUTION	Total parent contribution before the number in college adjustment for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_CTRB	NO	NO
IM_PARENT_TOTAL_INCOME	Total income used in the calculation of the parent Institutional Method contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_INC	NO	NO
IM_PARENT_TOTAL_UNTAX_INCOME	Amount of total untaxed income used in the parent's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_UNTAX_INC	NO	NO
IM_PARENT_WAGE_TAX_PAID	Amount of wage taxes used in the Institutional Method calculation of the parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_FICA_TAX	NO	NO
IM_REAL_ESTATE_EQUITY	Amount of other real estate/investment equity used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_RE_INV_VAL	NO	NO
IM_SECOND_TUITION_PAID	Amount of elementary/secondary school tuition paid that was used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_SCH_TUIT	NO	NO
IM_STAND_MAINT_ALLOWANCE	Standard maintenance allowance used in the Institutional Method calculation of the student's contribution.	NUMBER	RCRAPP2	RCRAPP2_C_2_MNT_ALLOW	NO	NO
IM_STATE_PROVINCE_TAX_PAID	Amount of state or province and other taxes used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_ST_OTH_TAX	NO	NO
IM_TAXABLE_INCOME_CONTRIBUTION	Taxable income contribution for single independent students for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TAX_INC_CTRB	NO	NO
IM_TOTAL_ALLOWANCES	Amount of total allowances used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_ALLOW	NO	NO
IM_TOTAL_CONTRIBUTION	Total student contribution before the number in college adjustment for the Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_CTRB	NO	NO
IM_TOTAL_FAMILY_CONTRIBUTION	Primary institutional methodology total family contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_TFC	NO	NO
IM_TOTAL_INCOME	The total income used in the student's Institutional Method calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_INC	NO	NO
IM_TOTAL_UNTAX_INCOME	Amount of total untaxed income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_UNTAX_INC	NO	NO
IM_TRUST_AMOUNT	Amount of the student trust account used in the student Institutional Method calculation.	NUMBER	RCRAPP4	RCRAPP4_C_2_TRUST_VAL	NO	NO
IM_UNASSESSED_VETERAN_BENEFITS	Unassessed VA benefits used in the primary Institutional Method student contribution calculation.	NUMBER	RCRAPP2	RCRAPP2_IM_1_UNASSESSED_VA	NO	NO
IM_VETERAN_BENEFITS_IND	Indicates if VA benefits have been included in the calculation of the student's Institutional Method contribution.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP2_C_2_VA_BEN_INCL)	NO	NO
IM_WAGE_TAX_PAID	Amount of wage taxes used in the student's IM calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_FICA_TAX	NO	NO
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	NO	NO
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP2	RCRAPP2_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP2	RCRAPP2_USER_ID	NO	NO

Ver: 9.2