Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICATION4

Description Contains information specific to the institutional methodology of computing applicant need.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number.

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  

RCRAPP4

RCRAPP4_ACTIVITY_DATE

ADDRESS_CHANGE Address Change Address Only Change Flag VARCHAR2(1)  

RCRAPP4

RCRAPP4_ADDRESS_CHG_FLAG

ADDRESS_CHANGE_DESC Address Change Description Address Only Change Flag description. VARCHAR2(40)  

CALCULATION

DECODE(RCRAPP4_ADDRESS_CHG_FLAG)

ADOPTED_AFTER_13 Adopted After 13   VARCHAR2(1)      
ADOPTED_AFTER_13_DESC Adopted After 13 Description   VARCHAR2(4000)      
AID_ELIGIBILITY_RESPONSE Financial Aid Eligibility Response Drug Offense Conviction indicated. VARCHAR2(1)  

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

AID_ELIGIBILITY_RESPONSE_DESC Financial Aid Eligibility Response Description Aid eligibility response description. VARCHAR2(25)      
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(4)  

RCRAPP4

RCRAPP4_AIDY_CODE

APPLICATION_NUMBER Application Number Financial aid application unique sequence number. NUMBER(3)  

RCRAPP4

RCRAPP4_SEQ_NO

ASSET_THRESHOLD_EXCEED Asset Threshold Exceed   NUMBER      
BUSINESS_NET_WORTH Business Net Worth Student's business net worth. NUMBER(6)  

RCRAPP4

RCRAPP4_BUS_NET_WORTH

CITIZENSHIP_TYPE Citizenship Type Student citizenship type. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

CITIZENSHIP_TYPE_DESC Citizenship Type Description Student citizenship type description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_SSA_CITIZEN_IND)

COMBAT_PAY Combat Pay   NUMBER      
CORRECTION_SOURCE Correction Source Source of the correction. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SOURCE_CORRECTION

CORRECTION_SOURCE_DESC Correction Source Description Correction source description. VARCHAR2(10)  

CALCULATION

DECODE(RCRAPP4_SOURCE_CORRECTION)

CPS_ISIR_PUSHED_IND Cps Isir Pushed Indicator CPS Pushed ISIR Flag VARCHAR2(1)  

CALCULATION

NVL(RCRAPP4_PUSH_ISIR_FLAG)

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DATA_TYPE_AVAILABLE Data Type Available Type of data available for the FM and/or IM calculations. VARCHAR2(1)  

RCRAPP4

RCRAPP4_TYPE_DATA_AVAIL

DATA_TYPE_AVAILABLE_DESC Data Type Available Description Data type description. VARCHAR2(10)  

CALCULATION

DECODE(RCRAPP4_TYPE_DATA_AVAIL)

DEATH_DATE Death Date Date of death associated with the person on this application as reported to the government. DATE  

RCRAPP4

RCRAPP4_DEATH_DATE

DIVIDEND_INCOME Dividend Income Amount of the student's dividend and interest income received. NUMBER(5)  

RCRAPP4

RCRAPP4_S_DIV_INT_INC

DOD_MATCH Dod Match   VARCHAR2(1)      
DOD_MATCH_DESC Dod Match Description   VARCHAR2(4000)      
DOD_PARENT_DEATH_DATE Dod Parent Death Date   DATE      
DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

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(1)  

CALCULATION

NVL(RCRAPP4_DUP_SSN_IND)

EFC_CHANGE_FLAG Effective Family Contribution Change Indicator The EFC Change flag indicates if the EFC has increased or decreased. VARCHAR2(1)  

RCRAPP4

RCRAPP4_EFC_CHANGE_IND

EFC_CHANGE_FLAG_DESC Effective Family Contribution Change Indicator Description description of the EFC change flag. VARCHAR2(10)      
EFM_DEPENDENCY_STATUS Efm Dependency Status   VARCHAR2(1)      
EFM_DEPENDENCY_STATUS_DESC Efm Dependency Status Description   VARCHAR2(4000)      
EMAIL_ADDRESS Email Address Student's e-mail address as reported on PROFILE. VARCHAR2(128)  

RCRAPP4

RCRAPP4_EMAIL_ADDRESS

FATHER_BIRTH_DATE Father Birth Date Father's/Stepfather's date of birth. DATE  

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

