Childrens Services Statutory Returns Suppliers Meeting

1
Childrens Services Statutory Returns Suppliers
Meeting

• Abbey Centre, Westminster, London
• 23 September 2008

2
AGENDA

• Welcome and introductions (Ryan Murray)
• Action summary from last meeting (Aspa Palamidas)
• ICS progress update (Andrew Hull)
• CIN 2008-09 update (Annie Sorbie/Aspa
  Palamidas)
• COLLECT update on testing (Jenny Simpson)
• Future XSLT (Ian Casey)
• LA Readiness on-line survey (Colin Bland)
• Lunch
• CIN 2009-10 - update Specification and
  processing issues (Aspa Palamidas/
• Steve Ward)
• Merging of LA codes update (Ryan Murray)
• CLA 903 update (Martin Hill)
• Closing questions and conclusions from the
  meeting

3
Action summary from last meeting

• Aspa Palamidas
• Date Development Unit
• Data Services Group

4
ICS Progress UpdateSeptember 2008

• Andrew Hull
• ICS Project Team
• IISaM Programme

5
Objectives

• Update on Phase 1B progress
• Update on Phase 1C progress
• Overview of timescales and approach for the ICS
  Phase 1C implementation

6
ICS Phase 1B Progress

• All 10 suppliers now have Phase 1B compliant
  products
• c. 80 LAs will implement by 30 September target
  date
• Additionally, the majority of LAs have told us
  that ICS will improve their service to children

7
Progress to Date
8
Advantages were categorised into three broad
areas IT, management and outcomes services for
children

• 99 LAs (69) noted that ICS will introduce an
  improved I.T. system which is more efficient and
  effective than previous systems
• 129 LAs (90) noted that ICS will improve their
  management tools and processes
• Both of the above will enable the LAs to improve
  the service they provide children
• 78 LAs (55) noted that ICS will enable better
  outcomes and services for children

Better services and outcomes for children
IT improvements
Management improvements
ENABLES
ENABLES
9
ICS Phase 1C Progress

• Business Requirements Specification published
• Exemplars for Adoption, Pathway Plan Review and
  Courts published
• All Family Court Judges required to accept new
  Courts exemplar formats
• Core Information Requirements (Process / Data
  Models) published
• We are currently responding to suppliers and
  LAs requests for further information

10
ICS Timeline
2008
2009
2010
Jul-Sep
Oct-Dec
Jan-Mar
Apr-Jun
Jul-Sep
Oct-Dec
Jan
Apr-Jun
Mar
P1C LA assessments start
P1C LAs implement products
Phase 1C Requirements Gathering
P1C requirements issued
Phase 1C

• Phase 1C
• LAs in P1C Business As Usual

Phase 1C software development
Suppliers
Phase 1C Product Tests
Phase 1C Product releases
11
ICS Funding and Implementation

• ICS Phase 1C implementation date
• 31 October 2009?
• Capital funding for LAs has been agreed in
  principle up to end March 2009
• But - new money in 2009-10 budgets cannot be
  guaranteed

12
Children in Need census 2008-09 Update

• Annie Sorbie, Customer Services
• Aspa Palamidas, Data Development Unit
• Data Services Group

13
Changes to validation rules (1)

• In v2.1 of specification notified in LA
  Newsletter July 2008
• Header validation rule added to check
  ReferenceDate (2009-03-31)
• Asylum Seeking validation check 8560
• Validation rule changed as asylum seeking is not
  required for unborn children. Had stated that
  this field is required for all children
• Looked After Child Adopted validation check 8580
• Validation rule changed as LAC adopted is not
  required for unborn children. Had stated that
  this field is required for all children
• Incorrect Rule 1570Q removed entirely would
  have flagged the majority of records with a
  FormerUPN as being in error

14
Changes to validation rules (2)

• To include in v2.2 of specification
• Change to disability validation/home information
  module
• Disability validation check 8540
• Validation rule will be changed as disability is
  not required for unborn children. It currently
  states that this field is required for all
  children
• Home Information Change the specification so
  that it says that the post code should be
  included rather than must be included as follows
• Each ltChildgt group contains 0..1
  ltHomeInformationgt group

