Composite View Target: AR_AWARD_BY_AID

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Financial Aid Composite View Reports

SGHE 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

ACADEMIC_YEAR_OVERRIDE Academic year to use for ACG and SMART Grant eligibility. VARCHAR2(1)
RPRAWRD

RPRAWRD_OVERRIDE_YR_IN_COLL

ACADEMIC_YEAR_OVERRIDE_DESC Year in college override description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DATE Date record was inserted or updated DATE
RPRAWRD

RPRAWRD_ACTIVITY_DATE

ADDITIONAL_STAFFORD_AWARDS Indicates if the applicant is eligible for additional Stafford awards. VARCHAR2(1)
RORSTAT2

RORSTAT_ADDL_STFD_ELIG_IND

ADDITIONAL_STAFFORD_AWRDS_DESC Additional Stafford awards description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(6)
RORSTAT

RORSTAT_APRD_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(30)
RTVAPRD

RTVAPRD_DESC

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(4)
RPRAWRD

RPRAWRD_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)
ROBINST

ROBINST_AIDY_DESC

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

ANNUAL_AWARD_AUTHORIZE_AMOUNT Authorized amount of financial aid for this fund. NUMBER(11,2)
RPRAWRD

RPRAWRD_AUTHORIZE_AMT

ANNUAL_AWARD_AUTHORIZE_DATE Date of the award authorization. DATE
RPRAWRD

RPRAWRD_AUTHORIZE_DATE

ANNUAL_AWARD_CANCEL_AMOUNT Total amount of this fund that was offered and or accepted by the students and then canceled. NUMBER(11,2)
RPRAWRD

RPRAWRD_CANCEL_AMT

ANNUAL_AWARD_CANCEL_DATE Date that the award was cancelled. DATE
RPRAWRD

RPRAWRD_CANCEL_DATE

ANNUAL_AWARD_LAST_WEB_UPDATE Date the award was last updated by web activity. DATE
RPRAWRD

RPRAWRD_LAST_WEB_UPDATE

ANNUAL_AWARD_LOCKED Aid year based lock code. VARCHAR2(1)
RPRAWRD

RPRAWRD_LOCK_IND

ANNUAL_AWARD_LOCKED_DESC Annual award locked description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

ANNUAL_AWARD_MEMO_AMOUNT Displays the amount of the memo'd or authorized award. NUMBER(11,2)
RPRAWRD

RPRAWRD_MEMO_AMT

ANNUAL_AWARD_MEMO_DATE Date of the memo'd award. DATE
RPRAWRD

RPRAWRD_MEMO_DATE

AWARD_OFFER_EXPIRATION_DATE Expiration date of the award offer. DATE
RPRAWRD

RPRAWRD_OFFER_EXP_DATE

AWARD_STATUS Current status for the financial aid award. VARCHAR2(4)
RPRAWRD

RPRAWRD_AWST_CODE

AWARD_STATUS_DATE Date that the financial aid award status was changed. DATE
RPRAWRD

RPRAWRD_AWST_DATE

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE
NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)
NA

NA

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

FUND Fund code to be associated with information in this record. VARCHAR2(6)
RPRAWRD

RPRAWRD_FUND_CODE

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

FUND_TITLE Fund code description or title. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

GROSS_NEED Applicant's gross need defined as budget minus EFC, minus resources. NUMBER(11,2)
RORSTAT

RORSTAT_GRS_NEED

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

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

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_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

OFFER_AMOUNT Maintains the current amount of the award fund offered. NUMBER(11,2)
RPRAWRD

RPRAWRD_OFFER_AMT

OFFER_DATE Date the award was offered. DATE
RPRAWRD

RPRAWRD_OFFER_DATE

PACKAGE_COMPLETE_DATE Date the student's financial aid package was complete. DATE
RORSTAT

RORSTAT_PCKG_COMP_DATE

PACKAGE_REQUIRE_COMPLETE_DATE Date that tracking requirements were satisfied for packaging. DATE
RORSTAT

RORSTAT_PCKG_REQ_COMP_DATE

PACKAGING_GROUP Assigned packaging group for this financial aid applicant. VARCHAR2(6)
RORSTAT

RORSTAT_PGRP_CODE

PACKAGING_GROUP_DESC Code description assigned to the packaging group. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

PELL_ORIGINATION_IND Indicates an updated Pell origination record is to be created. VARCHAR2(1)
RORSTAT

