MAZE Contact rules setup

Modified on Thu, 5 Mar at 5:07 PM

TABLE OF CONTENTS

Flagging individual contacts (Mother, Father, guardian)
Table definitions

This article may be of help for Administrators with some MAZE knowledge and an understanding of how the sync works. The information below seeks to provide a basic understanding of how rules are used to establish which contacts are synced into SEQTA based on the fields and data available in MAZE.

The sync code allows a lot of flexibility when it comes to applying rules to set contact flags. These may differ from school-to-school depending on the data and fields available in MAZE.

Flagging individual contacts (Mother, Father, guardian)

This example shows the rule for the correspondence type "Email" for the contact type "Primary Father". A similar rule will then be applied to "Primary mother", "Secondary father" and "Secondary mother".

Example rule: determining which contacts are flagged as 'Father'

RULE:

living with the Father on a permanent or balanced basis OR if there must be no secondary family
AND father must not be deceased
AND father's email must not be null or blank
AND the primary email must be set to father or both.

SYNC CODE:

WHEN (ST.LIVING_A IN ('P', 'B') OR ST.FAMB IS NULL) AND (LOWER(FNAME) NOT LIKE '%deceased%' OR LOWER(FSURNAME) NOT LIKE '%deceased%')      AND F_EMAIL IS NOT NULL      AND F_EMAIL != ''      AND DF.PRIME_EMAIL IN ('F', 'B')      THEN 'TRUE' ELSE 'FALSE'

Table definitions

TH, THTQ/ TTTQ etc - Timetabling

ST, SM, STMA, STAB, STBH, STBD - Student Tables

SF - Staff Table

SU - Subjects

KCY, KDIS, KGD, KGH, KSF - Supplementary Tables (lookup tables)

UM - Addresses

DF - Family Table

SPRR - Family Relation Table (New in Maze 9.5)