Page Comparison

...

TIS table	Field name	TIS location	Applicable statuses	Impact analysis (assumptions)	Comments
RolePermission whole entry status can be: INACTIVE / DELETE / ARCHIVE on the FE Should be stored against a relevant person ID (tbc) when deleted or archived
	roleName	TBC	DELETE ARCHIVE	deletion will remove the role from the FE, but retain the it in the BE permissions will be removed to the user on login a role must be assigned to any user who needs to use the system roles should be archived against a person record (i.e. for users who are also managed within TIS) roles should be archived against users (i.e. for users who are not managed within TIS)	This is held in Keycloak currently, this is only relevant where role/permission management moves into TIS
	permissionName	TBC	N/A	the permission is removed where the role is removed	This is held in Keycloak currently, this is only relevant where role/permission management moves into TIS
Role whole entry status can be: INACTIVE / DELETE / ARCHIVE on the FE
	name	TBC	INACTIVE DELETE	inactive will remove the role from being applied in the FE delete will remove the value from the table delete will remove data from forms where the role is in use	This is held in Keycloak currently, this is only relevant where role/permission management moves into TIS (as reference data) Assumption is that reference data archiving is not necessary
UserRole whole entry status can be: INACTIVE / DELETE / ARCHIVE on the FE Should be stored against a relevant person ID (tbc)
	userName	TBC	DELETE ARCHIVE	usernames are mandatory so at least 1 is necessary for a user to be active in TIS delete will remove their ability to login to TIS archive will retain a copy of the username details	Is it necessary to retain username details?
	roleName	Person form	DELETE ARCHIVE	deletion will remove the role from the FE, but retain the it in the BE permissions will be removed to the user on login a role must be assigned to any user who needs to use the system roles should be archived against a person record (i.e. for users who are also managed within TIS) roles should be archived against users (i.e. for users who are not managed within TIS)	This is held in Keycloak currently, this is only relevant where role/permission management moves into TIS Is this data linked to the data held in the RolePermission or is it held separately? If so, then would the status of one or both instances of a like-role need to be altered?
PersonalDetails entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	maritalStatus	Person form	DELETE ARCHIVE
	dateOfBirth	Person form	DELETE ARCHIVE
	gender	Person form	DELETE ARCHIVE
	nationality	Person form	DELETE ARCHIVE
	dualNationality	Person form	DELETE ARCHIVE
	sexualOrientation	Person form	DELETE ARCHIVE
	ethnicOrigin	Person form	DELETE ARCHIVE
	religiousBelief	Person form	DELETE ARCHIVE
	ethnicOrigin	Person form	DELETE ARCHIVE
	disability	Person form	DELETE ARCHIVE
	disabilityDetails	Person form	DELETE ARCHIVE
	nationalInsuranceNumber	Person form	DELETE ARCHIVE
TrainingNumber entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	trainingNumber	Person form	DELETE ARCHIVE
GdcDetails entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	gdcNumber	Person form	DELETE ARCHIVE
	gdcStatus	Person form	INACTIVE DELETE ARCHIVE
	gdcStartDate	Person form	DELETE ARCHIVE
	gdcEndDate	Person form	DELETE ARCHIVE
GmcDetails entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	gmcNumber	Person form	DELETE ARCHIVE
	gmcStatus	Person form	INACTIVE DELETE ARCHIVE
	gmcStartDate	Person form	DELETE ARCHIVE
	gmcEndDate	Person form	DELETE ARCHIVE
ContactDetails entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	surname	Person form	DELETE ARCHIVE
	forenames	Person form	DELETE ARCHIVE
	knownAs	Person form	DELETE ARCHIVE
	maidenName	Person form	DELETE ARCHIVE
	initials	Person form	DELETE ARCHIVE
	title	Person form	DELETE ARCHIVE
	telephoneNumber	Person form	DELETE ARCHIVE
	email	Person form	DELETE ARCHIVE
	workEmail	Person form	DELETE ARCHIVE
	postCode	Person form	DELETE ARCHIVE
	legalSurname	Person form	DELETE ARCHIVE
	legalForenames	Person form	DELETE ARCHIVE
	address1	Person form	DELETE ARCHIVE
	address2	Person form	DELETE ARCHIVE
	address3	Person form	DELETE ARCHIVE
	address4	Person form	DELETE ARCHIVE
RightToWork entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	eeaResident	Person form	DELETE ARCHIVE
	permitToWork	Person form	DELETE ARCHIVE
	settled	Person form	DELETE ARCHIVE
	visa Issued	Person form	DELETE ARCHIVE
	visa ValidTo	Person form	DELETE ARCHIVE
	visa Details	Person form	DELETE ARCHIVE
Qualification entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	qualification	Person form	DELETE ARCHIVE
	qualificationType	Person form	DELETE ARCHIVE
	qualificatinAttainedDate	Person form	DELETE ARCHIVE
	medicalSchool	Person form	DELETE ARCHIVE
	countryOfQualification	Person form	DELETE ARCHIVE
Comment entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	parentId	Person form	DELETE ARCHIVE
	threadId	Person form	DELETE ARCHIVE
	author	Person form	DELETE ARCHIVE
	body	Person form	DELETE ARCHIVE
PersonTrust entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	trustCode	Person form	DELETE ARCHIVE
	trustName	Person form	DELETE ARCHIVE
PersonOwner entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	owner	Person form	DELETE ARCHIVE
RotationPerson entry status can be: INACTIVE / DELETE / ARCHIVE
	rotationId	Person form	DELETE ARCHIVE
Rotation Whole entry status can be: INACTIVE / DELETE / ARCHIVE
	programmeId	Rotations form	DELETE
	name	Rotations form	DELETE
	status	Rotations form	INACTIVE DELETE ARCHIVE		Linked data should also be held in the Person form, any links will be broken by changing status to Inactive or Delete
RotationPost entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	postId	N/A	N/A		Not visible on TIS FE
	rotationId	N/A	N/A		Not visible on TIS FE
PlacementSupervisor entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	placementId	Person form	personId	Person form	TBC	TBC	Unclear if this is the visible field on TIS FE
	personId	TBC	TBC		Unclear if this is the visible field on TIS FE
	type	TBC	TBC		Unclear if this is the visible field on TIS FE
Programme entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	status	Person Programme form	INACTIVE DELETE ARCHIVE
	ownerPerson form	Programme form	DELETE ARCHIVE
	programmeNamePerson form	Programme form	DELETE ARCHIVE
	programmeNumber	Person formProgramme form	DELETE ARCHIVE
Placement entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	specialty	Person form
	dateFrom	Person form
	dateTo	Person form
	placementWholeTimeEquivalent	Person form
	traineeId	Person form
	postId	Person form
	localPostNumber	Person form
	siteCode	Person form
	gradeAbbreviation	Person form
	placementType	Person form
	status	Person form
	trainingDecriptionsiteId	Person form
	gradeId	Person form
Curriculum entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	name	Curricula form
	curriculumSubType	Curricula form
	assessmentType	Curricula form
	doesThisCurriculumLeadtoCct	Curricula form
	periodofGrace	Curricula form
Post entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	nationalPostNumber	Post form
	status	Post form
	employingBodyId	Post form
	traningBodyId	Post form
	suffix	Post form
	owner	Post form
	postFamily	Post form
	localPostNumber	Post form
	trainingDescription	Post form
PostFunding entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	startDate	Post form
	endDate	Post form
	fundingType	Post form
	info	Post form
	fundingBodyId	Post form
Specialty entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	status	Specialty reference
	college	Specialty reference
	specialtyCode	Specialty reference
	specialtyGroupId	Specialty reference
	name	Specialty reference
ProgrammeMembership entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	programmeMembershipType	Person form
	rotation	Person form
	curriculumStartDate	Person form
	curriculumEndDate	Person form
	periodOfGrace	Person form
	programmeStartDate	Person form
	curriculumCompletiondate	Person form
	programmeEndDate	Person form
	leavingDestination	Person form
	trainingNumberId	Person form
Assessment entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	firstName	Person form
	lastName	Person form
	reviewDate	Person form
	programmeNumber	Person form
	programmeName	Person form
	status	Person form
	type	Person form
AssessmentDetail entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	curriculumId	Assessment form
	curriculumName	Assessment form
	curriculumStartDate	Assessment form
	curriculumEndDate	Assessment form
	curriculumSpecialtyId	Assessment form
	curriculumSpecialty	Assessment form
	curriculumSubType	Assessment form
	membershipType	Assessment form
	gradeAbbreviation	Assessment form
	gradeName	Assessment form
	periodCoveredFrom	Assessment form
	periodCoveredTo	Assessment form
	portfolioReviewDate	Assessment form
	monthsWteDuringPeriod	Assessment form
	monthsCountedToTraining	Assessment form
	traineeNtn	Assessment form
AssessmentOutcome entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	outcome	Assessment form
	underAppeal	Assessment form
	comments	Assessment form
	trainingCompletionDate	Assessment form
	extendedTrainingCompletionDate	Assessment form
	extendedTrainingTimeInMonths	Assessment form
	tenPercentAudit	Assessment form
	externalTrainer	Assessment form
	nextRotationGradeName	Assessment form
	traineeNotifiedofOutcome	Assessment form
	nextReviewDate	Assessment form
	academicCurriculumAssessed	Assessment form
	academicOutcome	Assessment form
	detailedReasons	Assessment form
	mitigatingCircumstances	Assessment form
	competencesToBeDeveloped	Assessment form
	otherRecommendedActions	Assessment form
	addCommentsFromPanel	Assessment form
	reason	Assessment form
	nextRotationGradeAbbr	Assessment form
Revalidation entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	concernSummary	Assessment form
	responsibleOfficerComments	Assessment form
Reference Tables - these have been summarised since the rules should be similar in the majority of instances (some have other values which will be impacted if the below rules are adhered) entry status can be: INACTIVE / DELETE / ARCHIVE Should be stored against a relevant ID (tbc)
	code	Reference tables
	label	Reference tables
	name	Reference tables
	status	Reference tables

...

Versions Compared

Old Version 6

New Version 7

Key