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.

Acess the Query Report Scheduler

Reporting Tools > Bi Publisher > BIP Query Report Scheduler

Create or Select a Run Control ID
  1. To create a new Run Control ID:
    • Select the Add a New Value tab. Enter a unique Run Control ID. It is recommended to include your institution code and a short description, such as CC_ENRLVERIFY, for clarity. Click Add to proceed. Run Control IDs cannot be deleted, so reuse is encouraged.
  2. To use an existing Run Control ID:
    • Select the Find an Existing Value tab, click Search, and choose from the list of existing Run Control IDs.
Reprot Scheduler page
Enter Report Details
  1. In the Report Definition section, choose Connected Query from the Data Source Type drop-down menu.
  2. In the Report Name field, enter or look up BCS_ENRLVRFY.
Report Definition panet

Enter Query Prompts for CQCS_SR_ENRL_VER_P

  1. Enter or look up your Institution and enter the Student ID.
  2. Click OK. This will load prompts for the next query.
Prompts for Query

Enter Query Prompts for CQCS_SR_ENRL_VER_1

  1. Enter the From Term and To Term for the enrollment period.
  2. Click OK. This will load prompts for the next query.
Prompts for Query

Enter Query Prompts for CQCS_SR_ENRL_VER_5

  1. Again, enter the From Term and To Term as prompted.
Prompts for Query

Leave As Of Date Blank

  1. Do not enter a value in the As Of Date field because templates are often replaced with each update. Old versions are not retained, which can cause errors when running the BI Report.
As of Date

Review and Update Parameters

  1. The Query Parameters section becomes available. To modify prompt values, click the Update Parameters link.
Update Parameters link

Run/Monitor the Process and Access the Report

  1. Click Run in the top-right corner of the page.
  2. On the Process Scheduler Request page, click OK.
  3. Click the Distribution link to ensure the ID Type = User and your EMPLID is listed in the Distribution ID field.
  4. From the Format drop-down, select PDF, then click OK.
  5. Return to the Query Report Scheduler page and click the Report Manager link.
  6. Select the report name BCS_ENRLVRFY - BCS_ENRLVRFY.PDF, then click BCS_ENRLVRFY.pdf in the File List panel.
    • The report will open in a new tab. Ensure pop-up blockers are disabled.
  7. Process complete
PDF

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.