RCGP e-Portfolio Data Transfer Automation

The original agreement with the Royal Colleges was for a monthly transfer of Continuing Trainee Data from the 4 Nation SEBs (TIS, Turas, Intrepid). This was done through the creation of monthly data which are then uploaded to a secure SharePoint site where Royal Colleges has access to their named folders. For NHSE and NIMDTA, this is a fully automated process from TIS via the NDW. For Scotland and Wales this is managed from relevant colleagues via Turas and Intrepid respectively.

From conversations with the RCGP and NHSE GP administrators the process above was not sufficient due to the following reasons:

• RCGP e-Portfolio requires data to be maintained by NHSE GP administrators whereas other Royal College e-Portfolios the burden of data entry is on the Trainee. This means there is a far higher amount of double entry by admin staff.

• The above as well as the frequency of change within individual trainee’s training programmes (Programme/Curriculum end dates, Placements, WTE, etc) meant that the monthly frequency of the Continuing Trainee Data was not sufficient enough.

In light of the above, work has begun to investigate an automated solution where data is mapped from TIS to the RCGP e-portfolio (14Fish) on a more frequent basis. The current proposal is to use the same method as data is transferred to Accent Leave Manager, TIS ETL --> NDW --> NDW Secure Server --> 14Fish. This transfer would take place on a daily basis.

Data Mapping: TIS - 14Fish RCGP e-Portfolio

In order to achieve the above, the depth and breadth of the data required from TIS must be determined. Of that data set, a mapping of TIS data fields to 14Fish is also required.