New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Understand how Y03584's CCG was set #928

Closed
inglesp opened this Issue Jul 5, 2018 · 7 comments

Comments

Projects
None yet
3 participants
@inglesp
Copy link
Contributor

inglesp commented Jul 5, 2018

According to our Practice table, Y03584 (C/O THE LIMES MEDICAL CENTRE) is in 03W (NHS EAST LEICESTERSHIRE AND RUTLAND CCG).

In the prescribing dataset, it's been listed as being in Q59 since 2014_11. Q59 is in the PCT table with no name and "Unknown" org_type.

(Before that it was listed in 13A (LEICESTERSHIRE AND LINCOLNSHIRE COMMISSIONING HUB) which now closed, and 5PA (Leicestershire County and Rutland) which is not listed as closed but only has a couple of orphan practices.)

In the epraccur.csv data, it's always listed as being in Q78, which does not exist in the PCT table.

So where has 03W come from?

@inglesp

This comment has been minimized.

Copy link
Contributor

inglesp commented Jul 5, 2018

#321 looks relevant...

@sebbacon

This comment has been minimized.

Copy link
Contributor

sebbacon commented Jul 5, 2018

Not to my memory. I don't recall that issue ever having anything to do with CCG membership, nor can I see why it would do.

The relevance may just be that it's a "weird" practice.

So - I have no idea about 03W!

But don't we reimport epraccur every month? So whatever's changing it is doing it every month?

@inglesp

This comment has been minimized.

Copy link
Contributor

inglesp commented Jul 5, 2018

But don't we reimport epraccur every month? So whatever's changing it is doing it every month?

I wondered that, but no, since the CCG in epraccur is not in our database:

try:
    # Not all practices have a CCG - the ones that don't are mostly
    # in Jersey, Isle of Man, etc.
    pco_code = row[23].strip()
    ccg = PCT.objects.get(code=pco_code)
    practice.ccg = ccg
except PCT.DoesNotExist:
    if self.IS_VERBOSE:
        print 'ccg not found with code', pco_code

My best theory is that it was set by some prehistoric import from a different dataset.

@inglesp

This comment has been minimized.

Copy link
Contributor

inglesp commented Jul 5, 2018

Also: Q78 is another field value in the eccg.csv dataset, which might explain the problem.

$ grep 03W 2017_06/eccg.csv 
"03W","NHS EAST LEICESTERSHIRE AND RUTLAND CCG","Y55","Q78","BRIDGE PARK PLAZA","BRIDGE PARK ROAD","THURMASTON","LEICESTER","LEICESTERSHIRE","LE4 8BL","20130401","","","C","","","","","","","","0","","","","",""

Unfortunately eccg.csv doesn't have column headers.

@inglesp

This comment has been minimized.

Copy link
Contributor

inglesp commented Jul 5, 2018

Q78 is the "High Level Health Geography" according to the Organisation Data Service Standards Repository docs.

@inglesp

This comment has been minimized.

Copy link
Contributor

inglesp commented Jul 5, 2018

I will send NHS Digital a quick email, but I don't think there's anything else we need to worry about here.

@inglesp inglesp closed this Jul 5, 2018

@richiecroker

This comment has been minimized.

Copy link
Contributor

richiecroker commented Jul 5, 2018

It's not a "real" GP practice, it's a violent patients service. Little prescribing.
https://www.leicester.gov.uk/media/181923/homelessness-jspna.pdf

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment