Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: AWARD_BY_PERSON

Description Contains detail data for each person who was made an offer of a financial aid fund award within the aid year. Details may includes person, aid enrollment period, financial aid fund, fund source, fund type, fund detail code, award status, disbursement finalize indicator and award amount information. Also the accounts receivable and student academic periods.
Key & Frequency One row per person per aid year and per fund.
Recommended Search Columns PERSON_UID, FUND, AID_ENROLLMENT_PERIOD
AID_ENROLLMENT_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
ACADEMIC_PERIOD
AID_YEAR, FUND_SOURCE
FUND, AID_YEAR

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic Period Academic period representing the accounts receivable term for disbursement. VARCHAR2(63)

RPRATRM

RPRATRM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR_OVERRIDE Academic Year Override Academic year to use for ACG and SMART Grant eligibility. VARCHAR2(63)

RPRAWRD

RPRAWRD_OVERRIDE_YR_IN_COLL

ACADEMIC_YEAR_OVERRIDE_DESC Academic Year Override Description Year in college override description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

RPRATRM

RPRATRM_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_ENROLLMENT_PERIOD Aid Enrollment Period Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

RPRATRM

RPRATRM_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid Enrollment Period Description Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

AID_PERIOD 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

AID_PERIOD_DESC Aid Period Description Financial Aid period description. VARCHAR2(255)

RTVAPRD

RTVAPRD_DESC

AID_YEAR Financial Aid Year Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

CALCULATION

RPRATRM

NVL(RPRATRM_AIDY_CODE_FUNDS, RPRATRM_AIDY_CODE)

RPRATRM_AIDY_CODE

AID_YEAR_DESC Aid Year Description Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

ANNUAL_AWARD_LOCKED Annual Award Locked Aid year based lock code. VARCHAR2(63)

RPRAWRD

RPRAWRD_LOCK_IND

ANNUAL_AWARD_LOCKED_DESC Annual Award Locked Description Annual award locked description. VARCHAR2(255)

CALCULATION

DECODE(RPRAWRD_LOCK_IND)

AWARD_ACCEPT_AMOUNT Award Accept Amount Accepted amount for the financial aid fund that was accepted by students. NUMBER

RPRATRM

RPRATRM_ACCEPT_AMT

AWARD_ACCEPT_DATE Award Accept Date Date that the award was accepted. DATE

RPRATRM

RPRATRM_ACCEPT_DATE

AWARD_ACCEPT_IND Award Accept Indicator Indicates whether the person accepted this financial aid award. VARCHAR2(63)

RTVAWST

RTVAWST_ACCEPT_IND

AWARD_AUTHORIZE_AMOUNT Award Authorize Amount Authorized amount for the financial aid fund for the person. NUMBER

RPRATRM

RPRATRM_AUTHORIZE_AMT

AWARD_AUTHORIZE_DATE Award Authorize Date Date of the award authorization. DATE

RPRATRM

RPRATRM_AUTHORIZE_DATE

AWARD_BY_PERSON_DATA_ORIGIN Award By Person Data Origin Source system that created or updated the data. VARCHAR2(63)

RPRATRM

RPRATRM_DATA_ORIGIN

AWARD_CANCEL_AMOUNT Award Cancel Amount Canceled amount for the financial aid fund for the person. NUMBER

RPRATRM

RPRATRM_CANCEL_AMT

AWARD_CANCEL_DATE Award Cancel Date Date that the award was cancelled. DATE

RPRATRM

RPRATRM_CANCEL_DATE

AWARD_CANCEL_IND Award Cancel Indicator Indicates whether this financial aid award was canceled. VARCHAR2(63)

RTVAWST

RTVAWST_CANCEL_IND

AWARD_DECLINE_AMOUNT Award Decline Amount Declined amount for the financial aid award for the person. NUMBER

RPRATRM

RPRATRM_DECLINE_AMT

AWARD_DECLINE_DATE Award Decline Date Date that the award was declined. DATE

RPRATRM

