Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RORSTAT Financial Aid
SGHE Banner Operational Data Store Composite View Source: RORSTAT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
RORSTAT_AIDY_CODE ROASTAT COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

AR_APPLICANT_NEED

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_FINAID_BUDGET_COMPONENT

AR_AWARD_BY_AID_YEAR

AR_AWARD_BY_PERSON

AR_FINAID_APPLICANT_STATUS

AR_APPLICANT_NEED

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

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.0