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 Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRAPP4

RCRAPP4_ACTIVITY_DATE

ADDRESS_CHANGE Address Only Change Flag. VARCHAR2(1)

RCRAPP4

RCRAPP4_ADDRESS_CHG_FLAG

ADDRESS_CHANGE_DESC Address Only Change Flag description. VARCHAR2(40)

CALCULATION

DECODE(RCRAPP4_ADDRESS_CHG_FLAG)

ADOPTED_AFTER_13   VARCHAR2(1)    
ADOPTED_AFTER_13_DESC   VARCHAR2(4000)    
AID_ELIGIBILITY_RESPONSE Drug Offense Conviction indicated. VARCHAR2(1)

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

AID_ELIGIBILITY_RESPONSE_DESC Aid eligibility response description. VARCHAR2(25)    
AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RCRAPP4

RCRAPP4_AIDY_CODE

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRAPP4

RCRAPP4_SEQ_NO

ASSET_THRESHOLD_EXCEED   NUMBER    
BUSINESS_NET_WORTH Student's business net worth. NUMBER

RCRAPP4

RCRAPP4_BUS_NET_WORTH

CITIZENSHIP_TYPE Student citizenship type. VARCHAR2(1)

RCRAPP4

RCRAPP4_SSA_CITIZEN_IND

CITIZENSHIP_TYPE_DESC Student citizenship type description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_SSA_CITIZEN_IND)

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

RCRAPP4

RCRAPP4_SOURCE_CORRECTION

CORRECTION_SOURCE_DESC Correction source description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP4_SOURCE_CORRECTION)

CPS_ISIR_PUSHED_IND CPS Pushed ISIR Flag. VARCHAR2(1)

CALCULATION

NVL(RCRAPP4_PUSH_ISIR_FLAG)

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

NA

SYSDATE

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 description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP4_TYPE_DATA_AVAIL)

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

RCRAPP4

RCRAPP4_DEATH_DATE

DIVIDEND_INCOME Amount of the student's dividend and interest income received. NUMBER

RCRAPP4

RCRAPP4_S_DIV_INT_INC

DOD_MATCH   VARCHAR2(1)    
DOD_MATCH_DESC   VARCHAR2(4000)    
DOD_PARENT_DEATH_DATE   DATE    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

DUPLICATE_TAX_ID_IND 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 The EFC Change flag indicates if the EFC has increased or decreased. VARCHAR2(1)

RCRAPP4

RCRAPP4_EFC_CHANGE_IND

EFC_CHANGE_FLAG_DESC description of the EFC change flag. VARCHAR2(10)    
EFM_DEPENDENCY_STATUS   VARCHAR2(1)    
EFM_DEPENDENCY_STATUS_DESC   VARCHAR2(4000)    
EMAIL_ADDRESS Student's e-mail address as reported on PROFILE. VARCHAR2(128)

RCRAPP4

RCRAPP4_EMAIL_ADDRESS

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

RCRAPP4

RCRAPP4_FATH_BIRTH_DATE

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

RCRAPP4

RCRAPP4_FATH_FIRST_NAME_INI

FATHER_LAST_NAME Father's Last Name. VARCHAR2(60)

RCRAPP4

RCRAPP4_FATH_LAST_NAME

FATHER_TAX_ID Father's tax id. VARCHAR2(15)

RCRAPP4

RCRAPP4_FATH_SSN

FISAP_TOTAL_INCOME Indicates the person's total FISAP income. NUMBER

RCRAPP4

RCRAPP4_FISAP_INC

FM_CONTRIBUTION_OFFICIAL_AMT Official student contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_CTRB_FOR_STDT

FM_DEPENDENCY_STATUS   VARCHAR2(1)    
FM_DEPENDENCY_STATUS_DESC   VARCHAR2(4000)    
FM_EST_OTHER_ASSET Amount of the other asset (override) used in the student FM calculation. NUMBER

RCRAPP4

RCRAPP4_C_1_OTH_ASSET

FM_FISAP_TOTAL_INCOME   NUMBER    
FM_FORMULA Formula used for the FM calculation. VARCHAR2(1)

RCRAPP4

RCRAPP4_FORMULA_FOR_CALC

FM_FORMULA_DESC FM formula description. VARCHAR2(60)

CALCULATION

DECODE(RCRAPP4_FORMULA_FOR_CALC)