RPRATRM_DECLINE_DATE

AWARD_DECLINE_IND Award Decline Indicator Indicates whether this financial aid award was declined. VARCHAR2(63)

RTVAWST

RTVAWST_DECLINE_IND

AWARD_LOAD_MISMATCH_IND Award Load Mismatch Indicator Indicates that the package load does not match any of the disbursement load indicators. VARCHAR2(63)

FUNCTION

ROKODSF.F_GET_PCKG_LOAD_IND

AWARD_LOCKED Award Locked Academic period based lock code. VARCHAR2(63)

RPRATRM

RPRATRM_LOCK_IND

AWARD_LOCKED_DESC Award Locked Description Award locked description. VARCHAR2(255)

CALCULATION

DECODE(RPRATRM_LOCK_IND)

AWARD_MEMO_AMOUNT Award Memo Amount Memo amount for the financial aid award for the person. This amount is intended but does not yet fit into any of the other financial aid amount groupings. NUMBER

RPRATRM

RPRATRM_MEMO_AMT

AWARD_MEMO_DATE Award Memo Date Date that the award was memoed. DATE

RPRATRM

RPRATRM_MEMO_DATE

AWARD_MEMO_EXPIRATION_DATE Award Memo Expiration Date Date that the memo will be cancelled. DATE

RPRATRM

RPRATRM

RPRATRM_MEMO_DATE

RPRATRM_MEMO_EXP_DATE

AWARD_OFFER_AMOUNT Award Offer Amount Current offered amount for the financial aid award for the person. NUMBER

RPRATRM

RPRATRM_OFFER_AMT

AWARD_OFFER_DATE Award Offer Date Date that the current award was offered. DATE

RPRATRM

RPRATRM_OFFER_DATE

AWARD_OFFER_EXPIRATION_DATE Award Offer Expiration Date Expiration date of the award offered. DATE

RPRATRM

RPRATRM_OFFER_EXP_DATE

AWARD_OFFER_IND Award Offer Indicator Indicates whether this financial aid award was offered. VARCHAR2(63)

RTVAWST

RTVAWST_OFFER_IND

AWARD_ORIGINAL_OFFER_AMOUNT Award Original Offer Amount Dollar amount of the original offer of this fund code for this academic period. NUMBER

RPRATRM

RPRATRM_ORIG_OFFER_AMT

AWARD_ORIGINAL_OFFER_DATE Award Original Offer Date Date that the original offer of the award was made. DATE

RPRATRM

RPRATRM_ORIG_OFFER_DATE

AWARD_PAID_AMOUNT Award Paid Amount Paid or disbursed amount for the financial aid award for the person. NUMBER

RPRATRM

RPRATRM_PAID_AMT

AWARD_PAID_DATE Award Paid Date Date that the award was paid. DATE

RPRATRM

RPRATRM_PAID_DATE

AWARD_STATUS Award Status Current status for the financial aid award. VARCHAR2(63)

RPRATRM

RPRATRM_AWST_CODE

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

RPRATRM

RPRATRM_AWST_DATE

AWARD_STATUS_DESC Award Status Description Description for the financial aid status. VARCHAR2(255)

RTVAWST

RTVAWST_DESC

BBAY_TYPE Bbay Type Borrower-Based Academic Year type. VARCHAR2(63)

ROBBBAY

ROBBBAY_BBTP_CODE

BBAY_TYPE_DESC Bbay Type Description Borrower-Based Academic Year type description. VARCHAR2(255)

RTVBBTP

RTVBBTP_DESC

BORROWER_BASED_ACADEMIC_YEAR Borrower Based Academic Year Borrower-Based Academic Year. VARCHAR2(63)

RPRATRM

RPRATRM_BBAY_CODE

BORROWER_BASED_ACAD_YEAR_DESC Borrower Based Academic Year Description Borrower-Based Academic Year description. VARCHAR2(255)

ROBBBAY

ROBBBAY_DESC

