CASES, CHESS and MAZE export fields

This article is only relevant for schools using CASES, CHESS or MAZE as their SIS student administration package.

In this article

Student Fields

XUNO EXPORT FIELD
Student Code ST.STKEY
VSN ST.VSN
Status ST.STATUS
Surname ST.SURNAME
First name ST.FIRST_NAME
Preferred name ST.PREF_NAME
Gender ST.GENDER
Date of Birth ST.BIRTHDATE
Form / Homegroup ST.HOME_GROUP
Year Level ST.SCHOOL_YEAR
House ST.HOUSE
Campus ST.CAMPUS
Mobile ST.MOBILE
Email ST.EMAIL
Address ID DF.HOME_KEY joined onto ST.FAMILY
Primary Family Code ST.FAMILY
Secondary Family Code ST.FAMB
Exit Destination ST.EXIT_DEST01
Previous School ST.PREVIOUS_SCHOOL
Disability Alert ST.DISABILITY
Integration Alert ST.INTEGRATION
Medical Alert ST.MEDICAL_ALERT
Student At Risk Alert ST.RISK_ALERT
Access Restrictions Alert ST.ACCESS_RESTRICTIONS
Koorie ST.KOORIE

Staff Fields

XUNO EXPORT FIELD
Staff Code SF.SFPAYROLL_REC_NO
Initials ST.INITIALS
Status SF.STATUS
Surname SF.SURNAME
First name SF.FIRST_NAME
Preferred name SF.PREF_NAME
Title SF.TITLE
Gender SF.GENDER
Date of Birth SF.BIRTHDATE
Form / Homegroup KGC.KGCKEY
House SF.HOUSE
Campus SF.CAMPUS
Mobile SF.MOBILE
Phone (AH) UM.TELEPHONE
Phone (BH) SF.WORK_PHONE
Email SF.EMAIL
Car Rego SF.CAR_REGO
FTE SF.FTE
Address ID SF.HOME_KEY joined onto UM.UMKEY

  

Contact Details (for Staff and Students)

XUNO EXPORT FIELD
Code DF.DFKEY (+ ‘F’ if family)
Surname DF.SURNAME_A / DF.SURNAME_B
Firstname DF.NAME_A / DF.NAME_B
Preferred name DF.NAME_A / DF.NAME_B
Title DF.TITLE_A / DF.TITLE_B
Gender DF.GENDER_A / DF.GENDER_B
Date of Birth DF.BIRTHDATE_A / DF.BIRTHDATE_B
Mobile UM.MOBILE
Phone (AH) DF.AH_CONTACT_A if empty then UM.TELEPHONE / DF.AH_CONTACT_B if empty then UM.TELEPHONE
Phone (BH) DF.BH_CONTACT_A / DF.BH_CONTACT_B
Email DF.EMAIL_A / DF.EMAIL_B
Occupation DF.OCCUPATION_A / DF.OCCUPATION_B
Occupation Code DF.OCCUP_STATUS_A / DF.OCCUP_STATUS_B
Address ID DF.HOME_KEY joined onto UM.UMKEY
Mailing ID DF.MAILKEY joined onto UM.UMKEY

  

Emergency Contact Details (for Staff and Students)

XUNO EXPORT FIELD
Code DF.DFKEY (+ ‘F’ if family)
Surname (no surname exists in CASES)
Firstname DF.EMERG_NAME01 / DF.EMERG_NAME02
Preferred name (No preferred name exists in CASES)
Title (No title name exists in CASES)
Gender M (defaults to M, no gender exists in CASES)

  

Primary Family Relationships

XUNO EXPORT FIELD
Code ST.STKEY
Relationship ST.RELATION_A01 / ST.RELATION_A02
Academic Reports ST.ACADEMIC_A / ST.ACADEMIC_A (relates to ST.FAMILY, not person)
Correspondence ST.CONTACT_A
A=Yes
C=Yes
Else=No
Mobile UM.MOBILE

  

Secondary Family Relationships

XUNO EXPORT FIELD
Code ST.STKEY
Relationship ST.RELATION_B01 / ST.RELATION_B02
Academic Reports ST.ACADEMIC_B / ST.ACADEMIC_B (relates to ST.FAMB, not person)
Correspondence ST.CONTACT_B
A=Yes
C=Yes
Else=No

  

Address Details

XUNO EXPORT FIELD
Code UM.UMKEY
Street Address UM.ADDRESS01, then UM.ADDRESS02
City / Suburb UM.ADDRESS03
State UM.STATE
Postcode UM.POSTCODE
Country KGT.DESCRIPTION joined to UM.COUNTRY

  

Student Medical Details

XUNO EXPORT FIELD
Code SMC.SMCKEY
Medical Condition SMC.MED_CONDITION + SMC.COMMENT
DATE SMC.LW_DATE

  

Timetable Export

Timetable export details are available on request.

Still need help? Contact Us Contact Us