Programmes - Programme Membership and Curriculum Membership Bulk Tools

TIS_Programme_ID (UUID) *

Matching Criteria

Yes

Must match exactly to an Existing ProgrammeMembershipUUID on TIS.

Y

ProgrammeName/ProgrammeID

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

Rotation

Update

No

Accepted values should match to one of the Rotations associated with the Programme

Y

ProgrammeMembershipType

Update

No

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

Y

ProgrammeStartDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

ProgrammeEndDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

LeavingReason

Update

No

Accepted values should match to one of the LeavingReason reference table

Y

Status

Delete
Should this exist???

No

Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships

Y

TIS_Curriculum_ID *

Matching Criteria

Yes

Must match exactly to an Existing CurriculumID on TIS.

Y

CurriculumName/CurriculumID

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

ProgrammeName/ProgrammeID

Should it be possible to change the Programme of a ProgrammeMembership of a CurriculumMembership???

CurriculumStartDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

CurriculumEndDate

Update

No

Format must be dd/mm/yyyy. ProgrammeStartDate must be before ProgrammeEndDate

Y

Status

Delete
Should this exist???

No

Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships

Y