Sonia Student Importer Data Architecture - Optional Fields

A list of optional fields that can be brought into Sonia using the Sonia Student Importer tool

Dec 18, 2025
Knowledge

Title

Sonia Student Importer Data Architecture - Optional Fields

Answer

Sonia Student Importer Data Architecture - Optional Fields

The Sonia Student Importer supports several optional fields. Below are the field names and technical details for each.

Field Name		Data Type	Max. Size	Description	Example(s)
Salutation		Text	100	Student’s salutation	Mr
Middle Name		Text	250	Student’s middle name	Fauntleroy
Preferred Name		Text	250	Student’s preferred name	Quack
Date of Birth		Date	N/A	Student’s date of birth	09/06/1934
Gender[1]		Text	N/A	Student’s gender	Male
Subject Status		Text	N/A	Student’s enrollment status	E
Subject Grade		Text	400	Student's subject grade	HD
Course Code		Text	50	Unique Course ID	ABCP
Course Name[2]		Text	400	Student's enrollment program	Bachelor of Computer Science
Street Address	Line 1	Text	250	Student's residential address - line 1	Unit 4
	Line 2	Text	250	Student's residential address - line 2	Building A
	Line 3	Text	250	Student's residential address - line 3	24 Somewhere Street
	Suburb	Text	250	Student's residential address suburb	Mile End
	City	Text	250	Student's residental address City	Adelaide
	State	Text	100	Student's residential address State	SA
	Postcode	Text	10	Student's residential address postal code	5000
	Country	Text	200	Student's residential address country	Australia
Postal Address	Line 1	Text	250	Student’s postal address - line 1	Unit 4
	Line 2	Text	250	Student’s postal address - line 2	Building A
	Line 3	Text	250	Student’s postal address - line 3	24 Somewhere Street
	Suburb	Text	250	Student’s postal address - line 4	Mile End
	City	Text	250	Student's postal City	Adelaide
	State	Text	100	Student’s postal State	SA
	Postcode	Text	10	Student’s postal address postal code	5000
	Country	Text	200	Student’s postal address country	Australia
Home Phone		Text	100	Student’s home phone	08 8443 6499
Work Phone		Text	100	Student’s work phone	08 8443 6499
Mobile Phone		Text	100	Student’s mobile phone	0400 999 999

[1] The value of this field must be mapped to existing database values in the configuration.

[2] This field can only be specified if Course Code is also present.

Field Name		Data Type	Max. Size	Description	Example(s)
Next of Kin	Name	Text	250	Student’s next of kin name	Daisy Duck
	Email	Text	N/A	Student’s next of kin Email	daisy@gmail.com
	Contact Details	Text	500	Student’s next of kin Address	24 Somewhere Street, Adelaide, SA, 5000
	Phone	Text	N/A	Student’s next of kin Phone	0400 888 888
	Relationship	Text	100	Student’s next of kin relationship	Partner
Email		Text	500	Student’s email address	sonia@planetsoftware.com.au
Alternate Email		Text	500	An alternate email address	student@gmail.com
Home Campus		Text	400	Student's Campus City/Town	City
Region		Text	400	Student's region	North Shore
Study Mode Code[3]		Text	10S	Unique study mode ID	E
Study Mode Name		Text	400	Student's study mode name	External
On Leave		Boolean[4]	N/A	Student's On Leave status (Valued if True)	Yes, Y, True, T, 1
Leave Start Date		Date	N/A	Start Date of Leave (if applicable)	25/05/2011
Leave End Date		Date	N/A	End Date of Leave (if applicable)	10/06/2011
Student Filter		Text	500
International		Boolean[4]	N/A	Student's International status (Valued if True)	Yes, Y, True, T, 1
Accessibility		Boolean [4]	N/A	Student's Accessibility status (Valued if True)	Yes, T, True, T, 1
Country of Origin		Text	100	Student’s Country of origin	Ducksburg
<Check Value>		<Type>[5]		Student check value	True, 29/06/2011, XYZ
<Custom Value>		<Type>[6]		Student custom field value	True, 29/06/2011, XYZ
Student Topic		Text	400	Non-major student topic	Biology
Student Major		Text	400	Major student topic	Science
Public Note		Text	N/A	Student note that is visible to the student and all users associated with them	Has a car
Private Note		Text	N/A	Student note that is only visible to Placement Officers	License no. 1234

[3] If not provided, the default Study Mode Code specified in the configuration will be used.

[4] Text values are converted to Boolean values as in the example.

[5] The data type depends on how the Student Check is defined (String, Boolean or Date).

[6] The data type depends on how the student custom field is defined (String, Boolean, Date).

See More Info in link to Manadory Fields

URL Name

Sonia-Student-Importer-Data-Architecture-Optional-Fields