Programmes - Programme Membership and Curriculum Membership Bulk Tools

Programme Membership - Bulk Update using TIS_ProgrammeMembership_IDs validations

Column Heading	Add/Update/Matching Criteria	Mandatory	Rules	Applicable for Update (Y/N)
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
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 CERT N/A	Y
Status	Delete Should this exist???	No	Delete entry deletes the ProgrammeMembership and associated CurriculumMemberships	Y

Period of Grace should default to that set in the Curriculum reference table for that curriculum

Column Heading	Add/Update/Matching Criteria	Mandatory	Rules	Applicable for Update (Y/N)
TIS_Curriculum_ID * I think it should be 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 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???
CurriculumStartDate	Update	No	Format must be dd/mm/yyyy. CurriculumStartDate must be before CurriculumEndDate CurriculumStartDate must be after the associated ProgrammeStartDate	Y
CurriculumEndDate	Update	No	Format must be 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

Period of Grace should default to that set in the Curriculum reference table for that curriculum

Column Heading	Add/Update/Matching Criteria	Mandatory	Rules	Applicable for Update (Y/N)
TIS_Programme_ID (UUID) *	Matching Criteria	Yes	Must match exactly to an Existing ProgrammeMembershipUUID on TIS.	Y
CurriculumName	Add	Yes	Must match a Curriculum associated with the Programme of the ProgrammeMembership in the ProgrammeCurricula Table
CurriculumStartDate	Add	Yes	Format must be dd/mm/yyyy. CurriculumStartDate must be before CurriculumEndDate CurriculumStartDate must be after the associated ProgrammeStartDate	Y
CurriculumEndDate	Add	Yes	Format must be dd/mm/yyyy. CurriculumStartDate must be before CurriculumEndDate CurriculumEndDate must be before the associated ProgrammeEndDate	Y