Definition of a Programme
A programme is a local instance of the training of a curriculum. The office applies to the GMC for approval to train a curriculum and have to show sign off by the college of that curriculum. When that's approved the GMC give a number which is the programme number or GMC approval code. That code is then applied to sites which are approved to train that curriculum. This is where the association of the post to the programme number comes into play. It's actually the approval of the programme to the site via the post
(Not sure why this diagram is not showing up, might need a license - it was uploaded a while ago during Transform times, will keep it here for now.)
Posts and Rotations
...
...
Refactoring Programme membership in TIS
https://hee-tis.atlassian.net/browse/TISNEW-3934
Programme membership
A training pathway specific to a Local Office using Sites approved for that training pathway and Local Office. Each Local office will have an equivalent programme with a unique code.
e.g. EOE948 - East of England Paediatric Training Programme
WMD2369 - West Midlands Training Programme
Curriculum membership
A trainee following a specific Curriculum for a determined duration to achieve a set of competencies within a specialty.
Curriculum are not linked to a locality, they are a reference list.
Why the distinction between the 2 is necessary?
Curriculum membership/s is abstracted in the current TIS model, we need a refactor so that curriculum memberships can be distinctly identified from programme memberships. This causes problem in accurately reporting on a trainee's curriculum membership/s which is abstracted in the current model. The distinction between the two is necessary in order:
To be able to track changes to a trainee's unique programme membership
To be able to track changes to each unique curriculum memberships
To be able to uniquely update programme memberships and their curriculum memberships in bulk. Currently only the Curriculum ID is held in a programme membership record.
To be able to uniquely audit when change is made to either a programme membership or a curriculum membership separately, which is not possible at the moment
Possible developments to Form-R part A linked to Programme membership
To be able to support the development of a new bulk update tool for programme memberships and curriculum memberships
To be able to sync specific programme memberships to Trainee UI rather than having to sync all programme memberships when there is a change/addition/deletion on TIS
To be able to record NTN at programme membership level rather than curriculum membership level.
As_Is
The ProgrammeMembership table in TIS is a denormalised table (called CurriculumMembership in the Tis_Interim) and is split into two tables in Tis_Interim, one being the full ProgrammeMembership table but called CurriculumMembership, the other being a select distinct subselection called ProgrammeMembership.
To_Be - Proposed change to TIS data model
This table should be normalised by splitting into two in the following way. (note: the proposed split in the below diagram is only making reference to necessary fields and not all fields)
...