-
Notifications
You must be signed in to change notification settings - Fork 0
/
ssd_early_help_episodes.yml
167 lines (167 loc) · 3.97 KB
/
ssd_early_help_episodes.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
---
nodes:
- name: ssd_early_help_episodes
fields:
- name: earl_episode_id
description: EH Episode ID
item_ref: EARL001A
type: nvarchar
primary_key: true
validators:
- required:
enabled: true
- unique:
enabled: true
categories:
- early_help
returns:
- Local
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_id
- mosaic:earl_episode_id
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Row identifier for the ssd_early_help_episodes table
- name: earl_person_id
description: Person Unique ID
item_ref: EARL002A
type: nvarchar
foreign_key: ssd_person.pers_person_id
validators:
- required:
enabled: true
categories:
- early_help
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:earl_person_id
- mosaic:earl_person_id
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Person's ID generated in CMS Database
- name: earl_episode_start_date
description: EH Episode Start Date
item_ref: EARL003A
type: datetime
categories:
- early_help
returns:
- AnnexA
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_start_date
- mosaic:earl_episode_start_date
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Date Episode Started
- name: earl_episode_end_date
description: EH Episode End Date
item_ref: EARL004A
type: datetime
categories:
- early_help
returns:
- AnnexA
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_end_date
- mosaic:earl_episode_end_date
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Date Episode Ended
- name: earl_episode_reason
description: EH Episode Reason for Involvement
item_ref: EARL005A
type: nvarchar
categories:
- early_help
returns:
- ADCS_SP
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_reason
- mosaic:earl_episode_reason
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Broad categorisation of Reason for Early Help Involvement.
- name: earl_episode_end_reason
description: EH Episode End Reason
item_ref: EARL006A
type: nvarchar
categories:
- early_help
returns:
- ADCS_SP
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_end_reason
- mosaic:earl_episode_end_reason
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Reason Episode endeed e.g. Outcomes met/ Step-up/ NFA
- name: earl_episode_organisation
description: EH Episode Allocated Organisation
item_ref: EARL007A
type: nvarchar
categories:
- early_help
returns:
- AnnexA
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_organisation
- mosaic:earl_episode_organisation
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Organisation responsible for Early Help provision
- name: earl_episode_worker_id
description: EH Episode Allocated Worker
item_ref: EARL008A
type: nvarchar
foreign_key: ssd_professionals.prof_professional_id
categories:
- early_help
returns:
- RIIA
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:earl_episode_worker_name
- mosaic:earl_episode_worker_name
cms_table:
- liquid_logic:ssd_early_help_episodes
- mosaic:ssd_early_help_episodes
guidance: Allocated worker responsible for Early Help provision