...
| Table of Contents |
|---|
High Level Data Model
...
Data Separation by Area
KEY: | Narrative |
Unique | There is no overlap in the data. i.e. unique set of records. |
Same list | The same list is used across all entities. |
Unique + Overlap | There is an overlap/subset of data that will exist in more than one entities. |
Unique + Visible | TBD: Where a person overlaps, a view only overlap exists to other entities matching the person overlap |
Same list/filtered view by default | Where there is a long list, preference is to default to a filtered view by the user's entity, but has the ability to take the filter off and see all. |
All (NWD Dataset) | These are managed by the NHS National Workforce Dataset and would be aligned across systems, e.g. on Oriel, TIS or ESR. |
Web-app Area/Domain | TIS | NI | Wales | Scotland | HCS | Pharmacy |
People | Unique + Overlap | Unique + Overlap | Unique + Overlap | Unique + Overlap | Unique | Unique |
Programmes | Unique | Unique | Unique | Unique | Unique | Unique |
Programme memberships | Unique | Unique | Unique | Unique | Unique | Unique |
Posts | Unique | Unique | Unique | Unique | Unique | Unique |
Placements | Unique | Unique | Unique | Unique | Unique | Unique |
Rotations | Unique | Unique | Unique | Unique | Unique | Unique |
References > Sites | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default |
References > Trusts | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default | Same list/filtered view by default |
References > General (sex, religious belief etc.) | All (NWD Dataset) | All (NWD Dataset) | All (NWD Dataset) | All (NWD Dataset) | All (NWD Dataset) | All (NWD Dataset) |
References > Grades | Same list | Same list | Same list | Same list | Unique list | Unique list |
References > Placement Type | Same list | Same list | Same list | Same list | Same list | Same list |
References > Curriculum Sub-type | Same list | Same list | Same list | Same list | Unique list | Unique list |
Specialty | Same list | Same list | Same list | Same list | Unique list | Unique list |
Curriculum | Same list | Same list | Same list | Same list | Unique list | Unique list |
Specialty Group | Same list | Same list | Same list | Same list | Unique list | Unique list |
Assessments | Unique + Overlap | Unique + Overlap | Unique + Overlap | Unique + Overlap | Unique | Unique |
NDW flat tables | Separate NDW DB | Separate NDW DB | Separate NDW DB | Separate NDW DB | Separate NDW DB | Separate NDW DB |
Bulk Uploads Functionality | No duplication of People, Sites, Trusts. | No duplication of People, Sites, Trusts. | No duplication of People, Sites, Trusts. | No duplication of People, Sites, Trusts. | No duplication of People, Sites, Trusts. | No duplication of People, Sites, Trusts. | KEY:
Solution Design
...
Narrative
...
Unique
...
There is no overlap in the data. i.e. unique set of records.
...
Same list
...
The same list is used across all entities.
...
Unique + Overlap
...
There is an overlap/subset of data that will exist in more than one entities.
...
Unique + Visible
...
TBD: Where a person overlaps, a view only overlap exists to other entities matching the person overlap
...
Same list/filtered view by default
...
Where there is a long list, preference is to default to a filtered view by the user's entity, but has the ability to take the filter off and see all.
...
All (NWD Dataset)
...
Proof of Concept - Access Control List (ACL) Applied to Reference
...
Proof of Concept - Trust and Site Reference Data with ACL
...
Current limitations/bugs to address with ACL (PoC)
ACL control not currently applied to pageable lists. Need further dev investigation on solution design/architecture.
A bug introducing spurious entries in acl_sid table on creates/updates of users.
Other Possible solutions?
CQRS (Command Query Responsibility Segregation) Microservices Pattern - TIS - CQRS