9.2 Running Start Queries

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

Audience: Running Start and Student Financials Staff.

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 display.
  2. Enter " QCS_SR_RSBILLING" in Query Name.
  3. Select Search.  
Query Viewer Advanced Search page
  1. A list of queries will 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 High Schools.
Running Start Billing info report
  1. Section complete.
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 will display.
  2. On the Query Viewer page, enter " QCS_SF_SR_TUITIONDUE" in Query Name.
  3. Select Search.  
Query Viewer Advanced Search page
  1. A list of queries will display at the bottom of the page.
  2. 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 displays.
  2. You can view results in PeopleSoft or download to Excel to utilize information as needed for Billing Reports to High Schools.
Running Start Billing info report
  1. Process complete.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

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