Schoolbox can connect directly (Real-time integration not a data sync) to the MAZE database and fetch a range of information directly from the MAZE db. In order to get this functioning Schoolbox will require a user account with the following permissions.
Access Rights
Read
- STMA
- STMA.CLASS
- STMA.TTPERIOD
- STMA.IDENT
- STMA.MKEY
- STMA.SKEY
- SU (Subjects)
- SU.SUKEY
- SU.FULLNAME
- ST (Students)
- ST.STKEY
- ST.FIRST_NAME
- ST.SURNAME
- ST.SCHOOL_YEAR
- ST.STATUS
- ST.BIRTHDATE
- ST.HOUSE
- ST.EMERGENCY_ONE_NAME
- ST.EMERGENCY_ONE_PHONE
- ST.EMERGENCY_ONE_MOBILE
- ST.EMERGENCY_TWO_NAME
- ST.EMERGENCY_TWO_PHONE
- ST.EMERGENCY_TWO_MOBILE
- ST.MEDICAL
- ST.ROLL_GROUP
- ST.FAMILY
- ST.LW_DATE
- ST.STUDENT_PIC
- SF (Staff)
- SF.KLPID
- SF.MOBILE
- SF.FIRST_NAME
- SF.SURNAME
- SF.LW_DATE
- SF.STAFF_PIC
- DF (Parents)
- DF.DFKEY
- DF.MTITLE
- DF.MNAME
- DF.MSURNAME
- DF.M_EMAIL
- DF.MMOBILE
- DF.MBUS_PHONE
- DF.DFKEY
- DF.FTITLE
- DF.FNAME
- DF.FSURNAME
- DF.F_EMAIL
- DF.FMOBILE
- DF.FBUS_PHONE
- DF.HOMEKEY
- UM (Address)
- UM.UMKEY
- ADDRESS01
- ADDRESS02
- ADDRESS03
- SUBURB
- POSTCODE
- STATE
- KGH (House)
- DESCRIPTION
- KGC
- KGC.ROLL_GROUP
- KGC.TEACHER
- KGC.TEACHERB
- KGC.TEACHERC
- KGC.DESCRIPTION
- TT (Teachers)
- TT.TTKEY
- TT.T1TEACH
- TT.T2TEACH
- TTTG
- TTTG.GKEY
- TTTG.SUBJ
- TTTG.CLASS
- TCTD (Timetable Definition)
- TCTD.TIME_START
- TCTD.TIME_END
- TCTD.QKEY
- TCTQ (Class information)
- TCTQ.QKEY
- TH (Timetable headers)
- TH.THKEY
- THTQ (Timetable entries)
- THTQ.QROW
- THTQ.QCOL
- THTQ.SUBJ
- THTQ.CLASS
- THTQ.R1ROOM
- THTQ.R2ROOM
- KCT
- KCT.SFLINK
- KCY (Years)
- KCY.KCYKEY
- KSC
- KSC.KSCKEY
- KSC.SF_POSITION