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 Reporting View Source: RORSTAT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
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_APRD_CODE RBAABUD

REPORTING VIEW

APPLICANT_NEED

FINAID_APPLICANT_STATUS

FINAID_BUDGET_COMPONENT

AWARD_BY_AID_YEAR

AWARD_BY_PERSON

AID_PERIOD

AID_PERIOD

AID_PERIOD

AID_PERIOD

AID_PERIOD

NA
RORSTAT_BGRP_CODE ROASTAT

REPORTING VIEW

FINAID_BUDGET_COMPONENT

FINAID_APPLICANT_STATUS

BUDGET_GROUP

BUDGET_GROUP

NA
RORSTAT_DISB_REQ_COMP_DATE ROASTAT

REPORTING VIEW

FINAID_APPLICANT_STATUS

DISBURSE_REQUIRE_COMPLETE_DATE

NA
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_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

PELL_ORIGINATION_IND

 
RORSTAT_PGRP_CODE ROASTAT

REPORTING VIEW

FINAID_APPLICANT_STATUS

AWARD_BY_AID_YEAR

PACKAGING_GROUP

PACKAGING_GROUP

NA
RORSTAT_PIDM NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

APPLICANT_NEED

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


Ver: 8.0