The illustration below is an example of variables used to determine a tuition charge.

Fee Code: TU Tuition

Charge Type: S 

·       The Table Name and Column Code combine to uniquely identify each column in the database.

·       The Use Range? column allows you to specify whether one entry should represent a range of numbers (for example, 12-15) (Yes) or if the entry is to be an exact match (No). The range is convenient for numeric columns like credit hours that contain hundreds of possible values. An exact match is preferable for coded columns that typically have only a handful of values. There are two requirements on the use of ranges:

o     For each fee code, only one of the five variable columns may be designated as a range.

o     The range column must be the last variable on the list.

·       The Use in Per Hour Calculation? column is used to identify the variable column that will be used to calculate the per hour charge. This column will serve as the student credit hours in the amount formula (only one of the variable columns can be designated as being used in the per hour calculation):

Transaction amt = Flat fee + (per hour charge * (student credit hours - # of hours excluded)

·       This Description column contains a code that combines the previous two columns. The usage code indicates whether the variable is used in the per hour calculation and whether it is a range column. The illustration below is used to determine the usage code for each variable column:

1. Use Range?	Use in Per Hour Calculation?	Usage Code
   Yes	No	R
   Yes	Yes	N
   No	No	(blank)
   No	Yes	M

If your organization simply uses three of the course components to determine course fees, your charge definition may look like this:

And your Charge Table may look like this:

If your organization has many courses that require extra fees, you may instead want to define a user-defined column on the Section Master table as Charge Type Code or something similar and use it as a variable in the charge definition. In this column you can designate different levels of charges. For example, a 1 might be a $40 lab fee and a 2 might be a $65 materials fee. For each course that requires one of these fees, have your Registrar enter the appropriate code in that column and set up your course charges as follows:

Each course charge allows you to determine whether or not the course number will be included in the last 17 characters of the transaction description. If you include the course number in the description and the text that you enter on the Charges Definition/Charges Detail Entry window for the charge and the description extends into the last 17 characters, the course number will overwrite it.