Purpose

This form allows administrators to define the notice delivery condition. This determines whether or not a notice is displayed

SubSystem

Connect

This function allows an administrator to define the notice delivery condition which determines whether a notice will be displayed.

The condition is defined by an administrator in the form of an SQL statement which, when executed, returns a value of TRUE if the condition is met. If the statement returns any value other than TRUE, including NULL, then the condition is not met. There is one variable parameter of person ID available to the statement, but it is not mandatory. The statement may perform queries or execute functions as per the administrator’s requirements.

Each Notice Delivery Condition has a code so that it can be used in multiple Notices.

A comments field is available to allow the administrator to describe the purpose or intent of the condition.

Examples

A notice condition to determine if a student is studying a bachelor degree may be:

select distinct('TRUE')
from student_course_attempt sca, course_version cv
where sca.course_cd = cv.course_cd
and sca.version_number = cv.version_number
and cv.course_type = '10'
and sca.person_id = :p_person_id

The above query would return a single ‘TRUE’ value, even if a student is studying multiple courses with a Course Type of 10. If the query is not structured in such a way as to return only a single value, then only the first value will be considered by the Display Notice application. More complex queries, involving lists of data or multiple table joins may require a function to be written and called by the notice text.

The Self Serve Notice Delivery Condition block contains:

• Notice Delivery Condition Code
• Description
• Closed check box
• Condition
• Comment

Rules/Notes:

Consider the following before creating notices:

• The entered text should be a valid SQL
• The parameter Person ID may be included as part of the statement but is not mandatory
• Impact of Performance of the SQL should be considered
• A return of NULL or FALSE indicates that the condition has not been met

The Closed Check box is selected when the user no longer wants the delivery condition to be applied to NEW notices. Notices with this condition applied BEFORE the Closed check box was selected will continue to have the delivery condition met

Notice Delivery Condition Code

SNDC. NOTICE_DLVRY_CNDTN_CD

Text

Varchar2(10)

Description

SNDC.DESCRIPTION

Text

Varchar2(60)

Closed

SNDC.CLOSED_IND

Checkbox

Varchar2(1)

Default is N

Condition

SNDC.CONDITION

Text

Varchar2(2000)

Comments

SNDC.COMMENTS

Text

Varchar2(2000)