Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_AWARD_BY_AID_YEAR

Description Contains detail data for each person who was made an offer of financial aid within the aid year.
Key & Frequency One row per person per aid year per fund.

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: