Page Comparison

For Discussion

#

#

Comment

Owner

1

Should the Programme Name and Number be unique ?

Programme Name is not unique. I'm not sure on whether an agreement on naming convention has been agreed in consolidation but there will be many duplicate programmes.

Alistair Pringle (Unlicensed)/Former user (Deleted)/Joanne Watson (Unlicensed)

2

Should the Programme Number be unique ?

The programme number is unique. This number is assigned by the GMC to each local Programme when it gains first approval.

Alistair Pringle (Unlicensed)/Former user (Deleted)/Joanne Watson (Unlicensed)

Programme by LocalOfficeName and Status;

Code Block

	sql
	sql

select LocalOfficeName, Status, count(*) 
from [HEELIVE].[vwProgramme] as p
join [HEELIVE].[vwLocalOffice] as lo on (lo.ItemType = 'Programme' and lo.UniqueID = p.ProgrammeID)
group by LocalOfficeName, Status
order by 2,1;

This is the distribution of the Hicom LocalOffice table data to Programmes

LocalOfficeName	Status	RowCount
HEEM	Current	89
HEEOE	Current	110
HELASE	Current	257
HENE	Current	100
HENW	Current	193
HESW	Current	148
HEWM	Current	166
HEWTV	Current	151
HEYH	Current	108
HEEM	Inactive	367
HEEOE	Inactive	1
HELASE	Inactive	15812
HENE	Inactive	1
HENW	Inactive	8
HESW	Inactive	647
HEWTV	Inactive	79
HEYH	Inactive	142

...

Code Block

	sql
	sql

select LocalOfficeName, Status, count(*) 
from [HEELIVE].[vwProgramme] as p
join [HEELIVE].[vwLocalOffice] as lo on (lo.ItemType = 'Programme' and lo.UniqueID = p.ProgrammeID)
where p.ProgrammeID in (select UniqueID
						from [HEELIVE].[vwLocalOffice] as lo
						where lo.ItemType = 'Programme' 
						group by UniqueID
						having count(*) > 1)
group by LocalOfficeName, Status
order by 2,1;

The following LocalOffices have shared Programmes within them;

LocalOfficeName	Status	RowCount
HEEM	Inactive	140
HESW	Inactive	13
HEWTV	Inactive	13
HEYH	Inactive	140

...

Code Block

	sql
	sql

select ProgrammeNumber, ProgrammeName, status, count(*)
from [HEELIVE].[vwProgramme] as p
group by ProgrammeNumber, ProgrammeName, status
having count(*) > 1
order by 3,4 desc;

If using the smart search in TIS for Programmes, by Programme Number or Name, searching the following values will cause duplicates to be returned;

ProgrammeNumber	ProgrammeName	status	RowCount
NOR2137	Acute Internal Medicine	Current	2
YAH710	General Practice Northallerton	Current	2
NULL	NULL	Inactive	14
07/KSS/02/RTK01/01/F1/019	07/KSS/02/RTK01/01/F1/019	Inactive	3
08/KSS/01/RVV09/01/F1/020	08/KSS/01/RVV09/01/F1/020	Inactive	3
08/KSS/02/RA201/01/F1/013	08/KSS/02/RA201/01/F1/013	Inactive	2
08/KSS/02/RA201/02/F2/005	08/KSS/02/RA201/02/F2/005	Inactive	2
08/KSS/03/RPL04/01/F2/017	08/KSS/03/RPL04/01/F2/017	Inactive	2
08/KSS/03/RPL04/01/F2/022	08/KSS/03/RPL04/01/F2/022	Inactive	2
08/KSS/03/RTP04/02/F2/003	08/KSS/03/RTP04/02/F2/003	Inactive	2
08/KSS/03/RTP04/F1/001	08/KSS/03/RTP04/F1/001	Inactive	2
08/KSS/03/RXH01/01/F1/004	08/KSS/03/RXH01/01/F1/004	Inactive	2
08/KSS/03/RXH01/01/F1/005	08/KSS/03/RXH01/01/F1/005	Inactive	2
08/KSS/03/RXH01/01/F1/010	08/KSS/03/RXH01/01/F1/010	Inactive	2
08/KSS/03/RXH01/01/F1/028	08/KSS/03/RXH01/01/F1/028	Inactive	2
08/KSS/03/RXH01/02/F2/009	08/KSS/03/RXH01/02/F2/009	Inactive	2
08/KSS/03/RXH01/02/F2/018	08/KSS/03/RXH01/02/F2/018	Inactive	2
08/KSS/03/RXH01/02/F2/032	08/KSS/03/RXH01/02/F2/032	Inactive	2
08/KSS/03/RXH01/02/F2/047	08/KSS/03/RXH01/02/F2/047	Inactive	2
08/KSS/03/RXH01/02/F2/053	08/KSS/03/RXH01/02/F2/053	Inactive	2
08/KSS/RN707/01/F1/005	08/KSS/RN707/01/F1/005	Inactive	2
08/KSS/RN707/01/F2/001	08/KSS/RN707/01/F2/001	Inactive	2
08/KSS/RN707/01/F2/005	08/KSS/RN707/01/F2/005	Inactive	2
08/KSS/RN707/01/F2/018	08/KSS/RN707/01/F2/018	Inactive	2
08/KSS/RPL04/01/F1/004	08/KSS/RPL04/01/F1/004	Inactive	2
08/KSS/RPR01/01/F1/005	08/KSS/RPR01/01/F1/005	Inactive	2
08/KSS/RPR01/01/F2/007	08/KSS/RPR01/01/F2/007	Inactive	2
08/KSS/RPR01/01/F2/015	08/KSS/RPR01/01/F2/015	Inactive	2
08/KSS/RVV01/F1/007	08/KSS/RVV01/F1/007	Inactive	2
08/KSS/RVV09/01/F2/021	08/KSS/RVV09/01/F2/021	Inactive	2
08/KSS/RVVEK/GPST1/008	08/KSS/RVVEK/GPST1/008	Inactive	2
08/KSS/RVVKC/F2/013	08/KSS/RVVKC/F2/013	Inactive	2
08/KSS/RWF03/01/F1/003	08/KSS/RWF03/01/F1/003	Inactive	2
08/KSS/RWF03/01/F1/009	08/KSS/RWF03/01/F1/009	Inactive	2
08/KSS/RWF03/01/F2/012	08/KSS/RWF03/01/F2/012	Inactive	2
08/KSS/RWF03/01/F2/020	08/KSS/RWF03/01/F2/020	Inactive	2
08/RDU01/02/F2/506M	08/RDU01/02/F2/506M	Inactive	2
11/KSS/RYR18/CST/STR(L)/004	11/KSS/RYR18/CST/STR(L)/004	Inactive	2
11/LDN/01/RYQ30/001/F2/009	10/LDN/01/RYQ30/001/F2/009	Inactive	2
12/KSS/RPC04/CST/STR(L)/074	12/KSS/RPC04/CST/STR(L)/074	Inactive	2
12/KSS/RWF03/CST/STR(L)029	12/KSS/RWF03/CST/STR(L)029	Inactive	2
12/KSS/RXC/CST/STR(L)060	12/KSS/RXC/CST/STR(L)060	Inactive	2
12/LDN/01/RJ121/01/F1/021	10/LDN/01/RJ121/001/FY1/021	Inactive	2
12-13/KSS/RTK01/CMT/STR(L) 01	12-13/KSS/RTK01/CMT/STR(L) 01	Inactive	2
12-13/KSS/RXC02/CMT/STR(L) 02	12-13/KSS/RXC02/CMT/STR(L) 02	Inactive	2
13/KSS/RVV01/CMT/STR(L)/13	13/KSS/RVV01/CMT/STR(L)/13	Inactive	2
13/KSS/RXH01/CST/STR(L)049	13/KSS/RXH01/CST/STR(L)049	Inactive	2
07/KSS/RA201/01/F1/001	07/KSS/RA201/01/F1/001	Inactive	2
07/KSS/RA210/01/F2/003	07/KSS/RA210/01/F2/003	Inactive	2
07/KSS/RTK01/02/F1/019	07/KSS/RTK01/02/F1/019	Inactive	2
07/KSS/RTK01/02/F1/024	07/KSS/RTK01/02/F1/024	Inactive	2
07/KSS/RTK01/02/F1/028	07/KSS/RTK01/02/F1/028	Inactive	2
07/KSS/RVV09/01/F2/008	07/KSS/RVV09/01/F2/008	Inactive	2
07/KSS/RVVEK/GPST1/020	07/KSS/RVVEK/GPST1/020	Inactive	2
07/KSS/RVVEK/GPST2/001	07/KSS/RVVEK/GPST2/001	Inactive	2
07/KSS/RVVEK/GPST2/019	07/KSS/RVVEK/GPST2/019	Inactive	2
07/KSS/RVVKC/01/ST1/002	07/KSS/RVVKC/01/ST1/002	Inactive	2
07/KSS/RVVKC/01/ST1/003	07/KSS/RVVKC/01/ST1/003	Inactive	2
07/KSS/RXC01/01/F2/008	07/KSS/RXC01/01/F2/008	Inactive	2
07/KSS/RXC02/01/F2/003	07/KSS/RXC02/01/F2/003	Inactive	2
07/KSS/RXC02/01/F2/008	07/KSS/RXC02/01/F2/008	Inactive	2
07/KSS/RXC02/01/F2/013	07/KSS/RXC02/01/F2/013	Inactive	2
08/KSS//RDU01/02/F2/020	08/KSS//RDU01/02/F2/020	Inactive	2
08/KSS/01/RPA02/01/F1/010	08/KSS/01/RPA02/01/F1/010	Inactive	2
08/KSS/01/RPA02/01/F1/013	08/KSS/01/RPA02/01/F1/013	Inactive	2
08/KSS/01/RPA02/01/F1/043	08/KSS/01/RPA02/01/F1/043	Inactive	2
08/KSS/01/RPA02/F2/027	08/KSS/01/RPA02/F2/027	Inactive	2
08/KSS/01/RVV09/01/F1/008	08/KSS/01/RVV09/01/F1/008	Inactive	2
Rotation 6	FY2 NGH	Inactive	2
Rotation FP2 - 5	NGH FP2	Inactive	2

