Go To View:  RETURN TO COMPOSITE VIEW 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)

AID_ELIGIBILITY_RESPONSE Drug Offense Conviction indicated. VARCHAR2(1)

RCRAPP4

RCRAPP4_DRUG_OFFENSE_CONVIC

AID_ELIGIBILITY_RESPONSE_DESC Aid eligibility response description. VARCHAR2(25)

CALCULATION

DECODE(RCRAPP4_DRUG_OFFENSE_CONVIC)

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 Financial aid application unique sequence number. NUMBER(3)

RCRAPP4

RCRAPP4_SEQ_NO

BUSINESS_NET_WORTH Student's business net worth. NUMBER(6)

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

CALCULATION

DECODE(RCRAPP4_SSA_CITIZEN_IND)

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

RCRAPP4

RCRAPP4_S_DIV_INT_INC

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)

CALCULATION

DECODE(RCRAPP4_EFC_CHANGE_IND)

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

RCRAPP4

RCRAPP4_FISAP_INC

FM_CONTRIBUTION_OFFICIAL_AMT Official student contribution amount. NUMBER(5)

RCRAPP4

RCRAPP4_C_NA_1_CTRB_FOR_STDT

FM_EST_OTHER_ASSET Amount of the other asset (override) used in the student FM calculation. NUMBER(8)

RCRAPP4

RCRAPP4_C_1_OTH_ASSET

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

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

CALCULATION

DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)

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

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

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

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ALLOW

FM_PARENT_WORKSHEET_A_TOTAL Parents' Worksheet A untaxed income total. NUMBER(5)

RCRAPP4

RCRAPP4_PAR_WORKSHEET_A

FM_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 Student's Worksheet A untaxed income total. NUMBER(5)

RCRAPP4

RCRAPP4_WORKSHEET_A

HOME_AMOUNT_PAID Amount student paid for home. NUMBER(6)

RCRAPP4

RCRAPP4_HME_PURCH_AMT

HOME_YEAR_PURCHASED Year student purchased home. NUMBER(4)

RCRAPP4

RCRAPP4_HME_YR_PURCH

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

RCRAPP4

RCRAPP4_IM_BUDG_DUR_FOR_CALC

IM_CONTRIBUTION_AMOUNT Student IM contribution amount. NUMBER(5)

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_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 Amount of the other asset (override) used in the student IM calculation. NUMBER(8)

RCRAPP4

RCRAPP4_C_2_OTH_ASSET

IM_PARENT_CONTRIBUTION_AMOUNT Parent IM contribution amount. NUMBER(5)

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

RCRAPP4

RCRAPP4_C_PAR_2_OTH_ASSET_ALLW

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

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)

CALCULATION

DECODE(RCRAPP4_LOAN_INT)

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

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

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_BUSINESS_NET_WORTH Parent's business net worth. NUMBER(6)

RCRAPP4

RCRAPP4_PAR_BUS_NET_WORTH

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's Email Address. VARCHAR2(128)

RCRAPP4

RCRAPP4_P_EMAIL_ADDRESS

PARENT_EXPECTED_TUITION_PAID Parents expected tuition paid. NUMBER(5)

RCRAPP4

RCRAPP4_EXP_PAR_TUIT_PD

PARENT_EXP_NO_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's investment net worth. NUMBER(6)

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

CALCULATION

DECODE(RCRAPP4_PAR_TX_RET_FILED_IND)

PARENT_WORKSHEET_B_TOTAL Parents' Worksheet B untaxed income total. NUMBER(5)

RCRAPP4

RCRAPP4_PAR_WORKSHEET_B

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

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

CALCULATION

DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)

PELL_EFFECTIVE_FAMILY_CONT Student Pell effective family contribution. NUMBER(5)

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

CALCULATION

DECODE(RCRAPP4_SEC_INS_MATCH_IND)

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

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)

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

RCRAPP4

RCRAPP4_SAR_EFC

SECONDARY_SCHOOL_DIPLOMA_IND Indicates if the person has received a high school diploma/GED. VARCHAR2(1)

CALCULATION

DECODE(RCRAPP4_HS_GED_RCVD)

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

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

CALCULATION

DECODE(RCRAPP4_VA_MATCH_FLAG)

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

RCRAPP4

RCRAPP4_VISA_CLASS

VISA_CLASSIFICATION_DESC Visa classification description. VARCHAR2(5)

CALCULATION

DECODE(RCRAPP4_VISA_CLASS)

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

RCRAPP4

RCRAPP4_WORKSHEET_B

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

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: 8.0