Skip to end of banner
Go to start of banner

Export WACE Student Registration and Demographic (SRGDG)

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Export WACE Student Registration and Demographic (SRGDG)

Column

Heading

Notes

A

Record Type

"RSVET"

B

Provider Code

Comes from Configuration Key: ExternalSystem|CurriculumCouncil|SchoolCode

C

Calendar Year

Comes from the Process Date entered in the Curriculum Council tab

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) 

E

Student Title

Comes from the Title field in the Student's Community record

F

Student Family Name

Comes from the Surname field in the Student's Community record

G

Student Given Name

Comes from the Given 1 field in the Student's Community record

H

Student Middle Name

Comes from the Given 2 field in the Student's Community record

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)

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

K

Date of Birth

Comes from the Student's Birth Date (which can be amended both via Current Student Maintenance and Community Maintenance)

L

Sex

Comes from Student Gender

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

N

Home Address Line 1

Comes from the Student's Home Address

O

Home Address Line 2

Comes from the Student's Home Address

P

Home Suburb

Comes from the Student's Home Address

Q

Home State

Comes from the Student's Home Address

R

Home Postcode

Comes from the Student's Home Address

S

Home Country

Comes from the Student's Home Address

T

Postal Address Line 1

Comes from the Student's Mailing Address

U

Postal Address Line 2

Comes from the Student's Mailing Address

V

Postal Address Suburb

Comes from the Student's Mailing Address

W

Postal Address State

Comes from the Student's Mailing Address

X

Postal Address

Comes from the Student's Mailing Address

Y

Postal Address Country

Comes from the Student's Mailing Address

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.

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

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

AC

Home Phone Number 

Comes from the Home Phone (Phone tab in Community Maintenance of the Student)

AD

Alternate/Mobile Number 

Comes from the Home Phone Alt (Phone tab in Community Maintenance of the Student)

AE

Email Address 

Comes from the Home Email (Phone tab in Community Maintenance of the Student)

AF

Fax Number 

Comes from the Home Fax  (Phone tab in Community Maintenance of the Student)

AG

Previous Student Famly Name

Comes from the Prev Surname (Other tab in Community Maintenance of the Student)

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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

BE

VET USI

Comes from Vocational Education Code (Codes tab in Current Student Maintenance)

BF

Parent 1 School Education

Comes from Highest Secondary Year Level (Parent 1 subtab of the Demographic tab in Current Student Maintenance)

BG

Parent 1 Non-School Education

Comes from Highest Qualification Level (Parent 1 subtab of the Demographic tab in Current Student Maintenance)

BH

Parent 1 Occupation

Comes from Occupation Position (Parent 1 subtab of the Demographic tab in Current Student Maintenance)

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)

BJ

Parent 2 School Education

Comes from Highest Secondary Year Level (Parent 2 subtab of the Demographic tab in Current Student Maintenance)

BK

Parent 2 Non-School Education

Comes from Highest Qualification Level (Parent 2 subtab of the Demographic tab in Current Student Maintenance)

BL

Parent 2 Occupation

Comes from Occupation Position (Parent 2 subtab of the Demographic tab in Current Student Maintenance)

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)

BN

Class Identification

Comes from the Form (School tab in Current Student Maintenance) → NOTE: this is the luForm CODE not the DESCRIPTION

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.

BP

ABLEWA project student

Always N


  • No labels