Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADDITIONAL_PELL_AWARDS	Indicates whether student is receiving a second Pell award for the aid year.	VARCHAR2(1)	RORSTAT	RORSTAT_ADDL_PELL_ELIG_IND	NO	NO
ADDITIONAL_PELL_AWARDS_DESC	Additional Pell award description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND	NO	NO
ADDITIONAL_STAFFORD_AWARDS	Indicates if the applicant is eligible for additional Stafford awards.	VARCHAR2(1)	RORSTAT	RORSTAT_ADDL_STFD_ELIG_IND	NO	NO
ADDITIONAL_STAFFORD_AWRDS_DESC	Additional Stafford awards description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AID_PERIOD	Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.	VARCHAR2(63)	RORSTAT	RORSTAT_APRD_CODE	NO	NO
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	RTVAPRD	RTVAPRD_DESC	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RORSTAT	RORSTAT_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ALL_REQUIRE_COMPLETE_DATE	Date on which all tracking requirements for this applicant were satisfied.	DATE	RORSTAT	RORSTAT_ALL_REQ_COMP_DATE	NO	NO
APPLICATION_LOCKED_IND	Indicates whether the student's financial aid application record is locked.	VARCHAR2(1)	RORSTAT	RORSTAT_LOCK_IND	NO	NO
APPLICATION_RECEIVED_DATE	Date this financial aid status record for this person recorded because either a financial aid application was received, processed or created or at least one tracking requirement was satisfied as defined by institution options.	DATE	RORSTAT	RORSTAT_APPL_RCVD_DATE	NO	NO
BUDGET_GROUP	Student's assigned budget group.	VARCHAR2(63)	RORSTAT	RORSTAT_BGRP_CODE	NO	NO
BUDGET_GROUP_DESC	Budget group code description. Identifies what it represents.	VARCHAR2(255)	RTVBGRP	RTVBGRP_DESC	NO	NO
DEPENDENT_NO_PARENT_DATA	Indicates whether the dependent student is eligible for unsubsidized Stafford even though parent data has not been submitted on the FAFSA.	VARCHAR2(1)	RORSTAT	RORSTAT_DEP_NO_PAR_DATA	NO	NO
DEPENDENT_NO_PARENT_DATA_DESC	Dependent no parent data description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_DEP_NO_PAR_DATA	NO	NO
DISBURSE_REQUIRE_COMPLETE_DATE	Date that all tracking requirements mandatory for disbursement were satisfied for the particular student.	DATE	RORSTAT	RORSTAT_DISB_REQ_COMP_DATE	NO	NO
EXPECTED_ENROLL_STATUS	Student's expected enrollment status for the school's aid year.	VARCHAR2(63)	RORSTAT	RORSTAT_XES	NO	NO
EXPECTED_ENROLL_STATUS_DESC	Expected enrollment status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC	NO	NO
FINAID_APPLICANT_IND	Indicates if this person has a financial aid status or RORSTAT record identifying them as a financial aid applicant for the aid year.	VARCHAR2(1)	FUNCTION	F_FINAID_APPLICANT_IND	NO	NO
FINANCIAL_AID_APPLICATION_IND	Indicates whether this person is an applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO	NO	NO
FM_APPLICATION_IND	Indicates whether Banner has data from a federal application (FASFA-EDE) and should be identified as an FM applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO	NO	NO
FM_BATCH_LOCK_IND	Indicates whether the FM data for this person is locked from any updating by the batch tape load process.	VARCHAR2(1)	RORSTAT	RORSTAT_FM_BATCH_LOCK	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
IM_APPLICATION_IND	Indicates whether Banner has data from an institution application (CSS profile) and should be identified as an IM applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO	NO	NO
IM_BATCH_LOCK_IND	Indicates whether the IM data for this person is locked from any updating by the batch tape load process.	VARCHAR2(1)	RORSTAT	RORSTAT_IM_BATCH_LOCK	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PACKAGE_COMPLETE_DATE	Date the student's financial aid package was complete.	DATE	RORSTAT	RORSTAT_PCKG_COMP_DATE	NO	NO
PACKAGE_REQUIRE_COMPLETE_DATE	Date that tracking requirements were satisfied for packaging.	DATE	RORSTAT	RORSTAT_PCKG_REQ_COMP_DATE	NO	NO
PACKAGING_GROUP	Assigned packaging group for this financial aid applicant.	VARCHAR2(63)	RORSTAT	RORSTAT_PGRP_CODE	NO	NO
PACKAGING_GROUP_DESC	Code description assigned to the packaging group.	VARCHAR2(255)	RTVPGRP	RTVPGRP_DESC	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RORSTAT	RORSTAT_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
TRACKING_GROUP	Assigned tracking group for this financial aid applicant.	VARCHAR2(63)	RORSTAT	RORSTAT_TGRP_CODE	NO	NO
TRACKING_GROUP_DESC	Tracking group code description.	VARCHAR2(255)	RTVTGRP	RTVTGRP_DESC	NO	NO
VERIFICATION_COMPLETE_DATE	Specifies the date the verification has been completed.	DATE	RORSTAT	RORSTAT_VER_DATE	NO	NO
VERIFICATION_COMPLETE_IND	Specifies whether the verification has been completed.	VARCHAR2(1)	RORSTAT	RORSTAT_VER_COMPLETE	NO	NO
VERIFICATION_REQUIRED_IND	Specifies whether verification is required.	VARCHAR2(1)	RCRAPP1	RCRAPP1_VERIFICATION_MSG	NO	NO
VERIFICATION_TRANSACTION_NO	Transaction number of the verification.	VARCHAR2(63)	RORSTAT	RORSTAT_SAR_TRAN_NO	NO	NO

Ver: 9.2