Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated	DATE	RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADJUSTED_GROSS_INCOME	Amount of AGI in the base year reported by the student on his/her federal tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_YEAR	Aid year associated with this record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
APPLICATION_NUMBER	Financial aid application unique sequence number.	NUMBER	RCRAPP1	RCRAPP1_SEQ_NO
BUSINESS_DEBT	Amount of the student's outstanding debts against business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_DBT
BUSINESS_VALUE	Current market value of the student's business and farm assets.	NUMBER	RCRAPP1	RCRAPP1_BUS_FARM_VAL
CASH_SAVINGS	Amount the student currently has in cash on hand and in savings and checking accounts.	NUMBER	RCRAPP1	RCRAPP1_CASH_AMT
CHILD_CARE_NUMBER	Number of dependent children for whom the student will pay child care expenses.	NUMBER	RCRAPP3	RCRAPP3_CHILD_CARE
COLLEGE	College code identifying the school to which this financial aid applicant record has applied.	VARCHAR2(63)	RCRAPP1	RCRAPP1_COLL_CDE
CURRENT_RECORD_IND	Specifies that this is the current need analysis record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_CURR_REC_IND
DEGREE_TYPE	Contains the abbreviation of the degree or certificate a student is pursuing.	VARCHAR2(63)	RCRAPP3	RCRAPP3_DEGREE_TYPE
DEGREE_TYPE_DESC	Degree type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)
DEPENDENCY_INDEPEND	Code that indicates if the student is independent or dependent.	VARCHAR2(63)	RCRAPP2	RCRAPP2_MODEL_CDE
DEPENDENCY_INDEPEND_DESC	Depend independ code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
DEPENDENCY_OVERRIDE	Used by the financial aid administrator to override dependency.	VARCHAR2(63)	RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency override description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_FAA_DEP_OVERRIDE)
DEPENDENCY_STATUS	Indicates the students dependency status as computed by INAS or loaded from the tape record.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_DEPEND_STATUS
DEPENDENCY_STATUS_DESC	Students dependency status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_DEPEND_STATUS)
DRIVER_LICENSE_NUMBER	Student's drivers license number.	VARCHAR2(63)	RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	State or province that issued the student's drivers license.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_LIC
DRIVER_LICENSE_STATE_PROV_DESC	Description of the state or province in which the student holds a drivers license.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
EMAIL_ADDRESS	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)	RCRAPP4	RCRAPP4_EMAIL_ADDRESS
ENROLLMENT_PLANNING_SERVICE	Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research.	VARCHAR2(63)	RCRAPP2	RCRAPP2_EPS_CDE
ENROLLMENT_PLANNING_SERV_DESC	Enrollment planning service description.	VARCHAR2(255)	STVEPSC	STVEPSC_DESC
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_EXP_ENROLL_STATUS
EXPECTED_ENROLL_STATUS_DESC	Description of the student's expected enrollment status.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_EXP_ENROLL_STATUS)
FAMILY_IN_COLLEGE	Total number of family members in the student's household that attend college at least half time.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
FAMILY_SIZE	Number of people in the student's household during the school year.	NUMBER	CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
FATHER_HIGHEST_GRADE	Highest grade level completed by the father	VARCHAR2(63)	RCRAPP3	RCRAPP3_FATHER_HI_GRADE
FATHER_WORK_INCOME	Amount of income earned from work by the student's father in the base year.	NUMBER	RCRAPP1	RCRAPP1_FATH_INC_FR_WRK
FM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FR_ASSET
FM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FR_INC
FM_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_DESC	Contribution official description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)
FM_INAS	Student contribution for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_CTRB_FOR_STDT
FM_PARENT_CONTRIBUTION_ASSET	Portion of the primary parents contribution that came from assets.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_ASSET
FM_PARENT_CONTRIBUTION_INCOME	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FR_INC
FM_PARENT_INAS	Primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_FOR_STDT
FM_PARENT_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_1_TOT_INC
FM_PARENT_WORKSHEET_A_TOTAL	Parents' Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_A
FM_TOTAL_FAMILY_CONTRIBUTION	Primary federal methodology total family contribution.	NUMBER	RCRAPP4	RCRAPP4_C_INST_1_TOT_FAM_CTRB
FM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_1_TOT_INC
FM_WORKSHEET_A_TOTAL	Student's Worksheet A untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_A
GRADUATE_PROFESSIONAL_IND	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
HOME_DEBT	Student's current outstanding debts against the home.	NUMBER	RCRAPP1	RCRAPP1_HME_DBT
HOME_VALUE	Current market value of the student's home.	NUMBER	RCRAPP1	RCRAPP1_HME_VAL
HOUSING	Housing code reported by the student applicant for the school that is receiving this application record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_INST_HOUS_CDE
HOUSING_DESC	Institutional housing code description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_INST_HOUS_CDE)
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
IM_CONTRIBUTION	Institutional methodology calculated value for the student contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_SC
IM_CONTRIBUTION_ASSET	Student's contribution from assets for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_ASSET
IM_CONTRIBUTION_INCOME	Student's contribution from income for the primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_CTRB_FR_INC
IM_PARENT_CONTRIBUTION	Institutional methodology calculated value for the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_PC
IM_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	Portion of the primary parent contribution that came from income.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_CTRB_FR_INC
IM_PARENT_CONTRIB_OFFICIAL	Indicates if the primary parent contribution is official or estimated.	VARCHAR2(63)	RCRAPP2	RCRAPP2_C_PAR_1_CTRB_OFFL_EST
IM_PARENT_CONTRIB_OFF_DESC	Description of the primary parent contribution.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP2_C_PAR_1_CTRB_OFFL_EST)
IM_PARENT_TOTAL_INCOME	Total income used in the calculation of the primary parent contribution.	NUMBER	RCRAPP2	RCRAPP2_C_PAR_2_TOT_INC
IM_TOTAL_FAMILY_CONTRIBUTION	Primary institutional methodology for calculation of total family contribution.	NUMBER	RCRAPP2	RCRAPP2_IM_1_TFC
IM_TOTAL_INCOME	Total income used in the student's primary calculation.	NUMBER	RCRAPP2	RCRAPP2_C_2_TOT_INC
INAS_TFC	Total family contribution.	NUMBER	CALCULATION	LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)
INCOME_TAX_PAID	Amount of federal income taxes paid by the student in the base year as reported on the student's income tax return.	NUMBER	RCRAPP1	RCRAPP1_US_INC_TAX_PD
INCOME_WORK	Amount of the student's base year income from working.	NUMBER	RCRAPP1	RCRAPP1_INC_FR_WRK
INTERFACE_TAPE_CODE	Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).	VARCHAR2(63)	RCRAPP1	RCRAPP1_INFC_CODE
INTERFACE_TAPE_DESC	Description of the interface tape code.	VARCHAR2(255)	RTVINFC	RTVINFC_DESC
MARITAL_STATUS_IND	Indicates whether or not a student is married.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_MARRIED)
MOTHER_HIGHEST_GRADE	Highest grade level completed by the mother	VARCHAR2(63)	RCRAPP3	RCRAPP3_MOTHER_HI_GRADE
MOTHER_WORK_INCOME	Mother's reported base year income from work.	NUMBER	RCRAPP1	RCRAPP1_MOTH_INC_FR_WRK
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_SOURCE_IND	Official or unofficial indicator.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
PARENT_ADJUSTED_GROSS_INCOME	Amount of the AGI in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC
PARENT_CHILD_SUPPORT_PAID	Amount paid for child support by the parents.	NUMBER	RCRAPP3	RCRAPP3_PAR_CHILD_SUPP_PAID
PARENT_FAMILY_IN_COLLEGE	Number of people in the parents household that will be enrolled in college at least half-time.	NUMBER	RCRAPP1	RCRAPP1_PAR_NO_IN_COLL
PARENT_FAMILY_SIZE	Number of family members in the parents household.	NUMBER	RCRAPP1	RCRAPP1_PAR_FAM_MEMB
PARENT_INCOME_TAX_PAID	Amount of federal income taxes paid in the base year reported by the student's parents on their federal tax return.	NUMBER	RCRAPP1	RCRAPP1_PAR_US_INC_TAX_PD
PARENT_SHORT_TAX_FORM_IND	Indicates whether the parent is eligible to file a federal short tax form.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_PAR_1040A_ELIG_IND)
PARENT_STATE_OF_RESIDENCE	State or province of legal residence for the student's parents.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_STAT_CODE_RES
PARENT_STATE_OF_RESIDENCE_DESC	Parents stare or province of legal residence description.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
PARENT_TAX_RETURN_FILED	Indicates whether the parent has already filed, will file or will not file a tax return.	VARCHAR2(63)	RCRAPP4	RCRAPP4_PAR_TX_RET_FILED_IND
PARENT_TAX_RETURN_FILED_DESC	Parent tax return filed dscription.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_PAR_TAX_RET_FILED_IND)
PARENT_TAX_RETURN_TYPE	Type of federal income tax return form the student's parents filed.	VARCHAR2(63)	RCRAPP1	RCRAPP1_PAR_TAX_FORM_IND
PARENT_TAX_RETURN_TYPE_DESC	Parent tax return type description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_PAR_TAX_FORM_IND)
PARENT_WORKSHEET_B_TOTAL	Parents' Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_B
PARENT_WORKSHEET_C_TOTAL	Parent's total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_PAR_WORKSHEET_C
PELL_EFC	Primary system Pell PGI.	NUMBER	RCRAPP2	RCRAPP2_PELL_PGI
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RCRAPP1	RCRAPP1_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REJECTION_OVERRIDE2_IND	Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_2
REJECTION_OVERRIDE3_IND	Set to 'Y' by the electronic application user to override rejection 3: Student's taxes paid are greater than zero and equal to or greater than AGI.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_3
REJECTION_OVERRIDE5_IND	Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_5
REJECTION_OVERRIDE7_IND	Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_7
REJECTION_OVERRIDE_B_IND	Indicates if Reject B override accepted - Independent status in question because of student's age.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_1
REJECTION_OVERRIDE_N_IND	Set by electronic application user to override reject N: Missing first or last name.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_4
REJECTION_OVERRIDE_W_IND	Set by electronic application user to override reject W: Questionable number of family members, greater than 15.	VARCHAR2(63)	RCRAPP3	RCRAPP3_REJECT_OVRD_6
SAR_C_IND	Eligibility status message that is the result of data base matches indicating further investigation by the aid administrator needed.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP2_ELIGIBILITY_MSG)
SAR_EFC	Identifies what the SAR EFC was for a person when they were added in data load.	NUMBER	RCRAPP4	RCRAPP4_SAR_EFC
SELECTED_FOR_VERIFICATION_IND	Indicates whether the student has been selected for verification by the department of education edits or by the institution.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_MSG
SHORT_TAX_FORM_IND	Indicates whether the student is eligible to file a federal short tax form.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_1040A_ELIG_IND)
SPOUSE_INCOME_WORK	Amount of income earned from work by the student's spouse in the base year.	NUMBER	RCRAPP1	RCRAPP1_SPS_INC_FR_WRK
STATE_OF_RESIDENCE	Student's state of legal residence.	VARCHAR2(63)	RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	Name of the student's state, province of legal residence.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SUPPORT_CHILDREN_IND	Student has children who receive more than half of their support from him/her.	VARCHAR2(63)	CALCULATION	DECODE(RCRAPP4_HAVE_CHILDREN)
TAX_ID	Person's tax identification number assigned by their home federal government.	VARCHAR2(63)	RCRAPP1	RCRAPP1_SSN
TAX_ID_MATCH_STATUS	Tax ID match status.	VARCHAR2(63)	RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID match status description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP3_SOC_SEC)
TAX_RETURN_FILED	Indicates whether the student has already filed, will file or will not file a tax return.	VARCHAR2(63)	RCRAPP4	RCRAPP4_TX_RET_FILED_IND
TAX_RETURN_FILED_DESC	Student tax return filed description.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP4_TX_RET_FILED_IND)
TAX_RETURN_TYPE	Indicates which type of federal tax return the student filed (or will file) and whether or not the income data is estimated.	VARCHAR2(63)	RCRAPP1	RCRAPP1_TAX_FORM_IND
TAX_RETURN_TYPE_DESC	Description of the tax return type.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_TAX_FORM_IND)
TRANSACTION_NUMBER	The one up sequence number assigned by the Central Processing System to this application/correction record.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USED_TRANS_NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_PRIORITY	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)	RCRAPP1	RCRAPP1_VERIFICATION_PRTY
WORKSHEET_B_TOTAL	Student's Worksheet B untaxed income total.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_B
WORKSHEET_C_TOTAL	Student and spouse total amount from Worksheet C.	NUMBER	RCRAPP4	RCRAPP4_WORKSHEET_C
YEAR_IN_COLLEGE	Year of study (first, second, etc.) that the student enrolls in this year.	VARCHAR2(63)	RCRAPP1	RCRAPP1_YR_IN_COLL
YEAR_IN_COLLEGE_DESC	Description of the year of studty.	VARCHAR2(255)	CALCULATION	DECODE(RCRAPP1_YR_IN_COLL)

Ver: 8.1