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

There is the new QCS_SR_RSBILLING_HS query designed to simplify the refining of information required for the P223 Running Start invoice process.

List of Fields in QCS_SR_RSBILLING_HS (003).docx
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: 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: 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_RS_TUITIONDUE" in Query Name.
  3. Select Search.  A list of queries will display at the bottom of the page.
Query viewer page with Query Name selected in the Search By Drop-down and QCS_SF_RS_TUITIONDUE entered in the begins with field.
  1. Locate the row for the Running Start Tuition Due query and select the HTML or Excel link.  Excel was selected in this example.
image of QUery search results for QCS_SF_RS_TUITIONDUE
  1. The QCS_SF_RS_TUITIONDUE - 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.
  6. The Results display.
  7. 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).
QCS_SF_RS_TUITIONDUE query results with the unit, acct term, acct type entered.
  1. Process complete.

0 Comments

Add your comment

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