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

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:

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)