SOO is a no-impact service indicator.

This service indicator is date-based. The start date will default to “today.”

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.

The SOO service indicator has been built in Production with a single reason code: OPTOU. The college can add additional reason codes to their SOO service indicator and modify OPTOU as needed.

If a college decides to use the OPTOU reason code as originally set up, they should first review the Department code to determine if it is correct.

Note: The college can add additional reason codes to track why students opt out of receiving communications. However, it should be noted that the SOO exclusion criteria added to queries do not consider the reason code assigned to the student; if the student has an active SOO service indicator, they can be excluded from the query results.

Note: SOO will be the only service indicator added to query criteria to exclude students from query results. 

SACR access to place and release the SOO has not been assigned to any college users. College users will need to consult their campus security approvers/ IT Helpdesk to gain access to place and release this service indicator.  

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.

A Start Date is required to assign the service indicator. An End Date can also be added, if appropriate. The Start Term and End Term fields should be left blank.

The Contact Information section can be filled out according to the college’s business practices.

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.

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.

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

2. Under the Criteria tab, create a new “not in list” Subquery where the student’s EmplID is not returned in the subquery results.

3. Add the SRVC_IND_DATA record to the subquery.
4. 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.

5. Use the expression as a field.

6. 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)

7. Update the query description under the Properties hyperlink. Save the query.