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

SGHE Banner Operational Data Store
Composite View Target: AR_AWARD_BY_PERSON

Description Source composite view contains each applicant and award information for each fund and time indication.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(6)

RPRATRM

RPRATRM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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(15)    
ACTIVITY_DATE Date record was inserted or updated. DATE

RPRATRM

RPRATRM_ACTIVITY_DATE

AID_ENROLLMENT_PERIOD   VARCHAR2(15)    
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

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(30)

RTVAPRD

RTVAPRD_DESC

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

RPRATRM

RPRATRM_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

ROBINST

ROBINST_AIDY_DESC

ANNUAL_AWARD_LOCKED Aid year based lock code. VARCHAR2(1)

RPRAWRD

RPRAWRD_LOCK_IND

ANNUAL_AWARD_LOCKED_DESC Annual award locked description. VARCHAR2(55)

CALCULATION

DECODE(RPRAWRD_LOCK_IND)

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

RPRATRM

RPRATRM_ACCEPT_AMT

AWARD_ACCEPT_DATE Date that the award was accepted. DATE

RPRATRM

RPRATRM_ACCEPT_DATE

AWARD_ACCEPT_IND Indicates whether the person accepted this financial aid award. VARCHAR2(1)

RTVAWST

RTVAWST_ACCEPT_IND

AWARD_AUTHORIZE_AMOUNT Authorized amount for the financial aid fund for the person. NUMBER

RPRATRM

RPRATRM_AUTHORIZE_AMT

AWARD_AUTHORIZE_DATE Date of the award authorization. DATE

RPRATRM

RPRATRM_AUTHORIZE_DATE

AWARD_CANCEL_AMOUNT Canceled amount for the financial aid fund for the person. NUMBER

RPRATRM

RPRATRM_CANCEL_AMT

AWARD_CANCEL_DATE Date that the award was cancelled. DATE

RPRATRM

RPRATRM_CANCEL_DATE

AWARD_CANCEL_IND Indicates whether this financial aid award was canceled. VARCHAR2(1)

RTVAWST

RTVAWST_CANCEL_IND

AWARD_DECLINE_AMOUNT Declined amount for the financial aid award for the person. NUMBER

RPRATRM

RPRATRM_DECLINE_AMT

AWARD_DECLINE_DATE Date that the award was declined. DATE

RPRATRM

RPRATRM_DECLINE_DATE

AWARD_DECLINE_IND Indicates whether this financial aid award was declined. VARCHAR2(1)

RTVAWST

RTVAWST_DECLINE_IND

AWARD_LOAD_MISMATCH_IND Indicates that the package load does not match any of the disbursement load indicators. VARCHAR2(1)

FUNCTION

ROKODSF.F_GET_PCKG_LOAD_IND

AWARD_LOCKED Academic period based lock code. VARCHAR2(1)

RPRATRM

RPRATRM_LOCK_IND

AWARD_LOCKED_DESC Award locked description. VARCHAR2(55)

CALCULATION

DECODE(RPRATRM_LOCK_IND)

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_EXPIRATION_DATE Date that the memo will be cancelled. DATE

RPRATRM

RPRATRM_MEMO_DATE

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

RPRATRM

RPRATRM_OFFER_AMT

AWARD_OFFER_DATE Date that the current award was offered. DATE

RPRATRM

RPRATRM_OFFER_DATE

AWARD_OFFER_IND Indicates whether this financial aid award was offered. VARCHAR2(1)

RTVAWST

RTVAWST_OFFER_IND

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 Date that the original offer of the award was made. DATE

RPRATRM

RPRATRM_ORIG_OFFER_DATE

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

RPRATRM

RPRATRM_PAID_AMT

AWARD_PAID_DATE Date that the award was paid. DATE

RPRATRM

RPRATRM_PAID_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

AWARD_STATUS_DESC Description for the financial aid status. VARCHAR2(30)

RTVAWST

RTVAWST_DESC

CALC_STUDENT_ADJ_CREDITS Calculates and displays the student's adjusted credits for the academic period. NUMBER

FUNCTION

ROKODSF.F_SUM_CALC_STUD_ADJ_HRS

CALC_STUDENT_BILLING_HOURS Calculates and displays the student's billing hours for the academic period. NUMBER

FUNCTION

ROKODSF.F_SUM_CALC_STUD_BILL_HRS

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

NA

SYSDATE

DISBURSEMENT_FINALIZE_IND Indicates whether all disbursements have been made within the academic period. VARCHAR2(1)

RPRATRM

RPRATRM_DISB_FINAL_IND

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. 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 Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

RPRATRM

RPRATRM_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 Full title of the financial aid fund code. VARCHAR2(30)

RFRBASE

RFRBASE_FUND_TITLE

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

FUNCTION

F_INST_AID_FNC

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. 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

PELL_AWARD_ENROLLMENT_OPTION Source of the enrollment option when calculating a PELL award. VARCHAR2(1)

RPRATRM

RPRATRM_PELL_AWRD_LOAD_OPT

PELL_AWARD_ENROLLMENT_OPT_DESC Source of the enrollment option description. VARCHAR2(25)    
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RPRATRM

RPRATRM_PIDM

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

RPRATRM

RPRATRM_CIP_OVERRIDE_CODE

PROGRAM_CLASS_OVR_DESC CIP override description. VARCHAR2(100)

FUNCTION

ROKODSF.F_GET_CIPC_DESC

REPLACE_TFC_OVERRIDE_IND Used to override the rule to replace Total Family Contribution when manually adding the award to the students' record. VARCHAR2(1)

RPRAWRD

RPRAWRD_REPLACE_TFC_OVRDE_IND

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(6)

RORPRDS

RORPRDS_TERM_CODE

STUDENT_ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

STUDENT_LOAN_OVERRIDE Indicates which validation tests Packaging/Disbursment processes should override for a specific Year/Student/Fund/Academic Period. VARCHAR2(1)

RPRATRM

RPRATRM_NSLDS_OVRD_IND

STUDENT_LOAN_OVERRIDE_DESC Student loan override description. VARCHAR2(25)    
SYSTEM Specifies whether the award was system or manually generated. VARCHAR2(1)

RPRAWRD

RPRAWRD_SYS_IND

SYSTEM_DESC System description. VARCHAR2(6)

CALCULATION

DECODE(RPRAWRD_SYS_IND)

TERM_PERCENT_OF_DISTRIBUTION Distribution of the award over the academic periods associated with the record. NUMBER

RPRATRM

RPRATRM_DIST_PCT

TIME_STATUS Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time. VARCHAR2(1)

RPRATRM

RPRATRM_PCKG_LOAD_IND

TIME_STATUS_DESC Description of Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time. VARCHAR2(20)    
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(4)    
USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

RPRATRM

RPRATRM_USER_ID

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: