Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

IssuesDetailsActions/Comments
RTCESR 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 Notification Confirmation files - DCC - send to NWD - for esr to have access

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

DuplicationTIS 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?

Pave Response of 21/03/2019 in Red


  • which post code finder ESR is using, if any? Quick Address System supplied by Experian
  • can ESR look from their end on solutions; e.g. extending 8 characters, using text format etc? 8 characters, spaces are counted
  • are you talking about UK post codes? The validation we do is as specified below. There is no added intelligence to check if UK or not.
  • What sort of validation is ESR using to validate post codes? 8 characters, spaces are counted as a character
  • 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? This could be useful to ensure that postcodes don’t deviate from the format.

Note: There is an existing ticket on this issue and needs to be prioritise by the Product Owner to go into TIS sprint.

Some trust not using TIS-ESR interfaceTypical 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 ToolsNeed 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

...