General

PCTUR01

Data is to be provided where the Solution is hosted either via Public or Private Cloud, or in a Co located or Provider data centre

PCTUR02

Data can be provided where the Solution is locally hosted

GP-BI.2-02

Report will be provided on an annual basis

GP-BI.2-03

Report will cover the period from 00:00 on 1st August to 23:59 on 31st July of the following year

i.e. a report produced in August 2017 would cover the period from 1st August 2016 to 31st July 2017

GP-BI.2-04

Report will be provided by the end of September of the year in which the reporting period ends

i.e. a report for the period 1st August 2016 to 31st July 2017 will be submitted by the end of September 2017

Practices

GP-BI.2-06

Report to include aggregated data on code usage across all Practices in the Supplier estate

GP-BI.2-07

Report will only include aggregated data on code usage for Practices which went live with the Supplier System at least 2 months prior to the start of the reporting period

i.e. for a report for the period 1st August 2016 to 31st July 2017, the Supplier System will have gone live in the Practice prior to 1st June 2016

Patients

GP-BI.2-08a

Report to include aggregated data on code usage for Patients who were fully registered with a Practice as at the end of the reporting period 

GP-BI.2-08b

Report to include aggregated data on code usage for Patients who were fully registered with a Practice but died during the reporting period

GP-BI.2-09

Report will include codes entered during the reporting period via a different System e.g. where a Patient has moved to a new Practice and their record has been transferred via GP2GP

Codes

GP-BI.2-10

Report will only include coded data recorded during the reporting period

NB. this is to be determined by the System audit date

GP-BI.2-11

Report to exclude codes not normally used by or visible to users i.e. those inserted by the System (e.g. metadata codes to identify record component types)

GP-BI.2-12

Report to include all codes visible to the user as part of the Patient Record, including:

• codes entered directly by users into the System

• codes received via pathology laboratory links

• codes received from other feeder Systems

GP-BI.2-13 

Report to include all coded items newly entered within the reporting period, including where identical entries have been added prior to the reporting period

GP-BI.2-14

Where dual coding is in place, report will include the code from the primary coding scheme which was actually selected by the user 

Format

GP-BI.2-16

Suppliers will provide the Terminology Usage Report and the associated Metadata Report 

GP-BI.2-17

Reports will be provided in a TAB-delimited UTF8-MB3 text file (NOT comma separated, quote delimited or Excel spreadsheet).

GP-BI.2-18

The first row of the reports will contain the column names as specified in Primary Care Clinical Terminology Metadata Report GP-BI.2-21 and Primary Care Clinical Terminology Usage Report GP-BI.2-22

GP-BI.2-19

Report columns will always be submitted in the order as specified in Primary Care Clinical Terminology Metadata Report GP-BI.2-21 and Primary Care Clinical Terminology Usage Report GP-BI.2-22

GP-BI.2-20

Reports will be submitted via Secure Electronic File Transfer (SEFT)

GP-BI.2-21

The Metadata Report to be formatted as follows:

Column 1: PracticeCount. Number of Practices included in the report as per Primary Care Clinical Terminology Usage Report GP-BI.2-06 and Primary Care Clinical Terminology Usage Report GP-BI.2-07

Column 2: PatientCount. Number of Patients included in the report as per Primary Care Clinical Terminology Usage Report GP-BI.2-08a and Primary Care Clinical Terminology Usage Report GP-BI.2-22 

GP-BI.2-22

The Terminology Usage Report to be formatted as follows:

Column 1: CodeID.  5 character READ/CTV3 code, 18 digit SNOMED ConceptID or local code identifier that uniquely identifies the local OR national terminology concept e.g. N2450, XM1NJ, 18876004, EGTON460, Y7121

Column 2: TermID. 2 character READ termcode, 5 character CTV3 termcode, SNOMED DescriptionID or local term identifier for the actual description text selected by the user e.g. 12, YaYBJ, 31828016, 99

Column 3: TermDescription. Longest available preferred display term string encoded for by ConceptID+TermID e.g. 'Finger Pain', 'Vertigo', 'Herpetic Stomatitis'

Column 4: EPREntryCount. Aggregate count of the number of discrete new entries made using ConceptID+TermID across the selected Patients and Practices during the reporting period

 GP-BI.2-23

For the Terminology Usage Report, the following pseudo code to be used:

For all Patients fully registered with a Practice on <end date> AND those who were fully registered but died during the reporting period ("<start date>"-"<end date>") as per Primary Care Clinical Terminology Metadata Report GP-BI.2-21 and Primary Care Clinical Terminology Usage Report GP-BI.2-08b

ANALYSE

GROUPED_BY CodeID AND TermID AND TermDescription

FROM JOURNALS (ALL)

WHERE RECORD_DATE IN ("<start date>"-"<end date>") AND CODE IN ("%")

Where <start date> = 1st August <YYYY> and <end date> = 31st July <YYYY+1>

GP-BI.2-24

The actual query used for the Terminology Usage Report will NOT:

• Double count

• Sample different fragments of the same full coded Electronic Patient Record content

• Include codes attached to 'System' tables

Where the TermID does not exist or is not persisted, no data (an empty field) will be returned for the TermID column