Reporting View Source: RORSTAT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: RORSTAT Financial Aid Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
RORSTAT_ADDL_PELL_ELIG_IND	RPAAWRD ROARMAN RPAAPMT	REPORTING VIEW	FINAID_APPLICANT_STATUS	ADDITIONAL_PELL_AWARDS
RORSTAT_ADDL_STFD_ELIG_IND	RPAAWRD ROARMAN RPAAPMT	REPORTING VIEW	AWARD_BY_AID_YEAR FINAID_APPLICANT_STATUS	ADDITIONAL_STAFFORD_AWARDS ADDITIONAL_STAFFORD_AWARDS
RORSTAT_AIDY_CODE	ROASTAT	REPORTING VIEW	APPLICANT_NEED FINAID_APPLICANT_STATUS	AID_YEAR AID_YEAR	NA
RORSTAT_ALL_REQ_COMP_DATE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	ALL_REQUIRE_COMPLETE_DATE	NA
RORSTAT_APPL_RCVD_DATE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	APPLICATION_RECEIVED_DATE
RORSTAT_APRD_CODE	RBAABUD	REPORTING VIEW	AWARD_BY_AID_YEAR FINAID_BUDGET_COMPONENT APPLICANT_NEED FINAID_APPLICANT_STATUS APPLICANT_PERIOD_STATUS AWARD_BY_PERSON PERIOD_BUDGET_COMPONENT	AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD AID_PERIOD	NA
RORSTAT_BGRP_CODE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS FINAID_BUDGET_COMPONENT	BUDGET_GROUP BUDGET_GROUP	NA
RORSTAT_DEP_NO_PAR_DATA	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	DEPENDENT_NO_PARENT_DATA
RORSTAT_DISB_REQ_COMP_DATE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	DISBURSE_REQUIRE_COMPLETE_DATE	NA
RORSTAT_FM_BATCH_LOCK	RORSTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	FM_BATCH_LOCK_IND
RORSTAT_FORMER_HEAL_IND	RPAAPMT RPAAWRD	REPORTING VIEW	AWARD_BY_AID_YEAR	HEALTH_PROGRAM_IND
RORSTAT_GRS_NEED	ROASTAT RPAAPMT RPAAWRD	REPORTING VIEW	AWARD_BY_AID_YEAR	GROSS_NEED
RORSTAT_IM_BATCH_LOCK	RORSTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	IM_BATCH_LOCK_IND
RORSTAT_LOCK_IND	RNANAXX	REPORTING VIEW	FINAID_APPLICANT_STATUS	APPLICATION_LOCKED_IND	NA
RORSTAT_PC	RORSTAT				NA
RORSTAT_PCKG_COMP_DATE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS AWARD_BY_AID_YEAR	PACKAGE_COMPLETE_DATE PACKAGE_COMPLETE_DATE	NA
RORSTAT_PCKG_REQ_COMP_DATE	ROASTAT	REPORTING VIEW	AWARD_BY_AID_YEAR FINAID_APPLICANT_STATUS	PACKAGE_REQUIRE_COMPLETE_DATE PACKAGE_REQUIRE_COMPLETE_DATE	NA
RORSTAT_PELL_ORIG_IND	RPAAWRD RPAAPMT	REPORTING VIEW	AWARD_BY_AID_YEAR AWARD_BY_AID_YEAR	ADDITIONAL_PELL_AWARDS PELL_ORIGINATION_IND
RORSTAT_PGRP_CODE	ROASTAT	REPORTING VIEW	AWARD_BY_AID_YEAR FINAID_APPLICANT_STATUS	PACKAGING_GROUP PACKAGING_GROUP	NA
RORSTAT_PIDM	ROASTAT	REPORTING VIEW	APPLICANT_NEED FINAID_APPLICANT_STATUS	PERSON_UID PERSON_UID	NA
RORSTAT_POST_BA_PELL_OVRD	RPAAWRD RPAAPMT	REPORTING VIEW	AWARD_BY_AID_YEAR	POST_BACHELORS_DEGREE_IND
RORSTAT_PREP_OR_TEACH_IND	RPAAPMT RPAAWRD	REPORTING VIEW	AWARD_BY_AID_YEAR	PREP_TEACHER_ENROLLMENT
RORSTAT_SAR_TRAN_NO	RNANAXX	REPORTING VIEW	FINAID_APPLICANT_STATUS	VERIFICATION_TRANSACTION_NO	NA
RORSTAT_SC	RORSTAT				NA
RORSTAT_SUB_LOAN_EXCL_AMT	RPAAWRD RPAAPMT	REPORTING VIEW	AWARD_BY_AID_YEAR	SUBSIDIZED_LOAN_EXCLUSION_AMT
RORSTAT_TGRP_CODE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	TRACKING_GROUP	NA
RORSTAT_VER_COMPLETE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	VERIFICATION_COMPLETE_IND	NA
RORSTAT_VER_DATE	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	VERIFICATION_COMPLETE_DATE	NA
RORSTAT_XES	ROASTAT	REPORTING VIEW	FINAID_APPLICANT_STATUS	EXPECTED_ENROLL_STATUS

Ver: 9.0