...

Code Block

	sql
	sql

select lo.LocalOfficeName, p.*
from [HEELIVE].[vwProgramme] as p
join [HEELIVE].[vwLocalOffice] as lo on (lo.ItemType = 'Programme' and lo.UniqueID = p.ProgrammeID)
where ProgrammeNumber in ('NOR2137','YAH710')

Details on the 2 duplicated Current Programmes;

LocalOfficeName	RecordOrigin	Status	ManagingDeanery	ProgrammeName	ProgrammeNumber	ProgrammeID	LeadProviderTrustID	LeadProviderName	LeadProviderKnownAs	LeadProviderTrustNumber	ProgrammeDirectors
HENE	HEELIVE	Current	Health Education England North East	Acute Internal Medicine	NOR2137	5936324	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England North East	Acute Internal Medicine	NOR2137	8073940	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England Yorkshire and the Humber	General Practice Northallerton	YAH710	13943505	NULL	NULL	NULL	NULL	NULL
HEYH	HEELIVE	Current	Health Education England Yorkshire and the Humber	General Practice Northallerton	YAH710	14053554	NULL	NULL	NULL	NULL	NULL

...

Code Block

	sql
	sql

select ProgrammeNumber, status, count(*)
from [HEELIVE].[vwProgramme] as p
group by ProgrammeNumber, status
having count(*) > 1
order by 2,3 descby 2,3 desc;

If using the smart search in TIS for Programmes, by Programme Number, searching the following values will cause duplicates to be returned;

