-
Notifications
You must be signed in to change notification settings - Fork 0
/
ssd_address.yml
168 lines (165 loc) · 3.67 KB
/
ssd_address.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
---
nodes:
- name: ssd_address
fields:
- name: addr_table_id
description: Address table row ID
item_ref: ADDR007A
type: nvarchar
primary_key: true
validators:
- required:
enabled: true
- unique:
enabled: true
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:addr_table_id
- mosaic:addr_table_id
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Row identifier for the ssd_address table
- name: addr_address_json
description: Address
item_ref: ADDR001A
type: nvarchar
validators:
- required:
enabled: true
- unique:
enabled: true
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:addr_address_json
- mosaic:addr_address_json
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: 'Persons address Combined dictionary/ json type containing the following,
AS addr_address_json
---------------------------------------
-- SSD standard - all keys in structure regardless of data presence
{ ROOM: "", FLOOR: "", FLAT: "", BUILDING: "", HOUSE: "", STREET: "", TOWN:
"", UPRN: "", EASTING: "", NORTHING: "" }'
- name: addr_person_id
description: Person Unique ID
item_ref: ADDR002A
type: nvarchar
foreign_key: ssd_person.pers_person_id
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:addr_person_id
- mosaic:addr_person_id
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Person's ID generated in CMS Database
- name: addr_address_type
description: Address Type
item_ref: ADDR003A
type: nvarchar
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:addr_address_type
- mosaic:addr_address_type
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Type of Address, e.g. Home/ Placement/ Primary etc.
- name: addr_address_start_date
description: Address Start Date/ From
item_ref: ADDR004A
type: datetime
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:addr_address_start_date
- mosaic:addr_address_start_date
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Date person started living at the address
- name: addr_address_end_date
description: Address End Date/ To
item_ref: ADDR005A
type: datetime
categories:
- identity
- address
returns:
- Local
cms:
- liquid_logic
- mosaic
cms_field:
- liquid_logic:address_end
- mosaic:address_end
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Date person left the address
- name: addr_address_postcode
description: Address Postcode
item_ref: ADDR006A
type: nvarchar
categories:
- identity
- address
returns:
- SSDA903
- AnnexA
- SEN2
cms:
- liquid_logic
- mosaic
- eclipse
- caredirector
- azeus
cms_field:
- liquid_logic:addr_address_postcode
- mosaic:addr_address_postcode
cms_table:
- liquid_logic:ssd_address
- mosaic:ssd_address
guidance: Address Postcode, auto-formatted to remove spaces for consistency