Data Changes for 2017

Sysfile.PayPlan_Item to store default Cost Centre for Payment Plans

Sysfile.Cutoff  Number  Cutoff time for OnLine Payments

Subject_P    Data field Numeric to identify Breakset Set associated with the period

Receipt file added 2 fields to enhance FACTS integration

Identity  Add field for Image# to incorporate images to Identity rather than student

Identity  Add Gender field

Student Add field for Graduation Year

Absent EN_BATCH   change to String  50 character

Employee Super and Banking and Standard Pay . Add Date so that timesheet records can be created in advance and dated as per pay date. Need to add index that combines Type ie Standard or Timesheet and Date

Teacher  Add field for Working with Children Date verified and Status of application

Ver 2018 Development Changes

3/7/2019 Curriculum 2018.0.0.512 Minor change to date format in ACARA export changed from 01012019 to 01/01/2019.   Fixed bug in Result entry where change to data was updating Sub.Date_Entered.

1/7/2019 Finance 2018.0.0.250 Released tax changes for Australia’s new HELP Student loans. HELP and SFSS are now consolidated and the new tax table is now incorporated within the program.

12/6/2019 Timetable 2018.0.0.74  Added facility in Timetabler External Interface to import timetable for discrete year levels

6/6/2019 Curriculum 2018.0.0.497  MOE Roll return fix to ensure identified special characters are stripped from the submitted file.

5/6/2019 Finance 2018.0.0.240 Removed using Pay threshold for all types of Superannuation other than Monthly

4/6/2019 Curriculum 2018.0.0.486  Adjusted email address choices in eMerge to be responsive to Freedom model

4/5/2019 Foundation 2018.0.0.25  Adjusted update to Alumni based on changes to Identity in accord with changes associated with Freedom model

2/5/2019 Finance Payroll  2018.0.0.235 Added changes to cater for leave entitlements to be held unavailable until at he end of an accrual period so that now three options are available:

  • entitlement available at the beginning of the period
  • at the end
  • as earned

18/4/2019 TimeTable 2018.0.0.68 Modified TimeTabler sCourse import to preserve Date a subject was originally entered and to maintain attachment to previously entered results.  Also provided retention of Modified program flag in the replaced subjects

18/4/2019 Finance 2018.0.0.231  Fixed bug in Payroll Transaction Listing in Employee Order where employees were skipped when emailing prior Pay slips

7/4/2019 Scholastic 2018.0.0.470 Extended output options in Assessment Related reporting to cater for greater use of Freedom. Important bug fix to version 2018.0.0.438 where changes led to incomplete selection of eMail addresses in .  Adjusted code to set images table self correcting under Freedom.

4/4/2019 Debtors 2018.0.0.308  Bug fix where reprints of some debtor receipts were being misdirected under Freedom.

21/3/2019 Finance 2018.0.0.200  Added additional functionality to Ledger Budget Import enabling the re-importing of Prior Year budgets and enabling the importing of a revised current year budget based on an annual figure distributed according to previously established monthly distributions.

21/3/2019 Debtors 2018.0.0.304  Added facility in Batch Billing to enable schools to run a catchup billing based on Discount only. Where schools wish to rerun discounts only for families previously billed but where discounts were not applied at that time.

21/3/2019 Scholastic 2018.0.0.438  Extended output options in Assessment reporting to cater for greater use of Freedom. Corrected bug when verifying counters to ensure images added through Spider are considered in the calculation. NZAQ Standard import Fixed bug where standards with option of Digital Exam were not being correctly taged in Back Office. Schools need to download Followup then re-import the latest standard file.

10/3/2019 Debtors  2018.0.0.298 Modifications to Account Printing and Sundry Account Printing as well as Voluntary Payments printing to better align them with the Freedom Model, enabling output under the Freedom Model without the need to use a Tagset. These modules now support “All families” without using a tagset.

8/32019 Scholastic 2018.0.0.421 New Zealand NZQA Result import. Added addition identifier (Given name) to error report to assist in determining student.

8/3/2019 Scholastic 2018.0.0.418 All Modules. Addressed a security vulnerability in back office modules

25/2/2019 Finance 2018.0.0.172  Removed Images from Asset file

25/2/2019 Curric 2018.0.0.374 MOE Data Submission., Advised by MOE to report STP provider 11 as not a valid entry owing to to-days advice of liquidation of this service provider.

22/2/2019 Curric 2018.0.0.373 Government data submissions. MOE NZ Roll Returns added support for electronic approval and submission. NAPLAN data captures of student and care-giver details, tweaked for freedom to ensure only active care-givers are checked for items such as language.  Student Import added Freedom model support to csv imports.

