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 (DO NOT INCLUDE)

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

• ProgrammeStartDate must be equal to or before the earliest CurriculumMembership StartDate connected to the ProgrammeMembership

Y

Programme End Date

Update

No

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

• ProgrammeEndDate must be equal to or afterthe earliest after the latest CurriculumMembership EndDate connected to the ProgrammeMembership

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.

Y

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???

N

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