MAZE Contact rules setup

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)