20/2/2019 TimeTable 2018.0.0.46 Tweaked TimeTabler import to cater for minor change in the way custom entries are expressed in sCourse from TimeTabler.

8/2/2019 Curric 2018.0.0.343  Markbook creation modification. Added support in Areas of Assessment of type “data” to address a data field where the subject period specified is dynamic, based on the current subject period when the markbook was created. When identifying the subject period to be used you can now specify a period of eg -1.0. Should this be the case and the markbook is for subject period 19.1 then the specific data column will draw data from subject period (19.1 – 1.0) ie Pd 18.1, in other words from the previous year.



16/1/2019 Debtors 2018.0.0.251 Adjusted Debtor Family selection in Family tag set to enable selection of all families with a balance. Added facility to select on debtors proper or Sundry transactions. These changes made specifically to assist Freedom schools to select families when sending out accounts

15/12019  Finance 2018.0.0.168  Added support to Staff View for Freedom compatibility

27/12/2018 Curric 2018.0.0.310 Added support to use sort order in Area of Assessment allocation when creating new markbooks.

15/12/2019 Curric 2018.0.0.309 Added support to Staff View for Freedom compatibility

14/01/2019 Curric 2018.0.0.304 Bug fix to ensure logged in user is user passed to MOE Dex server in Arrivals and Leavers submissions.

10/01/2019 Curric 2018.0.0.300 Removed Country drop down list from staff entry to bring this in line with Freedom module

9/1/2019 Finance 2018.0.0.167 Adjusted ledger Transaction Entry for Payments batch where a payment is referenced to a specific Payee Creditor code then the default ledger dissection for that creditor is shown as default in payment entry dissection.

18/12/2018 Curric 2018.0.0.260 Adjusted NZ voting routines to be Freedom aware

18/11/2018 Curric 2018.0.0.215 Adjusted code to cater for Google’s change of policy enabling access to Google Geo code mapping control fixing Goggle poll error when entering an address. Addressed condition in eAsttle upload where error condition triggered by a space in front of NSN. Minor screen change to cater for Freedom email options in emailing Assessment reports.

13/11/2018 Finance 2018.0.0.142  Ledger Model Accounts added Campus to KPI student and Teacher counts. Also catered for in Spider KPI reports. Requires a Spider Ver 2018.11.13 minimum.  Fixed payroll bug associated with Sick and Holiday pay not adding to hours accrued at a Pay Table.

31/10/2018 Debtors 2018.0.0.203 Bug fix Import Spider Payment Portal Receipts

29/10/2018 Finance 2018.0.0.124 Fixed bug in Ledger Budget Imports released in ver 2018.0.0.123

29/10/2018 Debtors 2018.0.0.192 Added functionality to Import payments made through MyXPlor

05/10/2018 Curriculum 2018.0.0.197 Added support for new Student Address Capture for Australian Schools for 2018 format. This feature supports both Freedom and Non Freedom Schools

12/9/2018 Curriculum 2018.0.0.160  Primarily for Freedom schools. Updated ACARA export to extract based on Freedom Model. Modified eMerge to be sensitive to Family eMail options set in the Freedom model.  Added Freedom sensitivity to Assessment Reports for eMailing.

29/8/2018 Curriculum 2018.0.0.122  Bug fix in NZQA Tereo paper submission

28/8/2018 Curriculum 2018.0.0.121 Bug Fix where Homestay Care Giver given name was being written to Identity record as Surname.  Debtors 2018.0.0.169 Corrected display bug in Receipt entry where tender identified as Credit Card

16/8/2018 Curriculum 2018.0.0.119  Added support for new Age/Grade census for NT schools. Added support for Assessment report printing based on the Freedom Model for schools that have converted to Freedom using the new communication options available in Freedom. Added capacity to read in up to 4 simultaneous import co-curriculum records in Student Import by csv.

13/7/2018 Finance 2018.0.0.104 Added functionality in Payroll generation enabling the generation to be filtered based on employee payment frequency eg restrict payroll generation to just Monthly employees

12/7/2018 Finance 2018.0.0.99 Australian Payroll added functionality to cater for additional HECS classification. This change requires a modification to the HECS/HELP rates

New HELP table

New HELP No Tax Threshold table

Download Tax and New HECS Scales

5/7/2018 Finance  2018.0.0.89 Payroll Critical update A fix has been released to enable users to select how they wish to treat a banking allocation in payroll generation where the banking $ amount is set to zero. In the version release prior to this update the banking option had been reset so that a bank distribution of $ zero would allocate 0 dollars to that account. This was a change to prior behaviour

2/7/2018 Curriculum 2018.0.0.106 Fixed bug in NZQA Standard import for Digital Assessment options. Importing standard file was not importing the assessment options.

2/7/2018 Trigger Fixed bug re selecting Unmarked rolls

28/6/2018 Debtors 2018.0.0.154  Added facility to import FACTS early settlement discounts into AutoBill Batch.

Curriculum 2018.0.0.97 Added support for Freedom Model in Government reporting for Australian schools to return care-giver levels of education etc based on the Freedom model.

Finance 2018.0.0.83  Changes for 2018-19 Australian tax year. Changes to cater for Single Touch Payroll

16/5/2018  Debtors 2018.0.0.128 Added Campus to Student Selection in Debtor Batch Billing

9/5/2018 Curriculum 2018.0.0.66 Govt data Collection – Small bug fix in AEDC upload. Removed line feed mid record that was resulting in each student occupying 2 lines in csv

7/5/2018 Debtors 2018.0.0.123  Added data import for modified CBA-EVOLVE Card format to import payments directly into receipts.

1/5/2018 Curriculum 2018.0.0.63  Fixed bug where names that included a bracket eg Smith John (Johno) failed to translate correctly when appended with eMail ie  Smith John (Johno)(

1/5/2018 Curriculum 2018.0.0.63 – Added support for Freedom schools to cater for Account EMail owner to write this address to Identity.EMail_Billing and to change Caregiver email from Identity.EMail to Identity.EMail_Home this ensuring that Identity.EMail is reserved for School or Business email address.

30/3/2018 Debtor Ver 2018.0.0.89  Added Read Only access to Back Office Student view for Freedom schools

26/3/2018 Curriculum Ver 2018.0.0.61  Added “Canteen Staff” to Staff status

15/3/2018 Curriculum Govt data Collection – Added format for AEDC upload

3/3/2018 Debtors Ver 2018.0.0.68  Added functionality to Account emails to embed the  Payment Plan commitment amount into the account email body enabling schools to advise caregivers of the regular amount that will be withdrawn from their accounts.

3/3/2018 Finance Ver 2018.0.0.9  Bug Fix. In ver 2018.0.0.7 (27/2/2018) we released a bug in the printing of employee payslips that resulted in the display of duplicate references to banking’s made as a result of that pay.  This fix only applies to users who took the followup from 27/2/2018 – 3/3/2018 Finance Versions 2018.0.0.7 or 2018.0.0.8. This release in Ver 2018.0.0.7 addressed any rounding errors that occasionally occurred when displaying employee banking’s.

1/2/2018 Release of Ver 2018 Data Structure

1/12/2017 Scholastic Released changes for NZ MOE roll return submission

22/6/2017 Finance Ver 2016.0.0.194 Payroll changes for the 2017 – 18 Australian tax year including updates to Printed Payment Summaries and changes to Medicare rebate calculations to comply with ATO specifications. See for details

23/5/2017 Curriculum Ver 2016.0.0.521   Fixed bug in MOE reporting where program reported that the selected file name was incorrect.

18/5/2017 Curriculum Ver 2016.0.0.516 Fixed bug in NZQA upload of Emergency results where these results were passing a nul Date Complete resulting in an xml Schema failure during upload to NZQA

15/5/2017 Extended Community Ver 2016.0.0.19 Added Activity Category for “Interests”

14/5/2017 Curriculum Corrected duplicate error message associated with duplicate Alumni Activities when a student is departed, re-enters and is then departed again.

23/4/2017 Curriculum Ver 2016.0.0.504 Added 2017 Victorian SFOE data collection format. StudentID, Parent 1 School Educ, Parent 2 School Educ, Parent 1 Non School Educ, Parent 2 Non School Educ, Parent 1 Occupation, Parent 2 Occupation

10/4/2017 Curriculum Ver 2016.0.0.503 Added functionality to support the new NZQA initiative re Assessment Options for Digital Submissions ar Digital Exams. For more details see …

4/4/2017 Debtors Ver 2016.0.0.230 Encrypted Credit Card details to render PCI ready.

4/4/2017 Curriculum 2016.0.0.492  Added new street types for address capture inc Outlook, Run, End, and Firetrack

20/3/2017 Debtors Ver 2016.0.0.226 Added functionality to eMail caregivers prior to performing a direct debit draw down on their bank accounts

18/11/2016 Curriculum  New Zealand Ver 2016.0.0.307  Added import of University Entrance Approved standards as part of the standard import routine. The import requires the presence of the UEApproved.csv file which is now shipped along with the latest file. Extract the UEApproved.csv file along with the Standard.txt file to the same folder location. The standard import routine will do the rest.

7/11/2016 All modules From Address using Print Q. It is now possible to enter a generic “From Email Address” when processing bulk emails. This enables the system to show the email as from “” or “” instead of using the actual from address of the logged in user.

3/10/2016 Debtors Ver 2016.0.0.108   Added Cutoff time to import of OnLine Payment entries enabling the user to set the time at which the Secure Payment provider closes off transactions for the specific day. This enables receipt batches to reflect all transactions prior to this time and hold over latter transactions to the subsequent day.

30/9/2016  Finance Ver Payroll Ver 2016.0.0.91  Added support for superannuation clearing house format for QuickSuper Statewide Contribution CSV file specification (v2)

22/9/2016 Curriculum Ver 2016.0.0.233  Added TASC upload capability to Data Capture for Tasmanian schools. Read more

7/6/2016 Debtors Ver 2016.0.0.70  Added functionality to Debtor Payment Plans and Home Stay Plans. In the past the homestay transaction was written to the Creditor Payment area with reference to the family related to the payment. This has been adjusted to include reference to the Student and/or the comment text entered at the time of the creation of the HomeStay Plan. Text entered in this commentary will display in the Creditor Invoice Batch

20/5/2016 Curriculum Ver 2016.0.0.133  Added a check box in Subject Code view enabling the user to check a subject to exclude it from the displayed list of subjects within the “Result Entry” screens. This change will require a version of Spider released after 20/5/2016

20/5/2016 Debtors Ver 2016.0.0.74 Account Master File. Added additional filters to enable user t display

  • only families with a Db or Cr balance
  • only non current families with a Db or Cr Balance
  • only non current families with a Held Deposit
  • only “suspended” debtors

13/5/2016  Finance Ver 2016.0.0.62  Payroll. Added facility to edit Deduction amounts prior to Payroll Generation without the need to create Time Sheets. A much faster way to enter routine deductions such as Staff Lunches etc.

22/3/2016 Finance NZ Release of NZ Tax Scales for 2016 – 17 tax year.

22/3/2016 Curriculum Ver 2016.0.0.72 Security. Added a new security object “Deny Access to Back Office” Users assigned this object will be able to access “Spider” but will not be able to login to “Back Office”

22/3/2016 Curriculum Ver 2016.0.0.72 Co-Curriculum Added Semester 1 and Semester 2 to list of seasons ie  Summer, Winter, Term 1 – Term 4, now Sem 1 and Sem 2

22/3/2016 Finance Ver 2016.0.0.11  Corrected anomaly in the Monthly Super calculation associated with using a second Monthly Super line.

15/3/2016 Debtors Ver 2016.0.0.46 Receipting  Added PCSQ to receipting to support Email and Document Management via PCSQ thereby supporting Office365 as the SMTP server within the receipting module.

15/3/2016 Curriculum Ver 2016.0.0.72 Changes to Absence Roll Collection and Trigger to better cater for new flexibility in Period and Day definitions. Added a functionality to Early Notification to enable user to set the system to ignore unexplained absences, should the child arrive at the school at a later period in the day, there by not sending the parent a notification for unexplained absence if the child has subsequently arrived at school.

15/3/2016 Curriculum Ver 2016.0.0.72 Changes to Attendance Analysis reports significantly speeding up the production of these reports.

10/02/2016 Curric Ver 2016.0.0.46  Changes to Absence Roll Marking to cater for roll marking by full year level groups eg “show roll with all students from Primary School”. Misc tweaks and minor bug fixes associated with Roll Marking and Timetable to ensure new Time Period Header model caters for all varied school situations, to increase the flexibility and function of roll marking, associated with varying period lengths and differing periods on certain days, or for particular year levels.

17/1/2016  Release of 2016 Data Structure changes. Where users have not received an email notification they should contact PCSchool for advice on download.

17/1/2016  Debtors  Ver 2016  Added a new table for entering multiple student discount structures, removing the need for the Discount Calculator as sibling discounts are now calculated as the invoices are created.

Spider – Optional Payments in ‘Pay Student Fees’ is now sensitive to tag set

Available in Spider Version and above.

PCSchool have now made the Optional Payments in the ‘Pay Student Fees’ control sensitive to a saved student tag set. This means that the optional fee will only show for those students in the tag set not for all students / families as was previously the case.

The first step is to create and save a student tag set of the students to be included (via PCSchool BackOffice) and save this tag set into the pcschool/documents/webpayments folder on the server. save student tagset

Next open the ‘payments.xml’ and add the tagset name which defines students to which this payment is related to.Paymentsxml

Once the tagset has been saved and the xml modified the parent, if they have a student in the tagset, will see the optional charge on their Student Fees screen in the Spider.Student Fees View