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

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_PERSON

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

REPORTING VIEW

FINAID_APPLICANT_STATUS

APPLICATION_LOCKED_IND

NA
RORSTAT_PC RORSTAT

REPORTING VIEW

NEED_ANALYSIS

PARENTAL_CONTRIBUTION

NA
RORSTAT_PCKG_COMP_DATE ROASTAT

REPORTING VIEW

FINAID_APPLICANT_STATUS

PACKAGE_COMPLETE_DATE

NA
RORSTAT_PCKG_REQ_COMP_DATE ROASTAT

REPORTING VIEW

FINAID_APPLICANT_STATUS

PACKAGE_REQUIRE_COMPLETE_DATE

NA
RORSTAT_PGRP_CODE ROASTAT

REPORTING VIEW

FINAID_APPLICANT_STATUS

PACKAGING_GROUP

NA
RORSTAT_PIDM NA

REPORTING VIEW

FINAID_APPLICANT_STATUS

APPLICANT_NEED

PERSON_UID

PERSON_UID

NA
RORSTAT_SAR_TRAN_NO RNANAxx

REPORTING VIEW

FINAID_APPLICANT_STATUS

VERIFICATION_TRANSACTION_NO

NA
RORSTAT_SC RORSTAT

REPORTING VIEW

NEED_ANALYSIS

STUDENT_CONTRIBUTION

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