FATHER_FIRST_INITIAL Father First Initial Father's/Stepfather's first name/initial. VARCHAR2(1)  

RCRAPP4

RCRAPP4_FATH_FIRST_NAME_INI

FATHER_LAST_NAME Father Last Name Father's Last Name. VARCHAR2(60)  

RCRAPP4

RCRAPP4_FATH_LAST_NAME

FATHER_TAX_ID Father Tax ID Father's tax id. VARCHAR2(15)  

RCRAPP4

RCRAPP4_FATH_SSN

FISAP_TOTAL_INCOME Fisap Total Income Indicates the person's total FISAP income. NUMBER(7)  

RCRAPP4

RCRAPP4_FISAP_INC

FM_CONTRIBUTION_OFFICIAL_AMT Federal Method Contribution Official Amount Official student contribution amount. NUMBER(5)  

RCRAPP4

RCRAPP4_C_NA_1_CTRB_FOR_STDT

FM_DEPENDENCY_STATUS Federal Method Dependency Status   VARCHAR2(1)      
FM_DEPENDENCY_STATUS_DESC Federal Method Dependency Status Description   VARCHAR2(4000)      
FM_EST_OTHER_ASSET Federal Method Est Other Asset Amount of the other asset (override) used in the student FM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_1_OTH_ASSET

FM_FISAP_TOTAL_INCOME Federal Method Fisap Total Income   NUMBER      
FM_FORMULA Federal Method Formula Formula used for the FM calculation. VARCHAR2(1)  

RCRAPP4

RCRAPP4_FORMULA_FOR_CALC

FM_FORMULA_DESC Federal Method Formula Description FM formula description. VARCHAR2(60)  

CALCULATION

DECODE(RCRAPP4_FORMULA_FOR_CALC)

FM_PARENT_CONTRIB_OFFICIAL_AMT Federal Method Parent Contribution Official Amount Official parent contribution amount. NUMBER(7)  

RCRAPP4

RCRAPP4_C_NA_1_P_CTRB_FOR_STDT

FM_PARENT_CONTRIB_OFFICIAL_EST Federal Method Parent Contribution Official Est Indicates if the parental contribution amount is official or estimated. VARCHAR2(1)  

RCRAPP4

RCRAPP4_C_NA_1_P_CTRB_OFFL_EST

FM_PARENT_CONTRIB_OFF_EST_DESC Federal Method Parent Contribution Off Est Description Parent contribution official/estimate description. VARCHAR2(4000)      
FM_PARENT_DATA_AVAILABLE_IND Federal Method Parent Data Available Indicator Indicates whether parent data was available for the FM calculation. VARCHAR2(1)  

RCRAPP4

RCRAPP4_FM_PAR_DATA_AVAIL

FM_PARENT_EST_INCOME_ADJUST Federal Method Parent Est Income Adjustment Amount of the income adjustment used in the parent FM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_PAR_1_INC_ADJ

FM_PARENT_EST_OTHER_ASSET Federal Method Parent Est Other Asset Amount of the other asset (override) used in the parent FM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ASSET

FM_PARENT_EST_OTH_INCOME_ALLOW Federal Method Parent Est Oth Income Allow Amount of the other income allowance (override) used in the parent FM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ALLOW

FM_PARENT_WORKSHEET_A_TOTAL Federal Method Parent Worksheet A Total Parents' Worksheet A untaxed income total. NUMBER(5)  

RCRAPP4

RCRAPP4_PAR_WORKSHEET_A

FM_TOTAL_FAMILY_CONTRIBUTION Federal Method Total Family Contribution Total family contribution for the federal methodology calculation. NUMBER(6)  

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

FM_WORKSHEET_A_TOTAL Federal Method Worksheet A Total Student's Worksheet A untaxed income total. NUMBER(5)  

RCRAPP4

RCRAPP4_WORKSHEET_A

HOMELESS Homeless   VARCHAR2(1)      
HOMELESS_DESC Homeless Description   VARCHAR2(4000)      
HOME_AMOUNT_PAID Home Amount Paid Amount student paid for home. NUMBER(6)  

RCRAPP4

RCRAPP4_HME_PURCH_AMT

HOME_YEAR_PURCHASED Home Year Purchased Year student purchased home. NUMBER(4)  