FM_PARENT_CONTRIB_OFFICIAL_AMT Official parent contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_P_CTRB_FOR_STDT

FM_PARENT_CONTRIB_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 Parent contribution official/estimate description. VARCHAR2(4000)    
FM_PARENT_DATA_AVAILABLE_IND Indicates whether parent data was available for the FM calculation. VARCHAR2(1)

RCRAPP4

RCRAPP4_FM_PAR_DATA_AVAIL

FM_PARENT_EST_INCOME_ADJUST Amount of the income adjustment used in the parent FM calculation. NUMBER

RCRAPP4

RCRAPP4_C_PAR_1_INC_ADJ

FM_PARENT_EST_OTHER_ASSET Amount of the other asset (override) used in the parent FM calculation. NUMBER

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ASSET

FM_PARENT_EST_OTH_INCOME_ALLOW Amount of the other income allowance (override) used in the parent FM calculation. NUMBER

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ALLOW

FM_PARENT_WORKSHEET_A_TOTAL Parents' Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_PAR_WORKSHEET_A

FM_TOTAL_FAMILY_CONTRIBUTION Total family contribution for the federal methodology calculation. NUMBER

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

FM_WORKSHEET_A_TOTAL Student's Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_WORKSHEET_A

HOMELESS   VARCHAR2(1)    
HOMELESS_DESC   VARCHAR2(4000)    
HOME_AMOUNT_PAID Amount student paid for home. NUMBER

RCRAPP4

RCRAPP4_HME_PURCH_AMT

HOME_YEAR_PURCHASED Year student purchased home. NUMBER

RCRAPP4

RCRAPP4_HME_YR_PURCH

IM_BUDGET_DURATION Budget duration used for the IM calculation. NUMBER

RCRAPP4

RCRAPP4_IM_BUDG_DUR_FOR_CALC

IM_CONTRIBUTION_AMOUNT Student IM contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_IM_CTRB_STDT

IM_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 IM custodial parent description. VARCHAR2(10)

CALCULATION

DECODE(RCRAPP4_CUSTODIAL_PARENT)

IM_DEPENDENCY_STATUS   VARCHAR2(1)    
IM_DEPENDENCY_STATUS_DESC   VARCHAR2(4000)    
IM_OTHER_ASSET_ALLOW_OVR Amount of the other asset allowance (override) used in the student IM calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_OTH_ASSET_ALLOW

IM_OTHER_ASSET_OVR Amount of the other asset (override) used in the student IM calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_OTH_ASSET

IM_PARENT_CONTRIBUTION_AMOUNT Parent IM contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_P_IM_CTRB_STDT

IM_PARENT_DATA_AVAILABLE_IND Indicates whether parent data was available for the IM calculation. VARCHAR2(1)

RCRAPP4

RCRAPP4_IM_PAR_DATA_AVAIL

IM_PARENT_OTH_ASSET_ALLOW_OVR Amount of the other asset allowance (override) used in the parent IM calculation. NUMBER

RCRAPP4

RCRAPP4_C_PAR_2_OTH_ASSET_ALLW

IM_TRUST_AMOUNT Amount of the student trust account used in the student IM calculation. NUMBER

RCRAPP4

RCRAPP4_C_2_TRUST_VAL

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 Student's investment net worth. NUMBER

RCRAPP4

RCRAPP4_INV_NET_WORTH

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

CALCULATION

DECODE(RCRAPP4_LEGAL_RES_IND)

LOAN_INTEREST_IND Indicates that a student is interested in receiving student loans. VARCHAR2(1)    
MIF_DESC 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 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 match flag. VARCHAR2(1)

RCRAPP4

RCRAPP4_SS_MATCH

MILITARY_REGIST_STATUS_DESC Military registration match description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_SS_MATCH)

MILITARY_REG_REQ_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 Student military registration request status description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_SS_REG_FLAG)

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

RCRAPP4

RCRAPP4_MOTH_BIRTH_DATE

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

RCRAPP4

RCRAPP4_MOTH_FIRST_NAME_INI

MOTHER_LAST_NAME Mother's Last Name. VARCHAR2(60)

RCRAPP4

RCRAPP4_MOTH_LAST_NAME

MOTHER_TAX_ID Mother's tax id. VARCHAR2(15)

RCRAPP4

