-
Notifications
You must be signed in to change notification settings - Fork 0
/
ssd_person.yml
374 lines (356 loc) · 11.1 KB
/
ssd_person.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
---
nodes:
- name: ssd_person
fields:
- name: pers_person_id
description: Person Unique ID
item_ref: PERS001A
type: nvarchar
primary_key: true
validators:
- required:
enabled: true
- unique:
enabled: true
categories:
- identity
returns:
- SSDA903
- CIN
- AnnexA
- RIIA
- SEN2
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:pers_person_id
- mosaic:pers_person_id
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: Person's ID generated in CMS Database
- name: pers_sex
description: Sex
item_ref: PERS002A
type: nvarchar
categories:
- identity
returns:
- SSDA903
- RIIA
- AnnexA
- SEN2
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
cms_field:
- liquid_logic:pers_sex
- mosaic:pers_sex
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'Person''s Sex, as recorded on a birth certificate or in a gender recognition
certificate.
Code set
F - Female
M - Male
U - Unknown'
- name: pers_gender
description: Gender
item_ref: PERS003A
type: nvarchar
categories:
- identity
returns:
- CIN
- RIIA
cms:
- liquid_logic
- mosaic
- azeus
cms_field:
- liquid_logic:pers_gender
- mosaic:pers_gender
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: "A person\u2019s inner concept of self as male, female, neither or a\
\ blend of both.\nCode set\n00 - Not known (for example, question has not been\
\ asked, answer was refused)\n01 - Man / Boy / Male [systems should display\
\ the most appropriate value, e.g. Boy for children, Man for adults, Male if\
\ preferred] 02 - Woman / Girl / Female [systems should display the most appropriate\
\ value, e.g. Girl for children, Woman for adults, Female if preferred]\n09\
\ - Prefer to Self-Describe\nCodes 10 to 99 to be available for local use but\
\ to be regarded as subcodes of 9 (Other). Free text field or locally defined\
\ codes to be available for recording individual\u2019s identification where\
\ \u2018Prefer to Self-Describe\u2019 has been chosen. While there are no plans\
\ to transfer this data it is envisaged that, if transfer of codes were to be\
\ implemented, only code \u20189\u2019 would be transferred rather than codes\
\ \u201811\u2019, \u201812\u2019 etc."
- name: pers_ethnicity
description: Ethnicity
item_ref: PERS004A
type: nvarchar
categories:
- identity
returns:
- SSDA903
- CIN
- AnnexA
- RIIA
- SEN2
cms:
- liquid_logic
- mosaic
- azeus
cms_field:
- liquid_logic:pers_ethnicity
- mosaic:pers_ethnicity
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: "Person's Ethnicity. This information must come from the child, or the\
\ parent, guardian or carer.\nWhere the ethnicity has not yet been collected,\
\ this is recorded as \u2018NOBT\u2019 (information not yet obtained). Where\
\ a child, parent, guardian or carer declines to provide ethnicity data, code\
\ \u2018REFU\u2019 (refused) is recorded.\nEthnicity should be recorded using\
\ one of the DfE main categories shown below, which replicate those used in\
\ the school census and the children in need (CIN) return.\nCode set\nWBRI -\
\ White British\nWIRI - White Irish\nWOTH - Any other White background WIRT\
\ - Traveller of Irish Heritage\nWROM - Gypsy/Roma\nMWBC - White and Black Caribbean\n\
MWBA - White and Black African\nMWAS - White and Asian\nMOTH - Any other Mixed\
\ background\nAIND - Indian\nAPKN - Pakistani\nABAN - Bangladeshi\nCNHE - Chinese\n\
AOTH - Any other Asian background\nBCRB - Caribbean\nBAFR - African\nBOTH -\
\ Any other Black background\nOOTH - Any other ethnic group\nREFU - Refused\n\
NOBT - Information not yet obtained"
- name: pers_dob
description: Date of Birth
item_ref: PERS005A
type: datetime
categories:
- identity
returns:
- SSDA903
- CIN
- AnnexA
- RIIA
- SEN2
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:pers_dob
- mosaic:pers_dob
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'Person''s date of birth. Either Date of Birth or Expected Date of Birth
should be recorded, but not both. If the exact day of birth is not known:
Unknown dates can be a problem for unaccompanied asylum-seeking children, If
the day of birth is not known then assume that it was the 15th of the month.
Do not use first day of the month as a dummy date of birth.'
- name: pers_common_child_id
description: Common Child Identifier (NHS Number)
item_ref: PERS013A
type: nvarchar
categories:
- identity
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:pers_common_child_id
- mosaic:pers_common_child_id
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'This is a lifetime national identifier allocated from birth, or when
a person registers with the NHS
for the first time (England, Isle of Man and Wales). Allocated by the PDS, the
first nine digits are the identifier and the tenth helps the number test its
own validity.'
- name: pers_legacy_id
description: Person System ID
item_ref: PERS014A
type: nvarchar
categories:
- identity
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:pers_legacy_id
- mosaic:pers_legacy_id
guidance: "This must be a unique ID for each child (no longer than 20 characters)\
\ and should be retained from year to year. A child ID should not be reused\
\ after a period of time, it should be unique to a single child in your local\
\ authority. It can include alphabetic and numeric characters. Do not use non-numeric\
\ or non-alphabetic characters.\nIf a looked-after child is adopted, and subsequently\
\ becomes looked-after again later, they should have two separate unlinked records\
\ \u2013 one for pre-adoption and one for post-adoption \u2013 with two different\
\ child identifiers."
- name: pers_upn_unknown
description: UPN Unknown
item_ref: PERS007A
type: nvarchar
categories:
- identity
returns:
- RIIA
- CIN
- SEN2
cms:
- liquid_logic
- mosaic
- azeus
cms_field:
- liquid_logic:pers_upn_unknown
- mosaic:pers_upn_unknown
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'If the UPN is unknown, then one of the codes below should be used.
If a child is educated outside England, please use UPN unknown code UN3, unless
the child has a UPN from previously attending a school in England. If the child
is home educated and has previously attended a mainstream school, please provide
the UPN allocated earlier.
Code set
UN1 - Child looked-after is not of school age and has not yet been assigned
a UPN
UN2 - Child looked-after has never attended a maintained school in England (for
example, some unaccompanied asylum-seeking children (UASC))
UN3 - Child looked-after is educated outside England
UN4 - Child is newly looked-after and the UPN is not yet known
UN5 - Sources collating UPNs reflect discrepancy(ies) for the child''s name
and/or surname and/or date of birth therefore preventing reliable matching (for
example, duplicated UPNs)'
- name: pers_send_flag
description: SEND Flag
item_ref: PERS008A
type: nchar
categories:
- identity
returns:
- NEETandparticipation
- RIIA
cms:
- liquid_logic
cms_field:
- liquid_logic:pers_send_flag
- mosaic:pers_send_flag
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'Flag showing if a person has an EHC plan recorded on the system.
Code set
Y - Has an EHC Plan
N - Does not have an EHC Plan'
- name: pers_expected_dob
description: Expected Birth Date
item_ref: PERS009A
type: datetime
categories:
- identity
returns:
- CIN
- RIIA
cms:
- liquid_logic
- azeus
cms_field:
- liquid_logic:pers_expected_dob
- mosaic:pers_expected_dob
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: "The expected date of birth (due date) is recorded for a child who is\
\ unborn at the time of referral.\nIf the child is born before the case is closed,\
\ then the actual date of birth should be recorded.\nIf a child is stillborn,\
\ or the mother suffers a miscarriage (including a chemical pregnancy) or a\
\ phantom pregnancy, or there is a termination of the pregnancy, please record\
\ the expected date of birth and leave the date of birth blank. The children\
\ in need (CIN) closure date does not need to match the date on the death certificate.\
\ The date of death and the final closure date can both be recorded. The reason\
\ for CIN closure should be recorded as \u2018RC2 died\u2019."
- name: pers_death_date
description: Date of Death
item_ref: PERS010A
type: datetime
categories:
- identity
returns:
- CIN
- RIIA
cms:
- liquid_logic
- azeus
cms_field:
- liquid_logic:pers_death_date
- mosaic:pers_death_date
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: Date of death, which should be verified from the death certificate.
- name: pers_is_mother
description: Mother
item_ref: PERS011A
type: nchar
categories:
- identity
returns:
- SSDA903
- RIIA
cms:
- liquid_logic
- azeus
cms_field:
- liquid_logic:pers_is_mother
- mosaic:pers_is_mother
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: 'Calculated within the SSD extract based on if a parent-child relationship
exists for persons with a sex code other than Male (i.e. Female or Unknown).
A child will be classified as a mother even if they do not care for the child
themselves (for example, if consent was given for the child to be adopted).
Code set
N - Child is not a mother
Y - Child is a mother'
- name: pers_nationality
description: Country of Origin (UASC)
item_ref: PERS012A
type: nvarchar
categories:
- identity
returns:
- ADCS_SP
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:pers_nationality
- mosaic:pers_nationality
cms_table:
- liquid_logic:ssd_person
- mosaic:ssd_person
guidance: Required for UASC, reported in the ADCS Safeguarding Pressures research.