| Table of Contents |
|---|
...
Web-app Area | 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. |
Solution Design
...
Access Control List (ACL) Applied to Reference (Proof of Concept)
...
Trust and Site Reference Data with ACL (PoC)
...
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.