Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_YEAR	Academic Year	The last two digits of the first year for the academic year being processed. EXAMPLE: '90' for the 1990-91 academic year.	VARCHAR2(63)		RCRAPP1	RCRAPP1_ACYR_CODE
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		RCRAPP1	RCRAPP1_ACTIVITY_DATE
ADDRESS_CHANGE	Address Change	Address Only Change Flag	VARCHAR2(63)		RCRAPP4	RCRAPP4_ADDRESS_CHG_FLAG
ADDRESS_CHANGE_DESC	Address Change Description	Address Only Change Flag description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP4_ADDRESS_CHG_FLAG)
ADJUSTED_EFC_CALC_REQUEST	Adjusted Effective Family Contribution Calculated Request	Contains a request to calculate the adjusted Effective Family Contribution.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ADJ_EFC_CALC_REQ
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
AGE_OLDER_PARENT	Age Older Parent	Age of the older parent.	NUMBER		RCRAPP1	RCRAPP1_PAR_OLDER_AGE
AID_ELIGIBILITY_RESPONSE	Financial Aid Eligibility Response	Drug Offense Conviction indicated.	VARCHAR2(63)		RCRAPP4	RCRAPP4_DRUG_OFFENSE_CONVIC
AID_ELIGIBILITY_RESPONSE_DESC	Financial Aid Eligibility Response Description	Aid eligibility response description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
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)		RCRAPP1	RCRAPP1_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ALIEN_REGISTRATION_NUMBER	Alien Registration Number	Number assigned by the federal government to all eligible permanent resident non-citizens.	VARCHAR2(63)		RCRAPP1	RCRAPP1_ALIEN_REG_NO
APPLICATION_CREATE_DATE	Application Create Date	The date that this application record was created on the database, either manually or through dataload.	DATE		RCRAPP2	RCRAPP1_CREATE_DATE
APPLICATION_NUMBER	Application Number	Financial aid application unique sequence number.	NUMBER		RCRAPP1	RCRAPP1_SEQ_NO
APPLICATION_RECEIPT_DATE	Application Receipt Date	Date that the processor received the aid application.	DATE		RCRAPP1	RCRAPP1_RCPT_DATE
APPLICATION_REVISION_RCPT_DATE	Application Revision Rcpt Date	Date that the processor received a request for revisions from the student.	DATE		RCRAPP1	RCRAPP1_REV_RCPT_DATE
APPLICATION_SIGNED_BY	Application Signed By	Indicates if the application was signed by the student and/or the parent(s).	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_SIGNED)
APPLICATION_SIGNED_BY_DESC	Application Signed By Description	Application signed description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP1_SIGNED)
APPLICATION_TYPE	Application Type	Indicates the type (regular or renewal) of application.	VARCHAR2(63)		RCRIMP1	RCRIMP1_APPLIC_TYPE
APPLICATION_TYPE_DESC	Application Type Description	Application type description.	VARCHAR2(255)		CALCULATION	DECODE(RCRIMP1_APPLIC_TYPE)
ASSUMPTION_OVERRIDE1_IND	Assumption Override 1 Indicator	Set by electronic application user to override assumption 1: Parent's Number of Family Members assumed to be 3.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_1
ASSUMPTION_OVERRIDE2_IND	Assumption Override 2 Indicator	Set by electronic application user to override assumption 2: Parents' AGI assumed equal to sum parent 1 and parent 2 earned income portions.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_2
ASSUMPTION_OVERRIDE3_IND	Assumption Override 3 Indicator	Set by electronic application user to override assumption 3: Parent's AGI assumed equal to sum of parent's earned income portions.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_3
ASSUMPTION_OVERRIDE4_IND	Assumption Override 4 Indicator	Set by electronic application user to override assumption 4: Student's Number of College assumed to be 1.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_4
ASSUMPTION_OVERRIDE5_IND	Assumption Override 5 Indicator	Set by electronic application user to override assumption 5: Student's AGI assumed equal to sum of student's and spouse's earned income portions.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_5
ASSUMPTION_OVERRIDE6_IND	Assumption Override 6 Indicator	Set by electronic application user to override assumption 6: Student's social security benefits assumed to be zero.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_6
ASSUMPTION_OVERRIDE7_IND	Assumption Override 7 Indicator	Set by electronic application user to override assumption 7: Student's other real estate/investment value and debt assumed to be zero.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_7
ASSUMPTION_OVERRIDE8_IND	Assumption Override 8 Indicator	Set by electronic application user to override assumption 8: Student's business value and debt assumed to be zero.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_8
ASSUMPTION_OVERRIDE9_IND	Assumption Override 9 Indicator	Set by electronic application user to override assumption 9: Student's farm value and debt assumed to be zero.	VARCHAR2(63)		RCRAPP3	RCRAPP3_ASSUMPT_OVRD_9
AT_RISK_OF_HOMELESSNESS	At Risk Of Homelessness	Indicates whether student is at risk of being homeless.	VARCHAR2(63)		RCRAPP1	RCRAPP1_AT_RISK_HOMELESS
AT_RISK_OF_HOMELESSNESS_DESC	At Risk Of Homelessness Description	At risk of homelessness indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
BIRTH_DATE	Birth Date	Student's date of birth.	DATE		RCRAPP1	RCRAPP1_BIRTH_DATE
CITIZENSHIP_ELIGIBILITY_TYPE	Citizenship Eligibility Type	Identifies the person's citizen type relationship to the institution's home country.	VARCHAR2(63)		RCRAPP1	RCRAPP1_CITZ_IND
CITIZENSHIP_ELIGIBIL_TYPE_DESC	Citizenship Eligibil Type Description	Citizen type description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
CITIZENSHIP_TYPE	Citizenship Type	Student citizenship type.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SSA_CITIZEN_IND
CITIZENSHIP_TYPE_DESC	Citizenship Type Description	Student citizenship type description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
CITY	City	City of the student's address from the aid application.	VARCHAR2(63)		RCRAPP1	RCRAPP1_CITY
COLLEGE	College	College code identifying the school to which this financial aid applicant record has applied.	VARCHAR2(63)		RCRAPP1	RCRAPP1_COLL_CDE
COLLEGE_CHOICE1	College Choice 1	Student's first choice of college planning to attend.	VARCHAR2(63)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_1
COLLEGE_CHOICE10	College Choice 10	Student's tenth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_10
COLLEGE_CHOICE2	College Choice 2	Student's second choice of college planning to attend.	VARCHAR2(63)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_2
COLLEGE_CHOICE3	College Choice 3	Student's third choice of college planning to attend.	VARCHAR2(63)		RCRAPP1	RCRAPP1_FED_COLL_CHOICE_3
COLLEGE_CHOICE4	College Choice 4	Student's fourth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_4
COLLEGE_CHOICE5	College Choice 5	Student's fifth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_5
COLLEGE_CHOICE6	College Choice 6	Student's sixth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_6
COLLEGE_CHOICE7	College Choice 7	Student's seventh choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_7
COLLEGE_CHOICE8	College Choice 8	Student's eighth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_8
COLLEGE_CHOICE9	College Choice 9	Student's ninth choice of college planning to attend.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FED_COLL_CHOICE_9
CORRECTION_SOURCE	Correction Source	Source of the correction.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SOURCE_CORRECTION
CORRECTION_SOURCE_DESC	Correction Source Description	Correction source description	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP4_SOURCE_CORRECTION)
CPS_ISIR_PUSHED_IND	Cps Isir Pushed Indicator	CPS pushed ISIR flag.	VARCHAR2(63)		CALCULATION	NVL(RCRAPP4_PUSH_ISIR_FLAG)
CURRENT_RECORD_IND	Current Record Indicator	Specifies that this is the current need analysis record.	VARCHAR2(63)		RCRAPP1	RCRAPP1_CURR_REC_IND
DATE_APPLICATION_COMPLETED	Date Application Completed	Date the application was completed.	DATE		RCRAPP1	RCRAPP1_COMPLETION_DATE
DEATH_DATE	Death Date	Date of death associated with the person on this application as reported to the government.	DATE		RCRAPP4	RCRAPP4_DEATH_DATE
DEGREE_BY_JULY_IND	Degree By July Indicator	Indicates if the student will have a first bachelor's degree by July 1, of the start of the aid year.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_DEGREE_BY_JULY)
DEGREE_TYPE	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	Degree type description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP3_DEGREE_TYPE)
DEPENDENCY_OVERRIDE	Dependency Override	Used by the financial aid administrator to override dependency.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FAA_DEP_OVERRIDE
DEPENDENCY_OVERRIDE_DESC	Dependency Override Description	Dependency override description.	VARCHAR2(255)		CALCULATION	DECODE(I66RCRAPP3_FAA_DEP_OVERRIDE)
DOD_MATCH	Dod Match	Applicant's SSN included in the Department of Defense match file.	VARCHAR2(63)		RCRAPP4	RCRAPP4_DOD_MATCH_FLAG
DOD_MATCH_DESC	Dod Match Description	Department Of Defense match flag.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
DOD_PARENT_DEATH_DATE	Dod Parent Death Date	Date the parent of the applicant died.	DATE		RCRAPP4	RCRAPP4_DOD_PAR_DEATH_DATE
DRIVER_LICENSE_NUMBER	Driver License Number	Student's drivers license number.	VARCHAR2(63)		RCRAPP1	RCRAPP1_DRIVER_LIC_NO
DRIVER_LICENSE_STATE_PROVINCE	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	Driver License State Province Description	Description of the state or province in which the student holds a drivers license.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
DUPLICATE_TAX_ID_IND	Duplicate Tax ID Indicator	Duplicate tax id indicator identifies whether more than one person is using the same ID number.	VARCHAR2(63)		CALCULATION	NVL(RCRAPP4_DUP_SSN_IND)
EFC_CHANGE_FLAG	Effective Family Contribution Change Indicator	EFC change flag indicates whether the EFC has increased or decreased.	VARCHAR2(63)		RCRAPP4	RCRAPP4_EFC_CHANGE_IND
EFC_CHANGE_FLAG_DESC	Effective Family Contribution Change Indicator Description	EFC change flag description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP4_EFC_CHANGE_IND)
EFC_RECALC_SPECIAL_CIRCUM	Effective Family Contribution Recalc Special Circum	Indicates a request to the CPS to recalculate the Effective Family Contribution.	VARCHAR2(63)		RCRAPP3	RCRAPP3_EFC_RECALC_CORR_REQ
EFC_RECALC_SPECIAL_CIRCUM_DESC	Effective Family Contribution Recalc Special Circum Description	Request to the CPS to recalculate the Effective Family Contribution indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
EMAIL_ADDRESS	Email Address	Student's e-mail address as reported on PROFILE.	VARCHAR2(255)		RCRAPP4	RCRAPP4_EMAIL_ADDRESS
EMANCIPATED_MINOR	Emancipated Minor	Indicates whether student is an emancipated minor.	VARCHAR2(63)		RCRAPP1	RCRAPP1_EMANCIPATED_MINOR
EMANCIPATED_MINOR_DESC	Emancipated Minor Description	Emancipated minor indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
ENROLLMENT_PLANNING_SERVICE	Enrollment Planning Service	EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only)	VARCHAR2(63)		RCRAPP2	RCRAPP2_EPS_CDE
ENROLLMENT_PLANNING_SERV_DESC	Enrollment Planning Serv Description	Description of the EPS Marketing code based on the student's zip code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only)	VARCHAR2(255)		STVEPSC	STVEPSC_DESC
FAMILY_IN_COLLEGE	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	Family Size	Number of people in the student's household during the school year.	NUMBER		CALCULATION	DECODE(RCRAPP2_MODEL_CDE)
FATHER_BIRTH_DATE	Parent 1 Birth Date	Father's/Mother's/Stepparent's date of birth.	DATE		RCRAPP4	RCRAPP4_FATH_BIRTH_DATE
FATHER_LAST_NAME	Parent 1 Last Name	Father's/Mother's/Stepparent's last name.	VARCHAR2(63)		RCRAPP4	RCRAPP4_FATH_LAST_NAME
FATHER_SIGNATURE_IND	Father Signature Indicator	Indicates whether or not a father's signature is on the application. Obsolete after aid year 0405.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_C_SIGNED_FATH)
FATHER_TAX_ID	Parent 1 Tax ID	Father's/Mother's/Stepparent's tax id.	VARCHAR2(63)		RCRAPP4	RCRAPP4_FATH_SSN
FATHER_TAX_ID_MATCH	Parent 1 Tax ID Match	Father's/Mother's/Stepparent's Tax ID match flag.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FATH_SSN_MATCH
FATHER_TAX_ID_MATCH_DESC	Parent 1 Tax ID Match Description	Parent 1 Tax ID match description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
FEDERAL_SCHOOL_CODE	Federal School Code	School Code that requested a dependency override or adjusted calculation request.	VARCHAR2(63)		RCRAPP3	RCRAPP3_FAA_TITLE_IV_CODE
FINANCIAL_AID_STATUS	Financial Financial Aid Status	Indicates the student's financial aid status.	VARCHAR2(63)		RCRIMP1	RCRIMP1_FIN_AID_STATUS
FINANCIAL_AID_STATUS_DESC	Financial Financial Aid Status Description	Financial aid status description.	VARCHAR2(255)		CALCULATION	DECODE(RCRIMP1_AID_STATUS)
FIRST_NAME	First Name	The first name given to a person at birth, baptism, another naming ceremony or through legal change.	VARCHAR2(63)		RCRAPP1	RCRAPP1_FIRST_NAME
FOREIGN_ADDRESS_IND	Foreign Address Indicator	Indicates that the student lives outside the nation in which the institution is located.	VARCHAR2(63)		CALCULATION	DECODE(RCRIMP1_FOREIGN_ADDR_IND)
FOREIGN_COUNTRY	Foreign Country	Identifies the country for students that live outside the nation in which the institution is located.	VARCHAR2(63)		RCRIMP1	RCRIMP1_COUNTRY
FOREIGN_POSTAL_CODE	Foreign Postal Code	Identifies the foreign postal code for students that live outside the nation in which the institution is located.	VARCHAR2(63)		RCRIMP1	RCRIMP1_FOREIGN_POSTAL_CDE
GRADUATE_PROFESSIONAL_IND	Graduate Professional Indicator	Indicates whether or not a student is a graduate or professional student.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_GRAD_OR_PROF)
HOUSING	Housing	The 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	Housing Description	Institutional housing code description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
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
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)		RCRAPP1	RCRAPP1_INFC_CODE
INTERFACE_TAPE_DESC	Interface Tape Description	Description of the interface tape code.	VARCHAR2(255)		RTVINFC	RTVINFC_DESC
INTERNATIONAL_PHONE_NUMBER	International Phone Number	Phone number for a student who resides in a country outside the U.S.	VARCHAR2(63)		RCRAPP1	RCRAPP1_INTL_PHONE_NO
IRS_REQUEST_STATUS	Irs Request Status	Status of the data request sent to the IRS for the parent.	VARCHAR2(63)		RCRAPP3	RCRAPP3_IRS_REQUEST_FLAG
IRS_REQUEST_STATUS_DESC	Irs Request Status Description	IRS request status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
LAST_NAME	Last Name	The last name by which a person is known.	VARCHAR2(63)		RCRAPP1	RCRAPP1_LAST_NAME
LEGAL_DEPENDENT_IND	Legal Dependent Indicator	Indicates whether or not the student has legal dependents other than a spouse for determining dependency status.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_HAS_LEGAL_DEPEND)
LEGAL_GUARDIANSHIP	Legal Guardianship	Indicates whether student is in legal guardianship.	VARCHAR2(63)		RCRAPP1	RCRAPP1_LEGAL_GUARDIAN
LEGAL_GUARDIANSHIP_DESC	Legal Guardianship Description	Legal guardian indicator description	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
LEGAL_RESIDENT_IND	Legal Resident Indicator	Indicates whether the student was a legal resident before January 1, YYYY.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP4_LEGAL_RES_IND)
MAILING_CITY	Mailing City	City of the student's mailing address from the aid application.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MAIL_CITY
MAILING_NATION	Mailing Nation	Country code of the student's mailing address as reported on their application.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MAIL_COUNTRY_CDE
MAILING_NATION_DESC	Mailing Nation Description	Nation/country code description.	VARCHAR2(255)		STVNATN	STVNATN_NATN
MAILING_POSTAL_CODE	Mailing Postal Code	Postal code for the student's mailing address.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MAIL_POSTAL_CDE
MAILING_STATE_PROVINCE	Mailing State Province	Postal code for the student's mailing address.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MAIL_STAT_CODE
MAILING_STATE_PROVINCE_DESC	Mailing State Province Description	State or province name associated with the student's mailing address.	VARCHAR2(255)		STVSTAT	STVSTAT_DESC
MAILING_STREET	Mailing Street	Number and street of student's mailing address as reported on their aid application.	VARCHAR2(255)		RCRAPP1	RCRAPP1_MAIL_ADDR
MARITAL_STATUS	Marital Status	Student's reported marital status.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MRTL_STATUS
MARITAL_STATUS_DATE	Marital Status Date	Month and year the student is married, widowed, separated, or divorced.	VARCHAR2(63)		RCRAPP3	RCRAPP3_S_MAR_MTH_YR
MARITAL_STATUS_DESC	Marital Status Description	Marital status description associated with the student.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
MIDDLE_INITIAL	Middle Initial	The student's middle initial as reported on the aid application.	VARCHAR2(63)		RCRAPP1	RCRAPP1_MI
MILITARY_REGISTRATION_STATUS	Military Registration Status	Military registration match flag.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SS_MATCH
MILITARY_REGIST_STATUS_DESC	Military Regist Status Description	Military registration match description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
MILITARY_REG_REQ_STATUS	Military Registration Requirements Status	Results from the student's request to be registered with the military service.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SS_REG_FLAG
MILITARY_REG_REQ_STATUS_DESC	Military Registration Requirements Status Description	Student military registration request status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
MILTARY_ACTIVE_DUTY	Miltary Active Duty	Indicates whether applicant is on active duty in the military.	VARCHAR2(63)		RCRAPP1	RCRAPP1_ACTIVE_DUTY
MILTARY_ACTIVE_DUTY_DESC	Miltary Active Duty Description	Military active duty indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
MOTHER_BIRTH_DATE	Parent 2 Birth Date	Father's/Mother's/Stepparent's date of birth.	DATE		RCRAPP4	RCRAPP4_MOTH_BIRTH_DATE
MOTHER_LAST_NAME	Parent 2 Last Name	Father's/Mother's/Stepparent's last name.	VARCHAR2(63)		RCRAPP4	RCRAPP4_MOTH_LAST_NAME
MOTHER_SIGNATURE_IND	Mother Signature Indicator	Indicates whether or not a mother's signature is on the application. Obsolete after aid year 0405.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_C_SIGNED_MOTH)
MOTHER_TAX_ID	Parent 2 Tax ID	Father's/Mother's/Stepparent's tax id.	VARCHAR2(63)		RCRAPP4	RCRAPP4_MOTH_SSN
MOTHER_TAX_ID_MATCH	Parent 2 Tax ID Match	Father's/Mother's/Stepparent's Tax ID match flag.	VARCHAR2(63)		RCRAPP3	RCRAPP3_MOTH_SSN_MATCH
MOTHER_TAX_ID_MATCH_DESC	Parent 2 Tax ID Match Description	Parent 2 Tax ID match description.	VARCHAR2(255)		RORMVAL	RORMVAL_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
NAME_PREFIX	Name Prefix	An appellation used to connote rank, placement or status. A title that precedes person name.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_TITLE)
NATIONAL_STUDENT_LOAN_SYSTEM	National Student Loan System	Indicates the results of the tape match against the National Student Loan Data System database.	VARCHAR2(63)		RCRAPP4	RCRAPP4_NSLDS_MATCH
NATIONAL_STUDENT_LOAN_SYS_DESC	National Student Loan System Description	National student loan system description.	VARCHAR2(255)		CALCULATION	DECODE(RCRAPP4_NSLDS_MATCH)
NATION_OF_CITIZENSHIP	Nation Of Citizenship	The student's country of citizenship.	VARCHAR2(63)		RCRIMP1	RCRIMP1_CITZ_COUNTRY
NUMBER_OF_EXEMPTIONS	Number Of Exemptions	Number of tax exemptions claimed by the student on their federal tax return.	NUMBER		RCRAPP1	RCRAPP1_NO_EXEMPT
OFFICIAL_SOURCE_IND	Official Source Indicator	Official or unofficial indicator.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_OFFL_UNOFFL_IND)
OLDER_THAN_24_IND	Older Than 24 Indicator	Indicates whether or not the student is older than 24 years old.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_BORN_BEFORE_1_1_XX)
ORIGINAL_COMPUTE_DATE	Original Compute Date	Date that the application was originally processed by the processor.	DATE		RCRAPP1	RCRAPP1_ORIG_COMP_DATE
OTHERS_NUMBER_IN_COLLEGE	Others Number In College	Number of non-parents in the household that will be in college as used in the calculation of parent contribution.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_OTH_IN_COLL
PARENT_DIVORCE_YEAR	Parent Divorce Year	Year of parents' divorce.	VARCHAR2(63)		RCRIMP1	RCRIMP1_PAR_YR_DIV
PARENT_EMAIL_ADDRESS	Parent Email Address	Parent's Email Address.	VARCHAR2(255)		RCRAPP4	RCRAPP4_P_EMAIL_ADDRESS
PARENT_FAMILY_IN_COLLEGE	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	Parent Family Size	Number of family members in the parents household.	NUMBER		RCRAPP1	RCRAPP1_PAR_FAM_MEMB
PARENT_IRS_REQUEST_STATUS	Parent Irs Request Status	Status of the data request sent to the IRS for the student.	VARCHAR2(63)		RCRAPP3	RCRAPP3_PAR_IRS_REQUEST_FLAG
PARENT_IRS_REQUEST_STATUS_DESC	Parent Irs Request Status Description	IRS request status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
PARENT_LEGAL_RESIDENT_IND	Parent Legal Resident Indicator	Indicates whether the parent was a legal resident before January 1, YYYY.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP4_PAR_LEGAL_RES_IND)
PARENT_MARITAL_STATUS	Parent Marital Status	Marital status for the student's parents.	VARCHAR2(63)		RCRAPP1	RCRAPP1_PAR_MRTL_STATUS
PARENT_MARITAL_STATUS_DATE	Parent Marital Status Date	Month and year the parents were married, widowed, separated, or divorced.	VARCHAR2(63)		RCRAPP3	RCRAPP3_PAR_MAR_MTH_YR
PARENT_MARITAL_STATUS_DESC	Parent Marital Status Description	Parents marital status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
PARENT_NATION_OF_RESIDENCE	Parent Nation Of Residence	Nation/country of legal residence for the student's parents.	VARCHAR2(63)		RCRAPP1	RCRAPP1_PAR_CNTRY_CODE_RES
PARENT_NATION_RESIDENCE_DESC	Parent Nation Residence Description	Parent nation/country of residence description.	VARCHAR2(255)		STVNATN	STVNATN_NATN
PARENT_NUMBER_IN_COLLEGE	Parent Number In College	Number in college that are parents of the student.	NUMBER		RCRAPP2	RCRAPP2_C_PAR_PAR_IN_COLL
PARENT_NUMBER_OF_EXEMPTIONS	Parent Number Of Exemptions	Number of income tax exemptions claimed by the student's parents on their federal tax return.	NUMBER		RCRAPP1	RCRAPP1_PAR_NO_EXEMPT
PARENT_REMARRIAGE_DATE	Parent Remarriage Date	Date parent remarried.	DATE		RCRAPP1	RCRAPP1_PAR_REMARRIAGE_DATE
PARENT_SEPARATION_YEAR	Parent Separation Year	Year of parents' separation.	VARCHAR2(63)		RCRIMP1	RCRIMP1_PAR_YR_SEP
PARENT_STATE_OF_RESIDENCE	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	Parent State Of Residence Description	Parents state or province of legal residence description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PARENT_TYPE1	Parent Type 1	Type of parent assigned to the traditional father position.	VARCHAR2(63)		RCRAPP4	RCRAPP4_PARENT_TYPE_1
PARENT_TYPE1_DESC	Parent Type 1 Description	Parent type 1 description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
PARENT_TYPE2	Parent Type 2	Type of parent assigned to the traditional mother position.	VARCHAR2(63)		RCRAPP4	RCRAPP4_PARENT_TYPE_2
PARENT_TYPE2_DESC	Parent Type 2 Description	Parent type 2 description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
PERMIT_DRAFT_REGISTRATION_IND	Permit Draft Registration Indicator	Indicates whether or not the student gave permission to the processor to send data to the Selective Service for draft registration.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_PERMIT_DRAFT_REG)
PERM_RESIDENCY_CONFIRMED_IND	Perm Residency Confirmed Indicator	Indicates whether or not the student's permanent resident status has been confirmed by the federal government.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_INS)
PERM_RESIDENCY_VER_STATUS	Perm Residency Ver Status	Permanent residency verification status.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SEC_INS_MATCH_IND
PERM_RESIDENCY_VER_STATUS_DESC	Perm Residency Ver Status Description	Permanent residency verification status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER		RCRAPP1	RCRAPP1_PIDM
PHONE_AREA	Phone Area	Area code of the student's home telephone number.	VARCHAR2(63)		RCRAPP1	RCRAPP1_PHONE_AREA
PHONE_NUMBER	Phone Number	Student's home telephone number without area code.	VARCHAR2(63)		RCRAPP1	RCRAPP1_PHONE_NO
POSTAL_CODE	Postal Code	Postal code for the student's address.	VARCHAR2(63)		RCRAPP1	RCRAPP1_ZIP
PREPARER_EIN	Preparer Ein	Preparer's employee identification number.	VARCHAR2(63)		RCRAPP3	RCRAPP3_PREPARER_EIN
PREPARER_SIGNATURE_IND	Preparer Signature Indicator	Indicates whether or not the preparer's signature is on the application.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_PREPARER_SIGN)
PREPARER_TAX_ID	Preparer Tax ID	Preparer's tax identification number.	VARCHAR2(63)		RCRAPP3	RCRAPP3_PREPARER_SSN
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
REJECTION_OVERRIDE20_IND	Rejection Override 20 Indicator	Set by electronic application user to override reject 20: Non-tax filer reported income is above the IRS filing requirement.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_20
REJECTION_OVERRIDE21_IND	Rejection Override 21 Indicator	Set by electronic application user to override reject 21: Student's corrected marital status date is greater than application receipt date and less than transaction receipt date.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_21
REJECTION_OVERRIDE2_IND	Rejection Override 2 Indicator	Set to 'Y' by the electronic application user to override rejection 2: Independent student status in question because of student's age. No longer used.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_2
REJECTION_OVERRIDE3_IND	Rejection Override 3 Indicator	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_OVERRIDE4_IND	Rejection Override 4 Indicator	Set by electronic application user to override reject 4: Student's marital status date greater than date application was signed.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_4
REJECTION_OVERRIDE5_IND	Rejection Override 5 Indicator	Set to 'Y' by the electronic application user to override rejection 5: Student's first or last name blank. No longer used.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_5
REJECTION_OVERRIDE7_IND	Rejection Override 7 Indicator	Set to 'Y' by the electronic application user to override rejection 7: Unusually large number of family members. No longer used.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_7
REJECTION_OVERRIDE_B_IND	Rejection Override B Indicator	Indicates if Reject B override accepted - Independent status in question because of student's age.	VARCHAR2(63)		RCRAPP3 RCRAPP3	RCRAPP3_REJECT_OVRD_1 RCRAPP3_REJECT_OVRD_B
REJECTION_OVERRIDE_N_IND	Rejection Override N Indicator	Set by electronic application user to override reject N: Missing first or last name.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_N
REJECTION_OVERRIDE_W_IND	Rejection Override W Indicator	Set by electronic application user to override reject W: Questionable number of family members, greater than 15.	VARCHAR2(63)		RCRAPP3	RCRAPP3_REJECT_OVRD_W
REQUESTED_AID_FALL	Requested Financial Aid Fall	Indicates if the student requested aid for the fall term. No longer populated after aid year ending in 2014.	VARCHAR2(63)		RCRAPP1	RCRAPP1_RQST_FA_FALL_THIS_YR
REQUESTED_AID_FALL_DESC	Requested Financial Aid Fall Description	Requested aid for the fall description. No longer populated after aid year ending in 2014.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
REQUESTED_AID_NEXT_SUMMER	Requested Financial Aid Next Summer	Indicates if the student requested aid for the summer term following the normal school year. No longer populated after aid year ending in 2014.	VARCHAR2(63)		RCRAPP1	RCRAPP1_RQST_FA_SUMMER_NEXT_YR
REQUESTED_AID_NEXT_SUMMER_DESC	Requested Financial Aid Next Summer Description	Requested aid for the next summer description. No longer populated after aid year ending in 2014.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
REQUESTED_AID_PRECEDING_SUMMER	Requested Financial Aid Preceding Summer	Indicates if the student requested aid for the summer term that preceded the normal school year. No longer populated after aid year ending in 2014.	VARCHAR2(63)		RCRAPP1	RCRAPP1_RQST_FA_SUMMER_THIS_YR
REQUESTED_AID_PREC_SUMMER_DESC	Requested Financial Aid Prec Summer Description	Requested aid for the preceding summer description. No longer populated after aid year ending in 2014.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
REQUESTED_AID_SPRING	Requested Financial Aid Spring	Indicates if the student requested aid for the spring term. No longer populated after aid year ending in 2014.	VARCHAR2(63)		RCRAPP1	RCRAPP1_RQST_FA_SPRING_NEXT_YR
REQUESTED_AID_SPRING_DESC	Requested Financial Aid Spring Description	Requested aid for the spring description. No longer populated after aid year ending in 2014.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
REQUESTED_AID_WINTER	Requested Financial Aid Winter	Indicates if the student requested aid for the winter term. No longer populated after aid year ending in 2014.	VARCHAR2(63)		RCRAPP1	RCRAPP1_RQST_FA_WINTER_NEXT_YR
REQUESTED_AID_WINTER_DESC	Requested Financial Aid Winter Description	Requested aid for the winter description. No longer populated after aid year ending in 2014.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
REVISION_COMPUTE_DATE	Revision Compute Date	Date that the processor processed a revised report for the applicant.	DATE		RCRAPP1	RCRAPP1_REV_COMP_DATE
SAR_C_IND	SAR C Indicator	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)
SECONDARY_SCHL_STATE_PROV_DESC	Secondary Schl State Province Description	State/Province name.	VARCHAR2(255)		STVSTAT	STVSTAT_DESC
SECONDARY_SCHOOL	Secondary School	Secondary school code.	VARCHAR2(63)		RCRAPP4	RCRAPP4_HIGH_SCH_CDE
SECONDARY_SCHOOL_CITY	Secondary School City	City in which the student attended secondary school.	VARCHAR2(255)		RCRAPP4	RCRAPP4_HIGH_SCHOOL_CITY
SECONDARY_SCHOOL_DIPLOMA_IND	Secondary School Diploma Indicator	Indicates if the person has received a high school diploma/GED.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP4_HS_GED_RCVD)
SECONDARY_SCHOOL_INVALID	Secondary School Invalid	Indicates whether reported high school was not found in the file of valid high schools.	VARCHAR2(63)		RCRAPP4	RCRAPP4_HIGH_SCHOOL_FLG
SECONDARY_SCHOOL_INVALID_DESC	Secondary School Invalid Description	Secondary school invalid flag description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
SECONDARY_SCHOOL_NAME	Secondary School Name	Name of the secondary school attended by the student.	VARCHAR2(255)		RCRAPP4	RCRAPP4_HIGH_SCHOOL_NAME
SECONDARY_SCHOOL_STATE_PROV	Secondary School State Province	State/Province code in which the student attended secondary school.	VARCHAR2(63)		RCRAPP4	RCRAPP4_STAT_CODE_HIGH_SCH
SELECTED_FOR_VERIFICATION_IND	Selected For Verification Indicator	Indicates whether or not the student has been selected for verification by the Federal Government or by the institution.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_VERIFICATION_MSG)
SIGNATURE_IND	Signature Indicator	Indicates whether or not a student's signature is on the application.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_C_SIGNED)
SIMPLIFIED_NEEDS_TEST_IND	Simplified Needs Test Indicator	Indicates whether the Simplified Needs Test conditions have been met.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP2_PELL_ANLY_TYPE)
SPECIAL_CIRCUMSTANCE	Special Circumstance	Indicates type of special circumstance performed.	VARCHAR2(63)		RCRAPP3	RCRAPP3_SPEC_CIRCUM_FLAG
SPECIAL_CIRCUMSTANCE_DESC	Special Circumstance Description	Special circumstance description	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
SPOUSE_SIGNATURE_IND	Spouse Signature Indicator	Indicates whether or not a spouse's signature is on the application.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP3_C_SIGNED_SPS)
START_RESIDENCE_DATE	Start Residence Date	Date the student began living in his/her state or province of legal residence in MMYY format.	VARCHAR2(63)		RCRAPP1	RCRAPP1_START_RES_MTH_YR
STATE_OF_RESIDENCE	State Of Residence	Student's state or province of legal residence.	VARCHAR2(63)		RCRAPP1	RCRAPP1_STAT_CODE_RES
STATE_OF_RESIDENCE_DESC	State Of Residence Description	Name of the student's state or province of legal residence.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STATE_PROVINCE	State Province	State or province associated with the student's address.	VARCHAR2(63)		RCRAPP1	RCRAPP1_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State or province name associated with the student's address.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
STREET	Street	Student's number and street for their address as reported on their aid application.	VARCHAR2(255)		RCRAPP1	RCRAPP1_ADDR
SUBSEQUENT_RECORD_SELECTED_VER	Subsequent Record Selected Ver	Subsequent record selected for verification.	VARCHAR2(63)		RCRAPP4	RCRAPP4_SUB_VERIF_SELECTED
TAX_ID	Tax ID	Tax Identification Number (TIN) is a number which gets assigned by the government to companies (vendors) in the United States of America, for purposes of the IRS and Department of Revenue. Each company is assigned a unique TIN.	VARCHAR2(63)		RCRAPP1	RCRAPP1_SSN
TAX_ID_MATCH_STATUS	Tax ID Match Status	Tax ID match status.	VARCHAR2(63)		RCRAPP3	RCRAPP3_SOC_SEC
TAX_ID_MATCH_STATUS_DESC	Tax ID Match Status Description	Tax ID match status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
TRANSACTION_NUMBER	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
UNACCOMPANIED_YOUTH_HUD	Unaccompanied Youth Hud	Indicates whether student is an unaccompanied youth determined by HUD.	VARCHAR2(63)		RCRAPP1	RCRAPP1_UNACCOMP_YOUTH_HUD
UNACCOMPANIED_YOUTH_HUD_DESC	Unaccompanied Youth Hud Description	Unaccompanied youth HUD indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
UNACCOMPANIED_YOUTH_SCHL_DESC	Unaccompanied Youth Schl Description	Unaccompanied youth school indicator description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
UNACCOMPANIED_YOUTH_SCHOOL	Unaccompanied Youth School	Indicates whether student is an unaccompanied youth determined by a school district liaison.	VARCHAR2(63)		RCRAPP1	RCRAPP1_UNACCOMP_YOUTH_SCHOOL
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)		RCRAPP1	RCRAPP1_USER_ID
VERIFICATION_NUMBER	Verification Number	Government verification number.	VARCHAR2(63)		RCRAPP4	RCRAPP4_VERIF_NUM
VERIFICATION_PRIORITY	Verification Priority	Indicates the priority of the edits used to select the student for data verification.	VARCHAR2(63)		RCRAPP1	RCRAPP1_VERIFICATION_PRTY
VETERAN_IND	Veteran Indicator	Indicates if the student is a veteran of the Armed Forces.	VARCHAR2(63)		CALCULATION	DECODE(RCRAPP1_US_VET)
VETERAN_MATCH_STATUS	Veteran Match Status	Indicates the value of the Veteran's Administration federal database match flag.	VARCHAR2(63)		RCRAPP4	RCRAPP4_VA_MATCH_FLAG
VETERAN_MATCH_STATUS_DESC	Veteran Match Status Description	Veteran match status description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
VISA_CLASSIFICATION	Visa Classification	Indicates what a students VISA classification is, see CSS tape layout for valid values.	VARCHAR2(63)		RCRAPP4	RCRAPP4_VISA_CLASS
VISA_CLASSIFICATION_DESC	Visa Classification Description	Visa classification description.	VARCHAR2(255)		RORMVAL	RORMVAL_DESC
WARD_OF_COURT	Ward Of Court	Indicates whether the student reported is a ward of the court or is an orphan.	VARCHAR2(63)		RCRAPP1	RCRAPP1_WARD_OF_COURT
WARD_OF_COURT_DESC	Ward Of Court Description	Ward of court indicator description	VARCHAR2(255)		RORMVAL	RORMVAL_DESC

Ver: 9.0