How to Let Students Opt Out of Receiving Communications from Your College

Purpose: Use this document as a reference to stop a student from receiving communications.

Audience: College Staff responsible for maintaining student information.

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

  • ZD CC Service Indicate Student
  • ZZ CC Service Indicate Student
  • ZD CC Service Indicators
  • ZD CC Super user
  • ZZ CC Service Indicators

You must also set these SACR Security permissions:

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

The SOO service indicator is used to identify students who have opted out of receiving communications from the college. Once a student has been assigned an SOO service indicator, they can be excluded from query results that have SOO exclusion criteria. This exclusion criteria is added to queries as an optional prompt, meaning that a college can choose whether or not they want to exclude students with an active SOO service indicator from query results.

There are some instances in which a student should not be able to opt-out of communications:

  • Financial Aid Communications: Most Financial Aid communications are federally required or critical to send to students. Many Financial Aid offices already have a practice of “canceling” a student’s Financial Aid application to prevent students who do not have financial aid from receiving communications from the college. (A list of students with cancelled applications can be pulled with QCS_FA_AID_APP_STAT_CANCELLED.)
  • Student Financials Communications: Many Student Financials communications are also critical to send to students. Some colleges already have methods of excluding students from specific communications. For example, the college may place a B06 (Past Due) service indicator on a student’s account and then exclude students with this service indicator from receiving payment reminders if they have already arranged to pay off their debts. 
  • Other Communications: Communications related to college admissions, academic standing, drops for non-payment of tuition, etc., may also be considered by the college to be critical for the student to receive.

The power of the SOO service indicator and the optional exclusion prompt is the college can choose whether they want to exclude students with an active SOO service indicator from the 

Service Indicator Codes

SOO is a positive service indicator. It has not been initially set up to display in Self Service. The college can decide if it would like to display the service indicator and update this setting if needed.

The Description field gives information on the purpose of the service indicator, who is responsible for maintaining it, and how it can exclude students from population selection queries. This field will not be visible to students if the college decides to display the service indicator in Self Service. If appropriate, the college should update this field to add additional detail specific to its business practices.

Service Indicator Assignment

While the SOO service indicator can be assigned in batch, it is more likely to be manually assigned as students choose to opt out of receiving communications from the college.

Queries

There are currently five queries in Production that include the optional SOO exclusion prompt:

  • QCS_CC_CURRENROL_WEMAIL
  • QCS_CC_SI_GEN_POPSEL
  • QCS_CC_SI_STRM_POPSEL
  • QCS_SR_CART_REMINDER_POPSEL
  • QCS_SR_SCC_REG_REMINDER

This list will increase as queries are created and modified by campus query developers.

Criteria and Optional Prompt

Queries in Production will not exclude students who have opted out of receiving communications unless criteria to exclude students with an SOO service indicator have been added to the query.

The SOO exclusion criteria can be added to new and existing queries to provide the option of excluding opt-out students. The exclusion of students with an active SOO service indicator must be optional to ensure that all queries with these criteria can be fully utilized by all colleges and departments.

Step-by-Step: Adding SOO Exclusion Criteria to Queries

College query developers can add the following criteria to a query to create the optional SOO exclusion prompt.

  1. Under the Prompt tab, add a new prompt.
    • Field Name: YES_NO_FLAB_LBL
    • Heading Type: Text
    • Type: Character
    • Heading Text: Exclude Students with SOO SI
    • Format: Upper
    • Length: 1
    • Edit Type: Yes/ No Table
    • Default Value: N
  1. Under the Criteria tab, create a new “not in list” Subquery where the student’s EmplID is not returned in the subquery results.
Edit Criteria Properties
  1. Add the SRVC_IND_DATA record to the subquery.
  2. Under the Expressions tab, create the following expression:
    • CASE WHEN :X = 'Y' THEN C.EMPLID ELSE 'EMPLID' END

Note: Replace “:X” with the prompt number of the “Exclude Students with SOO SI” prompt.

Edit Expression Properties
  1. Use the expression as a field.
Select the Use as Field link
  1. Under the Criteria Tab, add the following criteria:
    • X.SRVC_IND_CD = 'SOO'
    • AND X.SRVC_IND_ACTIVE_DT <= SYSDATE
    • AND X.INSTITUTION = :1
    • AND (X.SCC_SI_END_DT IS NULL
    • OR X.SCC_SI_END_DT >= SYSDATE)
Criteria tab
  1. Update the query description under the Properties hyperlink. Save the query.

0 Comments

Add your comment

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