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

« Previous Version 2 Next »

Export WACE Student Registration and Demographic (SRGDG)

Column

Heading

Description

A

Record Type

Export file code.

Note: This value is always "RSVET".

B

Provider Code

Comes from Configuration Key: ExternalSystem|CurriculumCouncil|SchoolCode

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

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

  • No labels