RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: RCRAPP1 Financial Aid Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: RCRAPP1

Source Column Source Form Target Type Target Target Column Calculation Formula
RCRAPP1_AIDY_CODE RNANAxx

REPORTING VIEW

NEED_ANALYSIS

AID_YEAR

NA
RCRAPP1_BUS_FARM_DBT RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

BUSINESS_DEBT

NA
RCRAPP1_BUS_FARM_VAL RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

BUSINESS_VALUE

NA
RCRAPP1_CASH_AMT RNANAxx

REPORTING VIEW

NEED_ANALYSIS

CASH_SAVINGS

NA
RCRAPP1_COLL_CDE RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

COLLEGE

NA
RCRAPP1_CURR_REC_IND RNANAxx

REPORTING VIEW

NEED_ANALYSIS

CURRENT_RECORD_IND

NA
RCRAPP1_EXP_ENROLL_STATUS RNANAxx

REPORTING VIEW

NEED_ANALYSIS

EXPECTED_ENROLL_STATUS

NA
RCRAPP1_FAM_MEMB RNANAxx

REPORTING VIEW

NEED_ANALYSIS

FAMILY_SIZE

NA
RCRAPP1_HME_DBT RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

HOME_DEBT

NA
RCRAPP1_HME_VAL RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

HOME_VALUE

NA
RCRAPP1_INFC_CODE RNANAxx

REPORTING VIEW

NEED_ANALYSIS

INTERFACE_TAPE_CODE

NA
RCRAPP1_INST_HOUS_CDE RNANAxx

REPORTING VIEW

NEED_ANALYSIS

HOUSING_CODE

NA
RCRAPP1_NO_IN_COLL RNANAxx

REPORTING VIEW

NEED_ANALYSIS

FAMILY_IN_COLLEGE

NA
RCRAPP1_PAR_US_INC RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

PARENT_ADJ_GROSS_INCOME

NA
RCRAPP1_PIDM NA

REPORTING VIEW

NEED_ANALYSIS

PERSON_UID

NA
RCRAPP1_RE_INV_DBT RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

REAL_ESTATE_DEBT

NA
RCRAPP1_RE_INV_VAL RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

REAL_ESTATE_VALUE

NA
RCRAPP1_SEQ_NO RNANAxx

REPORTING VIEW

NEED_ANALYSIS

APPLICATION_NUMBER

NA
RCRAPP1_SSN RNANAxx

REPORTING VIEW

NEED_ANALYSIS

TAX_ID

NA
RCRAPP1_STAT_CODE_RES RNANAxx

REPORTING VIEW

NEED_ANALYSIS

STATE_OF_RESIDENCE

NA
RCRAPP1_US_INC RNANAxx

REPORTING VIEW

NEED_ANALYSIS

ADJ_GROSS_INCOME

NA
RCRAPP1_VERIFICATION_MSG RCRAPP1

REPORTING VIEW

FINAID_APPLICANT_STATUS

NEED_ANALYSIS

VERIFICATION_REQUIRED_IND

SELECTED_FOR_VERIFICATION

NA
RCRAPP1_VERIFICATION_PRTY RCRAPP1

REPORTING VIEW

NEED_ANALYSIS

VERIFICATION_PRIORITY

NA
RCRAPP1_YR_IN_COLL RNANAxx

REPORTING VIEW

NEED_ANALYSIS

YEAR_IN_COLLEGE

NA


Ver: 3.1