RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: RORSTAT Financial Aid Composite View Reports
SGHE Operational Data Store Composite View Source: RORSTAT

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_FINAID_APPLICANT_STATUS

AR_APPLICANT_NEED

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_LOCK_IND RNANAxx COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

APPLICATION_LOCKED_IND

NA
RORSTAT_PC RORSTAT COMPOSITE VIEW

AR_NEED_ANALYSIS

PARENTAL_CONTRIBUTION

NA
RORSTAT_PCKG_COMP_DATE ROASTAT COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

PACKAGE_COMPLETE_DATE

NA
RORSTAT_PCKG_REQ_COMP_DATE ROASTAT COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

PACKAGE_REQUIRE_COMPLETE_DATE

NA
RORSTAT_PGRP_CODE ROASTAT COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

PACKAGING_GROUP

NA
RORSTAT_PIDM NA COMPOSITE VIEW

AR_APPLICANT_NEED

AR_FINAID_APPLICANT_STATUS

PERSON_UID

PERSON_UID

NA
RORSTAT_SAR_TRAN_NO RNANAxx COMPOSITE VIEW

AR_FINAID_APPLICANT_STATUS

VERIFICATION_TRANSACTION_NO

NA
RORSTAT_SC RORSTAT COMPOSITE VIEW

AR_NEED_ANALYSIS

STUDENT_CONTRIBUTION

NA
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: 3.1