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