RCRAPP4

RCRAPP4_HME_YR_PURCH

IM_BUDGET_DURATION Institution Method Budget Duration Budget duration used for the IM calculation. NUMBER(3, 1)  

RCRAPP4

RCRAPP4_IM_BUDG_DUR_FOR_CALC

IM_CONTRIBUTION_AMOUNT Institution Method Contribution Amount Student IM contribution amount. NUMBER(5)  

RCRAPP4

RCRAPP4_C_NA_1_IM_CTRB_STDT

IM_CUSTODIAL_PARENT Institution Method Custodial Parent Custodial parent used for IM only calculation of custodial parent's adjustment contribution. VARCHAR2(1)  

RCRAPP4

RCRAPP4_CUSTODIAL_PARENT

IM_CUSTODIAL_PARENT_DESC Institution Method Custodial Parent Description IM custodial parent description. VARCHAR2(10)  

CALCULATION

DECODE(RCRAPP4_CUSTODIAL_PARENT)

IM_DEPENDENCY_STATUS Institution Method Dependency Status   VARCHAR2(1)      
IM_DEPENDENCY_STATUS_DESC Institution Method Dependency Status Description   VARCHAR2(4000)      
IM_OTHER_ASSET_ALLOW_OVR Institution Method Other Asset Allow Ovr Amount of the other asset allowance (override) used in the student IM calculation. NUMBER(8)  

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 IM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_2_OTH_ASSET

IM_PARENT_CONTRIBUTION_AMOUNT Institution Method Parent Contribution Amount Parent IM contribution amount. NUMBER(5)  

RCRAPP4

RCRAPP4_C_NA_1_P_IM_CTRB_STDT

IM_PARENT_DATA_AVAILABLE_IND Institution Method Parent Data Available Indicator Indicates whether parent data was available for the IM calculation. VARCHAR2(1)  

RCRAPP4

RCRAPP4_IM_PAR_DATA_AVAIL

IM_PARENT_OTH_ASSET_ALLOW_OVR Institution Method Parent Oth Asset Allow Ovr Amount of the other asset allowance (override) used in the parent IM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_PAR_2_OTH_ASSET_ALLW

IM_TRUST_AMOUNT Institution Method Trust Amount Amount of the student trust account used in the student IM calculation. NUMBER(8)  

RCRAPP4

RCRAPP4_C_2_TRUST_VAL

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(7)  

RCRAPP4

RCRAPP4_INFC_CODE

INVESTMENT_NET_WORTH Investment Net Worth Student's investment net worth. NUMBER(6)  

RCRAPP4

RCRAPP4_INV_NET_WORTH

LEGAL_RESIDENT_IND Legal Resident Indicator Indicates whether the student was a legal resident before January 1, YYYY. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

LOAN_INTEREST_IND Loan Interest Indicator Indicates that a student is interested in receiving student loans VARCHAR2(1)      
MIF_DESC MIF Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)  

NA

NA

MILITARY_REGISTRATION_STATUS Military Registration Status Military registration match flag. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SS_MATCH

MILITARY_REGIST_STATUS_DESC Military Regist Status Description Military registration match description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_SS_MATCH)

MILITARY_REG_REQ_STATUS Military Registration Requirements Status Results from the student's request to be registered with the military service. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SS_REG_FLAG

MILITARY_REG_REQ_STATUS_DESC Military Registration Requirements Status Description Student military registration request status description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_SS_REG_FLAG)

MOTHER_BIRTH_DATE Mother Birth Date Mother's/Stepmother's date of birth. DATE  

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

MOTHER_FIRST_INITIAL Mother First Initial Mother's/Stepmother's first name initial. VARCHAR2(1)  

RCRAPP4

RCRAPP4_MOTH_FIRST_NAME_INI

MOTHER_LAST_NAME Mother Last Name Mother's Last Name. VARCHAR2(60)  

RCRAPP4

RCRAPP4_MOTH_LAST_NAME

MOTHER_TAX_ID Mother Tax ID Mother's tax id. VARCHAR2(15)  

RCRAPP4

RCRAPP4_MOTH_SSN

NATIONAL_STUDENT_LOAN_SYSTEM National Student Loan System Indicates the results of the tape match against the National Student Loan Data System database VARCHAR2(1)  

