Student Billing Hours

Important

Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.

The Student Billing Hours page lets you review the number of credit hours, courses, and tuition hours for students. You can filter results based on a combination of student name/ID number, billing period, year/term, or hours/section count. This read-only information is useful for troubleshooting totals for student hours.

Desktop Location

You can also review student billing hours in Desktop in the View Student Hours window.

Permissions Required

To access this page, you must be in a Receivables Management role (or copy of it) with "Can view hours" permission.

How To

View Student Billing Hours

From the Receivables Management Hub options drop-down, select Student billing hours. The Student Billing Hours page opens.
Click the Criteria 1 drop-down and select from the following options.
- Student Name / ID: Enter a name, ID number, SSN, or birthdate to find students. You can select multiple students.
  Tip
  The system updates the ID Number / Name field when you enter a full ID number and press Tab to move to the next field.
- Billing Period: Select one or more billing periods from the drop-down options. Active and inactive billing periods can be selected.
- Year / Term Fields: Select the Year and Term. Only one year/term combination can be selected.
- Hours / Section Count 1 - 99: Select the minimum and maximum number of hours for the selected hours/section. This criteria returns a list of students whose total number of regular credit hours are within that range.
To add additional criteria, click the Add another criteria button, select an option from the drop-down, and enter the appropriate information.
Click the View billing hours button. The spreadsheet displays the students that meet the entered criteria and includes the following columns.
- ID Number
- Student Name
- Billing Period
- Year
- Term
- Hours / Section Count 1 - 99
To further refine the search results:
1. Use the Search field to the right above the spreadsheet.
2. Click the Column Selector to hide or display columns.

Download Student Billing Hours

On the View Student Billing Hours page, select your criteria to view billing hours and click the View billing hours button.
In the spreadsheet toolbar, click Download. The Download to Excel pop-up opens.
Select options for the Excel format and data columns.
sidebar. Download to Excel Options
Workbook Creation Options: This option lets you choose how you want the data to be organized when it's exported. If you are exporting a large number of rows, you may want to separate the data into different worksheets or even workbooks. Once you select this option, the Separate (Sheets or Workbooks) By drop-down becomes available so you can choose the groupings for each worksheet or workbook.
Separate (Sheets or Workbooks) By: This field becomes available when you choose to organize your export into multiple worksheets or workbooks. In general, you'll have the option to separate the data based on the columns. You will only see options for the visible columns.
Notice
For example, if you are exporting a set of definitions, you might choose to organize the data into two workbooks: one for active definitions, and one for inactive definitions. Do this by selecting the "Active" column in this drop-down. All of your rows designated as active will be in one workbook, and the inactive ones in a separate workbook.
Workbook Format: This section lets you set some Excel display options for your data. For more information about each of these features, consult Microsoft Excel help.
Autofit columns: Fits column width to the data so that fields are not truncated.
Turn on filtering: Turns on the AutoFilter feature, which allows you to show only rows that meet your selected criteria.
Freeze Top Row: Your worksheet displays the column title in the first row by default. Selecting this option keeps the top row at the top so that as you scroll down through your data, the column headings remain displayed.
Show totals for numeric columns: This option will include the sum of a column of numbers at the bottom of that column.
Columns to Include: These options are specific to the page you are viewing, so they will vary. You will only see options for columns that you can see on the page. All of the columns are selected by default, but you can deselect any of the columns you don't want to include.
Click Download. Your .xlsx or .zip file is saved in the file location that you have set in your browser settings.

FAQ

Why isn't the View billing hours button enabled?

The View billing hours button is enabled only when there are student billing hours that meet the selected criteria. Update your criteria to enable the button and view billing hours.