9.2 Enrollment Verification Report

Purpose: This document is a reference for processing enrollment verification requests in ctcLink.

Audience: Student Records.

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

  • ZD_DS_QRY_STUDENT_RECORDS

You must also have this local college-managed Query security role:

  • ZD_DS_QRY_SR_SSN_HIGHSENS 

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


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 Add. It 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.
The image displays the run control field.
  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) displays below.
  3. Click on the appropriate Run Control ID.
The image
  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_ENRLVRFY.
  3. Prompts appear in the query CQCS_SR_ENRL_VER_P.
    1. Enter or look up your Institution.
    2. Enter the Student ID.
    3. Select OK. Prompts for a second query will appear once OK is selected.
The image displays the query prompts - institution and student ID
  1. Prompts appear for the second query CQCS_SR_ENRL_VER_1.
    1. Enter the From Term.
    2. Enter the To Term.
The image highlights the from term and to term
  1. Prompts appear for the second query CQCS_SR_ENRL_VER_5.
    1. Enter the From Term.
    2. Enter the To Term.
The image highlights the query prompts from term and to term
  1. Enter a Template As Of Date. (Optional) The PDF displays the date.
The image highlights the Template As Of Date field
  1. The Query Report Scheduler page displays with the Query Parameters section populated. Enter new query prompt values by selecting the Update Parameters link.
  2. Select Run in the top-right corner of the page.
The image points out the Update Parameters hyperlink used to enter new query prompt values
  1. The Process Scheduler Request page displays. Select OK. (Note: Click on the Distribution link to ensure the ID Type = User and your EMPLID is in the Distribution ID field).
  2. Select "PDF" from the Format column drop-down menu.
  3. Click OK.
The image highlights the Format column, prompting to select PDF
  1. The Query Report Scheduler page displays.
  2. Select the Process Monitor link.
The image prompts you to select the Process Monitor link at the top of the page.
  1. Verify Run Status = Success and Distribution Status= Posted.
  2. The Query Report Scheduler page displays. Select the Report Manager link.
The image points out the successful post in order to select the Report Manager
  1. Select the Report name BCS_ENRLVRFY - BCS_ENRLVRFY.PDF link.
The image highlights the report link in the Reports panel
  1. Select the Report name BCS_ENRLVRFY.pdf link in the File List panel.
The image highlights the Report name
  1. The Enrollment Verification report opens in a new tab. Ensure pop-ups are enabled.
The image displays the Enrollment Verification Report
  1. Process complete.

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

0 Comments

Add your comment

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