Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Export WACE Student Registration and Demographic (SRGDG)

Key configuration details

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 studentderived 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

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


...