ProgrammeNumber	status	RowCount
LON557	Current	29
EMD669	Current	7
LONDFT	Current	5
LON202	Current	5
KSSDFT	Current	5
LON235	Current	4
LON183	Current	4
LON176	Current	4
LON239	Current	4
LON156	Current	4
LON508	Current	4
LON213	Current	4
LON204	Current	4
LON211	Current	4
LON910	Current	4
LON224	Current	3
LON234	Current	3
LON230	Current	3
LON227	Current	3
LON223	Current	3
LON220	Current	3
LON170	Current	3
LON927	Current	3
LON193	Current	3
LON165	Current	3
LON2009	Current	3
LON3026	Current	3
LON922	Current	3
LON178	Current	3
LON182	Current	3
LON208	Current	3
LON287	Current	3
LON209	Current	2
LONDCT	Current	2
NOR2137	Current	2
LON215	Current	2
LON253	Current	2
LON276	Current	2
DENT069	Current	2
LON154	Current	2
LON273	Current	2
MER943	Current	2
LON252	Current	2
YAH710	Current	2
LON177	Current	2
LON162	Current	2
LON214	Current	2
LON242	Current	2
LON222	Current	2
NULL	Inactive	21
LON2432	Inactive	4
LON512	Inactive	4
LON2434	Inactive	4
KSS/RTK02/06/F1/002	Inactive	3
KSS/RN707/01/F1/008	Inactive	3
KSS/RDU01/55/F1/002	Inactive	3
KSS/RXH01/01/F1/019	Inactive	3
KSS/RPL04/01/F1/002	Inactive	3
KSS/RPL04/01/F1/011	Inactive	3
KSS/RPR01/01/F1/001	Inactive	3
KSS/RN707/01/F1/016	Inactive	3
KSS/RPR01/01/F1/006	Inactive	3
KSS/RDU01/02/F1/001	Inactive	3
KSS/RWF02/01/F1/004	Inactive	3
KSS/RDU01/02/F1/009	Inactive	3
KSS/RN707/01/F1/001	Inactive	3
KSS/RPL04/01/F1/005	Inactive	3
KSS/RDU01/02/F1/015	Inactive	3
KSS/RWF02/01/F1/012	Inactive	3
KSS/RXH01/01/F1/015	Inactive	3
KSS/RXH01/01/F1/010	Inactive	3
KSS/RXH01/01/F1/011	Inactive	3
KSS/RN707/01/F1/006	Inactive	3
KSS/RXH01/01/F1/017	Inactive	3
KSS/RPA02/01/F1/004	Inactive	3
KSS/RN707/01/F1/015	Inactive	3
KSS/RPL04/01/F1/008	Inactive	3
KSS/RPL04/01/F1/010	Inactive	3
KSS/RPL04/01/F1/009	Inactive	3
KSS/RVV01/01/F1/001	Inactive	3
KSS/RWF02/01/F1/018	Inactive	3
KSS/RPA02/01/F1/013	Inactive	3
KSS/RPA02/01/F1/012	Inactive	3
KSS/RDU01/55/F1/003	Inactive	3
KSS/RXC02/01/F1/004	Inactive	3
KSS/RTK02/01/F1/002	Inactive	3
KSS/RPA02/01/F1/002	Inactive	3
KSS/RPA02/02/F1/007	Inactive	3
KSS/RWF02/01/F1/006	Inactive	3
KSS/RDU01/55/F1/006	Inactive	3
KSS/RXH01/01/F1/006	Inactive	3
KSS/RPL04/01/F1/018	Inactive	3
08/KSS/01/RVV09/01/F1/020	Inactive	3
KSS/RN707/01/F1/013	Inactive	3
KSS/RPA02/02/F1/005	Inactive	3
KSS/RTK02/01/F1/003	Inactive	3
KSS/RPL04/01/F1/003	Inactive	3
KSS/RN707/01/F1/010	Inactive	3
KSS/RPL04/01/F1/015	Inactive	3
KSS/RXH01/01/F1/009	Inactive	3
KSS/RXC02/01/F1/002	Inactive	3
KSS/RPL04/01/F1/006	Inactive	3
KSS/RDU01/02/F1/013	Inactive	3
KSS/RPL04/01/F1/004	Inactive	3
KSS/RPA02/01/F1/015	Inactive	3
KSS/RWF02/01/F1/015	Inactive	3
KSS/RXH01/01/F1/008	Inactive	3
KSS/RPL04/01/F1/012	Inactive	3
KSS/RDU01/55/F1/001	Inactive	3
KSS/RWF02/01/F1/014	Inactive	3
KSS/RDU01/02/F1/004	Inactive	3
KSS/RXC02/01/F1/003	Inactive	3
KSS/RWF02/01/F1/017	Inactive	3
KSS/RPR01/01/F1/004	Inactive	3
KSS/RPA02/01/F1/009	Inactive	3
KSS/RN707/01/F1/005	Inactive	3
KSS/RPA02/01/F1/011	Inactive	3
KSS/RXH01/01/F1/014	Inactive	3
KSS/RN707/01/F1/004	Inactive	3
KSS/RDU01/02/F1/003	Inactive	3
07/KSS/02/RTK01/01/F1/019	Inactive	3
KSS/RDU01/02/F1/006	Inactive	3
Rotation 6	Inactive	3
KSS/RN707/01/F1/011	Inactive	3
KSS/RXC02/01/F1/006	Inactive	3
KSS/RDU01/02/F1/012	Inactive	3
KSS/RPA02/01/F1/014	Inactive	3
KSS/RPL04/01/F1/021	Inactive	3
Rotation FP2 - 5	Inactive	3
KSS/RDU01/55/F1/005	Inactive	3
KSS/RPR01/01/F1/003	Inactive	3
KSS/RPR01/01/F1/002	Inactive	3
KSS/RXC02/01/F1/007	Inactive	3
KSS/RWF02/01/F1/007	Inactive	3
KSS/RWF02/01/F1/011	Inactive	3
KSS/RDU01/02/F1/007	Inactive	3
KSS/RWF02/01/F1/008	Inactive	3
KSS/RWF02/01/F1/013	Inactive	3
KSS/RXC02/01/F1/005	Inactive	3
KSS/RWF02/01/F1/005	Inactive	3
KSS/RDU01/55/F1/007	Inactive	3
KSS/RXH01/01/F1/007	Inactive	3
KSS/RXH01/01/F1/001	Inactive	3
KSS/RDU01/02/F1/010	Inactive	3
KSS/RXH01/01/F1/002	Inactive	3
KSS/RN707/01/F1/009	Inactive	3
KSS/RPA02/01/F1/003	Inactive	3
KSS/RXH01/01/F1/005	Inactive	3
KSS/RPL04/01/F1/001	Inactive	3
KSS/RPA02/02/F1/003	Inactive	3
KSS/RWF02/01/F1/003	Inactive	3
KSS/RDU01/02/F1/014	Inactive	3
KSS/RWF02/01/F1/016	Inactive	3
KSS/RXH01/01/F1/013	Inactive	3
KSS/RXC02/01/F1/009	Inactive	3
KSS/RWF02/01/F1/009	Inactive	3
KSS/RN707/01/F1/014	Inactive	3
KSS/RPA02/02/F1/002	Inactive	3
KSS/RPL04/01/F1/017	Inactive	3
KSS/RXH01/01/F1/012	Inactive	3
KSS/RWF02/01/F1/001	Inactive	3
KSS/RXC02/01/F1/001	Inactive	3
KSS/RXH01/01/F1/016	Inactive	3
KSS/RWF02/01/F1/002	Inactive	3
KSS/RPL04/01/F1/019	Inactive	3
KSS/RPR01/01/F1/005	Inactive	3
KSS/RPA02/02/F1/006	Inactive	3
KSS/RDU01/02/F1/016	Inactive	3
KSS/RTK02/06/F1/001	Inactive	3
KSS/RPA02/01/F1/010	Inactive	3
KSS/RPL04/01/F1/007	Inactive	3
KSS/RXH01/01/F1/003	Inactive	3
KSS/RPA02/01/F1/007	Inactive	3
KSS/RN707/01/F1/017	Inactive	3
KSS/RN707/01/F1/002	Inactive	3
KSS/RDU01/02/F1/008	Inactive	3
KSS/RWF02/01/F1/010	Inactive	3
KSS/RPA02/01/F1/008	Inactive	3
KSS/RDU01/02/F1/011	Inactive	3
KSS/RN707/01/F1/007	Inactive	3
KSS/RN707/01/F1/012	Inactive	3
KSS/RTK02/01/F1/001	Inactive	3
KSS/RPL04/01/F1/014	Inactive	3
KSS/RXC02/01/F1/008	Inactive	3
KSS/RPL04/01/F1/013	Inactive	3
KSS/RPA02/02/F1/008	Inactive	3
KSS/RPA02/01/F1/006	Inactive	3
KSS/RDU01/55/F1/004	Inactive	3
KSS/RPL04/01/F1/016	Inactive	3
KSS/RXH01/01/F1/004	Inactive	3
KSS/RPA02/01/F1/005	Inactive	3
KSS/RDU01/02/F1/005	Inactive	3
KSS/RDU01/02/F1/002	Inactive	3
KSS/RN707/01/F1/003	Inactive	3
KSS/RPL04/01/F1/020	Inactive	3
KSS/RXH01/01/F1/018	Inactive	3
KSS/RPA02/02/F1/001	Inactive	3
KSS/RPA02/01/F1/001	Inactive	3
KSS/RPA02/02/F1/004	Inactive	3
KSS/RPA02/02/F1/015	Inactive	2
KSS/RPR01/02/F1/004	Inactive	2
07/KSS/RTK01/02/F1/024	Inactive	2
KSS/RN707/01/F2/008	Inactive	2
KSS/RXH01/02/F2/009	Inactive	2
KSS/RPA02/01/F2/022	Inactive	2
KSS/RWF03/02/F1/006	Inactive	2
KSS/RWF02/01/F2/005	Inactive	2
KSS/RTK02/06/F1/003	Inactive	2
KSS/RTP04/01/F1/003	Inactive	2
KSS/RPL04/01/F2/019	Inactive	2
KSS/RDU01/02/F2/010	Inactive	2
Trent FP 050	Inactive	2
KSS/RXH01/02/F2/018	Inactive	2
KSS/RWF02/02/F1/003	Inactive	2
Trent FP 080	Inactive	2
KSS/RN707/01/F2/018	Inactive	2
KSS/RVV01/01/F1/007	Inactive	2
KSS/RA201/06/F2/011	Inactive	2
KSS/RXH01/01/F2/012	Inactive	2
07/KSS/RTK01/02/F1/028	Inactive	2
KSS/RPR01/02/F1/008	Inactive	2
KSS/RA201/01/F2/002	Inactive	2
KSS/RWF03/01/F1/010	Inactive	2
KSS/RWF02/01/F2/013	Inactive	2
KSS/RPA02/01/F2/016	Inactive	2
KSS/RN707/05/F1/004	Inactive	2
KSS/RWF02/01/F2/019	Inactive	2
KSS/RVV09/01/F1/001	Inactive	2
KSS/RXH09/01/F1/001	Inactive	2
KSS/RXH01/01/F2/004	Inactive	2
Trent FP 101	Inactive	2
KSS/RPL04/01/F1/023	Inactive	2
KSS/RA201/02/F2/009	Inactive	2
KSS/RWF03/01/F1/007	Inactive	2
KSS/RPA02/02/F1/014	Inactive	2
KSS/RPR01/01/F2/004	Inactive	2
KSS/RXH01/01/F2/016	Inactive	2
KSS/RXH09/02/F1/001	Inactive	2
07/KSS/RVVEK/GPST2/001	Inactive	2
KSS/RWF02/01/F2/004	Inactive	2
KSS/RVV01/02/F1/007	Inactive	2
KSS/RPR01/02/F1/002	Inactive	2
KSS/RXH01/01/F2/013	Inactive	2
KSS/RPA02/02/F2/007	Inactive	2
KSS/RPL04/01/F2/008	Inactive	2
KSS/RTK01/01/F2/009	Inactive	2
KSS/RXH01/02/F2/007	Inactive	2
KSS/RDU01/02/F2/002	Inactive	2
08/KSS/03/RXH01/02/F2/032	Inactive	2
KSS/RA201/02/F2/006	Inactive	2
KSS/RA201/06/F1/006	Inactive	2
KSS/RDU01/02/F2/013	Inactive	2
KSS/RWF02/02/F1/004	Inactive	2
Trent FP 078	Inactive	2
KSS/RVV01/02/F1/005	Inactive	2
KSS/RPL04/02/F2/003	Inactive	2
KSS/RA201/06/F1/004	Inactive	2
Trent FP 040	Inactive	2
KSS/RVV01/01/F1/002	Inactive	2
KSS/RPL04/01/F2/003	Inactive	2
KSS/RA201/02/F1/003	Inactive	2
Trent FP 077	Inactive	2
KSS/RWF02/02/F1/002	Inactive	2
08/KSS/03/RXH01/02/F2/009	Inactive	2
KSS/RTP04/06/F1/003	Inactive	2
KSS/RPA02/01/F2/017	Inactive	2
KSS/RPA02/01/F2/023	Inactive	2
KSS/RXH01/01/F2/010	Inactive	2
KSS/RA201/01/F1/001	Inactive	2
KSS/RXC01/05/F1/004	Inactive	2
KSS/RPR01/02/F1/003	Inactive	2
KSS/RPL04/01/F2/014	Inactive	2
KSS/RPA02/01/F2/025	Inactive	2
KSS/RTK01/06/F2/002	Inactive	2
KSS/RA201/02/F2/003	Inactive	2
KSS/RA201/06/F1/010	Inactive	2
KSS/RPA02/02/F2/006	Inactive	2
07/KSS/RVVEK/GPST1/020	Inactive	2
KSS/RPR01/01/F1/010	Inactive	2
KSS/RVV01/02/F1/002	Inactive	2
Trent FP 073	Inactive	2
KSS/RVV09/01/F1/004	Inactive	2
KSS/RPR01/02/F1/001	Inactive	2
08/KSS/03/RXH01/01/F1/005	Inactive	2
KSS/RTK01/02/F2/002	Inactive	2
KSS/RDU01/02/F2/008	Inactive	2
KSS/RXH01/01/F2/011	Inactive	2
Trent FP 007	Inactive	2
KSS/RA201/06/F2/008	Inactive	2
Trent FP 075	Inactive	2
KSS/RDU01/02/F2/016	Inactive	2
KSS/RA201/02/F1/004	Inactive	2
07/KSS/RWF03/01/F2/010	Inactive	2
KSS/RN707/01/F2/019	Inactive	2
KSS/RTK01/02/F2/015	Inactive	2
KSS/RPL04/01/F2/002	Inactive	2
12-13/KSS/RXC02/CMT/STR(L) 02	Inactive	2
07/KSS/RXC02/01/F2/003	Inactive	2
KSS/RTK01/02/F2/010	Inactive	2
KSS/RN707/05/F1/002	Inactive	2
Trent FP 008	Inactive	2
KSS/RPR01/02/F1/013	Inactive	2
KSS/RPA02/01/F2/019	Inactive	2
KSS/RPA02/01/F2/010	Inactive	2
KSS/RA201/02/F2/004	Inactive	2
KSS/RPA02/01/F2/021	Inactive	2
KSS/RTP04/01/F1/001	Inactive	2
KSS/RXH01/02/F2/017	Inactive	2
KSS/RTP04/02/F1/010	Inactive	2
Trent FP 071	Inactive	2
KSS/RXH01/02/F2/019	Inactive	2
Trent FP 074	Inactive	2
KSS/RXC02/02/F1/003	Inactive	2
KSS/RDU01/02/F1/017	Inactive	2
KSS/RXH09/02/F1/007	Inactive	2
08/KSS/RVVEK/GPST1/008	Inactive	2
Trent FP 096	Inactive	2
KSS/RPL04/01/F2/013	Inactive	2
KSS/RVV09/01/F1/005	Inactive	2
KSS/RTK01/01/F2/004	Inactive	2
Trent FP 066	Inactive	2
KSS/RTK01/02/F2/017	Inactive	2
KSS/RXC01/01/F1/009	Inactive	2
Trent FP 097	Inactive	2
KSS/RXH01/02/F1/002	Inactive	2
KSS/RPA02/02/F1/011	Inactive	2
13/KSS/RXH01/CST/STR(L)049	Inactive	2
KSS/RPR01/02/F1/010	Inactive	2
KSS/RTK01/02/F2/007	Inactive	2
KSS/RXC01/05/F1/001	Inactive	2
Trent FP 024	Inactive	2
KSS/RWF02/01/F2/001	Inactive	2
Trent FP 033	Inactive	2
KSS/RTK01/01/F2/001	Inactive	2
08/KSS/01/RPA02/F2/027	Inactive	2
KSS/RDU01/02/F2/003	Inactive	2
KSS/RXH01/02/F2/001	Inactive	2
KSS/RA201/06/F1/008	Inactive	2
KSS/RVV01/01/F1/012	Inactive	2
KSS/RA201/06/F2/002	Inactive	2
08/KSS/01/RPA02/01/F1/013	Inactive	2
Trent FP 099	Inactive	2
08/KSS/RWF03/01/F1/009	Inactive	2
Trent FP 093	Inactive	2
KSS/RPA02/02/F2/001	Inactive	2
KSS/RN707/01/F2/007	Inactive	2
Trent FP 025	Inactive	2
KSS/RXH01/02/F1/005	Inactive	2
08/KSS/03/RXH01/02/F2/053	Inactive	2
KSS/RTP04/02/F1/012	Inactive	2
KSS/RPR01/01/F1/009	Inactive	2
KSS/RA201/01/F1/004	Inactive	2
KSS/RVVKC/01/F1/009	Inactive	2
08/KSS/RPR01/01/F2/007	Inactive	2
Trent FP 029	Inactive	2
08/KSS/RPR01/01/F2/015	Inactive	2
KSS/RN707/01/F2/017	Inactive	2
KSS/RPR01/02/F1/011	Inactive	2
KSS/RPL04/02/F2/002	Inactive	2
Trent FP 037	Inactive	2
Trent FP 098	Inactive	2
KSS/RPL04/01/F2/016	Inactive	2
Trent FP 095	Inactive	2
KSS/RVV09/01/F1/007	Inactive	2
Trent FP 010	Inactive	2
KSS/RTK01/01/F1/002	Inactive	2
07/KSS/RTK01/02/F1/019	Inactive	2
KSS/RWF03/01/F1/004	Inactive	2
KSS/RA201/01/F2/004	Inactive	2
KSS/RVVKC/01/F1/006	Inactive	2
KSS/RXH01/02/F2/005	Inactive	2
Trent FP 038	Inactive	2
KSS/RPR01/02/F2/009	Inactive	2
KSS/RTP04/02/F1/004	Inactive	2
KSS/RPL04/01/F2/005	Inactive	2
KSS/RVV01/01/F2/002	Inactive	2
KSS/RPA02/02/F2/010	Inactive	2
08/KSS/RVVKC/F2/013	Inactive	2
Trent FP 027	Inactive	2
08/KSS/RPR01/01/F1/005	Inactive	2
Trent FP 021	Inactive	2
KSS/RTP04/02/F1/014	Inactive	2
KSS/RPR01/02/F2/005	Inactive	2
KSS/RPL04/01/F2/011	Inactive	2
KSS/RPR01/02/F1/005	Inactive	2
KSS/RTP04/02/F1/002	Inactive	2
KSS/RPA02/01/F2/018	Inactive	2
KSS/RA201/02/F2/007	Inactive	2
KSS/RXH01/02/F1/001	Inactive	2
Trent FP 023	Inactive	2
KSS/RVV09/01/F1/009	Inactive	2
KSS/RWF02/01/F2/016	Inactive	2
KSS/RPL04/01/F2/001	Inactive	2
Trent FP 083	Inactive	2
KSS/RXH09/02/F1/004	Inactive	2
Trent FP 039	Inactive	2
KSS/RDU01/02/F2/011	Inactive	2
KSS/RPA02/01/F2/020	Inactive	2
KSS/RXC01/01/F1/011	Inactive	2
KSS/RPA02/02/F2/002	Inactive	2
KSS/RN707/01/F1/019	Inactive	2
KSS/RN707/01/F2/002	Inactive	2
KSS/RVV09/02/F1/002	Inactive	2
07/KSS/RA210/01/F2/003	Inactive	2
KSS/RDU01/02/F2/014	Inactive	2
KSS/RPL04/01/F2/012	Inactive	2
08/KSS//RDU01/02/F2/020	Inactive	2
KSS/RPR01/01/F2/005	Inactive	2
KSS/RVV09/02/F1/001	Inactive	2
KSS/RA201/01/F2/003	Inactive	2
KSS/RXH01/02/F1/006	Inactive	2
KSS/RVVKC/01/F1/017	Inactive	2
KSS/RWF03/02/F1/002	Inactive	2
KSS/RTK01/02/F2/018	Inactive	2
KSS/RPR01/02/F1/009	Inactive	2
Trent FP 085	Inactive	2
Trent FP 042(Ac)	Inactive	2
KSS/RN707/05/F1/003	Inactive	2
KSS/RVV09/01/F1/008	Inactive	2
Trent FP 091	Inactive	2
Trent FP 094	Inactive	2
KSS/RTK01/02/F2/008	Inactive	2
KSS/RXC02/02/F1/004	Inactive	2
08/KSS/02/RA201/02/F2/005	Inactive	2
KSS/RXH01/01/F2/001	Inactive	2
KSS/RPL04/02/F2/001	Inactive	2
KSS/RA201/06/F2/012	Inactive	2
KSS/RDU01/55/F2/006	Inactive	2
KSS/RPA02/02/F1/013	Inactive	2
07/KSS/RVVKC/01/F1/001	Inactive	2
KSS/RDU01/55/F2/003	Inactive	2
KSS/RVV09/05/F1/003	Inactive	2
KSS/RVVKC/01/F1/007	Inactive	2
KSS/RVV01/01/F1/011	Inactive	2
KSS/RXH09/02/F1/003	Inactive	2
KSS/RVVKC/01/F1/011	Inactive	2
KSS/RDU01/02/F2/015	Inactive	2
KSS/RA201/06/F2/005	Inactive	2
08/KSS/RVV09/01/F2/021	Inactive	2
KSS/RA201/01/F1/003	Inactive	2
KSS/RXC02/01/F1/010	Inactive	2
Trent FP 062	Inactive	2
KSS/RWF03/01/F1/009	Inactive	2
KSS/RTP04/06/F1/001	Inactive	2
Trent FP 084	Inactive	2
KSS/RTK01/01/F1/001	Inactive	2
KSS/RPA02/02/F1/012	Inactive	2
KSS/RTP04/02/F1/009	Inactive	2
Trent FP 065	Inactive	2
07/KSS/RXC02/01/F2/008	Inactive	2
Trent FP 020	Inactive	2
08/KSS/01/RPA02/01/F1/043	Inactive	2
KSS/RPR01/02/F1/015	Inactive	2
Trent FP 069	Inactive	2
KSS/RWF02/01/F2/011	Inactive	2
08/KSS/02/RA201/01/F1/013	Inactive	2
Trent FP 090	Inactive	2
KSS/RPL04/02/F1/003	Inactive	2
08/KSS/03/RXH01/01/F1/010	Inactive	2
KSS/RWF03/01/F1/008	Inactive	2
Trent FP 064	Inactive	2
KSS/RPR01/02/F2/006	Inactive	2
KSS/RXH01/02/F2/016	Inactive	2
KSS/RVV09/05/F1/004	Inactive	2
08/RDU01/02/F2/506M	Inactive	2
Trent FP 041	Inactive	2
KSS/RXH01/01/F2/007	Inactive	2
KSS/RTP04/02/F1/006	Inactive	2
KSS/RXH01/01/F2/018	Inactive	2
Trent FP 067	Inactive	2
KSS/RXC01/01/F1/005	Inactive	2
KSS/RXH01/01/F1/021	Inactive	2
KSS/RDU01/02/F2/001	Inactive	2
Trent FP 056	Inactive	2
KSS/RXH01/01/F2/017	Inactive	2
KSS/RVVKC/01/F1/005	Inactive	2
KSS/RDU01/02/F2/006	Inactive	2
KSS/RPL04/01/F2/015	Inactive	2
KSS/RVV01/02/F1/006	Inactive	2
KSS/RXC02/01/F1/011	Inactive	2
KSS/RTK02/02/F1/001	Inactive	2
KSS/RVV01/01/F1/010	Inactive	2
KSS/RXH01/02/F2/004	Inactive	2
KSS/RTK01/02/F2/006	Inactive	2
Trent FP 015	Inactive	2
Trent FP 063	Inactive	2
07/KSS/RVVEK/GPST2/019	Inactive	2
08/KSS/RWF03/01/F2/012	Inactive	2
KSS/RWF02/01/F2/007	Inactive	2
KSS/RPA02/02/F2/013	Inactive	2
KSS/RXC01/01/F1/003	Inactive	2
07/KSS/RA201/01/F1/001	Inactive	2
KSS/RXH01/02/F2/015	Inactive	2
KSS/RPL04/02/F1/002	Inactive	2
KSS/RVVKC/01/F1/016	Inactive	2
KSS/RPA02/01/F2/005	Inactive	2
KSS/RPR01/02/F1/007	Inactive	2
KSS/RXH01/02/F2/006	Inactive	2
Trent FP 102	Inactive	2
KSS/RA201/06/F2/010	Inactive	2
KSS/RWF03/02/F1/004	Inactive	2
KSS/RN707/01/F1/018	Inactive	2
08/KSS/RN707/01/F2/018	Inactive	2
Trent FP 046	Inactive	2
KSS/RPA02/02/F2/004	Inactive	2
KSS/RPR01/02/F2/013	Inactive	2
KSS/RA201/02/F2/002	Inactive	2
KSS/RPA02/02/F2/012	Inactive	2
KSS/RTK01/02/F2/019	Inactive	2
KSS/RXH01/02/F2/010	Inactive	2
KSS/RDU01/55/F2/005	Inactive	2
08/KSS/03/RXH01/02/F2/018	Inactive	2
KSS/RTK01/02/F2/013	Inactive	2
KSS/RTP04/06/F1/005	Inactive	2
KSS/RN707/01/F2/001	Inactive	2
KSS/RDU01/02/F2/005	Inactive	2
KSS/RN707/01/F2/011	Inactive	2
KSS/RVVKC/01/F1/008	Inactive	2
KSS/RVV09/01/F1/006	Inactive	2
KSS/RTK01/01/F1/004	Inactive	2
KSS/RDU01/02/F2/012	Inactive	2
KSS/RTK01/02/F2/016	Inactive	2
KSS/RVV09/01/F1/003	Inactive	2
KSS/RXC01/01/F1/001	Inactive	2
KSS/RXH01/02/F2/012	Inactive	2
KSS/RPR01/02/F2/012	Inactive	2
KSS/RTK01/02/F2/003	Inactive	2
07/KSS/RXC02/01/F2/013	Inactive	2
Trent FP 019	Inactive	2
KSS/RVV01/01/F1/006	Inactive	2
KSS/RXH01/02/F2/003	Inactive	2
KSS/RTP04/02/F1/001	Inactive	2
KSS/RVV09/05/F1/001	Inactive	2
KSS/RPR01/02/F2/008	Inactive	2
KSS/RWF02/02/F1/006	Inactive	2
KSS/RPA02/01/F2/001	Inactive	2
KSS/RA201/02/F1/002	Inactive	2
KSS/RWF03/01/F1/002	Inactive	2
Trent FP 013	Inactive	2
KSS/RPR01/02/F2/007	Inactive	2
KSS/RPA02/01/F2/004	Inactive	2
KSS/RXH09/02/F1/002	Inactive	2
KSS/RA201/06/F1/009	Inactive	2
KSS/RA201/02/F2/011	Inactive	2
KSS/RTP04/02/F1/013	Inactive	2
KSS/RXC01/01/F1/008	Inactive	2
KSS/RWF02/01/F2/015	Inactive	2
Trent FP 092	Inactive	2
Trent FP 031	Inactive	2
KSS/RXH01/01/F2/005	Inactive	2
Trent FP 022	Inactive	2
Trent FP 061	Inactive	2
KSS/RTK01/02/F2/009	Inactive	2
KSS/RWF02/01/F1/019	Inactive	2
KSS/RXH01/02/F1/012	Inactive	2
Trent FP 076	Inactive	2
12/KSS/RXC/CST/STR(L)060	Inactive	2
Trent FP 035	Inactive	2
KSS/RA201/06/F2/007	Inactive	2
KSS/RTP04/02/F1/003	Inactive	2
KSS/RPA02/01/F2/026	Inactive	2
KSS/RA201/06/F1/011	Inactive	2
KSS/RWF03/02/F1/008	Inactive	2
KSS/RDU01/55/F2/004	Inactive	2
07/KSS/RXC01/01/F2/008	Inactive	2
KSS/RPA02/02/F2/005	Inactive	2
Trent FP 089	Inactive	2
KSS/RPL04/01/F2/006	Inactive	2
KSS/RPA02/02/F2/003	Inactive	2
KSS/RXH01/01/F2/002	Inactive	2
Trent FP 034	Inactive	2
KSS/RXH01/02/F1/010	Inactive	2
KSS/RXH01/01/F2/009	Inactive	2
KSS/RWF02/01/F2/008	Inactive	2
KSS/RPR01/02/F1/006	Inactive	2
KSS/RTK02/02/F1/002	Inactive	2
Trent FP 059	Inactive	2
KSS/RXH01/02/F1/011	Inactive	2
KSS/RXH01/02/F1/007	Inactive	2
KSS/RPA02/01/F2/007	Inactive	2
Trent FP 045	Inactive	2
KSS/RPA02/02/F1/009	Inactive	2
KSS/RTK01/02/F2/014	Inactive	2
08/KSS/01/RPA02/01/F1/010	Inactive	2
08/KSS/RN707/01/F2/001	Inactive	2
KSS/RTK02/02/F1/003	Inactive	2
KSS/RA201/06/F1/005	Inactive	2
KSS/RWF03/01/F1/003	Inactive	2
KSS/RVV01/01/F1/003	Inactive	2
KSS/RN707/01/F2/013	Inactive	2
08/KSS/03/RTP04/F1/001	Inactive	2
Trent FP 058	Inactive	2
KSS/RA201/06/F1/007	Inactive	2
KSS/RPA02/01/F2/024	Inactive	2
KSS/RVVKC/01/F1/013	Inactive	2
KSS/RTK01/02/F2/001	Inactive	2
KSS/RPA02/01/F2/013	Inactive	2
Trent FP 054	Inactive	2
KSS/RXH01/01/F2/008	Inactive	2
KSS/RTP04/01/F1/002	Inactive	2
KSS/RVV09/02/F1/003	Inactive	2
KSS/RTK01/01/F2/007	Inactive	2
KSS/RPR01/02/F2/011	Inactive	2
KSS/RA201/02/F2/008	Inactive	2
KSS/RPA02/01/F2/012	Inactive	2
KSS/RN707/01/F2/003	Inactive	2
KSS/RDU01/02/F2/018	Inactive	2
KSS/RVV09/05/F1/002	Inactive	2
08/KSS/RPL04/01/F1/004	Inactive	2
KSS/RTP04/02/F1/007	Inactive	2
07/KSS/RVVKC/01/ST1/002	Inactive	2
KSS/RXH09/02/F1/006	Inactive	2
Trent FP 048	Inactive	2
Trent FP 053	Inactive	2
KSS/RWF02/01/F2/012	Inactive	2
KSS/RVV01/02/F1/003	Inactive	2
KSS/RTK01/02/F2/004	Inactive	2
08/KSS/RVV01/F1/007	Inactive	2
Trent FP 049	Inactive	2
KSS/RA201/06/F2/003	Inactive	2
KSS/RVV09/05/F1/005	Inactive	2
KSS/RPA02/01/F2/006	Inactive	2
KSS/RDU01/55/F2/001	Inactive	2
KSS/RXC01/01/F1/012	Inactive	2
KSS/RXH01/02/F2/014	Inactive	2
KSS/RVV01/01/F1/009	Inactive	2
KSS/RDU01/02/F2/004	Inactive	2
Trent FP 043	Inactive	2
Trent FP 055	Inactive	2
Trent FP 104	Inactive	2
Trent FP 009	Inactive	2
KSS/RPA02/02/F2/011	Inactive	2
KSS/RPL04/01/F2/007	Inactive	2
KSS/RTK01/02/F2/011	Inactive	2
Trent FP 079	Inactive	2
Trent FP 026	Inactive	2
08/KSS/01/RVV09/01/F1/008	Inactive	2
KSS/RTP04/06/F1/006	Inactive	2
KSS/RPR01/02/F2/001	Inactive	2
KSS/RA201/06/F2/009	Inactive	2
KSS/RA201/02/F1/001	Inactive	2
Trent FP 001	Inactive	2
KSS/RXH01/02/F2/013	Inactive	2
12/KSS/RPC04/CST/STR(L)/074	Inactive	2
Trent FP 005	Inactive	2
KSS/RN707/05/F1/001	Inactive	2
08/KSS/RVVEK/CST1/002	Inactive	2
Trent FP 047	Inactive	2
KSS/RA201/02/F2/010	Inactive	2
Trent FP 100	Inactive	2
KSS/RA201/06/F1/001	Inactive	2
12/KSS/RWF03/CST/STR(L)029	Inactive	2
08/KSS/03/RPL04/01/F2/017	Inactive	2
KSS/RPR01/01/F2/001	Inactive	2
KSS/RVVKC/01/F1/004	Inactive	2
KSS/RA201/06/F2/001	Inactive	2
KSS/RXH01/02/F1/003	Inactive	2
KSS/RXH01/01/F2/015	Inactive	2
KSS/RXC02/02/F1/002	Inactive	2
KSS/RN707/01/F2/009	Inactive	2
13/KSS/RVV01/CMT/STR(L)/13	Inactive	2
Trent FP 032	Inactive	2
KSS/RA201/01/F2/001	Inactive	2
KSS/RA201/06/F1/003	Inactive	2
KSS/RTK01/02/F2/012	Inactive	2
KSS/RXC01/01/F1/002	Inactive	2
KSS/RPL04/01/F2/010	Inactive	2
KSS/RWF02/01/F2/014	Inactive	2
12/LDN/01/RJ121/01/F1/021	Inactive	2
KSS/RXH01/01/F2/006	Inactive	2
KSS/RXH01/01/F2/003	Inactive	2
KSS/RPA02/01/F2/008	Inactive	2
Trent FP 087	Inactive	2
12-13/KSS/RTK01/CMT/STR(L) 01	Inactive	2
08/KSS/RN707/01/F2/005	Inactive	2
KSS/RWF02/01/F2/006	Inactive	2
KSS/RWF03/02/F1/003	Inactive	2
KSS/RVV09/01/F1/010	Inactive	2
KSS/RPL04/01/F2/018	Inactive	2
Trent FP 003	Inactive	2
Trent FP 036	Inactive	2
KSS/RPR01/02/F1/012	Inactive	2
KSS/RDU01/02/F2/017	Inactive	2
KSS/RN707/01/F2/020	Inactive	2
KSS/RTP04/02/F1/005	Inactive	2
KSS/RVV09/01/F1/002	Inactive	2
KSS/RWF02/02/F1/005	Inactive	2
KSS/RVV01/01/F1/008	Inactive	2
KSS/RPR01/01/F1/007	Inactive	2
KSS/RXH01/02/F1/004	Inactive	2
KSS/RVVKC/01/F1/014	Inactive	2
KSS/RN707/01/F2/012	Inactive	2
KSS/RPR01/02/F1/014	Inactive	2
KSS/RVVKC/01/F1/010	Inactive	2
KSS/RXH09/02/F1/005	Inactive	2
KSS/RPL04/02/F1/001	Inactive	2
KSS/RPA02/02/F2/009	Inactive	2
Trent FP 088	Inactive	2
KSS/RTK01/02/F2/005	Inactive	2
KSS/RPL04/01/F1/024	Inactive	2
KSS/RPA02/01/F2/009	Inactive	2
KSS/RWF03/02/F1/007	Inactive	2
KSS/RTK01/02/F2/020	Inactive	2
Trent FP 068(Ac)	Inactive	2
Trent FP 070	Inactive	2
11/LDN/01/RYQ30/001/F2/009	Inactive	2
KSS/RXC01/01/F1/010	Inactive	2
KSS/RN707/01/F2/016	Inactive	2
KSS/RPL04/01/F1/022	Inactive	2
KSS/RPL04/01/F2/004	Inactive	2
KSS/RXH01/02/F2/020	Inactive	2
KSS/RPR01/02/F2/010	Inactive	2
KSS/RPL04/01/F2/017	Inactive	2
KSS/RTK01/01/F2/003	Inactive	2
KSS/RTK01/06/F2/004	Inactive	2
KSS/RA201/02/F1/005	Inactive	2
KSS/RXC01/01/F1/004	Inactive	2
KSS/RWF03/02/F1/005	Inactive	2
KSS/RTP04/06/F1/002	Inactive	2
KSS/RPA02/01/F2/011	Inactive	2
KSS/RVV01/02/F1/001	Inactive	2
KSS/RWF02/01/F2/010	Inactive	2
KSS/RPR01/02/F2/002	Inactive	2
KSS/RTK01/06/F2/001	Inactive	2
KSS/RWF02/01/F2/009	Inactive	2
KSS/RN707/01/F2/006	Inactive	2
08/KSS/03/RXC02/01/F1/013	Inactive	2
KSS/RPL04/01/F2/009	Inactive	2
KSS/RXH01/02/F1/008	Inactive	2
KSS/RPL04/01/F1/025	Inactive	2
KSS/RPR01/01/F2/002	Inactive	2
Trent FP 051	Inactive	2
08/KSS/RN707/01/F1/005	Inactive	2
KSS/RPR01/02/F2/003	Inactive	2
KSS/RWF02/01/F2/017	Inactive	2
Trent FP 052	Inactive	2
KSS/RA201/06/F2/004	Inactive	2
KSS/RPR01/02/F2/004	Inactive	2
KSS/RA201/06/F2/006	Inactive	2
KSS/RN707/01/F2/014	Inactive	2
KSS/RXH01/01/F1/020	Inactive	2
08/KSS/03/RXH01/02/F2/047	Inactive	2
KSS/RTK01/01/F2/006	Inactive	2
KSS/RXH01/01/F2/014	Inactive	2
KSS/RWF03/01/F1/006	Inactive	2
KSS/RVV01/01/F1/004	Inactive	2
08/KSS/RWF03/01/F1/003	Inactive	2
KSS/RVVKC/01/F1/012	Inactive	2
KSS/RA201/06/F1/012	Inactive	2
KSS/RWF02/01/F2/003	Inactive	2
KSS/RPA02/02/F2/008	Inactive	2
KSS/RTP04/06/F1/004	Inactive	2
KSS/RWF03/01/F1/005	Inactive	2
KSS/RXC01/05/F1/002	Inactive	2
KSS/RTK01/01/F2/008	Inactive	2
KSS/RXH01/02/F2/008	Inactive	2
08/KSS/RVV09/01/F2/018	Inactive	2
KSS/RXH01/02/F1/009	Inactive	2
11/KSS/RYR18/CST/STR(L)/004	Inactive	2
KSS/RXC01/01/F1/006	Inactive	2
KSS/RN707/01/F2/015	Inactive	2
KSS/RPA02/01/F2/003	Inactive	2
KSS/RXC01/05/F1/003	Inactive	2
KSS/RXH01/02/F1/013	Inactive	2
KSS/RXC01/01/F1/007	Inactive	2
KSS/RTK02/01/F1/004	Inactive	2
07/KSS/RVVKC/01/ST1/003	Inactive	2
KSS/RTP04/02/F1/011	Inactive	2
KSS/RWF02/01/F1/021	Inactive	2
KSS/RXH01/01/F2/019	Inactive	2
Trent FP 086	Inactive	2
KSS/RXH01/02/F2/011	Inactive	2
KSS/RPA02/02/F1/010	Inactive	2
Trent FP 028	Inactive	2
08/KSS/RWF03/01/F2/020	Inactive	2
Trent FP 030	Inactive	2
KSS/RXC02/02/F1/001	Inactive	2
KSS/RN707/01/F2/005	Inactive	2
Trent FP 103	Inactive	2
KSS/RPR01/01/F1/008	Inactive	2
08/KSS/03/RTP04/02/F2/003	Inactive	2
08/KSS/03/RXH01/01/F1/028	Inactive	2
07/KSS/RVV09/01/F2/008	Inactive	2
KSS/RDU01/55/F2/002	Inactive	2
KSS/RPA02/01/F2/002	Inactive	2
KSS/RTP04/02/F1/008	Inactive	2
KSS/RA201/06/F1/002	Inactive	2
Trent FP 017	Inactive	2
KSS/RTK01/01/F2/005	Inactive	2
KSS/RPA02/01/F2/014	Inactive	2
KSS/RTK01/06/F2/003	Inactive	2
Trent FP 018	Inactive	2
08/KSS/03/RXH01/01/F1/004	Inactive	2
KSS/RDU01/02/F2/009	Inactive	2
KSS/RWF02/01/F2/002	Inactive	2
KSS/RVVKC/01/F1/015	Inactive	2
KSS/RWF02/01/F2/018	Inactive	2
KSS/RPA02/01/F2/015	Inactive	2
KSS/RWF02/01/F1/020	Inactive	2
KSS/RDU01/02/F2/007	Inactive	2
KSS/RA201/02/F2/005	Inactive	2
KSS/RXH01/02/F2/002	Inactive	2
KSS/RVV01/01/F1/005	Inactive	2
Trent FP 060	Inactive	2
KSS/RWF02/02/F1/001	Inactive	2
KSS/RTK01/01/F1/003	Inactive	2
08/KSS/03/RPL04/01/F2/022	Inactive	2
Trent FP 016	Inactive	2
KSS/RTP04/01/F1/004	Inactive	2
KSS/RVV01/02/F1/004	Inactive	2
KSS/RN707/01/F2/010	Inactive	2
KSS/RWF03/01/F1/001	Inactive	2
KSS/RWF03/02/F1/001	Inactive	2
KSS/RA201/02/F2/001	Inactive	2
Trent FP 006	Inactive	2
KSS/RA201/01/F1/002	Inactive	2
KSS/RN707/01/F2/004	Inactive	2
KSS/RPR01/01/F2/003	Inactive	2