CALC_STUDENT_ADJ_CREDITS Calc Student Adjustment Credits Calculates and displays the student's adjusted credits for the aid enrollment period. NUMBER

FUNCTION

ROKODSF.F_SUM_CALC_STUD_ADJ_HRS

CALC_STUDENT_BILLING_HOURS Calculate Student Billing Hours Calculates and displays the student's billing hours for the aid enrollment period. NUMBER

FUNCTION

ROKODSF.F_SUM_CALC_STUD_BILL_HRS

DISBURSEMENT_FINALIZE_IND Disbursement Finalize Indicator Indicates whether all disbursements have been made within the academic period. VARCHAR2(63)

RPRATRM

RPRATRM_DISB_FINAL_IND

DISBURSEMENT_RULE_OVERRIDE_IND Disbursement Rule Override Indicator Indicates whether the fund disbursement rule will be overridden when disbursing a fund to the student. VARCHAR2(63)

RPRATRM

RPRATRM_OVERRIDE_DISB_RULE

FEDERAL_FUND_ID Federal Fund ID Federal fund associated with the fund code. VARCHAR2(63)

RFRBASE

RFRBASE_FED_FUND_ID

FEDERAL_LIMIT_OVERRIDE_IND Federal Limit Override Indicator Used to override a federal limit on a fund when manually entering the award. VARCHAR2(63)

RPRAWRD

RPRAWRD_FED_LIMIT_OVRDE_IND

FUND Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

RPRATRM

RPRATRM_FUND_CODE

FUND_AID_YEAR Fund Financial Aid Year Aid year associated with the Borrower-Based Academic_Year for origination and funding. VARCHAR2(63)

RPRATRM

RPRATRM_AIDY_CODE_FUNDS

FUND_AID_YEAR_DESC Fund Financial Aid Year Description Fund's aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

FUND_DETAIL_CODE Fund Detail Code Links a financial aid fund code to an AR detail code for crediting funds to student accounts. VARCHAR2(63)

RFRBASE

RFRBASE_DETAIL_CODE

FUND_LIMIT_OVERRIDE_IND Fund Limit Override Indicator Used to override the fund limit when manually entering the fund on the students' award record. VARCHAR2(63)

RPRAWRD

RPRAWRD_FUND_LIMIT_OVRDE_IND

FUND_PERIOD_ENABLED_IND Fund Period Enabled Indicator Determines whether the fund is enabled for aid enrollment period awarding. VARCHAR2(1)

RFRASPC

RFRASPC_ENABLE_PERIOD_AWARDING

FUND_SOURCE Fund Source Fund source code to be associated with the fund as defined by the institution. VARCHAR2(63)

RFRBASE

RFRBASE_FSRC_CODE

FUND_SOURCE_DESC Fund Source Description Describes the fund source code and identifies what it represents. VARCHAR2(255)

RTVFSRC

RTVFSRC_DESC

FUND_TITLE Fund Title Full title of the financial aid fund code. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

FUND_TYPE Fund Type Fund type code to be associated with the fund as defined by the institution. VARCHAR2(63)

RFRBASE

RFRBASE_FTYP_CODE

FUND_TYPE_DESC Fund Type Description Fund type code description or title. VARCHAR2(255)

RTVFTYP

RTVFTYP_DESC

GIFT_OR_SELF_HELP_AID Gift or Self Help Aid Indicator Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work. VARCHAR2(63)

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

GIFT_OR_SELF_HELP_AID_DESC Gift or Self Help Aid Indicator Description Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid. VARCHAR2(255)

CALCULATION

DECODE(RTVFTYP_ATYP_IND)

ID 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

INSTITUTION_AID_IND Institution Aid Indicator Indicates whether the person is receiving a financial aid award that is identified with a financial aid fund type of as institution aid. VARCHAR2(63)

FUNCTION

F_INST_AID_FNC

MAJOR_OVERRIDE Major Override Major the student intends to major in if the school does not require students to declare a major by their junior year. VARCHAR2(63)

RPRATRM

RPRATRM_MAJR_OVERRIDE_CODE

