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