RORSTAT_PELL_ORIG_IND

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)
RPRAWRD

RPRAWRD_PIDM

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

PREP_TEACHER_ENROLLMENT Indicates if loan limits should be different due to teacher certification enrollment. VARCHAR2(1)
RORSTAT

RORSTAT_PREP_OR_TEACH_IND

PREP_TEACHER_ENROLLMENT_DESC Describes teacher certification enrollment. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

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

SUBSIDIZED_LOAN_EXCLUSION_AMT VA Chapter 30 or Americorp amount that should be excluded from subsidized loan eligibility. NUMBER(5)
RORSTAT

RORSTAT_SUB_LOAN_EXCL_AMT

SYSTEM_IND Specifies whether the award was system or manually generated. VARCHAR2(1)
RPRAWRD

RPRAWRD_SYS_IND

SYSTEM_IND_DESC System description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

TOTAL_ACCEPT_AMOUNT Total amount accepted for this fund. NUMBER(11,2)
RPRAWRD

RPRAWRD_ACCEPT_AMT

TOTAL_ACCEPT_DATE Date the award was accepted. DATE
RPRAWRD

RPRAWRD_ACCEPT_DATE

TOTAL_DECLINE_AMOUNT Total amount offered and then declined for this fund. NUMBER(11,2)
RPRAWRD

RPRAWRD_DECLINE_AMT

TOTAL_DECLINE_DATE Date that the award was declined. DATE
RPRAWRD

RPRAWRD_DECLINE_DATE

TOTAL_OFFER_AMOUNT Total amount offered for this fund. NUMBER(11,2)
RPRAWRD

RPRAWRD_ORIG_OFFER_AMT

TOTAL_ORIGINAL_OFFER_DATE Date that the original offer of the award was made. DATE
RPRAWRD

RPRAWRD_ORIG_OFFER_DATE

TOTAL_PAID_AMOUNT Total amount offered and then paid from this fund. NUMBER(11,2)
RPRAWRD

RPRAWRD_PAID_AMT

TOTAL_PAID_DATE Date that the award was paid. DATE
RPRAWRD

RPRAWRD_PAID_DATE

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

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

UNMET_NEED_OVERRIDE_DESC Unmet need override description. VARCHAR2(30)
FUNCTION

GOKODSF.F_GET_DESC

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)
RPRAWRD

RPRAWRD_USER_ID

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)
NA

NA