...

Code Block

	sql
	sql

select lo.LocalOfficeName, p.*
from [HEELIVE].[vwProgramme] as p
join [HEELIVE].[vwLocalOffice] as lo on (lo.ItemType = 'Programme' and lo.UniqueID = p.ProgrammeID)
where ProgrammeNumber in (select ProgrammeNumber
						  from [HEELIVE].[vwProgramme] as p
						  where status = 'Current'
						  group by ProgrammeNumber, status
						  having count(*) > 1)
order by ProgrammeNumber

Details on the 49 duplicated Current Programmes Numbers;

LocalOfficeName	RecordOrigin	Status	ManagingDeanery	ProgrammeName	ProgrammeNumber	ProgrammeID	LeadProviderTrustID	LeadProviderName	LeadProviderKnownAs	LeadProviderTrustNumber	ProgrammeDirectors
HENE	HEELIVE	Current	Health Education England North East	Prosthodontics	DENT069	22239171	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England North East	Restorative Dentistry	DENT069	29846014	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Lincoln	EMD669	17489114	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Nottingham	EMD669	22589849	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Boston	EMD669	7305783	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP LNR	EMD669	5192400	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Chesterfield	EMD669	4628839	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Derby	EMD669	1568996	NULL	NULL	NULL	NULL	NULL
HEEM	HEELIVE	Current	Health Education England East Midlands	GP Sherwood Forest	EMD669	23604302	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England Kent, Surrey and Sussex	Dental Foundation Training South KSS	KSSDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England Kent, Surrey and Sussex	Dental Foundation Training East KSS	KSSDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England Kent, Surrey and Sussex	Dental Foundation Training Central KSS	KSSDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England Kent, Surrey and Sussex	Dental Foundation Training Coastal KSS	KSSDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England Kent, Surrey and Sussex	Dental Foundation Training West KSS	KSSDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Child and Adolescent Psychiatry North LDN	LON154	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Child and Adolescent Psychiatry South LDN	LON154	1.31E+08	1.29E+08	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	RV5	NULL
HELASE	HEELIVE	Inactive	London LETBs	Child and Adolescent Psychiatry - Legacy	LON154	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Core Psychiatry Training North East LDN	LON156	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Psychiatry Training South West LDN	LON156	1.31E+08	1.29E+08	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	RQY	NULL
HELASE	HEELIVE	Inactive	London LETBs	Core Psychiatry Training - Legacy	LON156	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Core Psychiatry Training North West LDN	LON156	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Psychiatry Training South East LDN	LON156	1.31E+08	1.29E+08	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	RV5	NULL
HELASE	HEELIVE	Current	Health Education England South London	Psychiatry of Learning Disability South LDN	LON162	1.31E+08	1.29E+08	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	RV5	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Psychiatry of Learning Disability North LDN	LON162	1.31E+08	33035923	Central and North West London NHS Foundation Trust	Central and North West London NHS Foundation Trust	RV3	NULL
HELASE	HEELIVE	Inactive	London LETBs	Psychiatry of Learning Disability - Legacy	LON162	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Forensic Psychiatry North West LDN	LON165	1.31E+08	33035923	Central and North West London NHS Foundation Trust	Central and North West London NHS Foundation Trust	RV3	NULL
HELASE	HEELIVE	Inactive	London LETBs	Forensic Psychiatry - Legacy	LON165	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Forensic Psychiatry South LDN	LON165	1.31E+08	1.29E+08	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	RV5	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Forensic Psychiatry North East LDN	LON165	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Medical Psychotherapy North East LDN	LON170	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Medical Psychotherapy South LDN	LON170	1.31E+08	1.29E+08	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	RQY	NULL
HELASE	HEELIVE	Inactive	London LETBs	Medical Psychotherapy - Legacy	LON170	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Medical Psychotherapy North West LDN	LON170	1.31E+08	33035923	Central and North West London NHS Foundation Trust	Central and North West London NHS Foundation Trust	RV3	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Anaesthetics Higher North West LDN	LON176	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Anaesthetics Higher South East LDN	LON176	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England South London	Anaesthetics Higher South West LDN	LON176	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Anaesthetics Higher North East & Central LDN	LON176	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Anaesthetics Higher - Legacy	LON176	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Ophthalmology - Legacy	LON177	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Ophthalmology South LDN	LON177	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Ophthalmology North LDN	LON177	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Haematology North West LDN	LON178	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Haematology South LDN	LON178	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Inactive	London LETBs	Haematology - Legacy	LON178	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Haematology North East LDN	LON178	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Endocrinology and Diabetes Mellitus North East LDN	LON182	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Endocrinology and Diabetes Mellitus North West LDN	LON182	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Endocrinology and Diabetes Mellitus - Legacy	LON182	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Endocrinology and Diabetes Mellitus South LDN	LON182	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England South London	Clinical Radiology South East LDN	LON183	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Clinical Radiology North East LDN	LON183	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Clinical Radiology North West LDN	LON183	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Clinical Radiology - Legacy	LON183	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Clinical Radiology South West LDN	LON183	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Inactive	London LETBs	Chemical Pathology - Legacy	LON193	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Chemical Pathology South LDN	LON193	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Chemical Pathology North West LDN	LON193	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Chemical Pathology North East LDN	LON193	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Acute Internal Medicine North East LDN	LON2009	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Acute Internal Medicine North West LDN	LON2009	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Acute Internal Medicine - Legacy	LON2009	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Acute Internal Medicine South LDN	LON2009	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Paediatrics ST1-5 North West LDN	LON202	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Paediatrics ST1-5 South LDN	LON202	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Paediatrics ST6-8 Pan LDN	LON202	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Paediatrics ST1-5 North East LDN	LON202	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Paediatrics - Legacy	LON202	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Paediatrics ST1-5 North LDN - Historic	LON202	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Trauma and Orthopaedic Surgery North East LDN	LON204	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Trauma and Orthopaedic Surgery South East LDN	LON204	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Trauma and Orthopaedic Surgery North West LDN	LON204	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Trauma and Orthopaedic Surgery South West LDN	LON204	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Inactive	London LETBs	Trauma & Orthopaedics - Legacy	LON204	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Cardiology South LDN	LON208	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Cardiology - Legacy	LON208	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Cardiology North East LDN	LON208	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Cardiology North West LDN	LON208	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Urology South LDN	LON209	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Urology North LDN	LON209	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Urology - Legacy	LON209	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Core Medical Training North West LDN	LON211	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Core Medical Training North East & Central LDN	LON211	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Core Medical Training - Legacy	LON211	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Medical Training South West LDN	LON211	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Medical Training South East LDN	LON211	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Renal Medicine South LDN	LON213	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Renal Medicine North West LDN	LON213	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Renal Medicine North East LDN	LON213	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	London LETBs	Renal Medicine North LDN - Historic	LON213	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Renal Medicine - Legacy	LON213	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Palliative Medicine North West & South LDN	LON214	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Palliative Medicine - Legacy	LON214	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Palliative Medicine North East LDN	LON214	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Neurosurgery North LDN	LON215	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Neurosurgery South LDN	LON215	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Neurosurgery - Legacy	LON215	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Gastro-enterology South LDN	LON220	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Inactive	London LETBs	Gastro-enterology - Legacy	LON220	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Gastro-enterology North East LDN	LON220	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Gastro-enterology North West LDN	LON220	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Dermatology North LDN	LON222	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Dermatology South LDN	LON222	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Dermatology - Legacy	LON222	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Genito-Urinary Medicine North East LDN	LON223	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Genito-Urinary Medicine North West LDN	LON223	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Genito-Urinary Medicine - Legacy	LON223	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Genito-Urinary Medicine South LDN	LON223	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England South London	Respiratory Medicine South LDN	LON224	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Inactive	London LETBs	Respiratory Medicine - Legacy	LON224	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Respiratory Medicine North West LDN	LON224	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Respiratory Medicine North East LDN	LON224	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Rheumatology South LDN	LON227	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Rheumatology - Legacy	LON227	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Rheumatology North West LDN	LON227	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Rheumatology North East LDN	LON227	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Obstetrics and Gynaecology South LDN	LON230	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Obstetrics and Gynaecology North East LDN	LON230	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Obstetrics and Gynaecology North West LDN	LON230	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Obstetrics and Gynaecology - Legacy	LON230	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Surgical Training South LDN	LON234	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Core Surgical Training North East LDN	LON234	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Core Surgical Training - Legacy	LON234	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Core Surgical Training North West LDN	LON234	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Geriatric Medicine South East LDN	LON235	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Geriatric Medicine North West LDN	LON235	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Geriatric Medicine North East LDN	LON235	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Geriatric Medicine - Legacy	LON235	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Geriatric Medicine South West LDN	LON235	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Surgery South East LDN	LON239	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Surgery South West LDN	LON239	1.31E+08	1.29E+08	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	ST GEORGE'S UNIVERSITY HOSPITALS NHS FOUNDATION TRUST	RJ7	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Surgery North West LDN	LON239	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	General Surgery - Legacy	LON239	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Surgery North East LDN	LON239	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Otolaryngology North LDN	LON242	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Otolaryngology South LDN	LON242	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Inactive	London LETBs	Otolaryngology - Legacy	LON242	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Clinical Neurophysiology - Legacy	LON252	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Clinical Neurophysiology North LDN	LON252	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Clinical Neurophysiology South LDN	LON252	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Clinical Oncology - Legacy	LON253	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Clinical Oncology North West & South LDN	LON253	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Clinical Oncology North East LDN	LON253	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Neurology South LDN	LON273	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Neurology North LDN	LON273	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Neurology - Legacy	LON273	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Medical Oncology North West & South LDN	LON276	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Medical Oncology North East LDN	LON276	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Medical Oncology - Legacy	LON276	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Public Health Medicine North LDN	LON287	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Public Health - Legacy	LON287	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Public Health Medicine South East LDN	LON287	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Public Health Medicine South West LDN	LON287	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Foundation North Central LDN	LON3026	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Foundation North West LDN	LON3026	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Foundation - Legacy	LON3026	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Foundation North East LDN	LON3026	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Histopathology North East LDN	LON508	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England South London	Histopathology ST1 Pan LDN	LON508	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Inactive	London LETBs	Histopathology - Legacy	LON508	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Histopathology North West LDN	LON508	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Histopathology South LDN	LON508	1.31E+08	33035919	Guy's and St Thomas' NHS Foundation Trust	Guy's and St Thomas' NHS Foundation Trust	RJ1	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Whipps Cross LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - St Georges LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Imperial LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Hackney LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Guys & St. Thomas' LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Northwick Park LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Central Middlesex LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Romford LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Whittington LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Barnet LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Tower Hamlets LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Royal Free LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Ealing LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Greenwich LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - St Helier LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Riverside LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Enfield & Haringey LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Ilford LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Bexley & Sidcup LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - UCLH LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Croydon LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - St Mary's LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Kingston & Roehampton LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Bromley LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Practice - Newham LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - West Middlesex LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Lewisham LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Practice - Hillingdon LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Practice - Kings LDN	LON557	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	General Psychiatry & Old Age Psychiatry - Legacy	LON910	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Psychiatry & Old Age Psychiatry South West LDN	LON910	1.31E+08	1.29E+08	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	SOUTH WEST LONDON AND ST GEORGE'S MENTAL HEALTH NHS TRUST	RQY	NULL
HELASE	HEELIVE	Current	Health Education England South London	General Psychiatry & Old Age Psychiatry South East LDN	LON910	1.31E+08	1.29E+08	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST	RV5	NULL
HELASE	HEELIVE	Current	Health Education England North West London	General Psychiatry & Old Age Psychiatry North West LDN	LON910	1.31E+08	33035923	Central and North West London NHS Foundation Trust	Central and North West London NHS Foundation Trust	RV3	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	General Psychiatry & Old Age Psychiatry North East LDN	LON910	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Anaesthetics Core - Legacy	LON922	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Core Anaesthetics Training North West LDN	LON922	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Current	Health Education England South London	Core Anaesthetics Training South LDN	LON922	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Core Anaesthetics Training North East & Central LDN	LON922	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Current	Health Education England North West London	Emergency Medicine North West LDN	LON927	1.31E+08	1.29E+08	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	IMPERIAL COLLEGE HEALTHCARE NHS TRUST	RYJ	NULL
HELASE	HEELIVE	Inactive	London LETBs	Emergency Medicine - Legacy	LON927	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	Health Education England South London	Emergency Medicine South LDN	LON927	1.31E+08	1.29E+08	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	KING'S COLLEGE HOSPITAL NHS FOUNDATION TRUST	RJZ	NULL
HELASE	HEELIVE	Current	Health Education England North Central and East London	Emergency Medicine North East LDN	LON927	1.31E+08	1.29E+08	UCL Partners	UCL Partners	UCLP	NULL
HELASE	HEELIVE	Inactive	London LETBs	Dental Core Training - Legacy	LONDCT	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Core Training South LDN	LONDCT	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Core Training North LDN	LONDCT	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Inactive	London LETBs	Dental Foundation Training - Legacy	LONDFT	1.31E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Foundation Training South East LDN	LONDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Foundation Training North Central LDN	LONDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Foundation Training South West LDN	LONDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Foundation Training North East LDN	LONDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HELASE	HEELIVE	Current	London LETBs	Dental Foundation Training North West LDN	LONDFT	2.69E+08	NULL	NULL	NULL	NULL	NULL
HENW	HEELIVE	Current	Health Education England North West	MER Public Health Medicine (Medical)	MER943	2.76E+08	NULL	NULL	NULL	NULL	NULL
HENW	HEELIVE	Current	Health Education England North West	MER Public Health Medicine (Associate)	MER943	2.76E+08	NULL	NULL	NULL	NULL	NULL
HENW	HEELIVE	Inactive	Health Education England North West	MER Public Health Medicine (Legacy)	MER943	8803096	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England North East	Acute Internal Medicine	NOR2137	5936324	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England North East	Acute Internal Medicine	NOR2137	8073940	NULL	NULL	NULL	NULL	NULL
HENE	HEELIVE	Current	Health Education England Yorkshire and the Humber	General Practice Northallerton	YAH710	13943505	NULL	NULL	NULL	NULL	NULL
HEYH	HEELIVE	Current	Health Education England Yorkshire and the Humber	General Practice Northallerton	YAH710	14053554	NULL	NULL	NULL	NULL	NULL

For Discussion

#

Alistair Pringle (Unlicensed)/Former user (Deleted)/Joanne Watson (Unlicensed)

#

Comment

Owner

1

Should the Programme Name and Number be unique ?

Programme Name is not unique. I'm not sure on whether an agreement on naming convention has been agreed in consolidation but there will be many duplicate programmes.

Alistair Pringle (Unlicensed)/Former user (Deleted)/Joanne Watson (Unlicensed)

2

Should the Programme Number be unique ?

The programme number is unique. This number is assigned by the GMC to each local Programme when it gains first approval.

Versions Compared

Old Version 4

New Version 5

Key