Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		RCRAPP2	RCRAPP2_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	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
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to eachuniversity constituent.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
IM_ADJUSTED_AVAILABLE_INCOME	Institution Method 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
IM_ADJUSTED_BUS_NET_WORTH	Institution Method 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
IM_ADJUSTED_GROSS_INCOME	Institution Method 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
IM_ANALYSIS_TYPE	Institution Method Analysis Type	Analysis type used for the Institutional Method student contribution.	VARCHAR2(63)		RCRAPP2	RCRAPP2_IM_1_ANLY_TYPE
IM_ANALYSIS_TYPE_DESC	Institution Method Analysis Type Description	Analysis type description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
IM_ASSET_PROTECT_ALLOWANCE	Institution Method Asset Protect Allowance	Asset protection allowance used in the calculation of the student Institutional Method contribution.	NUMBER		RCRAPP2	RCRAPP2_C_2_PROT_ALLOW
IM_AVAILABLE_INCOME	Institution Method Available Income	Student's available discretionary income for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_AVAIL_DISC_INC
IM_AVAILABLE_TAX_INCOME	Institution Method Available Tax Income	Student's available taxable income for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_AVAIL_TAX_INC
IM_BUDGET_DURATION	Institution Method Budget Duration	Budget duration used for the Institutional Method calculation.	NUMBER		RCRAPP4	RCRAPP4_IM_BUDG_DUR_FOR_CALC
IM_CALC_AVAILABLE_INCOME	Institution Method Calculated Available Income	Student's calculated available income for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CALC_AVAIL_INC
IM_CASH_AMOUNT	Institution Method Cash Amount	Student's amounts in cash, savings and checking accounts used in the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CASH_AMT
IM_CONTRIBUTION	Institution Method Contribution	Primary institutional methodology student contribution.	NUMBER		RCRAPP2	RCRAPP2_IM_1_SC
IM_CONTRIBUTION_AMOUNT	Institution Method Contribution Amount	Student Institutional Method contribution amount.	NUMBER		RCRAPP4	RCRAPP4_C_NA_1_IM_CTRB_STDT
IM_CONTRIBUTION_ASSET	Institution Method Contribution Asset	Student's contribution from assets for the primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CTRB_FR_ASSET
IM_CONTRIBUTION_INCOME	Institution Method Contribution Income	Student's contribution from income for the primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CTRB_FR_INC
IM_CONTRIBUTION_OFFICIAL	Institution Method Contribution Official	Indicates if the Institutional Method student contribution is official or estimated.	VARCHAR2(63)		RCRAPP2	RCRAPP2_C_2_CTRB_OFFL_EST
IM_CONTRIBUTION_OFFICIAL_DESC	Institution Method Contribution Official Description	Description of the Institutional Method student contribution.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)
IM_CONVERSION_PERCENT	Institution Method Conversion Percent	Conversion percent used in the student's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CONV_PCT
IM_CUSTODIAL_PARENT	Institution Method Custodial Parent	Custodial parent used for Institutional Method only calculation of custodial parent's adjustment contribution.	VARCHAR2(63)		RCRAPP4	RCRAPP4_CUSTODIAL_PARENT
IM_CUSTODIAL_PARENT_DESC	Institution Method Custodial Parent Description	Institutional Method custodial parent description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP4_CUSTODIAL_PARENT)
IM_DEPENDENCY_STATUS	Institution Method 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
IM_DEPENDENCY_STATUS_DESC	Institution Method Dependency Status Description	Institutional Method calculated dependency status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
IM_DISCRET_NET_WORTH	Institution Method Discret Net Worth	Student's discretionary net worth used in the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_DISC_NET_WTH
IM_EMPLOYMENT_ALLOWANCE	Institution Method Employment Allowance	Employment allowance used in the calculation of the student Institutional Method contribution.	NUMBER		RCRAPP2	RCRAPP2_C_2_EMP_ALLOW
IM_FEDERAL_TAX_PAID	Institution Method 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
IM_HOME_EQUITY	Institution Method Home Equity	Home equity used in the student's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_HME_VAL
IM_INAS	Institution Method INAS	The student contribution for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_CTRB_FOR_STDT
IM_INCOME_SUPPLEMENT	Institution Method Income Supplement	Amount of the income supplement used in the student's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_INC_SUPPLEMENT
IM_MEDICAL_DENTAL_EXPENSE	Institution Method 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
IM_MONTHLY_OTHER_VET_AMOUNT	Institution Method Monthly Other Vet Amount	Amount per month from other veteran educational benefit programs.	NUMBER		RCRAPP1	RCRAPP1_OTH_VA_AMT
IM_MULTI_ENROLL_ADJUSTED	Institution Method Multi Enrollment 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
IM_NET_WORTH	Institution Method Net Worth	Amount of the student's net worth used in the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_NET_WTH
IM_OTHER_ASSET_ALLOW_OVR	Institution Method 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
IM_OTHER_ASSET_OVR	Institution Method Other Asset Ovr	Amount of the other asset (override) used in the student Institutional Method calculation.	NUMBER		RCRAPP4	RCRAPP4_C_2_OTH_ASSET
IM_OTHER_VET_NUMBER_OF_MONTHS	Institution Method 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
IM_PARENT_ADJUST_GROSS_INCOME	Institution Method Parent Adjustment Gross Income	Adjusted gross taxable income used in the calculation of the secondary parent contribution.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_AGI_TAX_INC
IM_PARENT_ADJ_AVAILABLE_INCOME	Institution Method Parent Adjustment Available Income	Adjusted available income used in the calculation of the Institutional Method parent contribution.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_ADJ_AVAIL_INC
IM_PARENT_ADJ_BUS_NET_WORTH	Institution Method Parent Adjustment 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
IM_PARENT_ANALYSIS_TYPE	Institution Method Parent Analysis Type	Analysis type used for the Institutional Method parent contribution.	VARCHAR2(63)		RCRAPP2	RCRAPP2_IM_1_PAR_ANLY_TYPE
IM_PARENT_ANALYSIS_TYPE_DESC	Institution Method Parent Analysis Type Description	Analysis type description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
IM_PARENT_ASSET_PROT_ALLOWANCE	Institution Method 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
IM_PARENT_AVAILABLE_INCOME	Institution Method Parent Available Income	Parent's available discretionary income for the primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_AVAIL_DISC_INC
IM_PARENT_CASH_AMOUNT	Institution Method 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
IM_PARENT_CONTRIBUTION	Institution Method Parent Contribution	Primary institutional methodology parent contribution.	NUMBER		RCRAPP2	RCRAPP2_IM_1_PC
IM_PARENT_CONTRIBUTION_AMOUNT	Institution Method Parent Contribution Amount	Parent Institutional Method contribution amount.	NUMBER		RCRAPP4	RCRAPP4_C_NA_1_P_IM_CTRB_STDT
IM_PARENT_CONTRIBUTION_ASSET	Institution Method Parent Contribution Asset	Portion of the primary parent contribution that came from income.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_ASSET
IM_PARENT_CONTRIBUTION_INCOME	Institution Method Parent Contribution Income	Portion of the primary parent contribution that came from income.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_INC
IM_PARENT_CONTRIB_OFFICIAL	Institution Method Parent Contribution Official	Indicates if the Institutional Method parent contribution is official or estimated.	VARCHAR2(63)		RCRAPP2	RCRAPP2_C_PAR_2_CTRB_OFFL_EST
IM_PARENT_CONTRIB_OFF_DESC	Institution Method Parent Contribution Off Description	Description of the Institutional Method parent contribution.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)
IM_PARENT_CONVERSION_PERCENT	Institution Method Parent Conversion Percent	Conversion percent used in the parent's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_CONV_PCT
IM_PARENT_DATA_AVAILABLE_IND	Institution Method Parent Data Available Indicator	Indicates whether parent data was available for the Institutional Method calculation.	VARCHAR2(63)		RCRAPP4	RCRAPP4_IM_PAR_DATA_AVAIL
IM_PARENT_DISCRET_NET_WORTH	Institution Method Parent Discret Net Worth	Parent's discretionary net worth used in the primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_DISC_NET_WTH
IM_PARENT_EMPLOYMENT_ALLOWANCE	Institution Method Parent Employment Allowance	Employment allowance used in the Institutional Method calculation of the parent contribution.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_EMP_ALLOW
IM_PARENT_FEDERAL_INCOME_TAX	Institution Method Parent Federal Income Tax	Amount of federal income tax paid by the parent.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_US_INC_TAX
IM_PARENT_HOME_EQUITY	Institution Method Parent Home Equity	Home equity used in the parent's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_HME_VAL
IM_PARENT_INAS	Institution Method Parent INAS	The parent contribution for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FOR_STDT
IM_PARENT_INCOME_SUPPLEMENT	Institution Method Parent Income Supplement	Amount of the income supplement used in the parent's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_INC_SUPPLEMENT
IM_PARENT_MEDICAL_DENTAL_EXP	Institution Method Parent Medical Dental Expiration	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
IM_PARENT_MULTI_ENROLLMENT_ADJ	Institution Method Parent Multi Enrollment Adjustment	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
IM_PARENT_NET_WORTH	Institution Method Parent Net Worth	Amount of the parent's net worth used in the primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_NET_WTH
IM_PARENT_OTH_ASSET_ALLOW_OVR	Institution Method 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
IM_PARENT_REAL_ESTATE_EQUITY	Institution Method 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
IM_PARENT_SECONDARY_TUITION_PD	Institution Method 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
IM_PARENT_STAND_MAINT_ALLOW	Institution Method 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
IM_PARENT_STATE_PROV_TAX_PAID	Institution Method Parent State Province 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
IM_PARENT_TOTAL_ALLOWANCE	Institution Method Parent Total Allowance	Estimated amount of total allowances used in the parent's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_TOT_ALLOW
IM_PARENT_TOTAL_CONTRIBUTION	Institution Method 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
IM_PARENT_TOTAL_INCOME	Institution Method Parent Total Income	Total income used in the calculation of the parent Institutional Method contribution.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_2_TOT_INC
IM_PARENT_TOTAL_UNTAX_INCOME	Institution Method 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
IM_PARENT_WAGE_TAX_PAID	Institution Method 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
IM_REAL_ESTATE_EQUITY	Institution Method 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
IM_SECOND_TUITION_PAID	Institution Method 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
IM_STAND_MAINT_ALLOWANCE	Institution Method Stand Maint Allowance	Standard maintenance allowance used in the Institutional Method calculation of the student's contribution.	NUMBER		RCRAPP2	RCRAPP2_C_2_MNT_ALLOW
IM_STATE_PROVINCE_TAX_PAID	Institution Method 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
IM_TAXABLE_INCOME_CONTRIBUTION	Institution Method Taxable Income Contribution	Taxable income contribution for single independent students for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_TAX_INC_CTRB
IM_TOTAL_ALLOWANCES	Institution Method Total Allowances	Amount of total allowances used in the student's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_TOT_ALLOW
IM_TOTAL_CONTRIBUTION	Institution Method Total Contribution	Total student contribution before the number in college adjustment for the Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_TOT_CTRB
IM_TOTAL_FAMILY_CONTRIBUTION	Institution Method Total Family Contribution	Primary institutional methodology total family contribution.	NUMBER		RCRAPP2	RCRAPP2_IM_1_TFC
IM_TOTAL_INCOME	Institution Method Total Income	The total income used in the student's Institutional Method calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_TOT_INC
IM_TOTAL_UNTAX_INCOME	Institution Method Total Untax Income	Amount of total untaxed income used in the student's primary calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_TOT_UNTAX_INC
IM_TRUST_AMOUNT	Institution Method Trust Amount	Amount of the student trust account used in the student Institutional Method calculation.	NUMBER		RCRAPP4	RCRAPP4_C_2_TRUST_VAL
IM_UNASSESSED_VETERAN_BENEFITS	Institution Method Unassessed Veteran Benefits	Unassessed VA benefits used in the primary Institutional Method student contribution calculation.	NUMBER		RCRAPP2	RCRAPP2_IM_1_UNASSESSED_VA
IM_VETERAN_BENEFITS_IND	Institution Method Veteran Benefits Indicator	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)
IM_WAGE_TAX_PAID	Institution Method Wage Tax Paid	Amount of wage taxes used in the student's IM calculation.	NUMBER		RCRAPP2	RCRAPP2_C_2_FICA_TAX
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
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	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.0