Export file logic - criteria for student inclusion
Screen parameter field options able to be used:
- Process date,
- File Year,
- Campus,
- Year Level
(Leave the Include Blank Studies Codes checkbox disabled as will not be used for this export)
The export logic will find and use any Current Students who do not have a Government Student Number on their record, and include these studens within the export data set.
The students to include will be selected using the param fields (ie find Current Students in the File Year/Campus/Year Level range, and where their start date is on or before Process Date).
Source Documents
All source Documents are held centrally on the QCAA Student Management - 2018 Requirements Page.
File specification
Student Registration File Definition (QCAA)
Template file
Student Create File Upload Template (QCAA)
File Analysis
Mappings are provided where the Synergetic usage may not be immediately obvious.
Codes are provided for those fields to be reported as codes.
| Data File field | Synergetic field | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Given names | Given1 | |||||||||||||||
| Middle names | Given2 | |||||||||||||||
| Family name | Surname | |||||||||||||||
| Preferred name | Preferred | |||||||||||||||
| Gender | Gender Codes: M, F, X | |||||||||||||||
| Date of birth | Birthdate | |||||||||||||||
| USI | The USI is a reference number made up of ten numbers and letters. Mapping VocationalEducationCode | |||||||||||||||
| Birth country | Mapping CountryofBirthCode Codes 1269.0 - Standard Australian Classification of Countries (SACC), Second Edition The current version of ABS Country code currently in use at Synergetic will suffice. Any discrepancies with QCAA will be resolved during testing. | |||||||||||||||
| Indigenous status | Derived based on TSIFlag and IndigenousFlag This is the ABS Indigenous Status Code N This does not exist in Synergetic, we have two Flags in Student Maintenance:
Ahead of a fully developed implementation of a Synergetic Status Look Up for Indigenous Status ( Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration. ), the initial QCAA solution will use this mapping:
See 60002018 | |||||||||||||||
| Home language | Calculated per ref data in template Mapping HomeLanguageCode Codes 1267.0 - Australian Standard Classification of Languages (ASCL), 2011 The current version of ABS Language codes currently in use at Synergetic will suffice. Any discrepancies with QCAA will be resolved during testing. | |||||||||||||||
| Disability | DisabilityFlag (1, 0) | |||||||||||||||
| International full fee-paying student | FFPOS flag | |||||||||||||||
| Documents sighted | New field to add to International tab - Visa Subclasses - would need a flag per record and then use the flag value from the Active entry Default value while field not present = "0" (false)
| |||||||||||||||
| Date entered Australia | Arrival Date (from international - visa subclasses) | |||||||||||||||
| Home email | ||||||||||||||||
| School email | OccupEmail | |||||||||||||||
| Other email | (blank not used) | |||||||||||||||
| Home phone | PhoneActual | |||||||||||||||
| Mobile phone | MobilePhoneActual | |||||||||||||||
| Address line 1 | HomeAddress1 | |||||||||||||||
| Address line 2 | HomeAddress2 | |||||||||||||||
| Address line 3 | HomeAddress3 | |||||||||||||||
| Address line 4 | <Blank - not used> | |||||||||||||||
| Address suburb / town | HomeSuburb | |||||||||||||||
| Postcode | HomePostcode | |||||||||||||||
| State | Mapping HomeState Codes As per SIF - AU 3.4 (ACT, NSW, NT, QLD, SA, TAS, VIC) | |||||||||||||||
| Country | Mapping HomeCountryCode Codes 1269.0 - Standard Australian Classification of Countries (SACC), Second Edition The current version of ABS Country code currently in use at Synergetic will suffice. Any discrepancies with QCAA will be resolved during testing. | |||||||||||||||
| Postal address line 1 | Address1 | |||||||||||||||
| Postal address line 2 | Address2 | |||||||||||||||
| Postal address line 3 | Address3 | |||||||||||||||
| Postal address line 4 | <Blank - not used> | |||||||||||||||
| Postal suburb / town | Suburb | |||||||||||||||
| Postal postcode | Postcode | |||||||||||||||
| Postal state | State | |||||||||||||||
| Postal country | Mapping CountryCode Codes 1269.0 - Standard Australian Classification of Countries (SACC), Second Edition The current version of ABS Country code currently in use at Synergetic will suffice. Any discrepancies with QCAA will be resolved during testing. | |||||||||||||||
| Exit year | YearsUntilGraduation (from luYearLevel) | |||||||||||||||
| Student ID | Synergetic ID | |||||||||||||||
| Intended learning option | New field LearningPathway
New Lookup table will be linked to a new lookup table luLearningPathway
Lookup population can be loaded via ref table data set - coded and stored by region (VIC, QLD, NZ etc) and with ExternalSystemType/Code also populated via load. SynergyMeaning will include at least one value for "IB" so can replicate IBFlag handling Default flag - only one value is allowed to be set as default (if user tries to set two, show an error message indicating cannot have two - refer luFutureApplicationCategory handling for example) Change to Maint Screens Lookup Dropdown field: "Learning Pathway"
Changes to database logic
For upgrade process DML to
For data export Default QCAA value in export logic if and while new field not present = "Not identified" Otherwise use the External System Type/Code value per the lookup table Values
|
Indigenous Status
| Code | Meaning | Indigenous Student | Torres Strait Islander |
|---|---|---|---|
| 1 | Aboriginal but not Torres Strait Islander origin | On | Off |
| 2 | Torres Strait Islander but not Aboriginal origin | Off | On |
| 3 | Both Aboriginal and Torres Strait Islander origin | On | On |
| 4 | Neither Aboriginal nor Torres Strait Islander origin | Off | Off |
| 9 | Not stated/inadequately described | N/A | N/A |