Go To View:  RETURN TO BANNER ODS META DATA 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.
Recommended Search Columns AID_YEAR, PERSON_UID, RESOURCE_TYPE, RESOURCE_NUMBER
AID_YEAR, APPLICANT_RESOURCE

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

RPRARSC

RPRARSC_TERM_CODE

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

STVTERM

STVTERM_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated DATE  

RPRARSC

RPRARSC_ACTIVITY_DATE

ADMINISTRATIVE_GROUP 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 Financial 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 Description Financial aid year name. VARCHAR2(255)  

ROBINST

ROBINST_AIDY_DESC

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

RPRARSC

RPRARSC_ARSC_CODE

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

RPRARSC

RTVARSC

RPRARSC_RESOURCE_DESC

RTVARSC_ARSC_DESC

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTI_SOURCE 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 Multi Source Description 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 Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER  

RPRARSC

RPRARSC_PIDM

PROCESS_GROUP 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 Resource Actual Amount Actual amount of the resource for the student in this record. NUMBER  

RPRARSC

RPRARSC_ACTUAL_AMT

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

RPRARSC

RPRARSC_EST_AMT

RESOURCE_NUMBER Resource Number System generated number. NUMBER  

RPRARSC

RPRARSC_RESOURCE_NUMBER

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

RPRARSC

RPRARSC_TYPE_CODE

RESOURCE_TYPE_DESC Resource Type Description Resource type description. VARCHAR2(255)  

CALCULATION

DECODE(RPRARSC_TYPE_CODE)

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

RPRARSC

RPRARSC_USER_ID



Ver: 9.0