You are here

Child services assessment meeting data standard

Standard identifier: 
ISB-000282
Standard Type: 
Business Data Standards
Version: 
1.00
Status: 
Approved: Recommended
Date of Standard: 
Monday, 8 December 2014
Category: 
Party (including organisation and person)
Target audience: 
Data modellers
ICT procurers
Statisticians
System developers or programmers
Introduction: 
This Business Data Standard (BDS) has been designed to satisfy all Education Skills and Children’s Services (ESCS) business needs to store or exchange data that covers the event of recording a meeting that takes place as part of a CHILD SERVICES ASSESSMENT.

 

Application

This standard can be used to store or exchange data that covers the event of recording a meeting that takes place as part of a CHILD SERVICES ASSESSMENT.

The assessment of a child as part of a CHILD SERVICES ASSESSMENT will result in many associated meetings being conducted. These meeting are not assessments as they do not involve the assessee and are conducted to discuss and plan the assessment itself. This standard allows the recording of these meetings, attendees and any decisions or actions that are identified during that meeting.

Compatibility with non-ISB standards

There are no known compatibility issues related to this standard

Terminology and notation

The following sections contain:

  • Entity Definition Model – A high level diagram showing: entities; their descriptions and relationships

  • Attribute Model – A lower level diagram showing the names of attributes making up entities. Attributes in the top section of an entities box are those making up its primary key

  • Data Definitions – Detailed descriptions of each of the entities at an attribute level, showing attribute: name; definition; whether it is part of a key; whether it is mandatory; its data type and format; parent information and Controlled List association

Only those entities within the boundary square in the diagrams are part of this particular data standard, entities outside the boundary are shown for context purposes only (and can be found within other Business Data Standards), or separate Controlled List reference data.

The standards for naming, notation and conventions used for this development can be found in the BDA Data Architecture Modelling Standards document. For convenience, a quick reference of the colours used in these diagrams is shown below.

 

Entity Definition Model

Attribute Model

 

 

 

 

Data definitions: 
Entity
Child Services Assmnt Meeting

The assessment of a PARTY where there is a "child" about whom a "concern" has been identified by another PARTY. This can result in services being provided to the PARTY and additional assessments being conducted as required. A PARTY can be an individual PERSON who is identified under specific guidelines as a "child", or a family group of which that "child" is member.

Attribute NameAttribute DefinitionPKFKMDatatypeFK Source EntityFK Source Attribute
Party_Id_Assessor
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Child Services Assessment
Party_Id_Assessor
Party_Id_Assessee
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Child Services Assessment
Party_Id_Assessee
Party_Personal_Assessment_Type
A controlled list of values that identifies the type of PARTY PERSONAL ASSESSMENT. Values include "Educational Exclusion", "Free School Meals", "Ability", "Condition", "Learning Provider Inspection", "Special Educational Needs".
Y
Y
Y
Unicode_String(1,50)
Child Services Assessment
Party_Personal_Assessment_Type
CSAM_Effective_DateTime
The date and time that the meeting commenced.
Y
N
Y
Simple_DateTime
Meeting_Notes
The notes of the meeting
N
N
N
Unicode_String(1,1000)
Party_Id_Attendees
A value that denotes and distinguishes the PARTY.
N
Y
Y
Unicode_String(1,32)
Party
Party_Id
Domestic_Abuse_Flag
A flag that indicates whether domestic abuse is present in the family of the assesse.
N
N
N
Simple_Flag
Associative Entity
CSAM Participant

The list of participants in a CHILD SERVICES ASSMNT MEETING.

Attribute NameAttribute DefinitionPKFKMDatatypeFK Source EntityFK Source Attribute
Party_Id_Assessor
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Child Services Assmnt Meeting
Party_Id_Assessor
Party_Id_Assessee
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Child Services Assmnt Meeting
Party_Id_Assessee
Party_Personal_Assessment_Type
A controlled list of values that identifies the type of PARTY PERSONAL ASSESSMENT. Values include "Educational Exclusion", "Free School Meals", "Ability", "Condition", "Learning Provider Inspection", "Special Educational Needs".
Y
Y
Y
Unicode_String(1,50)
Child Services Assmnt Meeting
Party_Personal_Assessment_Type
CSAM_Effective_DateTime
The date and time that the meeting commenced.
Y
Y
Y
Simple_DateTime
Child Services Assmnt Meeting
CSAM_Effective_DateTime
Party_Id
A value that denotes and distinguishes the PARTY.
Y
Y
Y
Unicode_String(1,32)
Party
Party_Id
Changes from previous version: 

Not applicable

References: 

The following references are specific to this Business Data Standard:

  • ESCS ISB Business Data Architecture Entity Relationship Diagram, version 8.02

The following references apply to all Business Data Standards:

  • ESCS ISB Standards Overview and Context

  • ESCS ISB “System“ Enterprise Architecture - Business Data Architecture

  • ESCS ISB Business Data Architecture Data Types

  • ESCS ISB BDA Data Architecture Modelling Standards

  • ESCS ISB Management Process

Notes: 

The standard reflects canonical model version 1.2 for Children’s Services - not all data items from the analysis are resolved as yet in this version.  The remaining data items will be resolved in an April 2015 release of this standard.