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

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

AR_NEED_ANALYSIS

AID_YEAR

NA
RCRAPP1_BUS_FARM_DBT RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

BUSINESS_DEBT

NA
RCRAPP1_BUS_FARM_VAL RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

BUSINESS_VALUE

NA
RCRAPP1_CASH_AMT RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

CASH_SAVINGS

NA
RCRAPP1_COLL_CDE RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

COLLEGE

NA
RCRAPP1_CURR_REC_IND RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

CURRENT_RECORD_IND

NA
RCRAPP1_EXP_ENROLL_STATUS RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

EXPECTED_ENROLL_STATUS

NA
RCRAPP1_FAM_MEMB RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

FAMILY_SIZE

NA
RCRAPP1_HME_DBT RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

HOME_DEBT

NA
RCRAPP1_HME_VAL RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

HOME_VALUE

NA
RCRAPP1_INFC_CODE RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

INTERFACE_TAPE_CODE

NA
RCRAPP1_INST_HOUS_CDE RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

HOUSING_CODE

NA
RCRAPP1_NO_IN_COLL RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

FAMILY_IN_COLLEGE

NA
RCRAPP1_PAR_US_INC RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

PARENT_ADJ_GROSS_INCOME

NA
RCRAPP1_PIDM NA COMPOSITE VIEW

AR_NEED_ANALYSIS

PERSON_UID

NA
RCRAPP1_RE_INV_DBT RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

REAL_ESTATE_DEBT

NA
RCRAPP1_RE_INV_VAL RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

REAL_ESTATE_VALUE

NA
RCRAPP1_SEQ_NO RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

APPLICATION_NUMBER

NA
RCRAPP1_SSN RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

AR_NEED_ANALYSIS

APPLICATION_SSN

SSN

NA
RCRAPP1_STAT_CODE_RES RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

STATE_OF_RESIDENCE

NA
RCRAPP1_US_INC RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

ADJ_GROSS_INCOME

NA
RCRAPP1_VERIFICATION_MSG RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

AR_FINAID_APPLICANT_STATUS

SELECTED_FOR_VERIFICATION

VERIFICATION_REQUIRED_IND

NA
RCRAPP1_VERIFICATION_PRTY RCRAPP1 COMPOSITE VIEW

AR_NEED_ANALYSIS

VERIFICATION_PRIORITY

NA
RCRAPP1_YR_IN_COLL RNANAxx COMPOSITE VIEW

AR_NEED_ANALYSIS

YEAR_IN_COLLEGE

NA


Ver: 3.1