RCRAPP4

RCRAPP4_NSLDS_MATCH

NATIONAL_STUDENT_LOAN_SYS_DESC National Student Loan System Description National student loan system description. VARCHAR2(30)  

CALCULATION

DECODE(RCRAPP4_NSLDS_MATCH)

PARENT_ASSET_THRESHOLD_EXCEED Parent Asset Threshold Exceed   NUMBER      
PARENT_BUSINESS_NET_WORTH Parent Business Net Worth Parent's business net worth. NUMBER(6)  

RCRAPP4

RCRAPP4_PAR_BUS_NET_WORTH

PARENT_COMBAT_PAY Parent Combat Pay   NUMBER      
PARENT_DEPEND_CARE_MED_ACCOUNT Parent Depend Care Med Account Amounts withheld from parent wages for dependent care and medical spending accounts. NUMBER(5)  

RCRAPP4

RCRAPP4_PAR_DEP_CARE_AND_MED

PARENT_EMAIL_ADDRESS Parent Email Address Parent's Email Address. VARCHAR2(128)  

RCRAPP4

RCRAPP4_P_EMAIL_ADDRESS

PARENT_EXPECTED_TUITION_PAID Parent Expected Tuition Paid Parents expected tuition paid. NUMBER(5)  

RCRAPP4

RCRAPP4_EXP_PAR_TUIT_PD

PARENT_EXP_NO_CHILD_TUITION_PD Parent Expiration Number Child Tuition Pd Parents expected number of children for whom they are paying tuition. NUMBER(1)  

RCRAPP4

RCRAPP4_EXP_PAR_NO_CHILD_TUIT

PARENT_INVESTMENT_NET_WORTH Parent Investment Net Worth Parent's investment net worth. NUMBER(6)  

RCRAPP4

RCRAPP4_PAR_INV_NET_WORTH

PARENT_LEGAL_RESIDENT_IND Parent Legal Resident Indicator Indicates whether the parent was a legal resident before January 1, YYYY. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_PAR_LEGAL_RES_IND)

PARENT_NUMBER_OF_BUSINESSES Parent Number Of Businesses   NUMBER      
PARENT_NUMBER_OF_FARMS Parent Number Of Farms   NUMBER      
PARENT_SHORT_TAX_FORM_IND Parent Short Tax Form Indicator Indicates whether the parent is eligible to file a federal short tax form. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_PAR_1040A_ELIG_IND)

PARENT_TAX_RETURN_FILED Parent Tax Return Filed Indicates whether the parent has already filed, will file or will not file a tax return. VARCHAR2(1)  

RCRAPP4

RCRAPP4_PAR_TX_RET_FILED_IND

PARENT_TAX_RETURN_FILED_DESC Parent Tax Return Filed Description Parent tax return filed description. VARCHAR2(4000)      
PARENT_TYPE1 Parent Type 1   VARCHAR2(1)      
PARENT_TYPE1_DESC Parent Type 1 Description   VARCHAR2(4000)      
PARENT_TYPE2 Parent Type 2   VARCHAR2(1)      
PARENT_TYPE2_DESC Parent Type 2 Description   VARCHAR2(4000)      
PARENT_WORKSHEET_B_TOTAL Parent Worksheet B Total Parents' Worksheet B untaxed income total. NUMBER(5)  

RCRAPP4

RCRAPP4_PAR_WORKSHEET_B

PARENT_WORKSHEET_C_TOTAL Parent Worksheet C Total Parent's total amount from Worksheet C. NUMBER(5)  

RCRAPP4

RCRAPP4_PAR_WORKSHEET_C

PELL_EFC_OFFICIAL_ESTIMATE Pell Effective Family Contribution Official Estimate Indicates if the Pell parental contribution amount is official or estimated. VARCHAR2(1)  

RCRAPP4

RCRAPP4_C_NA_1_PELL_OFFL_EST

PELL_EFC_OFFICIAL_EST_DESC Pell Effective Family Contribution Official Est Description Pell EFC official/estimate description. VARCHAR2(4000)      
PELL_EFFECTIVE_FAMILY_CONT Pell Effective Family Contribution Student Pell effective family contribution. NUMBER(5)  

RCRAPP4

RCRAPP4_C_NA_1_PELL_PGI

