There are two variable columns that are checked; therefore, each combination of values that the variables may contain must be entered. The Graduate, Undergraduate, & Continuing Ed In the Student Division column must be accounted for and, for each of these, the P, C, or H Transaction Status must be accounted for. With this configuration you need three buckets, one for each division--on the Student Hours/Courses table. The Hours Detail would look like the following:
Hours Code: DV Credit Hours by Division
|
Variable 1 |
Variable 2 |
Variable 3 |
Variable 4 |
Variable 5 |
|
Course |
Transaction |
|
|
|
|
Division |
Status |
|
|
|
Undergrad: Current |
U |
C |
|
|
|
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 1 |
||
Undergrad: Pre-reg |
U |
P |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 1 |
||
Undergrad: History |
U |
H |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 1 |
||
Grad: Current |
G |
C |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 2 |
||
Grad: Pre-reg |
G |
P |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 2 |
||
Grad: History |
G |
H |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 2 |
||
Contin Ed.: Current |
C |
C |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 3 |
||
Contin Ed.: Pre-reg |
C |
P |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 3 |
||
Contin Ed.: History |
C |
H |
|
||
Hours/Course Count: Hours |
|
|
Student Hrs/Crs Bucket: 3 |
||
If you need to consider whether a course is audited, the Credit Type Code column in the Student Course History table can be checked. This would add another variable to the table below and make the Hours table a bit more lengthy.