Page content:
| Table of Contents |
|---|
Background
An integration A mechanism/process is required to bring across GMC LRMP (List of Registered Medical Practitioners) data to update trainees records on TIS. This page captured captures the LRMP data mapping and how we'd intend to bring across the LRMP data as an MVP and Post MVP.
Currently, the LRMP Data can be accessed only via an SFTP share a secure webiste or sent (daily) by email in CSV format with the following schema. The user guide has been attached to this page too, see list of attachments at the bottom of the page.
The archived space for relevant comments made previously - /wiki/spaces/TISDEV/pages/57281626
GMC LRMP Data
from SpecSpecification
Column Name | Example | Description |
|---|---|---|
| GMC Ref No | 1393398 | This is the unique seven digit reference number allocated by the GMC to each registered doctor. |
| Surname | Chater | The surname, last name or family name in mixed case. |
| Given Name | Susan | The given / first names in mixed case. |
| Other Names | Y/N | The doctor’s other or “middle” names in mixed case. This field will contain all of the other names that the doctor has registered with the GMC. |
| Gender | W | Man (M) or Woman (W) |
| Qualification | MB BCh | This is the name of the doctor’s Primary Medical Qualification |
| Year Of Qualification | 1978 | The year when Primary Medical Qualification exams were passed. |
| Place of Qualification | National University of Ireland | The name of the Place of Study for Primary Medical Qualification |
| PR Date (Provisional Registration) | 5071978 | This is the date that the doctor was first granted Provisional Registration. |
| FR Date (Full Registration) | 8021980 | This is the date that the doctor was first granted Full Registration. |
| Specialist Register Date | 25022003 | This is the date that the doctor was entered into the Specialist Register. |
| GP Register Date | This is the date that the doctor was entered into the GP Register. | |
| Registration Status | Registered with Licence | The current status of a doctor's entry in the Register, including the doctor’s Licence status. |
| ARF Due Date ( Annual Retention Fee) | 8022012 | This is the date that the doctor’s Annual Retention Fee (ARF) is due. |
| Specialty1 | General (internal) medicine | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. |
| Sub_Specialty1 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty2 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty2 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty3 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty3 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty4 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty4 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty5 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty5 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty6 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty6 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| Specialty7 | This is the specialty identified in the specialist register. Up to 7 specialties can be provided for a given doctor. | |
| Sub_Specialty7 | This is the sub-specialty identified in the specialist register. Up to 7 sub-specialties can be provided for a given doctor. | |
| FTP Conditions Exist (Fitness to Practise) | This indicates whether the doctor has active Fitness to Practise Conditions applied to their Registration. | |
| FTP Undertakings Exist | N | This indicates whether the doctor has active Fitness to Practise Undertakings applied to their Registration. |
| FTP Warnings Exist | N | This indicates whether the doctor has an active Fitness to Practise Warning. |
| Place of Qualification Country | Ireland | The name of the country where a doctor undertook their Primary Medical Qualification. |
...
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
The Main fields we are interested in for TIS are:
- ARF Due Date ( Annual Retention Fee) = 'GMC end date' on TIS
- 'FR Date (Full Registration)' or 'PR Date (Provisional Registration)' = 'GMC start date' on TIS based on the 'GMC status' the trainee hold.
- GMC Status
For TIS purpose GMC has confirmed the following to be appropriate:
• GMC start date = PR date to update on TIS:
| TIS Field | GMC LRMP Field to populate with |
|---|---|
| GMC start date |
|
...
| GMC end date |
...
| |
| GMC Status |
|
Note: “The ‘Delta’ file contains all LRMP records that have been updated in the last 24 hours.”
In a scenario where the last delta failed to update on TIS for whatever reason the following has been suggested by the GMC:
- GMC preserve a rolling 7 days of Delta files in the download area, which should allow us to recover from any load issues
- Failing that, then the suggestion is to get the full file before carrying on with the delta
- Delta files are produced 7 days a week
MVP - (discuss with devs and split ticket)
- 11/06/2020: Suggestion is to at least consider periodical updates on TIS with the GMC LRMP data that is now available in National Data Warehouse under sql02
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Post MVP- (discuss with devs and split ticket)
- Consider Delta updates in addition to full loads
- Engage in discussions with GMC stakeholders to build an API and some form of alignment with their roadmap
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
List of Registration Statuses and Dates
...