Programmes - Programme Membership and Curriculum Membership Bulk Tools

1

TIS_ProgrammeMembership_ID*

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

2

Rotation

Update

No

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

Y

3

Programme Membership Type

Update

No

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

Y

4

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

5

Programme End Date

Update

No

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

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

Y

6

Leaving Reason

Update

No

Accepted values should match to one of the CURRENT LeavingReason codes in reference table

Y

7

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