Page Comparison

1

TIS_ProgrammeProgrammeMembership_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

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

3ProgrammeMembershipType

Programme Membership Type

Update

No

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

Y

ProgrammeStartDate4

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

5ProgrammeEndDate

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

6LeavingReason

Leaving Reason

Update

No

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

Y

7

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

• CERTCESR

• N/A

Y

Status

Delete
Should this exist???

No

Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships

Y

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

CurriculumStartDateN

Not recommended due to the cascading effects and potentially risky.

• Agreed

Curriculum Start Date

Update

No

Valid date Format must be of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumStartDate must be after the associated ProgrammeStartDate

YCurriculumEndDate

Curriculum End Date

Update

No

Valid date Format must be of 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

TIS_ProgrammeProgrammeMembership_ID (UUID) *

Matching Criteria

Yes

Must match exactly to an Existing ProgrammeMembershipUUID on TIS.

YCurriculumName

Curriculum Name*

Add

Yes

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

Y

Curriculum Start Date*

Add

Yes

Valid date Format must be of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumStartDate must be after the associated ProgrammeStartDate

YCurriculumEndDate

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

Curriculum End Date*

Add

Yes

Valid date Format must be of dd/mm/yyyy.

CurriculumStartDate must be before CurriculumEndDate

CurriculumEndDate must be before the associated ProgrammeEndDate

Y