RCRAPP4_MOTH_SSN

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. VARCHAR2(30)

CALCULATION

DECODE(RCRAPP4_NSLDS_MATCH)

PARENT_ASSET_THRESHOLD_EXCEED   NUMBER    
PARENT_BUSINESS_NET_WORTH Parent's business net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_BUS_NET_WORTH

PARENT_COMBAT_PAY   NUMBER    
PARENT_DEPEND_CARE_MED_ACCOUNT Amounts withheld from parent wages for dependent care and medical spending accounts. NUMBER

RCRAPP4

RCRAPP4_PAR_DEP_CARE_AND_MED

PARENT_EMAIL_ADDRESS Parent's Email Address. VARCHAR2(128)

RCRAPP4

RCRAPP4_P_EMAIL_ADDRESS

PARENT_EXPECTED_TUITION_PAID Parents expected tuition paid. NUMBER

RCRAPP4

RCRAPP4_EXP_PAR_TUIT_PD

PARENT_EXP_NO_CHILD_TUITION_PD Parents expected number of children for whom they are paying tuition. NUMBER

RCRAPP4

RCRAPP4_EXP_PAR_NO_CHILD_TUIT

PARENT_INVESTMENT_NET_WORTH Parent's investment net worth. NUMBER

RCRAPP4

RCRAPP4_PAR_INV_NET_WORTH

PARENT_LEGAL_RESIDENT_IND 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   NUMBER    
PARENT_NUMBER_OF_FARMS   NUMBER    
PARENT_SHORT_TAX_FORM_IND 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 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. VARCHAR2(4000)    
PARENT_TYPE1   VARCHAR2(1)    
PARENT_TYPE1_DESC   VARCHAR2(4000)    
PARENT_TYPE2   VARCHAR2(1)    
PARENT_TYPE2_DESC   VARCHAR2(4000)    
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_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 EFC official/estimate description. VARCHAR2(4000)    
PELL_EFFECTIVE_FAMILY_CONT Student Pell effective family contribution. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_PELL_PGI

PERM_RESIDENCY_VER_STATUS Permanent residency verification status. VARCHAR2(1)

RCRAPP4

RCRAPP4_SEC_INS_MATCH_IND

PERM_RESIDENCY_VER_STATUS_DESC Permanent residency verification status description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_SEC_INS_MATCH_IND)

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RCRAPP4

RCRAPP4_PIDM

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

CALCULATION

DECODE(RCRAPP4_FEE_WAIVER_IND)

RETIREMENT_PLAN_PAYMENT   NUMBER    
SAR_C_CHANGE_IND SAR C Change Flag. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP4_SAR_C_CHANGE_FLAG)

SAR_EFC Identifies what the SAR EFC was for a person when they were added in dataload. NUMBER

RCRAPP4

RCRAPP4_SAR_EFC

SECONDARY_SCHL_STATE_PROV_DESC   VARCHAR2(30)    
SECONDARY_SCHOOL   VARCHAR2(12)    
SECONDARY_SCHOOL_CITY   VARCHAR2(28)    
SECONDARY_SCHOOL_DIPLOMA_IND Indicates if the person has received a high school diploma/GED. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

SECONDARY_SCHOOL_INVALID   VARCHAR2(1)    
SECONDARY_SCHOOL_INVALID_DESC   VARCHAR2(4000)    
SECONDARY_SCHOOL_NAME   VARCHAR2(50)    
SECONDARY_SCHOOL_STATE_PROV   VARCHAR2(2)    
SHORT_TAX_FORM_IND 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 For Verification. VARCHAR2(1)

RCRAPP4

RCRAPP4_SUB_VERIF_SELECTED

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

CALCULATION

DECODE(RCRAPP4_HAVE_CHILDREN)

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 Student tax return filed description. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_TX_RET_FILED_IND)

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

RCRAPP4

RCRAPP4_USER_ID

VERIFICATION_NUMBER Government verification number. VARCHAR2(15)

RCRAPP4

RCRAPP4_VERIF_NUM

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. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_VA_MATCH_FLAG)

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. VARCHAR2(4000)

CALCULATION

DECODE(RCRAPP4_VISA_CLASS)

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

WORK_STUDY_INTEREST_IND Indicates that a student is interested in receiving work-study assistance. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP4_WORK_STUDY)

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

NA

NA



Ver: