In order to have the system total the number of hours or courses that a student is registered to take, you must tell it how to calculate the totals.
· On the Hours Definition window, enter the table and columns to be looked at to determine hours or courses to total.
· On the Hours Definition window, enter values in those fields that determine which bucket to put the totals in and whether the total is for number of credit hours, tuition hours, course clock hours, or courses. Student Hours information can consist of credit hours count, tuition hours count, course clock hours, and course count. When the student charges process runs, the program calculates each student's number of hours or courses. This information is stored on the Student Hours/Courses table. The charge details can be set up to use buckets from this table to determine charge amounts.
· On the Hours Definition window, enter the table and columns to use in the accumulation of hours or courses for which the student is registered.
|
Is the student pre-registered for classes? Did the student drop any of their classes? The Transaction Status field on the Student Course History table indicates whether each class is current, pre-registered, dropped, etc; therefore, use this table/column when defining the element(s) on the Hours Definition window. Since dropped course hours should not be used in the accumulation of hours, the only valid values should be Current, Preregistered and possibly History (‘C','P','H'). |
The following general rules can be used to designate where to use the Division code:
· If the student can only take courses in one division at a time or if they can take courses in multiple divisions but are charged the same regardless of division, then use the division code in the Charges Detail table.
|
If we only need a total of credit hours, the Current Division column in the Charge Details table can be used to determine charges (Undergrad, Continuing Ed, or Graduate). Mary White is classified as an Undergrad student in the Current Division column. She is taking 15 hours of Undergrad courses and 3 hours of Graduate courses. The system looks at the total number of credit hours (18) and charges based on the Undergrad tuition fees. |
· If the students can take courses in different divisions in the same term and are charged differently for each, then place the course division code in the Hours Definition and Hours Detail tables and create a separate bucket on the Student Hours/Courses table for each. This creates a separate hours code for each division. Under this configuration, a student is charged for 15 hours at the Undergraduate rate and for 3 hours at the Graduate rate. In the Hours Definition, the system needs to check the Course Division column on the Student Course History table in order to keep different hour or course totals per division on the Student Hours/Courses table. This is in addition to the Transaction Status column mentioned above.
· Rather than using the Current Division at the Charge Table level, you may want to use the Course Division at the Hours Definition level, which implies that the student can take courses in different divisions in the same term and be charged based on the division of the course regardless of the students current division classification. You must configure the system to keep separate totals for each course division in which the student is registered. Therefore, we may want to have a separate hours code for each division.
Hours Code |
Description |
UG |
Undergraduate credit hours |
GR |
Graduate credit hours |
CE |
Continuing Ed. credit hours |
For each hours code you can define up to five columns to check. Some columns from system tables that organizations typically use to determine hour/course counts are listed in the table below:
Table name |
Column Descri p tion |
Student Course History |
Transaction status |
Student Course History |
Course division |
Student Course History |
Student division |
Student Course History |
Credit type code |
Section master |
Tuition code |
Section master |
Refund code |
Section master |
Exclude from tuition |
Section master |
Day/evening status |
Student master |
Tuition type |
Try to limit the number of definitions or hour codes to reduce processing time when generating charges. For our example, we only need to define one hour code and place one variable (the Transaction status column from the Student Course History table) in it. In other words, the Transaction Status is checked to see if the course was dropped.
Hours Code: HR |
|
Description: Total Credit Hours |
|
Table Name |
Column Description |
Student Course History |
Transaction Status |
If you need a separate count for each division, you can create a separate hours code for each .
Technically, you would not need to create a separate hours code for each since they all use the same variables. However, this is accomplished by creating one hours code that can be used for all of them and separating the divisions in the Hours Detail table.
Hours Code : DV |
|
Description : Credit Hours by Division |
|
Table Code |
Column Code/Description |
Student Courses History |
CRS_DIVCourse division |
Student Courses History |
CRS_DIVTransaction status |
By creating one hours code for all three divisions since they use the same variables, the amount of time is takes to run the Charges Generation program is greatly reduced.
Before we can tell the computer to use this column, an hours code must be defined. This simply creates a unique code into which we can place hours definitions. You may have more than one hours code if necessary.
|
You may need to look at different columns in the database to place number of hours or courses in separate Student Hours/Courses table buckets. This might include an hours code for audit hours; or, if you are not checking the student's division in the charge detail, you may need to define that column as part of an hours definition code. |
Hours Code: UG |
|
Description: Undergraduate Credit Hours |
|
|
|
Table Name |
Column Description |
Student Course History |
Course Division |
Student Course History |
Transaction Status |
|
|
|
|
Hours Code: GR |
|
Description: Graduate Credit Hours |
|
|
|
Table Name |
Column Description |
Student Course History |
Course Division |
Student Course History |
Transaction Status |
|
|
|
|
Hours Code: CE |
|
Description: Continuing Ed. Credit hours |
|
|
|
Table Name |
Column Description |
Student Course History |
Course Division |
Student Course History |
Transaction Status |