Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: 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(63)

RPRARSC

RPRARSC_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Date record was inserted or updated DATE

RPRARSC

RPRARSC_ACTIVITY_DATE

ADMINISTRATIVE_GROUP The institution value of the organization-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

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

RPRARSC

RPRARSC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

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

RPRARSC

RPRARSC_ARSC_CODE

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

RPRARSC

RTVARSC

RPRARSC_RESOURCE_DESC

RTVARSC_ARSC_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RPRARSC

RPRARSC_PIDM

PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA

RESOURCE_ACTUAL_AMOUNT Actual amount of the resource for the student in this record. NUMBER

RPRARSC

RPRARSC_ACTUAL_AMT

RESOURCE_ESTIMATED_AMOUNT Estimated amount of the resource if the actual amount is not available. NUMBER

RPRARSC

RPRARSC_EST_AMT

RESOURCE_NUMBER System generated number. NUMBER

RPRARSC

RPRARSC_RESOURCE_NUMBER

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

RPRARSC

RPRARSC_TYPE_CODE

RESOURCE_TYPE_DESC Resource type description. VARCHAR2(255)

CALCULATION

DECODE(RPRARSC_TYPE_CODE)

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

RPRARSC

RPRARSC_USER_ID



Ver: 8.0