ctcLink Reference Center9.2 Campus Solutions9.2 CS - Campus CommunityResources9.2 Run the Student Schedule Batch - BCS_STDNTSCD Report

9.2 Run the Student Schedule Batch - BCS_STDNTSCD Report

Purpose:  Use this document as a reference for running the BCS_STDNTSCD report.

Audience: Campus Community.

You must have the following local college-managed security roles:


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

The Report prompts for Institution, Career, Term, Select Advisor ID or Student Group.

For additional information about reporting solutions, visit the Report Catalog.

Navigation:  NavBar > Navigator > Reporting Tools > Bi Publisher > Query Report Scheduler

  1. The Query Report Scheduler search page displays.
  2. Select the Add a New Value tab. Select the Add a New Value tab to create a new Run Control ID and select AddIt is important to note that Run Control IDs cannot be deleted; therefore, we encourage them to be reused. Because of this, including your institution code and a short process description in the Run Control ID  is recommended. This only has to be done once.
New Run Control ID highlighted in red
  1. To use an existing Run Control ID, click on the Find an Existing Value tab and select Search.
  2. Existing Run Control ID(s) are displayed below.
  3. Click on the appropriate Run Control ID.
Saved Run Control ID highlighted with a red box
  1. Select Connected Query from the Data Source Type drop-down list in the Report Definition section.
  2. In the Report Name field, enter or look up BCS_STDNTSCD.
  3. Prompts appear for Query CQCS_SR_STDNT_SCHEDULE_P
  4. Enter or look up the following:
    1. Institution
    2. Career
    3. Term
    4. Select Advisor ID or Student Group
  5. Select OK.
query prompts are entered and the OK button is highlighted
  1. A prompt box appears for Query CQCS_SR_STDNT_SCHEDULE_2.
  2. Enter or look up the Institution.
  3. Select OK.
the second query prompt box displays with the OK button highlighted
  1. The Query Report Scheduler page displays with the Query Parameters section populated.
    • Select the Update Parameters link and enter new values to modify prompt criteria.
  2. Select Run.
A red arrow points to the Update Parameters link
  1. The Process Scheduler Request page displays.
  2. Select OK. (Note: Click the Distribution link to ensure the ID Type = User and your EMPLID is in the Distribution ID field).
tA red box highlights the OK button on the Process Scheduler Request
  1. The Query Report Scheduler page displays.
  2. Select the Process Monitor link. Ensure the process successfully posted.
Red box highlights the Process Monitor link at the top of the image
  1. Ensure the process successfully posted.
A red box borders the Success-Posted row on the Process Monitor page
  1. Select the Report Manager link.
Red border highlights the Report Manager link
  1. Select the BCS_STDNTSCD - BCS_STDNTSCD.PDF link.
Red border highlights the Report name link
  1. Select the BCS_STDNTSCD.pdf link in the File List section.
A red border highlights the pdf link in the File List panel
  1. The student schedules are displayed in a new window. Save the PDF file to your computer.
Student schedules display (PDF)
  1. Process complete.


Cristina Simental

Love this! Is there a way to email these to students in batch?
Thank you!

Tanjagay Martin

Hi Cristina,
Thank you for your comment. If you need to send a message with an attachment, please submit a CS Support ticket. One possible way to communicate with enrolled students is by identifying them using query QCS_SR_ENRLLD_STDNTS_BY_TERM or CTC_SR_ENROLLED_STUDENTS, and then sending a Message Center message with a hyperlink to view their class schedule (Message Center > Setup > Hyperlinks). This will direct students to log in and view their schedules and any tuition-due notifications to prevent enrollment cancellation. Thanks again, Cristina! Tanjagay Martin | CS Core Functional Trainer

Add your comment

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