Page Comparison

TIS_ProgrammeMembership_ID (UUID)*

Matching Criteria

Yes

Must match exactly to an Existing ProgrammeMembershipUUID on TIS.

Y

Need to send this field to the NDW ideally in both the VwCurriculumMembership and VwProgrammeMembership tables.

ProgrammeName/ProgrammeID

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

N

Not recommended due to the cascading effects and potentially risky.

• Agreed

Rotation

Update

No

Accepted values should match to one of the Rotations on TIS with a status of CURRENT associated with the Programme

Y

Programme Membership Type

Update

No

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

Y

Programme Start Date

Update

No

Valid date Format of dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

Programme End Date

Update

No

Valid date Format of dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

Leaving Reason

Update

No

Accepted values should match to one of the LeavingReason reference table

Y

Training Pathway

Update

No

Accepted values should match one of the following:

• CCT

• CESR

• N/A

Y

TIS_Curriculum_Membership_ID*

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 CurriculumMembership.ID on TIS.

Y

TIS_ProgrammeMembership_ID (UUID)*

Match Criteria

Yes

Must match exactly to the programmeMembershipUuid attached to the Curriculum Membership ID.

Data leads to decide if both are required in order to match the record to be update on TIS.
- Agreed to have both

CurriculumName/CurriculumID

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

Not recommended due to the cascading effects and potentially risky.

• Agreed

Curriculum Start Date

Update

No

Valid date Format of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumStartDate must be after the associated ProgrammeStartDate

Y

Curriculum End Date

Update

No

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

Y