Export Students

Student number allocated by the Board of Senior Secondary Studies.

Students without the BSSS student number will not be populated into the BSSS data transfer table.

• This field is defined using the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
• This field has a maximum field length of  characters.

• This field is defined when students are added to the Synergetic community database.
• This field has a maximum field length of 7 characters.

• This field is defined using the Surname field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This field has a maximum length of 26 characters.

• This field is defined using the first text box of the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This field has a maximum length of 40 characters.

• This field is defined using the second text box of the Given field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This field has a maximum length of 40 characters.

• This field is defined using the Preferred field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This field has a maximum field length of 20 characters.

• This field is defined using the Gender field on the Name tab of Community Maintenance. See Community Maintenance - Name tab.
• This field is populated based on the SynergyMeaning in the luGender lookup table. See luGender lookup table.
• This field has a maximum field length of 1 character.
• This field has a value of either:
  
  - M when the SynergyMeaning of the luGender record is Male
  - F when the SynergyMeaning of the luGender record is Female
  - X when the SynergyMeaning of the luGender record is Other.

• This field is defined using the Date of Birth field on the Other tab of Community Maintenance. See Community Maintenance - Other tab.
• This field has a maximum field length of 8 characters.

• This field is defined using the Previous School field on the Entry tab of Current Student Maintenance. See Current Student Maintenance - Entry tab.
• This field has a maximum field length of 4 characters.

• This field always has a value of F.

• This field is defined using the Leaving Date field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
• This field has a maximum length of 4 characters.
• This field value is:
  
  - LEFT when the leaving date is before the process date of the export
  - ATTD when the leaving date is after the process date of the export.

• This field is defined using the Status field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
• This field is populated using the luStudentStatus lookup table. See luStudentStatus lookup table.
• This field has a maximum length of 1 character.
• This field value is:
  
  - Y when the selected status has a SynergyMeaning of REPEATING in the luStudentStatus lookup table
  - N when the selected status has any SynergyMeaning in the luStudentStatus lookup table.

• This field is defined using the ID field of the SC1 contact on the Contacts tab of Current Student Maintenance. See Current Student Maintenance - Contacts tab.
• This field has a maximum field length of 7 characters.

Note: To allow identifying the address of a student across the Export Students and Export Student Addresses tables, a join across xeACT_ST_TFR (Export Students) and xeACT_ST_TFR (Export Student Addresses) is made on the fields xeACT_ST_TFR.Family to xeACT_Student_Address_TFR.DFKey.

A single row in the export student addresses table may contain the address of more than one student. For instance, siblings living with the same Primary Contact (eg parent) will all use the address of the parent.

• This field is defined using the Intends Tertiary field on the Flags tab of Current Student Maintenance. See Current Student Maintenance - Flags tab.
• This field has a maximum field length of 1 character.
• This field value is:
  
  - Y when the Intends Tertiary field is selected
  - N when the Intends Tertiary field is not selected.

• This field is defined using the Full Fee Paying field on the Debtor tab of Current Student Maintenance. See Current Student Maintenance - Debtor tab.
• This field has a maximum length of 1 character.
• This field value is:
  
  - F when the Full Fee Paying field is selected
  - P when the Full Fee Paying field is not selected 

• This field is defined using the Country of Birth field on the Other tab of Community Maintenance. See Community Maintenance - Other tab.
• This field has a maximum field length of 30 characters.

Note: The default country code is used when the Country of Birth field is blank. See Default_CountryOfBirthCode configuration setting.

• This field is defined using the Tutor Group field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
• This field has a maximum field length of 10 characters.

• This field is defined using the Indigenous Student field on the Flags tab of Current Student Maintenance. See Current Student Maintenance - Flags tab.
• This field has a maximum length of 1 character.
• This field value is:
  
  - Y when the Indigenous field is selected
  - N when the Indigenous field is not selected.

• This field is defined using the Torres Strait Islander field on the Flags tab of Current Student Maintenance. See Current Student Maintenance - Flags tab.
• This field has a maximum length of 1 character.
• This field value is:
  
  - Y when the Torres Strait Islander field is selected
  - N when the Torres Strait Islander field is not selected.

• This field is defined using the Campus field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
• This field has a maximum length of 15 characters.

• This field is defined using the Year Level field on the Status sub-tab of the School tab of Current Student Maintenance. See Current Student Maintenance - School tab - Status sub-tab.
• This field has a maximum field length of 3 characters.

W

Student_EMail

Email address of the student.

Mandatory

• This field is defined using the default email address.  Default email is defined using the Default Email field on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
• If default email is set to Home Email then this field is populated with the Home Email field on the Phone tab of Community Maintenance. See Community Maintenance - Phone tab.
• If default email is set to Occupation Email then this field is populated with the Email field on the Occupation tab of Community Maintenance. See Community Maintenance - Occupation  tab.

Note: If default is Home and Occupation Email, both email addresses are used.

X

USI

Unique_Student_Identifier - Government-issued reference code which uniquely identifies students as someone who has undertaken education or training in Australia.

Mandatory

• This field is defined using the Unique Student Identifier field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
• This field has a maximum field length of 10 characters, while Syn Web and Syn Main allow 20 characters, the BSSS export only takes the first 10 characters.