Column | Heading | Description |
---|
A | Record Type | Export file code. Note: This value is always "RSVET". |
B | Provider Code | Comes from Configuration Key: ExternalSystem|CurriculumCouncil|SchoolCodeProvider code of the school or organisation authorised to offer the Western Australian Certificate of Education. |
Key configuration details |
---|
C | Calendar Year | Comes from the Process Date entered in the Curriculum Council tab |
Key configuration details |
---|
D | WA Student Number (WASN) | Comes from the Studies Code (Codes tab in Current Student Maintenance for the student) derived from the matching Student (i.e. active student in the Students tab in Class Maintenance) |
Key configuration details |
---|
E | Student Title | Comes from the Title field in the Student's Community record |
Key configuration details |
---|
F | Student Family Name | Comes from the Surname field in the Student's Community record |
Key configuration details |
---|
G | Student Given Name | Comes from the Given 1 field in the Student's Community record |
Key configuration details |
---|
H | Student Middle Name | Comes from the Given 2 field in the Student's Community record |
Key configuration details |
---|
I | Student Third Initial | Comes from the Initials field in the Student's Community record (if the initials are more than three letters in the set of initials, then it returns the third initial) |
Key configuration details |
---|
J | Certificate Name | Comes from the External Name in the Student's Community record (can be viewed/amended in by clicking on the Display Names button on the Names tab in Community Maintenance) - if the External Name matches the Legal Name, then the field is left blank |
Key configuration details |
---|
K | Date of Birth | Comes from the Student's Birth Date (which can be amended both via Current Student Maintenance and Community Maintenance) |
Key configuration details |
---|
L | Sex | Comes from Student Gender |
Key configuration details |
---|
M | Status | Derived from School tab of Current Student Maintenance: - if the student has a Status with the SynergyMeaning of LEFT or LEAVING and the Leaving Date is less than the Process Date, 4 is returned,
- if the student is Deceased, 2 is returned
- otherwise 1 is returned
|
Key configuration details |
---|
N | Home Address Line 1 | Comes from the Student's Home Address |
Key configuration details |
---|
O | Home Address Line 2 | Comes from the Student's Home Address |
Key configuration details |
---|
P | Home Suburb | Comes from the Student's Home Address |
Key configuration details |
---|
Q | Home State | Comes from the Student's Home Address |
Key configuration details |
---|
R | Home Postcode | Comes from the Student's Home Address |
Key configuration details |
---|
S | Home Country | Comes from the Student's Home Address |
Key configuration details |
---|
T | Postal Address Line 1 | Comes from the Student's Mailing Address |
Key configuration details |
C | Calendar Year | Calendar year. |
Key configuration details |
---|
- This value is defined using the Process Date field on the Curriculum Council tab of Import/Export Student Data window. See Import_Export Student Data - Curriculum Council tab.
- This value has a maximum field length of 4 characters.
- This value has the format YYYY.
|
D | Western Australian Student Number (WASN) | Candidate number allocated to the student by the School Curriculum and Standards Authority. |
Key configuration details |
---|
- This value is defined using the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
- This value has a maximum field length of 15 characters.
|
E | Student Title | Title of the student. For example, Mr. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 20 characters.
|
F | Student Family Name | Family name of the student taking the class. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 30 characters.
|
G | Student Given Name | Given name of the student taking the class. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 30 characters.
|
H | Student Middle Name | Middle name of the student taking the class. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 30 characters.
|
I | Student Third Initial | Third Initial of the student taking the class, if necessary. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 1 character.
|
J | Certificate Name | Comes from the External Name in the Student's Community record (can be viewed/amended in by clicking on the Display Names button on the Names tab in Community Maintenance) - if the External Name matches the Legal Name, then the field is left blank |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 61 characters.
|
K | Date of Birth | Date of birth of the student. Comes from the Student's Birth Date (which can be amended both via Current Student Maintenance and Community Maintenance) |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 10 characters.
- This field has the format DD/MM/YYYY.
|
L | Sex | Gender of the student. |
Key configuration details |
---|
- This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
- This value has a maximum field length of 1 character.
|
M | Status | Status of the student. |
Key configuration details |
---|
- This field is defined using the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
- This field has a value of 4 when the Status field is populated with a status that has a SynergyMeaning of LEFT or LEAVING.
- This field has a value of 2 when the Reason field is populated with a reason with a SynergyMeaning of DECEASED.
- This field has a value of 1 when neither of the above rules are true.
|
N | Home Address Line 1 | First line of the student's home address. |
Key configuration details |
---|
|
O | Home Address Line 2 | Second line of the student's home address. |
Key configuration details |
---|
|
P | Home Suburb | Suburb of the student's home address. |
Key configuration details |
---|
|
Q | Home State | State of the student's home address. |
Key configuration details |
---|
|
R | Home Postcode | Postcode of the student's home address. |
Key configuration details |
---|
|
S | Home Country | Country of the student's home address. |
Key configuration details |
---|
|
T | Postal Address Line 1 | First line of the student's postal address. |
Key configuration details |
---|
|
U | Postal Address Line 2 | Comes from the Student's Mailing Address |
Key configuration details |
---|
|
V | Postal Address Suburb | Comes from the Student's Mailing Address |
Key configuration details |
---|
|
W | Postal Address State | Comes from the Student's Mailing Address |
Key configuration details |
---|
|
X | Postal Address | Comes from the Student's Mailing Address |
Key configuration details |
---|
|
Y | Postal Address Country | Comes from the Student's Mailing Address |
Key configuration details |
---|
|
Z | Academic Year | Comes from Year Level (School tab in Current Student Maintenance) 'SCSA Data Procedures Manual' states "Must be either K, PP, 01–12", this is not enforced by Synergetic, and relies upon the school configuration to enforce this. |
Key configuration details |
---|
|
AA | Australian Residency Status | Derived from the Non Resident flag (Flags tab in Current Student Maintenance): if ticked, Y is returned - otherwise N is returned |
Key configuration details |
---|
|
AB | Student Fee Status | Derived from the Full Fee Paying flag (Debtor tab in Current Student Maintenance): if ticked, Y is returned - otherwise N is returned |
Key configuration details |
---|
|
AC | Home Phone Number | Comes from the Home Phone (Phone tab in Community Maintenance of the Student) |
Key configuration details |
---|
|
AD | Alternate/Mobile Number | Comes from the Home Phone Alt (Phone tab in Community Maintenance of the Student) |
Key configuration details |
---|
|
AE | Email Address | Comes from the Home Email (Phone tab in Community Maintenance of the Student) |
Key configuration details |
---|
|
AF | Fax Number | Comes from the Home Fax (Phone tab in Community Maintenance of the Student) |
Key configuration details |
---|
|
AG | Previous Student Famly Name | Comes from the Prev Surname (Other tab in Community Maintenance of the Student) |
Key configuration details |
---|
|
AH | Previous Student Given Name | Blank |
AI | Exemption from School | Derived from the Student status (School tab in Current Student Maintenance): if the status has a SynergyMeaning of EXEMPTION then Y is returned - otherwise N) |
Key configuration details |
---|
|
AJ | Country of Birth Identifier | Derived from the Country of Birth field (Personal tab in Current Student Maintenance): if the code (in luCountry) has an External System Code = MCEETYA, it returns that - otherwise left blank |
Key configuration details |
---|
|
AK | Language Spoken at Home Identifier | Derived from the Home Language field (Personal tab in Current Student Maintenance): if the code (in luLanguage) has an External System Code = MCEETYA, it returns that - otherwise it is left blank |
Key configuration details |
---|
|
AL | Proficiency in Spoken English | Derived from the Speaking field (ESL section in the Flags tab in Current Student Maintenance): if the code (in luESLProficiencyLevel) has an External System Code, it returns the first letter of that - otherwise it is left blank |
Key configuration details |
---|
|
AM | Labour Force Identifier | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the first attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of LABOUR – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AN | Highest School Level Completed | Derived from the Year Level field in the School tab in Current Student Maintenance: if there is a previous Year Level (i.e. for a FileYear earlier than than the Year selected in the extract window AND the Year Level is less than the current one), then it'll return that one (unless that Year Level is 8 or less - in which case, it'll return 8) - otherwise it'll return the current Year Level - 1 |
Key configuration details |
---|
|
AO | Year Highest School Level Completed | Derived from the Student Year records (can be viewed by clicking on Show History in the School tab in Current Student Maintenance): if there is a previous Entry (i.e. for a FileYear earlier than than the Year selected in the extract window and the Year Level is less than the current one), then it'll return that one - otherwise it'll return the current FileYear - 1 |
Key configuration details |
---|
|
AP | Prior Education Achievement 1 | Derived from the Qualifications tab in Community Maintenance (of the Student): will return the value of the first qualification entered where the Qualification code (in luQualificationLevel) has an External System Type of CCWA – if such a qualification doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AQ | Prior Education Achievement 2 | Derived from the Qualifications tab in Community Maintenance (of the Student): will return the value of the second qualification entered where the Qualification code (in luQualificationLevel) has an External System Type of CCWA – if such a qualification doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AR | Prior Education Achievement 3 | Derived from the Qualifications tab in Community Maintenance (of the Student): will return the value of the third qualification entered where the Qualification code (in luQualificationLevel) has an External System Type of CCWA – if such a qualification doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AS | Disability Code 1 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the first attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AT | Disability Code 2 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the second attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AU | Disability Code 3 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the third attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AV | Disability Code 4 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the fourth attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then it the field is left blank |
Key configuration details |
---|
|
AW | Disability Code 5 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the fifth attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AX | Disability Code 6 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the sixth attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AY | Disability Code 7 | Derived from the Community Attributes tab in Community Maintenance (of the Student): will return the value of the seventh attribute entered where the Attribute code (in luCommunityAttributes) has an External System Type of CCWA and an External System Code of DISABILITY – if such an attribute doesn't exist, then the field is left blank |
Key configuration details |
---|
|
AZ | Australian Aboriginal or Torres Strait Islander | Derived from the Indigenous and Torres Strait Islander flags (Flags tab in Student Maintenance): if both are ticked, then 3 is returned, if only Indigenous is ticked, then 1 is returned, if only Torres Strait Islander is ticked, then 2 is returned - otherwise 4 is returned |
Key configuration details |
---|
|
BA | Date of Status | Derived from the following: if the Student has a Status (School tab in Current Student Maintenance) with a SynergyMeaning of LEFT or LEAVING, then the Leaving Date is returned, if the Student is DECEASED, then the Deceased Date is returned - otherwise the Process Date (from the Extract screen) is returned |
Key configuration details |
---|
|
BB | Hours of Community Service | Derived from the Community Service and (Hours) text box (Flags tab in Current Student Maintenance): if the Community Service checkbox is ticked then the value in the (Hours) textbox is returned - otherwise the field is left blank |
Key configuration details |
---|
|
BC | Visa Subclass | Derived from Visa Subclasses (International tab in Current Student Maintenance): if there is a Visa Subclass, this will be returned - otherwise the field will be left blank → NOTE: if there are multiple Visa Subclasses, then a separate line will be produced, in the file, for each subclass |
Key configuration details |
---|
|
BD | Arrival Date | Derived from Visa Subclasses (International tab in Current Student Maintenance): if there is an Arrival Date, this will be returned (in ddmmyy format) - otherwise the field will be left blank → NOTE: if there are multiple Visa Subclasses, then a separate line will be produced, in the file, for each subclass |
Key configuration details |
---|
|
BE | VET USI | Comes from Vocational Education Code (Codes tab in Current Student Maintenance) |
Key configuration details |
---|
|
BF | Parent 1 School Education | Comes from Highest Secondary Year Level (Parent 1 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BG | Parent 1 Non-School Education | Comes from Highest Qualification Level (Parent 1 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BH | Parent 1 Occupation | Comes from Occupation Position (Parent 1 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BI | Parent 1 Main Language Other than English Spoken at Home | Comes from Home Language (Parent 1 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BJ | Parent 2 School Education | Comes from Highest Secondary Year Level (Parent 2 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BK | Parent 2 Non-School Education | Comes from Highest Qualification Level (Parent 2 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BL | Parent 2 Occupation | Comes from Occupation Position (Parent 2 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BM | Parent 2 Main Language Other than English Spoken at Home | Comes from Home Language (Parent 2 subtab of the Demographic tab in Current Student Maintenance) |
Key configuration details |
---|
|
BN | Class Identification | Comes from the Form (School tab in Current Student Maintenance) → NOTE: this is the luForm CODE not the DESCRIPTION |
Key configuration details |
---|
|
BO | Brightpath Project Student | All students in a Brightpath Year are marked as Y, all others No. Brightpath Year is configurable in Curriculum Council tab when SRGDG radio button is On. |
Key configuration details |
---|
|
BP | ABLEWA project student | Always N |