Address Collection (Aus)
Overview
The Address Collection (Aus) program exports student and parent/guardian information for the Australian Government Department of Education (DoE) for the Student Residential Address and Other Information Collection (Address Collection), formerly known as an SES return.
For more information about this return, refer to the SchoolsHub website.
The format required by DoE differs from how the address data is stored natively in the TASS database. Therefore, this program contains logic that re-organises the layout of the extracted data based on the rules outlined in this article.
Follow the Address Collection Checklist to ensure your Address Collection is accurate.
Selecting the Records to Include in Your Extract
Fields from the 'General', 'User Defined' and 'Billing' tabs can be used as selection criteria to filter the data to be included in the extract. These tabs are similar to those found in TASS.web Student Admin > Student Records > Student Information > Students.
How Parent Data Is Extracted for the Address Collection Extract
The Department of Education (DoE) requires separate records for the name and address of each parent or guardian. For each student, the submitted data must include a minimum of one parent or guardian and a maximum of two. The parent information is extracted from TASS.web based on the type of family arrangement.
Refer to the 'How to Handle Split Family Arrangements' guide for more information about Family Arrangements.
The fields used for ‘Parent or Guardian 1 (Mother)’ and ‘Parent or Guardian 2 (Father)’ data are set up in TASS.web Student Admin > Parent Records > Setup Information > Parent Records Setup.
For example:
Person Position 1 = ‘Parent or Guardian 1 (Mother)’
Person Position 2 = ‘Parent or Guardian 2 (Father)’.
The ‘Person Position’ field names are customisable so they may be called something different at your school.
Family Arrangement | How Parent Data Is Extracted |
---|---|
Nuclear family Simple split family When there is only one Parent Code on the 'Address and Communication Rules' tab of the Student Record. | The parent names will be extracted from the 'Parent or Guardian 1 (Mother)' and/or 'Parent or Guardian 2 (Father)' fields on the 'General' tab of the parent record associated with the student. The address for each parent will be extracted as follows:
Addresses will be excluded from the report if the 'Excl Addr Coll' checkbox is ticked on the 'Addresses & Comm. Rules' tab in TASS.web Student Admin > Student Records > Student Information > Students. |
Complex split family When there is more than one Parent Code on the 'Address and Communication Rules' tab of the Student Record. | The Address Collection (Aus) program will determine the parents for each student using a combination of the 'Staff View' Communication Rule and 'Relationship Tags'.
The parent names will be extracted from the 'Parent or Guardian 1 (Mother) Name' or 'Parent or Guardian 2 (Father) Name' linked to the address with the 'Relationship Tag' matching the 'Biological Parent Tag' or 'Guardian Tag'. The address for each parent identified above will be extracted as follow:
Addresses will be excluded from the report if the 'Excl Addr Coll' checkbox is ticked on the 'Addresses & Comm. Rules' tab in TASS.web Student Admin > Student Records > Student Information > Students. |
Address Tokens
The Address Collection (Aus) program uses the following two Address Token modes for extracting the address data:
Tokenised Addresses (Addresses with Address Validation Enabled) | ‘Tokinised Addresses’ are addresses that have been tokenised and validated using the Address Validation API. To tokenise an address, you can either: Use TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ Tab. Start typing the parent address into the magnifying glass field (below the Parent Name field). Click on the correct address when it appears in the pick list. The address data will automatically populate the required fields, and the ‘View Address Tokens’ icon will appear in the links column. Click this icon to display more information. or Use the TASS.web System Admin > Utilities > Bulk Address Validation to tokenise and review multiple address records. For more information on Tokinised Addresses, refer to the ‘With Address Validation Enabled’ section of the Parents article. | ||||||
Non-Tokenised Addresses (Addresses with Address Validation Disabled) | ‘Non-Tokinised Addresses’ are addresses that have not been verified using the using the Address Validation API. For non-tokenised addresses, the export file is heavily dependent on your parent address records that are maintained using TASS.web Student Admin > Parent Records > Parent Information > Parents conforming to the following:
For more information, refer to the ‘With Address Validation Disabled’ section of the Parents article. |
General Tab
When you open the Address Collection (Aus) program, the ‘General' Tab will appear.
From the ‘General’ tab, you can select ‘Use Previously Saved Configurations’ from the drop-down list or leave the selection blank to create a new report configuration.
Configurations can be saved by entering a Configuration name into the ‘Save this Configuration as' field on the 'Process’ tab.
Currently, there is no option to delete or rename a saved configuration in this program area.
Click ‘Next’ to continue.
After clicking next, a more detailed version of the ‘General’ tab will appear with additional fields.
Fields on the 'General' tab can be used as selection criteria to filter the data to be included in the extract. The fields displayed are similar to those found in TASS.web Student Admin > Student Records > Student Information > Students.
Filter Field | Details |
---|---|
Year Levels | Use the 'Year Group' drop-down list to highlight the relevant 'Year Groups' to include in your export file. DoE requires students in early childhood education programs (referred to as Year 1 minus 2) to be excluded from the submission. Data is only to be submitted for 'Year Groups' '0' to '12'. At your school, 'Year Group' '0' could be 'P' or 'K' (as this is school definable) in TASS.web. Refer to SchoolsHub for more information. Hold down the 'Shift' key to enable a range selection, and hold down the 'Ctrl' key to allow individual selection of additional fields. |
Date of Entry | Use the ‘Date of Entry’ field to include all students who were enrolled on the collection start date in the report by setting the date range picker to ‘less than’ the collection start date. |
Campus | Use the ‘Campus’ field to select the campus to be included in your report. Ensure the campus selected is the same campus the Location AGEID recorded on the 'Location Details' tab. DoE requires Distance Education students to be excluded from the submission. Refer to SchoolsHub for more information. To cross-check your Distance Education student data against your Campus data, you can run the Details Listing and highlight ‘Distance Ed’ and ‘Campus’ in the Report Options > ‘Additional Fields’ section. |
FFPOS (Full-fee paying overseas students) | Use the ‘FFPOS’ field to ‘No’ to exclude ‘Full-fee paying overseas students’ from your report. When ‘No’ is selected for the FFPOS filter field, students with Null in this field on their student record will also be included in the export, as will students who have ‘No’. When ‘Yes’ is selected for the FFPOS filter field, only students who have ‘Yes’ in this field on their student record will be included. DoE requires full-fee-paying overseas students (international students who do not attract Australian Government recurrent funding) to be excluded from the submission. Refer to SchoolsHub for more information. To check FFPOS student data, you can run the Details Listing and highlight ‘FFPOS’ and ‘Residency Status’ in Report Options > ‘Additional Fields’ section. |
User Defined and Billing Tabs
Fields from the 'User Defined' and 'Billing' tabs can be used as additional selection criteria to filter the data that will be included in the extract.
Location Details Tab
DoE uses the information in the 'Location Details' tab to identify the school.
Fields that require further explanation | |
---|---|
* Location AGEID | A unique 5-digit number allocated by the Department of Education identifies a school's location. This number should be above 40000 and below 99999. The ‘Location AGEID’ differs from the school’s ‘AGEID’. |
* State | Select the Australian state or territory within which the school is located. |
* Boarding Students | Select ‘Yes’ or ‘No’ to indicate whether any boarding students will be reported for this location. |
* Education Level | Indicates the education level for this location. Select from one of the following: Primary, Secondary or Combined (both Primary and Secondary). |
* Contact First Name | The first name of the person who is the primary contact for data queries related to this location. Do not include salutations (e.g. Mr, Mrs, etc.). Minimum 1 character. Maximum 30 characters. Do not enter full stops (.), commas (,) or quotation marks (“) or tabs. |
* Contact Surname | The last name of the person who is the primary contact for data queries related to this location. Minimum 1 character. Maximum 30 characters. Do not enter full stops (.), commas (,) quotation marks (“) or tabs. |
* Contact Email | The email address of the person who is the primary contact for data queries related to this location. The value must be entered in the format ‘local@domain’. Maximum 100 characters. |
* Contact Phone | The phone number for the person who is the primary contact for data queries related to this location. It can be a mobile phone number or a landline. For a landline, include the area code. It must be 10 digits in length and only numbers. No spaces, no special characters. e.g., 0730207900. |
* Contact Position | The position of the person who is the primary contact for data queries related to this location. Maximum 100 characters. Do not enter full stops (.), commas (,) quotation marks (“) or tabs. |
Process Tab
The ‘Process’ tab is used to enter information that will be included in your extract and to choose the file format.
Extract Options
* Student Residential Address | This option is used to determine the student address that will be included in this export. Addresses will be excluded from the report if the 'Excl Addr Coll' checkbox is ticked on the 'Addresses & Comm. Rules' tab in TASS.web Student Admin > Student Records > Student Information > Students.
| ||||
* Student's Record Number | The default is to include the TASS Student Code in your extract file. Alternatively, select the 'Alternate ID' Code if this is required for your data extract. 'Alternate ID' is maintained using TASS.web Student Admin > Student Records > Student Information > Students Grid Entry or TASS.web Student Admin > Student Records > Student Information > Students. ‘Alternate ID' is not a mandatory field in the database. Use the 'Students Grid Entry’ program to check that there is no missing data if you intend to use this option. DoE specifies that this number must be numeric only. If your school is using an alpha/numeric or alpha student code, then you will either have to use the 'Alternate ID' code or manually adjust your file before submitting it. |
Parent Options
The 'Relationship Tags' selected in these fields are only used to identify parents/guardians of students in complex split families. For further information on how parent data is extracted for complex split family scenarios, refer to the ' 'How Parent Data Is Extracted for the Address Collection Extract' section above.
* Biological Parent Tag | Select the ‘Relationship Tag’ from the picklist that has been used to identify ‘biological parents’ on the 'Addresses and Communication Rules' tab of the student record. This field will only be active when ‘Use Communication Rules (Lives With Communication Type)’ is selected in the Extract Options section of the ‘Process’ tab. If your school has configured more than one 'Relationship Tag' to identify 'Biological Parents' (e.g. Biological Mother, Biological Father), please contact TASS Software Support for further guidance. |
Guardian Tag | Select the ‘Relationship Tag’ from the picklist that has been used to identify ‘guardians’ on the 'Addresses and Communication Rules' tab of the Student record. This field will only be active when ‘Use Communication Rules (Lives With Communication Type)’ is selected in the Extract Options section of the ‘Process’ tab. If your school has configured more than one 'Relationship Tag' to identify 'Guardians', please contact TASS Software Support for further guidance. |
Parent or Guardian 1 (Mother) Residential Address This field name is customisable. | Select the address block where the ‘Parent or Guardian 1 (Mother)’s’ Residential Address is stored. When the selected address block contains an address, the selected address field will be used instead of ‘Parent or Guardian 1 (Mother) Address’ in the data export. When left blank, the address linked to the 'Parent or Guardian 1 (Mother) Name' will be used. The Person Label used in this field (‘Parent or Guardian 1 (Mother)') is customisable and can be edited by the school in TASS.web Student Admin > Parent Records > Setup Information > Parent Records Setup on the ‘Addresses’ tab. Therefore, your field name may be different to these instructions. |
Parent or Guardian 1 (Father) Residential Address This field name is customisable. | Select the address block where the ‘Parent or Guardian 2 (Father)’s’ Residential Address is stored. When the selected address block contains an address, the selected address field will be used instead of ‘Parent or Guardian 2 (Father) Address’ in the data export. When left blank, the address linked to the 'Parent or Guardian 2 (Father) Name' will be used. The Person Label used in this field (‘Parent or Guardian 2 (Father)') is customisable and can be edited by the school in TASS.web Student Admin > Parent Records > Setup Information > Parent Records Setup on the 'Addresses' tab. Therefore, your field name may be different to these instructions. |
Extract Format
Address Collection Extract | This is in the file format required by DoE for uploading to SchoolsHub. The format required by DoE differs from how the address data is stored natively in the TASS database. Therefore, the data in this report has been reorganised to meet the DoE requirements. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. You can export to an XML File (as required for upload to SchoolsHub) or an Excel® worksheet. The Excel worksheet columns are in the same order and format as the 'Address Collection Data Upload' tool, available on the SchoolsHub website. Refer to the Address Collection Extract Format section below for more information. |
Raw Data Records | Use this option to check your Raw Data Records before reorganising them to meet DoE requirements. Use this extract format to check that your address data is accurate and information is stored in the correct fields. Items of note:
You can only export to an Excel® worksheet. Refer to the Raw Data Records Format section below for more information. |
Export To
XML File | Use this option, along with 'Address Collection Extract', to generate the file that you'll upload to SchoolsHub. |
Excel | Use this option to export 'Raw Data Records' and the 'Address Collection Extract' to an Excel® worksheet to check before creating the final file for uploading to SchoolsHub. |
Save this Configuration as
Enter a Configuration name to use this configuration again in future.
Saved configurations can be selected from the ‘Use a Previously Saved Configuration’ drop-down list that is displayed when you open the Address Collection (Aus) program.
Currently, there is no option to delete or rename a saved configuration in this program area.
Click the 'GO' button to produce your extract file.
Exception Reports
If you have missing data or something is preventing the extract from being produced, a PDF file Exception Report may appear.
There are three types of exception reports that may be displayed:
Exception Report | Reason | Action Required |
---|---|---|
Students with no Communication Rules - 'Lives With' address. | The student does not have at least one address on the 'Addresses & Comm. Rules' tab that has been ticked for the Communication Type 'Lives With'. | Review the 'Addresses & Comm. Rules' tab for the student. Tick at least one address for Communication Type 'Lives With'. |
Students with no Parents. | The student is from a complex split family, and there are no matching biological parents or guardians on the 'Addresses & Comm. Rules' tab of the student record. | Review the 'Addresses & Comm. Rules' tab for the student. Tick at least one address for Communication Type ‘Staff View' and set the relationship tag to match the ‘biological’ or 'guardian’ tag as defined on the 'Process' tab. |
Students with more than two [selected Biological Parent Tag] Parents | There are more than 2 biological parents identified for the student. | Review the 'Addresses & Comm. Rules' tab for the student. Ensure there is a maximum of 2 parents with the biological Relationship Tag. |
After fixing the records identified in the exception report, rerun the extract.
Address Collection Extract Format
The following table indicates the data that will be included in the ‘Address Collection Extract’ file.
Any raw data that contains full stops (.) commas (,) or double quotes (“) will be replaced with blank spaces in the Excel file.
Column | DoE Field Name | TASS Program and TASS Field Name | Details |
---|---|---|---|
A | Student Record Number (SRN) | TASS.web Student Admin > Student Records > Student Information > Students on the ‘General’ tab > ‘Student Code’ or ‘Alternate ID’ field. | The Code/ID number used as the SRN in this export is selected on the 'Process' tab as you generate your extract. Student names are not included in the final XML file. The SRN is an unidentifiable number generated by the school for the purpose of this data collection only. |
B | Boarding Student (D or B) | TASS.web Student Admin > Student Records > Student Information > Students on the ‘General’ tab > 'Boarder' field. | Identifies whether a student is a:
If TASS ‘Boarder' field is set to ‘Yes’, then the DoE field will be 'B'. If TASS ‘Boarder' field is set to ‘No’, then the DoE field will be 'D’. |
C | Education Level Primary (P) or Secondary (S) | TASS.web Student Admin > Student Records > Student Information > Students on the ‘General’ tab > ‘Year Group’ field. | This field identifies whether a student attends Primary or Secondary level education. For all students with a ‘Year Group' of 0 to 6, the program will allocate 'P' for 'Primary’. When 'SA Format' is selected in the 'Data Format' section in the 'Process' tab, all students with a 'Year Group' of 7 will be 'P'. For all other States, students with a 'Year Group' of 7 will be 'S'. For all students with a ‘Year Group' of 8 to 12, the program will allocate 'S' for 'Secondary’. |
D | Address Line 1 | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab. Address data fields differ based on:
| The unit and/or street number, street name and full form of street type (e.g. street, court, etc not St, Crt, etc). The Address used for this data is based on the options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for more information. Tokenised Addresses: Use the Address Token data to generate the address from the following Parent Address Token fields: Unit Type, Unit Number, Street No. or Lot No., Street Name, Street Type, Street Suffix. Non-Tokenised Addresses: Use the Parent Address ‘Address Line 2' field. |
E | Address Line 2 (optional) | Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab. Address data fields differ based on:
|
The Address used for this data is based on the options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for more information. Tokenised Address: Do not use this field. The field will be blank. Non-Tokenised Address: Use the Parent Address ‘Address Line 3' field. |
F | Suburb or City | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Town/Suburb’ field | The suburb, city, locality, township, or shire of the address. |
G | State or territory | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘State’ field. | The Australian state or territory of the address. |
H | Postcode | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Post Code’ field. | A four-digit number allocated by Australia Post. |
I | Parent or Guardian 1 First Name | TASS.web Student Admin > Parent Records > Parent Information > Parents > ‘Parent or Guardian 1 (Mother)’ field. | The first name of Parent/Guardian 1. Not including salutations (e.g. Mr, Mrs, Dr, etc) or both Parent 1 and Parent 2 names (e.g. Bob and Joan). Hyphenated first names are acceptable (e.g. Mary-Ellen). |
J | Parent or Guardian 1 Last Name | TASS.web Student Admin > Parent Records > Parent Information > Parents > ‘Parent or Guardian 1 (Mother) - Last Name’ field. | |
K | Parent or Guardian 1 Preferred Name (optional) | TASS.web Student Admin > Parent Records > Parent Information > Parents > ‘Parent or Guardian 1 (Mother) - Preferred Name’ field. | The preferred name for Parent/Guardian 1. |
L | Parent or Guardian 1 Address Same as Student Address (Y or N) | N/A | Identifies whether Parent/Guardian 1 resides at the same address as the student. If the address of Parent 1 is the same as the student, the program will allocate 'Y'. When set to ‘Y’ the address fields for Parent 1 will be empty. Otherwise, this field will be 'N'. If ‘Same residential address as student’ is N, then data must be entered for Parent 1 address fields. The address fields are the same as Student address fields. |
M | Parent or Guardian 1 Address Line 1 | TASS.web Student Admin > Parent Records > Parent Information > Parents > Parent or Guardian 1 (Mother) Address data fields differ based on:
| The address details for Parent or Guardian 1. The Address used for this data is based on the options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for more information. Tokenised Addresses: Use the Address Token data to generate the address from the following Parent Address Token fields: Unit Type, Unit Number, Street No. or Lot No., Street Name, Street Type, Street Suffix. Non-Tokenised Addresses: Use the Parent Address ‘Address Line 2' field. |
N | Parent or Guardian 1 Address Line 2 (optional) | TASS.web Student Admin > Parent Records > Parent Information > Parents > Parent or Guardian 1 (Mother) Address data fields differ based on:
|
The Address used for this data is based on the options selected on the ‘Process’ tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for more information. Tokenised Address: Do not use this field. The field will be blank. Non-Tokenised Address: Use the Parent Address ‘Address Line 3' field. |
O-Q | Parent or Guardian 1 Suburb or City State or territory Postcode | Refer to the Details mentioned above in Student Data area (columns F-H) for more information. | |
R | Are you reporting Parent 2? (Y or N) | This field identifies if a second parent address is being reported. If a Parent/Guardian2 record is provided, this field will be set to ‘Y’. If there is no second parent address being reported, this field will be set to 'N'. | |
S-AA | Parent or Guardian 2 First Name Last name Preferred Name (optional) Same as student address? (Y or N) Address Line 1 Address Line 2 (optional) Suburb or City State or territory Postcode | TASS.web Student Admin > Parent Records > Parent Information > Parents > Parent or Guardian 2 (Father) | These fields are similar to the 1-Q columns detailed above for ‘Parent or Guardian 1’ and will only be populated with data for ‘Parent or Guardian 2’ when Parent 2 address is being reported. |
Raw Data Records Format
Use the ‘Raw Data Records’ to check that your address data is accurate and that information is stored in the correct fields.
The ‘Raw Data Records’ Extract Format will return a maximum of three separate rows per student grouped by the ‘Student Code’:
One record for the student with a 'Record Type' of 'St'.
One record for the first parent/guardian of the student with a 'Record Type' of 'Pa'.
One record for the second parent/guardian of the student with a 'Record Type' of 'Pa' (if applicable).
The following table indicates the data that will be included in the ‘Raw Data Records’ when exported to an Excel file.
Column | Excel File Column Name | TASS Program and TASS Field Name | Details |
---|---|---|---|
A | Student Code | TASS.web Student Admin > Student Records > Student Information > Students on the ‘General’ tab > ‘Student Code’ or ‘Alternate ID’ field. | The Code/ID number used for Student Code column is selected on the 'Process' tab as you generate your extract. |
B | Address Line 1 | TASS.web Student Admin > Parent Records > Parent Information > Parents > Address Tab > ‘Address Line 1’ field. Address data fields differ based on:
|
If an address is non-tokenised, this address field will not generate in the XML file. Refer to the ‘Address Tokens’ section for more information. |
C | Address Line 2 | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Address Line 2’ field. The Parent Address used for this field is based on options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
To generate the 'Address Collection Extract’ XML file for non-tokenised addresses, the data entered into the ‘Address Line 2’ field must be formatted exactly, as shown in the examples below. Use this Raw Data Records report to check that your data is formatted correctly. Refer to the ‘Address Tokens’ section for more information. Examples For a house number and street name and type: 31 Thompson Street For a unit or flat number as well, enter the unit/flat number with a slash and no spaces. 12/31 Thompson Street For a Lot, Section, Portion or RNN plus street name and type: Lot 9 Farrar Road Section 34 Stuart Close RNN 622 Ross Highway Portion 105 Johnson Road The abbreviations 'Sec' and 'Por' can be used. Do not enter any commas into this field. Use this report to ensure that there are no PO Boxes included in the report. All listed addresses must all be physical Residential Addresses. Refer to the guidelines for ‘Address Line’ data at the beginning of this article for more information. To check for PO Box data from being included, run the Bulk Address Validation program. |
D | Address Line 3 | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Address Line 3’ field. The Parent Address used for this field is based on options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
If an address is non-tokenised, this address field will not generate in the XML file. Refer to the ‘Address Tokens’ section for more information. |
E | Town / Suburb | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Town/Suburb’ field. |
The Parent Address used for this field is based on options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
F | Postcode | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘Postcode’ field. |
The Parent Address used for this field is based on options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
G | State | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘Address’ tab > ‘State’ field. |
The Parent Address used for this field is based on options selected on the 'Process' tab. Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
H | Year | TASS.web Student Admin > Student Records > Student Information > Students on the 'General' tab > 'Year Group' field. | This field will only be populated for student records (record type = St in column M). |
I | Boarder | TASS.web Student Admin > Student Records > Student Information > Students on the 'General' tab > 'Boarder' field. | This field will only be populated for student records (record type = St in column M). |
J | Surname | TASS.web Student Admin > Student Records > Student Information > Students on the 'General' tab > 'Surname' field. | This field will only be populated for student records (record type = St in column M). Student Names will not be included in the final extract uploaded to SchoolsHub. They are only included in this Excel file for data-checking purposes. |
K | Given Name | TASS.web Student Admin > Student Records > Student Information > Students on the 'General' tab > ‘First Name' field + 'Other Name’ field. | This field will only be populated for student records (record type = St in column M). Student Names will not be included in the final extract uploaded to SchoolsHub. They are only included in this Excel file for data-checking purposes. |
L | Parent Code | TASS.web Student Admin > Parent Records > Parent Information > Parents > ‘Parent Code’ field. | |
M | Record Type (St or Pa) | For all students, the 'Record Type' will be 'St'. For all parents, the 'Record Type' will be 'Pa'. | |
N | Parent First Name | TASS.web Student Admin > Parent Records > Parent Information > Parents on the ‘General’ tab > ‘Name’ field > ‘First Name’ field. | This field will only be populated for parent records (record type = Pa in column M). Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
O | Parent Last Name | Student Admin > Parent Records > Parent Information > Parents > 'General' tab > ‘Name’ field > ‘Surname’ field. | This field will only be populated for parent records (record type = Pa in column M). Refer to the 'How Parent Data Is Extracted for the Address Collection Extract' section above for further information. |
P | Address same as Student Address | Y = the Parent’s Residential address is the same as the Student’s Residential Address. N = the Parent’s Residential address is different to the Student’s Residential Address. This field will only be populated for parent records (record type = Pa in column M). |