PERM_RESIDENCY_VER_STATUS Perm Residency Ver Status Permanent residency verification status. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SEC_INS_MATCH_IND

PERM_RESIDENCY_VER_STATUS_DESC Perm Residency Ver Status Description Permanent residency verification status description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_SEC_INS_MATCH_IND)

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER(8)  

RCRAPP4

RCRAPP4_PIDM

PROFILE_FEE_WAIVER_IND Profile Fee Waiver Indicator Indicates whether or not this applicant used a Fee Waiver. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_FEE_WAIVER_IND)

RETIREMENT_PLAN_PAYMENT Retirement Plan Payment   NUMBER      
SAR_C_CHANGE_IND SAR C Change Indicator SAR C Change Flag VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)

SAR_EFC SAR Effective Family Contribution Identifies what the SAR EFC was for a person when they were added in dataload. NUMBER(5)  

RCRAPP4

RCRAPP4_SAR_EFC

SECONDARY_SCHL_STATE_PROV_DESC Secondary Schl State Province Description   VARCHAR2(30)      
SECONDARY_SCHOOL Secondary School   VARCHAR2(12)      
SECONDARY_SCHOOL_CITY Secondary School City   VARCHAR2(28)      
SECONDARY_SCHOOL_DIPLOMA_IND Secondary School Diploma Indicator Indicates if the person has received a high school diploma/GED. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

SECONDARY_SCHOOL_INVALID Secondary School Invalid   VARCHAR2(1)      
SECONDARY_SCHOOL_INVALID_DESC Secondary School Invalid Description   VARCHAR2(4000)      
SECONDARY_SCHOOL_NAME Secondary School Name   VARCHAR2(50)      
SECONDARY_SCHOOL_STATE_PROV Secondary School State Province   VARCHAR2(2)      
SHORT_TAX_FORM_IND Short Tax Form Indicator Indicates whether the student is eligible to file a federal short tax form. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_1040A_ELIG_IND)

SUBSEQUENT_RECORD_SELECTED_VER Subsequent Record Selected Ver Subsequent Record Selected For Verification. VARCHAR2(1)  

RCRAPP4

RCRAPP4_SUB_VERIF_SELECTED

SUPPORT_CHILDREN_IND Support Children Indicator Student has children who receive more than half of their support from him/her. VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_HAVE_CHILDREN)

TAX_RETURN_FILED Tax Return Filed Indicates whether the student has already filed, will file or will not file a tax return. VARCHAR2(1)  

RCRAPP4

RCRAPP4_TX_RET_FILED_IND

TAX_RETURN_FILED_DESC Tax Return Filed Description Student tax return filed description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_TX_RET_FILED_IND)

USER_ID User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)  

RCRAPP4

RCRAPP4_USER_ID

VERIFICATION_NUMBER Verification Number Government verification number. VARCHAR2(15)  

RCRAPP4

RCRAPP4_VERIF_NUM

VETERAN_MATCH_STATUS Veteran Match Status Indicates the value of the Veteran's Administration federal database match flag. VARCHAR2(1)  

RCRAPP4

RCRAPP4_VA_MATCH_FLAG

VETERAN_MATCH_STATUS_DESC Veteran Match Status Description Veteran match status description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_VA_MATCH_FLAG)

VISA_CLASSIFICATION Visa Classification Indicates what a students VISA classification is, see CSS tape layout for valid values. VARCHAR2(5)  

RCRAPP4

RCRAPP4_VISA_CLASS

VISA_CLASSIFICATION_DESC Visa Classification Description Visa classification description. VARCHAR2(4000)  

CALCULATION

DECODE(RCRAPP4_VISA_CLASS)

WORKSHEET_B_TOTAL Worksheet B Total Student's Worksheet B untaxed income total. NUMBER(5)  

RCRAPP4

RCRAPP4_WORKSHEET_B

WORKSHEET_C_TOTAL Worksheet C Total Student and spouse total amount from Worksheet C. NUMBER(5)  

RCRAPP4

RCRAPP4_WORKSHEET_C

WORK_STUDY_INTEREST_IND Work Study Interest Indicator Indicates that a student is interested in receiving work-study assistance VARCHAR2(1)  

CALCULATION

DECODE(RCRAPP4_WORK_STUDY)

ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA



Ver: