Page Comparison

TIS_Programme_ID (UUID) *

Matching Criteria

Yes

Must match exactly to an Existing ProgrammeMembershipUUID on TIS.

Y

ProgrammeName/ProgrammeID

Should it be possible to change the Programme of a ProgrammeMembership or should a programmeMembership be deleted and a new one created???

Rotation

Update

No

Accepted values should match to one of the Rotations associated with the Programme

Y

ProgrammeMembershipType

Update

No

Accepted values should match to one of the Membership Type reference table

Y

ProgrammeStartDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

ProgrammeEndDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

LeavingReason

Update

No

Accepted values should match to one of the LeavingReason reference table

Y

Training Pathway

(James Harris - I suppose we need this as well in this template)

Update

No

Accepted values should match one of the following:

• CCT

• CERT

• N/A

Y

Status

Delete
Should this exist???

No

Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships

Y

TIS_Curriculum_ID *

I think it should be TIS_Curriculum_Membership_ID * James Harris

Also is this sufficient to say this is the right curriculum membership needed to be updated without a further check on the attached Programme Membership as matching criteria? James Harris

Matching Criteria

Yes

Must match exactly to an Existing CurriculumID on TIS.

Y

CurriculumName/CurriculumID

Should it be possible to change the Curriculum of a CurriculumMembership or should a CurriculumMembership be deleted and a new one created???

CurriculumStartDate

Update

No

Format must be dd/mm/yyyy. CurriculumStartDate must be before CurriculumEndDate

CurriculumStartDate must be after the associated ProgrammeStartDate

Y

CurriculumEndDate

Update

No

Format must be dd/mm/yyyy. CurriculumStartDate must be before CurriculumEndDate
CurriculumEndDate must be before the associated ProgrammeEndDate

Y

Status

Delete
Should this exist???

No

Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships

Y