Composite View Source: RORSTAT

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: RORSTAT Financial Aid

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
RORSTAT_AIDY_CODE	ROASTAT	COMPOSITE VIEW	AR_APPLICANT_NEED AR_FINAID_APPLICANT_STATUS	AID_YEAR AID_YEAR	NA
RORSTAT_ALL_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	ALL_REQUIRE_COMPLETE_DATE	NA
RORSTAT_APRD_CODE	RBAABUD	COMPOSITE VIEW	AR_APPLICANT_NEED AR_AWARD_BY_AID_YEAR AR_AWARD_BY_PERSON AR_FINAID_APPLICANT_STATUS AR_FINAID_BUDGET_COMPONENT	AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD	NA
RORSTAT_BGRP_CODE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS AR_FINAID_BUDGET_COMPONENT	BUDGET_GROUP BUDGET_GROUP	NA
RORSTAT_DISB_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	DISBURSE_REQUIRE_COMPLETE_DATE	NA
RORSTAT_FM_BATCH_LOCK	RORSTAT
RORSTAT_FORMER_HEAL_IND	RPAAPMT RPAAWRD	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	HEALTH_PROGRAM_IND
RORSTAT_GRS_NEED	ROASTAT RPAAPMT RPAAWRD	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	GROSS_NEED
RORSTAT_IM_BATCH_LOCK	RORSTAT
RORSTAT_LOCK_IND	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	APPLICATION_LOCKED_IND	NA
RORSTAT_PC	RORSTAT				NA
RORSTAT_PCKG_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR AR_FINAID_APPLICANT_STATUS	PACKAGE_COMPLETE_DATE PACKAGE_COMPLETE_DATE	NA
RORSTAT_PCKG_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR AR_FINAID_APPLICANT_STATUS	PACKAGE_REQUIRE_COMPLETE_DATE PACKAGE_REQUIRE_COMPLETE_DATE	NA
RORSTAT_PELL_ORIG_IND	RPAAWRD RPAAPMT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	PELL_ORIGINATION_IND
RORSTAT_PGRP_CODE	ROASTAT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR AR_FINAID_APPLICANT_STATUS	PACKAGING_GROUP PACKAGING_GROUP	NA
RORSTAT_PIDM	NA	COMPOSITE VIEW	AR_APPLICANT_NEED AR_FINAID_APPLICANT_STATUS AS_ACTIVE_TERMS	PERSON_UID PERSON_UID PERSON_UID	NA
RORSTAT_POST_BA_PELL_OVRD	RPAAWRD RPAAPMT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	POST_BACHELORS_DEGREE_IND
RORSTAT_PREP_OR_TEACH_IND	RPAAPMT RPAAWRD	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	PREP_TEACHER_ENROLLMENT
RORSTAT_SAR_TRAN_NO	RNANAXX	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	VERIFICATION_TRANSACTION_NO	NA
RORSTAT_SC	RORSTAT				NA
RORSTAT_SUB_LOAN_EXCL_AMT	RPAAWRD RPAAPMT	COMPOSITE VIEW	AR_AWARD_BY_AID_YEAR	SUBSIDIZED_LOAN_EXCLUSION_AMT
RORSTAT_TGRP_CODE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	TRACKING_GROUP	NA
RORSTAT_VER_COMPLETE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	VERIFICATION_COMPLETE_IND	NA
RORSTAT_VER_DATE	ROASTAT				NA

Ver: 8.1