Ver: 8.1

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
ACADEMIC_YEAR_OVERRIDE	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(1)	RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL
ACADEMIC_YEAR_OVERRIDE_DESC	Year in college override description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ACTIVITY_DATE	Date record was inserted or updated	DATE	RPRAWRD	RPRAWRD_ACTIVITY_DATE
ADDITIONAL_STAFFORD_AWARDS	Indicates if the applicant is eligible for additional Stafford awards.	VARCHAR2(1)	RORSTAT2	RORSTAT_ADDL_STFD_ELIG_IND
ADDITIONAL_STAFFORD_AWRDS_DESC	Additional Stafford awards description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
AID_PERIOD	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(6)	RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(30)	RTVAPRD	RTVAPRD_DESC
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)	RPRAWRD	RPRAWRD_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC
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
ANNUAL_AWARD_AUTHORIZE_AMOUNT	Authorized amount of financial aid for this fund.	NUMBER(11,2)	RPRAWRD	RPRAWRD_AUTHORIZE_AMT
ANNUAL_AWARD_AUTHORIZE_DATE	Date of the award authorization.	DATE	RPRAWRD	RPRAWRD_AUTHORIZE_DATE
ANNUAL_AWARD_CANCEL_AMOUNT	Total amount of this fund that was offered and or accepted by the students and then canceled.	NUMBER(11,2)	RPRAWRD	RPRAWRD_CANCEL_AMT
ANNUAL_AWARD_CANCEL_DATE	Date that the award was cancelled.	DATE	RPRAWRD	RPRAWRD_CANCEL_DATE
ANNUAL_AWARD_LAST_WEB_UPDATE	Date the award was last updated by web activity.	DATE	RPRAWRD	RPRAWRD_LAST_WEB_UPDATE
ANNUAL_AWARD_LOCKED	Aid year based lock code.	VARCHAR2(1)	RPRAWRD	RPRAWRD_LOCK_IND
ANNUAL_AWARD_LOCKED_DESC	Annual award locked description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ANNUAL_AWARD_MEMO_AMOUNT	Displays the amount of the memo'd or authorized award.	NUMBER(11,2)	RPRAWRD	RPRAWRD_MEMO_AMT
ANNUAL_AWARD_MEMO_DATE	Date of the memo'd award.	DATE	RPRAWRD	RPRAWRD_MEMO_DATE
AWARD_OFFER_EXPIRATION_DATE	Expiration date of the award offer.	DATE	RPRAWRD	RPRAWRD_OFFER_EXP_DATE
AWARD_STATUS	Current status for the financial aid award.	VARCHAR2(4)	RPRAWRD	RPRAWRD_AWST_CODE
AWARD_STATUS_DATE	Date that the financial aid award status was changed.	DATE	RPRAWRD	RPRAWRD_AWST_DATE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
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
FUND	Fund code to be associated with information in this record.	VARCHAR2(6)	RPRAWRD	RPRAWRD_FUND_CODE
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
FUND_TITLE	Fund code description or title.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
GROSS_NEED	Applicant's gross need defined as budget minus EFC, minus resources.	NUMBER(11,2)	RORSTAT	RORSTAT_GRS_NEED
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
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
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_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
OFFER_AMOUNT	Maintains the current amount of the award fund offered.	NUMBER(11,2)	RPRAWRD	RPRAWRD_OFFER_AMT
OFFER_DATE	Date the award was offered.	DATE	RPRAWRD	RPRAWRD_OFFER_DATE
PACKAGE_COMPLETE_DATE	Date the student's financial aid package was complete.	DATE	RORSTAT	RORSTAT_PCKG_COMP_DATE
PACKAGE_REQUIRE_COMPLETE_DATE	Date that tracking requirements were satisfied for packaging.	DATE	RORSTAT	RORSTAT_PCKG_REQ_COMP_DATE
PACKAGING_GROUP	Assigned packaging group for this financial aid applicant.	VARCHAR2(6)	RORSTAT	RORSTAT_PGRP_CODE
PACKAGING_GROUP_DESC	Code description assigned to the packaging group.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PELL_ORIGINATION_IND	Indicates an updated Pell origination record is to be created.	VARCHAR2(1)	RORSTAT	RORSTAT_PELL_ORIG_IND
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	RPRAWRD	RPRAWRD_PIDM
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
PREP_TEACHER_ENROLLMENT	Indicates if loan limits should be different due to teacher certification enrollment.	VARCHAR2(1)	RORSTAT	RORSTAT_PREP_OR_TEACH_IND
PREP_TEACHER_ENROLLMENT_DESC	Describes teacher certification enrollment.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
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
SUBSIDIZED_LOAN_EXCLUSION_AMT	VA Chapter 30 or Americorp amount that should be excluded from subsidized loan eligibility.	NUMBER(5)	RORSTAT	RORSTAT_SUB_LOAN_EXCL_AMT
SYSTEM_IND	Specifies whether the award was system or manually generated.	VARCHAR2(1)	RPRAWRD	RPRAWRD_SYS_IND
SYSTEM_IND_DESC	System description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
TOTAL_ACCEPT_AMOUNT	Total amount accepted for this fund.	NUMBER(11,2)	RPRAWRD	RPRAWRD_ACCEPT_AMT
TOTAL_ACCEPT_DATE	Date the award was accepted.	DATE	RPRAWRD	RPRAWRD_ACCEPT_DATE
TOTAL_DECLINE_AMOUNT	Total amount offered and then declined for this fund.	NUMBER(11,2)	RPRAWRD	RPRAWRD_DECLINE_AMT
TOTAL_DECLINE_DATE	Date that the award was declined.	DATE	RPRAWRD	RPRAWRD_DECLINE_DATE
TOTAL_OFFER_AMOUNT	Total amount offered for this fund.	NUMBER(11,2)	RPRAWRD	RPRAWRD_ORIG_OFFER_AMT
TOTAL_ORIGINAL_OFFER_DATE	Date that the original offer of the award was made.	DATE	RPRAWRD	RPRAWRD_ORIG_OFFER_DATE
TOTAL_PAID_AMOUNT	Total amount offered and then paid from this fund.	NUMBER(11,2)	RPRAWRD	RPRAWRD_PAID_AMT
TOTAL_PAID_DATE	Date that the award was paid.	DATE	RPRAWRD	RPRAWRD_PAID_DATE
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
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
UNMET_NEED_OVERRIDE_DESC	Unmet need override description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RPRAWRD	RPRAWRD_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA