-
Notifications
You must be signed in to change notification settings - Fork 0
/
ssd_linked_identifiers.yml
127 lines (127 loc) · 3.55 KB
/
ssd_linked_identifiers.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
---
nodes:
- name: ssd_linked_identifiers
fields:
- name: link_table_id
description: Link table row ID
item_ref: LINK001A
type: nvarchar
primary_key: true
categories:
- linked_identifiers
returns:
- 1aNotInCMS
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:link_table_id
- mosaic:link_table_id
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Row identifier
for the ssd_linked_identifiers table
- name: link_person_id
description: Person Unique ID
item_ref: LINK002A
type: nvarchar
foreign_key: ssd_person.pers_person_id
categories:
- linked_identifiers
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:link_person_id
- mosaic:link_person_id
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Person's
ID generated in CMS Database
- name: link_identifier_type
description: '[''Case Number'', ''Unique Pupil Number'', NHS Number'', ''Home
Office Registration'', National Insurance Number'', ''YOT Number'', Court Case
Number'', RAA ID'', ''Incident ID'']'
item_ref: LINK003A
type: nvarchar
categories:
- linked_identifiers
returns:
- 1aNotInCMS
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:link_identifier_type
- mosaic:link_identifier_type
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Linked Identifier
Type e.g. ['Case Number', 'Unique Pupil Number', NHS Number', 'Home Office Registration',
National Insurance Number', 'YOT Number', Court Case Number', RAA ID', 'Incident
ID']
- name: link_identifier_value
description: Identifier or reference code
item_ref: LINK004A
type: nvarchar
categories:
- linked_identifiers
returns:
- 1aNotInCMS
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:link_identifier_value
- mosaic:link_identifier_value
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Identifier
value
- name: link_valid_from_date
description: Date the identifier is known/valid from
item_ref: LINK005A
type: datetime
categories:
- linked_identifiers
returns:
- 1aNotInCMS
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:link_valid_from_date
- mosaic:link_valid_from_date
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Date the
identifier is known/valid from
- name: link_valid_to_date
description: Date the identifier ceases to be known/valid
item_ref: LINK006A
type: datetime
categories:
- linked_identifiers
returns:
- 1aNotInCMS
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:link_valid_to_date
- mosaic:link_valid_to_date
cms_table:
- liquid_logic:ssd_linked_identifiers
- mosaic:ssd_linked_identifiers
guidance: (currently 'PLACEHOLDER_DATA' pending further development) Date the
identifier ceases to be known/valid