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

SGHE Banner Operational Data Store
Composite View Target: AR_APPLICANT_RESOURCE

Description Contains Financial Aid resource information and amounts available to financial aid applicants.
Key & Frequency One row per aid year per person per resource type per resource number.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period associated with the applicant's resources. VARCHAR2(6)

RPRARSC

RPRARSC_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Date record was inserted or updated DATE

RPRARSC

RPRARSC_ACTIVITY_DATE

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)

RPRARSC

RPRARSC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

ROBINST

ROBINST_AIDY_DESC

APPLICANT_RESOURCE Code defining a financial aid resource. VARCHAR2(6)

RPRARSC

RPRARSC_ARSC_CODE

APPLICANT_RESOURCE_DESC Description of the financial aid resource in this record. VARCHAR2(50)

RPRARSC

RTVARSC

RPRARSC_RESOURCE_DESC

RTVARSC_ARSC_DESC

CURRENT_DATE The current date for which this data was extracted. DATE

NA

SYSDATE

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

NA

NA

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

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

RPRARSC

RPRARSC_PIDM

RESOURCE_ACTUAL_AMOUNT Actual amount of the resource for the student in this record. NUMBER(11,2)

RPRARSC

RPRARSC_ACTUAL_AMT

RESOURCE_ESTIMATED_AMOUNT Estimated amount of the resource if the actual amount is not available. NUMBER(11,2)

RPRARSC

RPRARSC_EST_AMT

RESOURCE_NUMBER System generated number. NUMBER(2)

RPRARSC

RPRARSC_RESOURCE_NUMBER

RESOURCE_TYPE Type code associated with the resource code in this record. VARCHAR2(1)

RPRARSC

RPRARSC_TYPE_CODE

RESOURCE_TYPE_DESC Resource type description. VARCHAR2(10)

CALCULATION

DECODE(RPRARSC_TYPE_CODE)

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

RPRARSC

RPRARSC_USER_ID

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

NA

NA



Ver: 8.0