15
CIN 2008-09 update (cont)

• Amendment to XML schema CBDS-Standard-Header-v2-0
  -CIN.xsd file to allow Child as a value
• XML schema v2.2 delayed to reflect all of above
  validation rule changes will be issued shortly
• XSLT not yet issued due to need to reflect all of
  above changes - but to follow shortly

16
CIN November Conferences 2008

• London, Emirates Stadium Thursday 13 November
• Birmingham, Holiday Inn Wednesday 19 November
• Leeds, Queens Hotel Thursday 20 November
• PJA sent invitations out w/c 15 Sept with online
  registration details
• Up to 2 places can be reserved from each supplier
  each LA
• Planning to cover
• 2008-09 CIN including feedback on LA readiness
  survey
• Collect demo including outputs
• Feedback on 2009-10 CIN Census requirements

17
COLLECT Update on testing

• Jenny Simpson
• Technical Development Unit
• Data Services Group

18
Collect User Acceptance Testing

• Test Strategy
• We created and agreed a formal User Acceptance
  test strategy. This included
• Testing Overview and Assumptions
• Data Loading
• Web Form Navigation
• Validation Testing
• Reports and Outputs

• Test Data
• Internal Usability Testing
• External Usability Testing
• Incident Logging and Handling
• Communications
• Go Live testing
• XSLT
• CSV To XML Converter
• Test Report

19

• Internal testing
• Formal Test Period 28/07/2008 - 29/08/2008
• 13 Users including 2 main testers, 1 LA secondee
  and several naïve users
• There were  37 issues raised in the Issues
  Tracker during testing. These were mainly minor
  validation or formatting errors and have been
  resolved.
• External testing
• Formal Test Period 04/08/2008 29/08/2008
• 21 Users including 1 software provider and 15
  different LAs
• 5 LA users and 1 software provider accessed the
  test system and 2 users provided feedback
• XSLT
• This was tested ready for release but changed to
  match new data requirements (re disability, home
  information etc for unborn children). Being
  retested before release.
• CSV to XML Converter
• This was tested and released but needed to be
  upgraded to deal with very large files. Testing
  now completed and it will released shortly.

20
Future XSLT

• Ian Casey
• Data Development Unit
• Data Services Group

21
LA readiness on-line survey

• Colin Bland
• LA secondee
• Data Services Group

22
LA Readiness Online Survey - Aug 2008

• 1 - Summary of Concerns

23
LA Readiness Online Survey - Aug 2008

• 2 - Data Modules Causing Concern

24
LA Readiness Online Survey - Aug 2008

• 3 - Summary of Text Responses by Problem Type

25
LA Readiness Online Survey - Aug 2008

• 4 Use of CSV to XML converter

26
Questions for suppliers CIN 08-09

• Data entry
• Does the current version of your system enable
  the user to populate all the data items for the
  Census?
• If no, when will such a version be available?
• Data extract
• Does the current version of your system enable
  the user to extract a Census return?
• If no, when will such a version be available?
• Reporting
• What reports are available to help LAs with the
  process?
• Are these available now? If no, when will they
  be available?

27
Lunch
28
CIN Census 2009-10 Update

• Aspa Palamidas / Steve Ward
• Data Services Group

29
CIN 09-10 - Specification

• Baselined version 1.0 issued 25 July
• File of example data on website w/c 8 Sept
• Version 1.1 of spec to include change to
  validation rules re disability and home
  information will release shortly
• XSD schema version (1.1) ready for release with
  v1.1 of spec
• Guidance Notes on track to be published in
  October
• http//www.dcsf.gov.uk/datastats1/guidelines/child
  ren/returns.shtmlcin

30
CIN 2009-10 Summary of changes

• Summary of changes from 2008-09
• new data for the replacement of CPR3
• Ethnicity now specified using CBDS codes
• the addition of a Date of Death item for a
  deceased child
• the addition of a new Reason for Closure
• full twelve months data from 1 April 2009 to 31
  March 2010
• restructuring of the data
• supported by ICS Phase 1C requirements
• ICS system MUST be able to produce the
  information to complete the CIN Census
  (requirement 1C / D10)
• DESIRABLE that ICS can import census data from
  other systems

31
CIN 2009-10 revised Data Structure

• Revision places Service Provision and CPPs within
  a specific CIN episode

Child Level
1
1
1
1..n
1
ChildIdentifiers
ChildCharacteristics
Children In NeedDetails
HomeInformation
0..n
0..n
Child ProtectionPlans
ServiceProvision
32
2009-10 Developer issues

• Minor spec changes
• XML Message Structure shows ltDisabilitiesgt group
  and ltHomeInformationgt group as mandatory (p 23).
  Both should be optional (i.e. 0..1)
• 8540 Disability not required for an unborn
  child, DOB check to be added
• 8610 not required for a NFA case, additional
  check required
• 8620 CIN Closure Date prior to 31.3.2010, not
  within census year as stated
• Placement of the Date of Initial CPC
• RFC for new data item, UPN unknown code

33
Year on Year corrections an update

• reminder of the problem
• relevant points at this stage
• will not require the automated creation of a
  special return from ICS
• may require some reporting from ICS
• will take place after the main extract / COLLECT
  activity

34
Year on year corrections process
ICS / other LA systems
Discrepancy annotations
Discrepancies
Send discrepancies to LAs
Check and annotate discrepancies
Return to DCSF
35
Process change

• Outline 2009-10 process (LA perspective)

Interim PIs tables
1. Prepare data, as per spec guidance
Final PIs tables
2. LA Load data into COLLECT
3. Deal with errors/queries and Approve
4. Receive and deal with Y-on-Y queries
5. Final data available from DCSF
Apr 2009 Mar 2010
Jun 2010 ??? 2010
Apr Jun 2010
36
Merging of LA codes Update

• Ryan Murray
• Data Services Group

37
Children Looked After in England Update

• Martin Hill
• Customer Services
• Data Services Group

38
Changes in 2008-09 SSDA903 collection

• Reason for no SDQ score
• LA score could be deflated Appear to have worse
  score than they actually have.
• On a voluntary basis.
• How many have been able to implement this change
  to the system?
• Guidance Notes and xml schema have been updated
  to reflect this change.
• http//www.dcsf.gov.uk/datastats1/guidelines/chil
  dren/returns.shtmlclad

39
Changes in 2009-10 SSDA903 collection

• Reason for no SDQ score Mandatory field.
• Codes to be used for this item-
• No form returned as child was aged under 4 or
  over 17 at date of last assessment
• Carer refused to complete and return
  questionnaire
• Not possible to complete the questionnaire due to
  severity of the childs disabilities
• Child or young person refuses to allow an SDQ to
  be completed
• Other

40
Changes in 2009-10 SSDA903 collection

• Ethnicity Code Changes

41
Changes in 2009-10 SSDA903 collection
42
Closing Questions and Conclusions

• Further Questions?
• Actions
• Contacts
• Ryan Murray, Chair ryan.murray_at_dcsf.gsi.gov.uk
• Aspa Palamidas, Business Development
  aspa.palamidas_at_dcsf.gsi.gov.uk
• Steve Ward, Business Development
  steve.ward_at_dcsf.gsi.gov.uk
• Colin Bland, LA Secondee colin.bland_at_dcsf.gsi.gov
  .uk
• Pippa Cribben, LA Secondee pippa.cribben_at_dcsf.gsi
  .gov.uk
• Annie Sorbie, Customer Services
  annie.sorbie_at_dcsf.gsi.gov.uk
• Laura Nurse, Customer Services
  laura.nurse_at_dcsf.gsi.gov.uk
• Isabella Craig, Policy link isabella.craig_at_dcsf.g
  si.gov.uk
• Matt Walker, Policy link matt.walker_at_dcsf.gsi.gov
  .uk
• Jenny Simpson, Technical jenny.simpson_at_dcsf.gsi.g
  ov.uk
• Andrew Hull, ICS andrew.hull_at_dcsf.gsi.gov.uk
• Ian Casey, Data Development Unit
  ian.casey_at_dcsf.gsi.gov.uk
• Martin Hill, Customer Services (SSDA903)
  martin.hill_at_dcsf.gsi.gov.uk
• Thank You!!