Reporting View Target: FINAID_BUDGET

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	(Banner EDW Source Report)
	Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FINAID_BUDGET_COMPONENT

Description Contains the budget component details for the person for the budget group assigned for the aid year. Details may include budget type, budget component amount, total budget.
Key & Frequency One row per aid year per budget type per budget component per budget group per person.
Recommended Search Columns AID_YEAR, PERSON_UID, BUDGET_TYPE, BUDGET_COMPONENT

Target Column Business Definition Database Data Type Source Name Source Column

ACADEMIC_PERIOD Academic period associated with this record. VARCHAR2(63)
FUNCTION

MRKFUNC.F_GET_ACADEMIC_PERIOD

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)
FUNCTION

MRKFUNC.F_GET_ACADEMIC_PERIOD

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

NA

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(63)
RORSTAT

RORSTAT_APRD_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

RBRAPBC_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

ALTERNATIVE_PELL_IND Indicates whether to use the amount associated with this flag in the calculation for eligibility for the alternate Pell schedule. No longer used after the 2007-2008 aid year. VARCHAR2(1)
RTVCOMP

RTVCOMP_ALTERNATE_PELL_IND

BUDGET_COMPONENT Source of the expense in the student's budget. VARCHAR2(63)
RBRAPBC

RBRAPBC_PBCP_CODE

BUDGET_COMPONENT_AMOUNT Amount of this particular budget component. NUMBER
RBRAPBC

RBRAPBC_AMT

BUDGET_COMPONENT_DESC Budget component code description. VARCHAR2(255)
RTVPBCP

RTVPBCP_DESC

BUDGET_COMP_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE
RBRACMP
RBRAPBC

RBRACMP_ACTIVITY_DATE
RBRAPBC_ACTIVITY_DATE

BUDGET_COMP_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(63)
RBRACMP
RBRAPBC

RBRACMP_DATA_ORIGIN
RBRAPBC_DATA_ORIGIN

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

RBRACMP_USER_ID
RBRAPBC_USER_ID

BUDGET_GROUP Student's assigned budget group. VARCHAR2(63)
RORSTAT

RORSTAT_BGRP_CODE

BUDGET_GROUP_DESC Budget group code description. Identifies what it represents. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

BUDGET_TFC_IND Show which total family contribution is to be used for this student when calculating need. For example, Federal or Institutional methodology. VARCHAR2(1)
RBRPBTP

RBRPBTP_EFC_IND

BUDGET_TYPE Budget types associated with the financial aid applicant. VARCHAR2(63)
RBRACMP

RBRACMP_BTYP_CODE

BUDGET_TYPE_DESC Budget type description. VARCHAR2(255)
RTVBTYP

RTVBTYP_DESC

BUDGET_TYPE_PELL_IND Indicates whether the budget type being defined is a Pell budget type. VARCHAR2(1)
RBRPBTP

RBRPBTP_PELL_IND

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

MGKFUNC.F_GET_PERSON_INFO

MIXED_BUDGET_IND Indicates if the student applicant has data in the mixed enrollment table. VARCHAR2(1)
FUNCTION

F_RBRMIXD_DATA

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

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. 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

PELL_LESS_THAN_HALF_IND Indicates that the budget component is used to calculate less than half time Pell budgets. VARCHAR2(1)
RBRPBCP

RBRPBCP_PELL_LT_HALF_IND

PERIOD_BUDGET_ENABLED_IND Indicates whether period (aid enrollment period) budgeting is enabled. VARCHAR2(1)
ROBINST

ROBINST_PERIOD_BUDGET_ENABLED

PERIOD_BUDGET_IND Indicates whether budget was created from period (aid enrollment period) budget component tables (Y) or aid year budget component tables (N). VARCHAR2(1)
CONSTANT

'Y' OR 'N'

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

RBRAPBC_PIDM

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

NA

TOTAL_BUDGET Sum of all the budget components for the budget type. NUMBER
FUNCTION

F_CALC_TOTAL_BUDGET

Ver: 8.4.1

Description	Contains the budget component details for the person for the budget group assigned for the aid year. Details may include budget type, budget component amount, total budget.
Key & Frequency	One row per aid year per budget type per budget component per budget group per person.
Recommended Search Columns	AID_YEAR, PERSON_UID, BUDGET_TYPE, BUDGET_COMPONENT

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period associated with this record.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_ACADEMIC_PERIOD
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_ACADEMIC_PERIOD
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_PERIOD	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)	RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RBRAPBC	RBRAPBC_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ALTERNATIVE_PELL_IND	Indicates whether to use the amount associated with this flag in the calculation for eligibility for the alternate Pell schedule. No longer used after the 2007-2008 aid year.	VARCHAR2(1)	RTVCOMP	RTVCOMP_ALTERNATE_PELL_IND
BUDGET_COMPONENT	Source of the expense in the student's budget.	VARCHAR2(63)	RBRAPBC	RBRAPBC_PBCP_CODE
BUDGET_COMPONENT_AMOUNT	Amount of this particular budget component.	NUMBER	RBRAPBC	RBRAPBC_AMT
BUDGET_COMPONENT_DESC	Budget component code description.	VARCHAR2(255)	RTVPBCP	RTVPBCP_DESC
BUDGET_COMP_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	RBRACMP RBRAPBC	RBRACMP_ACTIVITY_DATE RBRAPBC_ACTIVITY_DATE
BUDGET_COMP_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	RBRACMP RBRAPBC	RBRACMP_DATA_ORIGIN RBRAPBC_DATA_ORIGIN
BUDGET_COMP_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RBRACMP RBRAPBC	RBRACMP_USER_ID RBRAPBC_USER_ID
BUDGET_GROUP	Student's assigned budget group.	VARCHAR2(63)	RORSTAT	RORSTAT_BGRP_CODE
BUDGET_GROUP_DESC	Budget group code description. Identifies what it represents.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
BUDGET_TFC_IND	Show which total family contribution is to be used for this student when calculating need. For example, Federal or Institutional methodology.	VARCHAR2(1)	RBRPBTP	RBRPBTP_EFC_IND
BUDGET_TYPE	Budget types associated with the financial aid applicant.	VARCHAR2(63)	RBRACMP	RBRACMP_BTYP_CODE
BUDGET_TYPE_DESC	Budget type description.	VARCHAR2(255)	RTVBTYP	RTVBTYP_DESC
BUDGET_TYPE_PELL_IND	Indicates whether the budget type being defined is a Pell budget type.	VARCHAR2(1)	RBRPBTP	RBRPBTP_PELL_IND
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MIXED_BUDGET_IND	Indicates if the student applicant has data in the mixed enrollment table.	VARCHAR2(1)	FUNCTION	F_RBRMIXD_DATA
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	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
PELL_LESS_THAN_HALF_IND	Indicates that the budget component is used to calculate less than half time Pell budgets.	VARCHAR2(1)	RBRPBCP	RBRPBCP_PELL_LT_HALF_IND
PERIOD_BUDGET_ENABLED_IND	Indicates whether period (aid enrollment period) budgeting is enabled.	VARCHAR2(1)	ROBINST	ROBINST_PERIOD_BUDGET_ENABLED
PERIOD_BUDGET_IND	Indicates whether budget was created from period (aid enrollment period) budget component tables (Y) or aid year budget component tables (N).	VARCHAR2(1)	CONSTANT	'Y' OR 'N'
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RBRAPBC	RBRAPBC_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TOTAL_BUDGET	Sum of all the budget components for the budget type.	NUMBER	FUNCTION	F_CALC_TOTAL_BUDGET