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_ADDL_PELL_ELIG_IND	RPAAWRD ROARMAN RPAAPMT
RORSTAT_ADDL_STFD_ELIG_IND	RPAAWRD ROARMAN RPAAPMT
RORSTAT_AIDY_CODE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS AR_APPLICANT_NEED AR_STUDENT_PERIOD_DEFINITION	AID_YEAR AID_YEAR AID_YEAR	NA
RORSTAT_ALL_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	ALL_REQUIRE_COMPLETE_DATE	NA
RORSTAT_APPL_RCVD_DATE	ROASTAT
RORSTAT_APRD_CODE	RBAABUD	COMPOSITE VIEW	AR_APPLICANT_NEED AR_AWARD_BY_PERSON AR_FINAID_APPLICANT_STATUS AR_STUDENT_PERIOD_DEFINITION AR_AWARD_BY_AID_YEAR AR_FINAID_BUDGET_COMPONENT	AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD	NA
RORSTAT_BGRP_CODE	ROASTAT	COMPOSITE VIEW	AR_FINAID_BUDGET_COMPONENT AR_FINAID_APPLICANT_STATUS	BUDGET_GROUP BUDGET_GROUP	NA
RORSTAT_DEP_NO_PAR_DATA	ROASTAT
RORSTAT_DISB_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	DISBURSE_REQUIRE_COMPLETE_DATE	NA
RORSTAT_FM_BATCH_LOCK	RORSTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	FM_BATCH_LOCK_IND
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	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS	IM_BATCH_LOCK_IND
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_FINAID_APPLICANT_STATUS AR_AWARD_BY_AID_YEAR	PACKAGE_COMPLETE_DATE PACKAGE_COMPLETE_DATE	NA
RORSTAT_PCKG_REQ_COMP_DATE	ROASTAT	COMPOSITE VIEW	AR_FINAID_APPLICANT_STATUS AR_AWARD_BY_AID_YEAR	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	ROASTAT	COMPOSITE VIEW	AR_STUDENT_PERIOD_DEFINITION AR_FINAID_APPLICANT_STATUS AR_APPLICANT_NEED AS_ACTIVE_TERMS	PERSON_UID 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
RORSTAT_XES	ROASTAT

Ver: