Introduction / Chapter 01
Preparing for the Pupil Referral Unit Census 2012 Return / 1
Introduction / Chapter 01
Preparing for the Pupil Referral Unit Census 2012 Return / 1
C / Contents

01Introduction......

Introduction......

How has the Pupil Referral Unit Census Return Changed Since Last Year?

Permissions Required......

What Version of SIMS is Required?......

Importing Filesets......

Before Importing the Revised Files......

Importing the Revised Files......

Overview of the Pupil Referral Unit Census 2012 Return Process...

02Carrying out a Dry Run......

Why Carry out a Dry Run?......

The Dry Run Process......

Creating and Validating the Return......

Producing Detail Reports......

03Preparing School Level Information......

Checking Establishment Details......

Checking Address, Telephone and Email Information......

04Preparing Pupil/Student Level Information......

Checking/Correcting Pupil/Student Details......

Updating Information Using the Bulk Update Routine......

Recording Leavers and Re-Admissions......

Recording a Leaver......

Re-Admitting a Pupil/Student......

Deleting Unwanted Pupil/Student Records......

Checking/Correcting a Pupil/Student’s Basic Details......

Recording a Pupil/Student’s Change of Surname......

Checking/Correcting Registration Details......

Checking/Correcting Enrolment Status, Admission Date, Year Taught In and Boarder Status

Checking/Correcting UPNs......

Checking/Correcting Unique Learner Numbers......

Checking/Correcting Part-Time Pupil/Student Information....

Checking/Correcting the National Curriculum Year Group.....

Checking Home Address Information......

Checking Free School Meals Eligibility......

Checking/Correcting Ethnic and Cultural Information......

Checking/Correcting Service Children in Education Indicator

Checking/Correcting Connexions Assent......

Checking/Correcting Special Educational Needs Information......

Preparing Exclusions Information......

Recording an Exclusion......

Checking/Correcting In Care Details for Excluded Pupil/Students

Preparing Attendance Information......

Checking/Correcting Hours for Nursery Children......

Identifying which Pupils have no Hours Entered......

Updating Time in Unit Information......

Resetting Time in Unit Values......

Identifying which Pupil/Students have no Time in Unit Specified

05What Next?......

Where Can I Get More Information?......

Index......

/

Pupil Referral Unit Census 2012Preparation Check List

Use this check list to tick off each of the preparation tasks when they have been completed.

Complete / Description
 / Check with your System Administrator/Manager that you have the appropriate permissions to run the PRU Census and to record associated data.
For more information, please seePermissions Requiredon page3.
 / Upgrade to the SIMS 2011 Autumn Release (SIMS 7.142) or later as soon as possible to enable dry runs to be carried out.
For more information, please seeWhat Version of SIMS is Required?on page5.
 / Check with your System Administrator/Manager that the latest fileset version has been imported.
For more information, please seeImporting Filesetson page5.
 / Carry out a dry run to determine what information needs to be updated.
For more information, please seeCarrying out a Dry Runon page11.
 / Check School Level information.
For more information, please seePreparing School Level Informationon page 19.
 / Ensure that leavers and re-admissions have been recorded, and that any pupil/student records created in error have been deleted.
For more information, please see:
Recording Leavers and Re-Admissions on page 27
Deleting Unwanted Pupil/Student Recordson page30.
 / Check the pupil/student’s basic details, e.g. name, date of birth, gender, etc.
For more information, please seeChecking/Correcting a Pupil/Student’s Basic Detailson page30.
 / Check the pupil/student’s various registration details, e.g. enrolment status, admission date, year taught in, etc.
For more information, please seeChecking/Correcting Registration Details on page 32.
 / Check the pupil/students home address information.
For more information, please see Checking Home Address Information on page 43.
 / Check the pupil/student’s eligibility for free school meals.
For more information, please see Checking Free School Meals Eligibility on page 45.
 / Check the pupil/student’s ethnic and cultural information.
For more information, please seeChecking/Correcting Ethnic and Cultural Informationon page46.
 / Indicate whether the pupil/student is a child of a parent(s) in the armed forces.
For more information, please see Checking/Correcting Service Children in Education Indicatoron page47.
 / Check the Connexions Assent information.
For more information, please see Checking/Correcting Connexions Assenton page47.
 / Check Special Educational Needs information.
For more information, please see Checking/Correcting Special Educational Needs Informationon page48.
 / Check exclusions information.
For more information, please seePreparing Exclusions Informationon page50.
 / Check attendance data.
For more information, please seePreparing Attendance Informationon page56.
 / Check Hours at Setting and Funded Hours information (applicable to schools that have 2, 3 or 4 year olds pupils only).
For more information, please see Checking/Correcting Hours for Nursery Childrenon page57.
 / Check the Time in Unit recorded for all pupil/students who are on-roll on census day.
For more information, please see Updating Time in Unit Informationon page61.
Notes
Preparing for the Pupil Referral Unit Census 2012 Return
Preparing Pupil/Student Level Information / 04
01
/

Introduction

Introduction

This preparation guide has been produced to help to identify the most common tasks that need to be carried out before running the Pupil Referral Unit (PRU) Census 2012 Return.

The PRU Census is an annual return to be completed in Spring each year. The 2012 return can be completed in SIMS, enabling you to utilise the data stored in the SIMS database.

/ NOTE: PRUs provide full-time and part-time education for pupil/students with a range of ages. Therefore, the contents of the graphics (dates, names, etc.) displayed in this document are examples only of what you might expect to see when using SIMS to prepare for the forthcoming PRU Census Return.

How has the Pupil Referral Unit Census Return Changed Since Last Year?

Changes to the Pupil Referral Unit Census Return include the following:

Items Removed from the 2012 Census
  • Source of Ethnicity
  • In Care information, except for those with exclusions
  • Parental Contacts
  • Mode of Travel
  • Gifted and Talented.
Census Details Panel
  • The census Description now defaults to PRU Census Spring 2012.
  • The Calculate All Details button has been moved from the School Information panel to the top right-hand side of the Census Details panel.
Update Hours for Nursery Children Panel

Applicable to schools with 2, 3 and 4 year olds only

For the first time, all schools, except City Technology Colleges, Academies and non-maintained special schools, are required to submit the Funded Hours as a separate data item while still providing Hours at Setting (a combination of funded and unfunded hours).

  • Update Hours for Nursery Children panel
  • The previously named Update Hours at Setting panel has been renamed Update Hours for Nursery Children.
  • A Funded Hours column has been added to the individual 2, 3 and 4 year old grids. By default, no values are displayed in the Funded Hours column, as this is the first time that it is being collected.
  • The Age at date is now displayed on the Update Hours for Nursery Children panel.
  • Update Hours for age year olds page
  • The previously named Update Hours at Settingfor age year olds panel has been renamed Update Hours for age year olds.
  • The Tools | Statutory Returns Tools menu routes have been renamed to reflect the change in page names.
  • The Funded Hours column has been added to the right-hand side of the grid.
Update Provider Status Page

The Update Provider Status page is accessed via Routines | Statutory Returns | PRU Census (Provider Status panel) and Tool | Statutory Returns Tools | Update Provider Status.

After saving, the display in the Enrolment Status column is now refreshed to reflect the updated provider status. The values then displayed in the Enrolment Status column are those collected in the return.

/ IMPORTANT NOTE: The Enrolment Status recorded in the Registration panel viaFocus | Pupil (or Student) | Pupil (or Student) Details is not updated.
The update(s) made on the Update Provider Status page are for PRU Census purposes only.
Teenage Mothers Panel

For clarity, one of thelabels (Number of places available for teenage mothers), displayed on the Teenage Mothers panel has been changed to Number of teenage mothers expected to attend in Census week.

Teenage Mother Report

The previously entitled General report has been renamed Teenage Mothers report. The report criteria has also changed to more accurately reflect the content of the report.

Permissions Required

The following permissions are applicable to PRU Census return users.

Producing the Return

To produce the return, you will need to be a member of the Returns Manager user group in System Manager.

Editing and Preparing Data

Users who edit and prepare data must have permissions to access other areas of SIMS, e.g. pupil/student details, school details, etc. These users will need to be a member of any of the following user groups in System Manager:

  • Administration Assistant
  • Admissions Officer
  • School Administrator.
Importing Filesets

A fileset contains the files used to determine the information to be collected in the return. It also enable updates to the Validation Errors Summary and the Summary report (both derived from files supplied by the Statutory Body), and detail reports (provided by SIMS) to be imported into SIMS between SIMS releases.

It is therefore essential that the correct fileset is imported. The correct fileset can be identified by its accompanying number.

To use the Import Fileset functionality (via Tools | Setups | Import | Fileset), you must be a member of one of the following user groups in System Manager:

  • Personnel Officer
  • Returns Manager
  • System Manager.

For more information about the Import Fileset functionality, please see Importing Filesets on page 5.

Where to find More Information about Permisssions

Please see your System Administrator/Manager if you are not sure whether you have the required permissions. For more information, please refer to the Managing SIMS Users, Groups and Databaseshandbook.

For a list of the permissions available for each release, please refer to the applicable permissions spreadsheet, which can be found on our SupportNet website ( by entering PERMLIST in the Site Search field on the SupportNet Homepage then clicking the Go button.

What Version of SIMS is Required?

In order to run the PRU Census 2012 Return, you must have the SIMS 2011 Autumn Release (7.142) or later installed.

To check which version of SIMS you have installed, open SIMS then select Help | About SIMS. A dialog similar to the following graphic is displayed.

The version should read 7.142 or later.

Importing Filesets

Applicable to the Personnel Officer, Returns Manager andSystem Manager only

A fileset contains the following:

  • Files used to determine the information to be collected in the return
  • Updates to the Validation Errors Summary (derived from files supplied by the Statutory Body)
  • Updates to the Summary report (derived from files supplied by the Statutory Body)
  • Updates to detail reports
    SIMS provides detail reports to enable the checking of data used to generate the return. These report files are included as part of a SIMS release.

Occasionally, additions or corrections are made to these files, after a SIMS release, which are required for the forthcoming return. The Import Fileset functionality is provided to enable these files to be imported into SIMS by the Personnel Officer, Returns Manager or System Manager between SIMS releases. For more information, please see Permissions Requiredon page3.

/ IMPORTANT NOTE: The report files are not always updated between releases.Therefore, it is not always necessary to use the Import Fileset routine. A SupportNet news feed will be posted if updated files are available for import.

If revised files are supplied, the fileset will be available as a .ZIP file, which should be downloaded from SupportNet, unzipped, then imported into the SIMS Document Management Server (DMS) via Tools | Setups | Import Fileset. Ensure that the DMS is configured correctly before attempting to import the files.

/ TIP: To check which version of the fileset is currently in use, select Routines | Statutory Returns | <census name>, select a return then run the Create and Validate routine. The Validation Fileset ID is displayed on the left-hand side of the Validation Errors Summary panel header. For information about the latest available Fileset version, please check the PRU Census 2012 News Feed on SupportNet.

Before Importing the Revised Files

To enable the file(s) to be imported successfully, ensure that the DMS is configured correctly. This is achieved via Tools | Setups | Document Management Server. Click the Test server connection button to check if the specified DMS is available for use and functioning correctly.

If the connection is unsuccessful, check the following details:

  • The Protocol field defaults to http and should not be edited.
  • The Computer name should be the name/number of the PC on which the DMS is installed.
  • The Port number is usually 8080. The number must be between 0 and 65535.
  • The Active check box must be selected, indicating that the server is in use.

Click the Test server connection button again. If the DMS is now working correctly, click the Save button.

For more information, please refer to the Setting up and Administering SIMS handbook.

Importing the Revised Files

1.If revised files are supplied, download the required .ZIP file from SupportNet to a folder of your choice. The SupportNet resource number is quoted in the associated news item.

2.Unzip the .ZIP file to a folder of your choice.

3.In SIMS, select Tools | Setups | Import Fileset to display the ImportFileset page.

4.Click the Browse button to display the Open dialog.

/ NOTE: The following graphics show example data only.

5.Navigate to the location of the unzipped fileset. The file name is made up of the following data fields: <Fileset Number>-<Census Name<Term and Year>Fileset.mfs.

6.Highlight the file then click the Open button. Alternatively, doubleclick the required .MFS file to return to the ImportFileset page.

/ IMPORTANT NOTE: If more than one .MFS file is displayed in the Open dialog, care should be taken to select the correct file.

Details of the selected fileset are displayed, including the version Number of the fileset, the Release Date and a description (Title) of the fileset.

7.Click the Import Fileset button to import the fileset into the DMS. When the import process is finished, Import complete is displayed at the bottom left-hand side of the Fileset panel.

8.After installing the fileset, re-open SIMS to ensure that the new data takes effect.

9.Run the return in the usual way.

/ NOTE: A fileset can be re-imported if, for example, during the previous import the data corrupted.

Overview of the Pupil Referral Unit Census 2012 Return Process

The following provides a brief outline of the steps involved in producing the PRU Census Return. If data has been regularly and accurately maintained, many of the activities in this document will be unnecessary. However, it is advisable to check to ensure that the data is up-to-date.

1.Upgrade to the SIMS 2011 Autumn Release (SIMS 7.142) or later.

2.Carry out one or more dry runs to identify any errors that may exist in your data.

3.Ensure that the relevant pupil/student, staff and school data exists in SIMS and that it is complete and correct. Use the SIMS Bulk Update routine (Routines | Pupil | Bulk Update) to correct missing/invalid data as required.

4.Complete the required information on the Census Return Details page via Routines | Statutory Returns | PRU Census.

  • Enter non-student data.
  • If SIMS Attendance is not in use, enter the required attendance information.

5.Create and validate the return.

6.Resolve any errors/queries then create and validate the return again. Repeat these processes until you are satisfied that the content of the return is correct.

The detail reports and Summary report can be generated to assess the accuracy and completeness of the return.

7.Provide the Head Teacher with the latest copy of the Summary report to enable them to check the report details and approve the authorisation of the return. Once approval has been given, authorise the return (Routines | Statutory Returns | PRU Census – Authorise button).

8.Submit the return (with the Summary report) in the way requested by your Local Authority.

Preparing for the Pupil Referral Unit Census 2012 Return / 1
Preparing Pupil/Student Level Information / 04
02
/

Carrying out a Dry Run

Why Carry out a Dry Run?

When the SIMS 2011Autumn Release (SIMS 7.142) has been installed, you can carry out one or more dry runs of the PRU Census 2012 Return.

The purpose of a dry run is to produce the Validation Errors Summary, which details the corrections that need to be made to your data. It is advisable to do this as early as possible, even if you know that your data has not yet been fully prepared or checked.

Whilst a significant number of errors may be generated, many of the errors that relate to pupil/students, e.g.language, SEN provision type, etc. can be fixed quickly using the Bulk Update routine. For more information, please see Updating Information Using the Bulk Update Routineon page23.