Programmes - Programme Membership and Curriculum Membership Bulk Tools

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.

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

TIS_ProgrammeMembership_ID (UUID) *

Matching Criteria

Yes

Must match exactly to an Existing ProgrammeMembershipUUID on TIS.

Y

Curriculum Name

Add

Yes

Must match a Curriculum associated with the Programme of the ProgrammeMembership in the ProgrammeCurricula Table

Y

Curriculum Start Date

Add

Yes

Valid date Format of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumStartDate must be after the associated ProgrammeStartDate

Y

Need to investigate endpoints FE vs BE. Should ideally give a validation error if not.

Curriculum End Date

Add

Yes

Valid date Format of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumEndDate must be before the associated ProgrammeEndDate

Y