Page Comparison

ID

N

N/A

Assumption this is a unique system ID

Title

Y

Person.Title

First Name

Y

Person.Forenames

Surname

Y

Person.Surname

Gender

Y

Person.Gender

Main Email

Y

Person.ContactEmail

Other Email

Y

Person.EmailAddress

This email address is what is held by the current employing trust and is populated by the TIS-ESR bidirectional interface if live

GMC

Y

Person.GMCNumber

Nat. Training No.

Y

NTN

This field is not saved in TIS but is calculated based upon TIS data

Start of Training

Y

ProgrammeMembership/CurriculumMembership.ProgrammeStartDate

End of Training

Y

ProgrammeMembership/CurriculumMembership.ProgrammeCurriculumCompletionDate or ProgrammeMembership/CurriculumMembership.ProgrammeEndDate

ProgrammeCurriculumCompletionDate is the last date of all curriculum components of a programme whereas ProgrammeEndDate will include Period of Grace. GP Trainees do not have access to POG and so the dates should be identical

Enable Postfolio

N

Assume an action by a trainee, NHSE admin or other system admin will trigger this to be enabled

Phone

Y

Person.TelephoneNumber

Mobile

Y

Person.MobileNumber

Address

N

Person.AddressLine1

Person.AddressLine2

Person.AddressLine3

Person.AddressLine4

Person.AddressPostCode

Multiple fields in TIS which would need to be concatenated if one field in 14Fish

Certificate Type

Y

ProgrammeMembership/CurriculumMembership.TrainingPathway

Certificate subtype

N

Deanery

Y

ProgrammeMembership/CurriculumMembership.ProgrammeManagingDeanery

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Training prog

Y

ProgrammeMembership/CurriculumMembership.ProgrammeName

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Trainee

N

Concatenation of Person.Title Person.Forenames Person.Surname

Phonetic name

N

This field is not on Oriel and therefore TIS

GMC

Y

Person.GMCNumber

Training number

Y

NTN

This field is not saved in TIS but is calculated based upon TIS data

Certificate type

Y

ProgrammeMembership/CurriculumMembership.TrainingPathway

Certificate subtype

N

Current stage of training

N

Placement.ApprovedGradeAbbreviation or Placement.PlacementType

Assumption that this field is displaying data populated in the Stage of Training page. Please see below

Educational Supervisor

N

Concatenation of PlacementSupervisor.SupervisorForenames PlacementSupervisor.Surname where the Placement is CURRENT, Placement.PlacementTisID = PlacementSupervisor.PlacementTisID and PlacementSupervisor.SupervisorType = ‘EducationalSupervisor’

Unsure of whether this field is populated by Post or by ESR

Deanery

Y

ProgrammeMembership/CurriculumMembership.ProgrammeManagingDeanery

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Training Programme

Y

ProgrammeMembership/CurriculumMembership.ProgrammeName

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Dean/RO

Y/N

This field exists in the TIS backend and in Revalidation but is not exposed currently for export. There is a mapping of ProgrammeManagingDeanery/Local Office from TIS or the GMC which could be used.

CCT date

Y

ProgrammeMembership/CurriculumMembership.ProgrammeCurriculumCompletionDate

Scheme Days - Primary Care

N

Total of data differentials of Placement.StartDate and Placement.EndDate where Placement.SpecialtyName = ‘General Practice’

Assumption that this is derived from Posts or Stage of Training. On TIS this would most likely be all the placements where the specialty = ‘General Practice’

Scheme Days - Non-primary care

N

Total of data differentials of Placement.StartDate and Placement.EndDate where Placement.SpecialtyName <> ‘General Practice’

Assumption that this is derived from Posts or Stage of Training. On TIS this would most likely be all the placements where the specialty <> ‘General Practice’

Scheme Days - Total

N

Total of data differentials of Placement.StartDate and Placement.EndDate

Assumption that this is derived from Posts or Stage of Training.

GP - Organisation

Y

Placement.SiteName where Placement is CURRENT

There is a Site reference table on 14Fish and TIS. These are not aligned and would need to be as mapping would be extremely labour intensive and quickly become deprecated.

GP - Dates

N

Concatenation of Placement.StartDate - Placement.EndDate where Placement is CURRENT

Assumption that this is derived from current Post

GP - Days

N

Date differential of the above

GP - Time Out of training

N

TIS does not currently record short periods of time out of training

GP - WTE

Y

Placement.WholeTimeEquivalent

In TIS this is a decimal, 1 being Full Time

Is this an ITP Post

N

If PlacementOtherSite.PlacementTisID is not null and/or??? PlacementOtherSpecialty.PlacementTisID is not null for a Placement then Is this an ITP Post = Y

If a placement has an OtherSite and/or an OtherSpecialty than there is a record in the PlacementOtherSite or PlacementOtherSpecialty table respectively for that parent Placement

Scheme Days - Primary Care

N

DateDiff Placement.StartDate and Placement.EndDate where Placement.SpecialtyName = ‘General Practice’

If this is an ITP post, on TIS the PlacementOtherSpecialty/Site will have the same dates as the parent placement and therefore any count of days will be the same. Should these be split even across this range, i.e. Datediff(day,Placement.StartDate,Placement.EndDate)/2???

Scheme Days - Non-Primary Care

N

DateDiff Placement.StartDate and Placement.EndDate where Placement.SpecialtyName <> ‘General Practice’

If this is an ITP post, on TIS the PlacementOtherSpecialty/Site will have the same dates as the parent placement and therefore any count of days will be the same. Should these be split even across this range, i.e. Datediff(day,Placement.StartDate,Placement.EndDate)/2???

Scheme Days - Total

N

What is this a total of???

Organisation

Y

Placement.SiteName

There is a Site reference table on 14Fish and TIS. These are not aligned and would need to be as mapping would be extremely labour intensive and quickly become deprecated.

Dates

N

Concatenation of Placement.StartDate - Placement.EndDate

Days

N

Datediff(day,Placement.StartDate,Placement.EndDate)

WTE

Y

Placement.WholeTimeEquivalent

In TIS this is a decimal, 1 being Full Time

GMC

Y

Person.GMCNumber

Training Number

Y

NTN

This field is not saved in TIS but is calculated based upon TIS data

Certificate Type

Y

ProgrammeMembership/CurriculumMembership.TrainingPathway

Certificate subtype

N

Current stage of training

N

For the current placement:

If Placement.PlacementType in ('In Post','In Post - Acting Up','In Post - Extension') then Placement.ApprovedGradeAbbreviation

If Placement.PlacementType not in ('In Post','In Post - Acting Up','In Post - Extension') then Placement.PlacementType

Not sure if all placement types should be displayed in the second logic. Attached is a list of current placement types on TIS.

Unsure if ‘In Post’, ‘In Post - Acting Up’ and 'In Post - Extension should be different stages of training???

Educational Supervisor

N

Concatenation of PlacementSupervisor.SupervisorForenames PlacementSupervisor.Surname where the Placement is CURRENT, Placement.PlacementTisID = PlacementSupervisor.PlacementTisID and PlacementSupervisor.SupervisorType = ‘EducationalSupervisor’

Unsure of whether this field is populated by Post or by ESR

Deanery

Y

ProgrammeMembership/CurriculumMembership.ProgrammeManagingDeanery

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Training Programme

Y

ProgrammeMembership/CurriculumMembership.ProgrammeName

This is a reference table that exists in both systems which are not aligned. Either these reference tables need to be aligned or equivalents mapped

Dean/RO

Y/N

This field exists in the TIS backend and in Revalidation but is not exposed currently for export. There is a mapping of ProgrammeManagingDeanery/Local Office from TIS or the GMC which could be used.

CCT Date

Y

ProgrammeMembership/CurriculumMembership.ProgrammeCurriculumCompletionDate

Stage of Training

N

A combination of sequential placements should be considered to make up on stage of training if the following are the equal Placement.GradeAbbreviation, Placement.PlacementType in ('In Post','In Post - Acting Up','In Post - Extension'), Placement.WholeTimeEquivalent.

If any of the above of sequential placement is not equal to the previous placement, a new Stage of Training should be created.

If Placement.PlacementType in ('In Post','In Post - Acting Up','In Post - Extension') then Placement.ApprovedGradeAbbreviation

If Placement.PlacementType not in ('In Post','In Post - Acting Up','In Post - Extension') then Placement.PlacementType

Unsure if ‘In Post’, ‘In Post - Acting Up’ and 'In Post - Extension should be different stages of training???

Dates

N

A combination of sequential placements should be considered to make up on stage of training if the following are the equal Placement.GradeAbbreviation, Placement.PlacementType in ('In Post','In Post - Acting Up','In Post - Extension'), Placement.WholeTimeEquivalent.

Dates would then be Min(Placement.StartDate) - Max(Placement.EndDate)

Full-Time

N

If Placement.WholeTimeEquivalent = 1 then Yes, else No

Is an extension

N

If Placement.PlacementType = ‘In Post - Extension’ then Yes, else No

Do NOT count towards training

N

If Placement.PlacementType not in ('In Post','In Post - Acting Up','In Post - Extension') then Yes, else No

Notes

Y/N

There is a Placement.Comments field but unsure if the notes in these fields are equivalent