The RZVPBGP view assists in the creation of period budget group assignment rules by providing a consistent view of the appropriate student data. It provides one record per period in the student's aid period for a given aid year. The view handles determining which student data to gather for any given period. If the student has an Admissions record for the given term, data from that Admissions record is used. If the student has both a Student record and an Admissions record for any term term in the Aid Year, the view will use data from whichever record has most recent term code. If the student is missing either a Student record or an Admissions record, the other will be used.
The RZVPBGP contains the folowing fields:
- Student's PIDM
- Aid Year Code
- Aid Period Code
- Period Code
- Term Code (The term code associated with the student module for the period)
- Term Start Date
- Module (Either 'A' for Admissions or 'S' for Student depending on which record is used for the period.)
- Term Code of the Record (May be earlier than the term code associate with the period)
- Level Code
- Student Type Code
- Primary Major Code
- Admit Code
- Latest Decision Code
- Student Status Code
- Class Code
- Billing Hours
- Housing Code
The MC_FA_UTIL package contains the following helper functions used in the RZVPBGP view.
Returns the latest decision code for an Admissions application.
Returns the ROWID of the effective student record.
Returns the ROWID of the Admissions application for a given term
Returns the ROWID of the most recent Admissions application for a given Aid Year.
The MC_FA_BUDGET package contains helper functions used in Algorithmic budget rules. Most of the functions look up information from RORALGS.
Return the art fee amount from RORALGS. Accepts Aid Year Code and Budget Type Code as parameters.
Return the nursing fee amount from RORALGS. Accepts Aid Year Code, Budget Type Code, and Class Code as parameters.
Return the music fee amount from RORALGS. Accepts Aid Year Code and Budget Type Code as parameters.
Return the loan fees amount from RORALGS. Accepts Aid Year Code and Budget Type Code as parameters.
Return the graduate tuition rate per hour from RORALGS. Accepts Aid Year Code and Tuition Group as parameters.
Return the graduate technology fee from RORALGS. Accepts Aid Year Code as a parameter.
Return the graduate room amount for standard courses from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the graduate board amount for standard courses from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the graduate books allowance from RORALGS. Accepts Aid Year Code as a parameter.
Return the graduate travel allowance from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the graduate personal allowance from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the graduate room amount for intensive courses from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the graduate board amount for intensive courses from RORALGS. Accepts Aid Year Code and Billing Hours as parameters.
Return the undergraduate part-time tuition rate from RORALGS. Accepts Aid Year Code as a parameter.
Return the undergraduate overloaded tuition rate from RORALGS. Accepts Aid Year Code as a parameter.
Example Period Budget Group Assignment Rules show methods of grouping students.
Example Algorithmic Rules show methods of calculating various budget components, including looking up values from RORALGS, calculating amounts based on the number of credits a student is taking, calculating amounts based on the number of courses the student is taking, and others.