TIS - ESR interface Bi-directional meetings

TIS - ESR Meeting 14/03/2019 in Sheffield

Attendee:

Victoria Hartland - ESR
Craig Elton - ESR
Pavitra Paniker - ESR
Nazia Akhtar - TIS
Chris Mills - TIS
Adewale Adekoya - TIS
Tayo Okuyedi

In table below are issues raised at the meeting with the details. I have created the Actions/Comments' column to give up to date findings

Please Note: text in red are actions

Issues	Details	Actions/Comments
RTC	ESR needs exception report from TIS for the RMT they send TIS	15/03/2019: Now in NDW. Naz may have to look at this from TIS end and decide who to give access to in NDW .
DNC	ESR needs exception report	15/03/2019: There is a ticket for it under the EPIC TISNEW-2528 which is - TISNEW-2698. TIS team and POs need to prioritise this piece of work.
Error Reports	ESR wants a view of all the error reports Missing Mandatory Fields - Trainees with missing mandatory ESR fields for future placements on TIS Unmatched Deleted DPNs - Deleted positions on ESR but CURRENT on TIS Unmatched Pending DPNs- .Mismatch of ESR DPNs against TIS NPNs, i.e. DPN's incorrectly entered on ESR APC warnings - Warnings generated by ESR e.g. missing GMC end date, nationality does not match etc	15/03/2019: Create your reports via NDW- Tableau - Naz may have to look at this from TIS end and decide who to give access
Duplication	TIS sending us the same information again and again and ERS duplicating the detials	15/03/2019: ESR- to send Chris M samples. ESR have a temporary solutions in place – ESR keeps sending us the same 'positions' again and again – Problem should be resolve at source (recommendation) A ticket already created - TISNEW-2062 Chris and TIS team may have to look at the issue
Post Code	Joined together post codes from TIS. ESR only accept 8 characters in this field and TIS allows free text	15/03/2019: Ade to investigate and go back to Pav Questions to ask Pav which post code finder ESR is using, if any? can ESR look from their end on solutions; e.g. extending 8 characters, using text format etc? are you talking about UK post codes? What sort of validation is ESR using to validate post codes? there is a ticket for the trimming of leading and trailing spaces - TISNEW-2819, should we just keep it at this or there is more to the issue?
Some trust not using TIS-ESR interface	Typical example is St' Helen and Knowley using Trac - with over 9000 trainees.	15/03/2019: To be considered during the bi-directional solution. Maybe the bi-directional solution needs to be flexible enough to accepting GMC number and NTN if possible
Monitoring Tools	Need a two way tools to monitor ETL. Something that will work for both TIS and ESR. TIS already have a tool to monitor ETL but might need to be developed on.	15/03/2019: Chris looking at this from TIS end There are tickets already on this - TISNEW-2543 and 2544
POs Involvement	Getting POs to get involve in this interface and attend meetings	15/03/2019: Naz may have to look at this from TIS end

Meeting Outcome:

It was agreed that we should look at the above data quality issues and make sure they are resolved before with start the bi-directional interface. It will not be appropriate to carry the known issues to bi-directional interface without being resolved.
To fix another date for meeting after Tayo's team must have completed their work on the business requirements side of things - 19th April 2019 suggested