Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_YEAR_OVERRIDE	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(1)	RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL	NO	NO
ACADEMIC_YEAR_OVERRIDE_DESC	Year in college override description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RPRAWRD	RPRAWRD_ACTIVITY_DATE	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(6)	RORSTAT	RORSTAT_APRD_CODE	NO	NO
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(30)	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(4)	RPRAWRD	RPRAWRD_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ANNUAL_AWARD_ACCESS_IND	Allows information for this award to be accessed via Banner Web, Voice Response and similar methods.	VARCHAR2(1)	RPRAWRD	RPRAWRD_INFO_ACCESS_IND	NO	NO
ANNUAL_AWARD_AUTHORIZE_AMOUNT	Authorized amount of financial aid for this fund.	NUMBER	RPRAWRD	RPRAWRD_AUTHORIZE_AMT	NO	NO
ANNUAL_AWARD_AUTHORIZE_DATE	Date of the award authorization.	DATE	RPRAWRD	RPRAWRD_AUTHORIZE_DATE	NO	NO
ANNUAL_AWARD_CANCEL_AMOUNT	Total amount of this fund that was offered and or accepted by the students and then canceled.	NUMBER	RPRAWRD	RPRAWRD_CANCEL_AMT	NO	NO
ANNUAL_AWARD_CANCEL_DATE	Date that the award was cancelled.	DATE	RPRAWRD	RPRAWRD_CANCEL_DATE	NO	NO
ANNUAL_AWARD_LAST_WEB_UPDATE	Date the award was last updated by web activity.	DATE	RPRAWRD	RPRAWRD_LAST_WEB_UPDATE	NO	NO
ANNUAL_AWARD_LOCKED	Aid year based lock code.	VARCHAR2(1)	RPRAWRD	RPRAWRD_LOCK_IND	NO	NO
ANNUAL_AWARD_LOCKED_DESC	Annual award locked description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ANNUAL_AWARD_MEMO_AMOUNT	Displays the amount of the memo'd or authorized award.	NUMBER	RPRAWRD	RPRAWRD_MEMO_AMT	NO	NO
ANNUAL_AWARD_MEMO_DATE	Date of the memo'd award.	DATE	RPRAWRD	RPRAWRD_MEMO_DATE	NO	NO
AWARD_OFFER_EXPIRATION_DATE	Expiration date of the award offer.	DATE	RPRAWRD	RPRAWRD_OFFER_EXP_DATE	NO	NO
AWARD_STATUS	Current status for the financial aid award.	VARCHAR2(4)	RPRAWRD	RPRAWRD_AWST_CODE	NO	NO
AWARD_STATUS_DATE	Date that the financial aid award status was changed.	DATE	RPRAWRD	RPRAWRD_AWST_DATE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
FEDERAL_LIMIT_OVERRIDE_IND	Used to override a federal limit on a fund when manually entering the award.	VARCHAR2(1)	RPRAWRD	RPRAWRD_FED_LIMIT_OVRDE_IND	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	RPRAWRD	RPRAWRD_FUND_CODE	NO	NO
FUND_LIMIT_OVERRIDE_IND	Used to override the fund limit when manually entering the fund on the students' award record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_FUND_LIMIT_OVRDE_IND	NO	NO
FUND_TITLE	Fund code description or title.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GROSS_NEED	Applicant's gross need defined as budget minus EFC, minus resources.	NUMBER	RORSTAT	RORSTAT_GRS_NEED	NO	NO
HEALTH_PROGRAM_IND	Indicates if applicant qualifies for additional stafford due to enrollment in a health profession program.	VARCHAR2(1)	RORSTAT	RORSTAT_FORMER_HEAL_IND	NO	NO
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)	NA	NA	NO	NO
NO_PELL_OVERRIDE_IND	Indicates if the Pell award validation rule has been overridden for the ACG or SMART Grant award.	VARCHAR2(1)	RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL	NO	NO
OFFER_AMOUNT	Maintains the current amount of the award fund offered.	NUMBER	RPRAWRD	RPRAWRD_OFFER_AMT	NO	NO
OFFER_DATE	Date the award was offered.	DATE	RPRAWRD	RPRAWRD_OFFER_DATE	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(6)	RORSTAT	RORSTAT_PGRP_CODE	NO	NO
PACKAGING_GROUP_DESC	Code description assigned to the packaging group.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PELL_ORIGINATION_IND	Indicates an updated Pell origination record is to be created.	VARCHAR2(1)	RORSTAT	RORSTAT_PELL_ORIG_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRAWRD	RPRAWRD_PIDM	NO	NO
POST_BACHELORS_DEGREE_IND	Indicates applicant is eligible to receive Pell Grant even though applicant has earned a Bachelor's degree.	VARCHAR2(1)	RORSTAT	RORSTAT_POST_BA_PELL_OVRD	NO	NO
PREP_TEACHER_ENROLLMENT	Indicates if loan limits should be different due to teacher certification enrollment.	VARCHAR2(1)	RORSTAT	RORSTAT_PREP_OR_TEACH_IND	NO	NO
PREP_TEACHER_ENROLLMENT_DESC	Describes teacher certification enrollment.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REPLACE_TFC_OVERRIDE_IND	Used to override the rule to replace Expected Family Contribution when manually adding the award to the students' record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_REPLACE_TFC_OVRDE_IND	NO	NO
SUBSIDIZED_LOAN_EXCLUSION_AMT	VA Chapter 30 or Americorp amount that should be excluded from subsidized loan eligibility.	NUMBER	RORSTAT	RORSTAT_SUB_LOAN_EXCL_AMT	NO	NO
SYSTEM_IND	Specifies whether the award was system or manually generated.	VARCHAR2(1)	RPRAWRD	RPRAWRD_SYS_IND	NO	NO
SYSTEM_IND_DESC	System description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
TOTAL_ACCEPT_AMOUNT	Total amount accepted for this fund.	NUMBER	RPRAWRD	RPRAWRD_ACCEPT_AMT	NO	NO
TOTAL_ACCEPT_DATE	Date the award was accepted.	DATE	RPRAWRD	RPRAWRD_ACCEPT_DATE	NO	NO
TOTAL_DECLINE_AMOUNT	Total amount offered and then declined for this fund.	NUMBER	RPRAWRD	RPRAWRD_DECLINE_AMT	NO	NO
TOTAL_DECLINE_DATE	Date that the award was declined.	DATE	RPRAWRD	RPRAWRD_DECLINE_DATE	NO	NO
TOTAL_OFFER_AMOUNT	Total amount offered for this fund.	NUMBER	RPRAWRD	RPRAWRD_ORIG_OFFER_AMT	NO	NO
TOTAL_ORIGINAL_OFFER_DATE	Date that the original offer of the award was made.	DATE	RPRAWRD	RPRAWRD_ORIG_OFFER_DATE	NO	NO
TOTAL_PAID_AMOUNT	Total amount offered and then paid from this fund.	NUMBER	RPRAWRD	RPRAWRD_PAID_AMT	NO	NO
TOTAL_PAID_DATE	Date that the award was paid.	DATE	RPRAWRD	RPRAWRD_PAID_DATE	NO	NO
TRACKING_REQ_OVERRIDE_IND	Used to override the rule that all tracking requirements must be satisfied when manually adding the fund to the students' award record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_TREQ_OVRDE_IND	NO	NO
UNMET_NEED_OVERRIDE	Used to override the unmet need rule when manually adding an award to the students' record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_UNMET_NEED_OVRDE_IND	NO	NO
UNMET_NEED_OVERRIDE_DESC	Unmet need override description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RPRAWRD	RPRAWRD_USER_ID	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: