Running Start Queries

Purpose: Use this document as a reference for running the Running Start Billing and Tuition Due queries.

Audience: Running Start and Student Financials Staff.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Running Start Queries

Running Start Enrollment/Billing Query

This query generates Running Start data for a particular term that helps with invoicing/billing school districts and reviewing student enrollment data.

Navigation:  NavBar > Navigator > Reporting Tools > Query > Query Viewer

  1. The Query Viewer search page displays.
  2. Select the Advanced Search link.  
Query Viewer Basic Search page
  1. Additional search fields displays.
  2. Enter "QCS_SR_RSBILLING" in Query Name.
  3. Select Search.  
Query Viewer Advanced Search page
  1. A list of queries display at the bottom of the page.
  2. Locate the row for the Running Start Billing Info query and select the HTML or Excel link.  Excel was selected in this example.
Query Viewer page query search results
  1. The QCS_SR_RSBILLING - Running Start Billing Info page displays.
  2. Enter or select the Institution.
  3. Enter or select the Term.
  4. Select View Results.
Query Viewer parameter entry page
  1. The QCS_SR_RSBILLING - Running Start Billing Info report displays.
  2. You can view results in PeopleSoft or download to Excel to utilize information as needed for Billing Reports to School Districts (or Charter High Schools as needed).
Running Start Billing info report
Running Start Tuition Due Query

This query generates Running Start balance owed data for a particular term using the account type of tuition (TUT) or fees (FEE.)

Navigation:  NavBar > Navigator > Reporting Tools > Query > Query Viewer

  1. The Query Viewer search page displays.
  2. Select the Advanced Search link.  
Query Viewer Basic Search page
  1. Additional search fields display.
  2. Enter "QCS_SF_SR_TUITIONDUE" in Query Name.
  3. Select Search.  A list of queries will display at the bottom of the page.
Query Viewer Advanced Search page
  1. Locate the row for the Running Start Tuition Due query and select the HTML or Excel link.  Excel was selected in this example.
Query Viewer page query search results
  1. The QCS_SF_SR_RSBILLING - Running Start Tuition Due query page displays.
  2. Enter or select the Institution.
  3. Enter or select the Term.
  4. Enter the Account Type.
  5. Select View Results.
Query Viewer parameter entry page
  1. The Results display.
  2. You can view results in PeopleSoft or download to Excel to utilize information as needed for Billing Reports to School Districts (or Charter High Schools as needed).
Running Start Billing info report
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.