MAJOR_OVERRIDE_DESC Major Override Description. Major override description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO_PELL_OVERRIDE_IND No Pell Override Indicator Indicates if the Pell award validation rule has been overridden for the ACG or SMART grant award. VARCHAR2(63)

RPRAWRD

RPRAWRD_OVERRIDE_NO_PELL

ORIGINAL_AID_YEAR Original Financial Aid Year Original aid year in the event the fund's aid year is used. VARCHAR2(63)

RPRATRM

RPRATRM_AIDY_CODE

ORIGINAL_AID_YEAR_DESC Original Financial Aid Year Description Original financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

PELL_AWARD_ENROLLMENT_OPTION Pell Award Enrollment Option Source of the enrollment option when calculating a PELL award. VARCHAR2(63)

RPRATRM

RPRATRM_PELL_AWRD_LOAD_OPT

PELL_AWARD_ENROLLMENT_OPT_DESC Pell Award Enrollment Option Description Source of the enrollment option description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

PERCENT_DISTRIBUTION_ACAD_PER Percent Distribution Acad Period Distribution of the award over the academic periods associated with the record. NUMBER

RPRATRM

RPRATRM_DIST_PCT

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

RPRATRM

RPRATRM_PIDM

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROGRAM_CLASSIFICATION_OVR Program Classification Override Used to override the CIP code associated with the student's current major to enable a SMART grant to disburse. VARCHAR2(63)

RPRATRM

RPRATRM_CIP_OVERRIDE_CODE

PROGRAM_CLASS_OVR_DESC Program Classification Override Description CIP override description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_CIPC_DESC

REPLACE_TFC_OVERRIDE_IND Replace TFC Override Indicator Used to override the rule to replace Total Family Contribution when manually adding the award to the students' record. VARCHAR2(63)

RPRAWRD

RPRAWRD_REPLACE_TFC_OVRDE_IND

STUDENT_ACADEMIC_PERIOD Student Academic Period Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student. VARCHAR2(63)

RORPRDS

RORPRDS_TERM_CODE

STUDENT_ACADEMIC_PERIOD_DESC Student Academic Period Description. Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

STUDENT_LOAN_OVERRIDE Student Loan Override Indicates which validation tests Packaging/Disbursement processes should override for a specific Year/Student/Fund/Academic Period. VARCHAR2(63)

RPRATRM

RPRATRM_NSLDS_OVRD_IND

STUDENT_LOAN_OVERRIDE_DESC Student Loan Override Description Student loan override description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

SYSTEM System Specifies whether the award was system or manually generated. VARCHAR2(63)

RPRAWRD

RPRAWRD_SYS_IND

SYSTEM_DESC System Description System description. VARCHAR2(255)

CALCULATION

DECODE(RPRAWRD_SYS_IND)

TIME_STATUS Time Status Identifies the student enrollment load at the time of packaging as either full time, three-quarter time, half time or less than half time. VARCHAR2(63)

RPRATRM

RPRATRM_PCKG_LOAD_IND

TIME_STATUS_DESC Time Status Description Description of the student enrollment load at the time of packaging as either full time, three-quarter time, half time or less than half time. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

TRACKING_REQ_OVERRIDE_IND Tracking Requirement Override Indicator Used to override the rule that all tracking requirements must be satisfied when manually adding the fund to the students' award record. VARCHAR2(63)

RPRAWRD

RPRAWRD_TREQ_OVRDE_IND

UNMET_NEED_OVERRIDE Unmet Need Override Used to override the unmet need rule when manually adding an award to the students' record. VARCHAR2(63)

RPRAWRD

RPRAWRD_UNMET_NEED_OVRDE_IND

UNMET_NEED_OVERRIDE_DESC Unmet Need Override Description Unmet need override description. VARCHAR2(255)

FUNCTION

ROKODSF.F_GET_RORMVAL_DESC

USER_ID User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RPRATRM

RPRATRM_USER_ID



Ver: 9.2