The Integrated Sexual Health Tariff Data Set allows providers to deliver their clinical data to the Grouper service.

The table below specifics the acceptable criteria for each field.  Where ever possible, existing GUMCAD and SRHAD fields have been used.

Note about implementation of support for GUMCADv3 

Prerequisites/Assumptions

It assumed that data collection systems within a clinic use common Patient IDs across all reports (ie a patient will appear in a GUMCAD and SRHAD report with the same Patient ID code.

It is assumed that Patient IDs are not 'Patient Identifiable' by a third party (without access to a secured decode list).

It is required that GUMCAD and SRHAD reports are correctly formed and delivered in csv, xlsx or xls format

It is required that Excel baseline date used is 1900 and not 1904.

Submission Scope

Data should be submitted for each calendar month within six weeks of the month's end (later submissions are allowed for shadow and historical data collection).  Submissions are restricted to a particular provider organisation.  Each submission month can receive multiple files.

Data Fields

Providers should also ensure they include the appropriate activity data fields for SRHAD or GUMCAD when they upload their data to the Integrated Tariff Grouper.

GUMCAD: Some providers will have their GUMCAD data formated with space for twelve activity codes (SHHAPT fields) per row, others will have only one activity code per row, in which case the data needs to be transposed during the Grouper upload process.

Non-Standard Fields
There is one non-standard field not found in the SRHAD or GUMCAD that should be included:

  • Organisation ID (mandatory) this field is deprecated from Nov 15.
  •  GUMCAD (use this field if your clinic normally submits a full GUMCAD report) this field is deprecated from 1 Apr 15

Local Codes
There are a number of standard Local Codes offered to all Tariff Configurations (Local Configurations may adopt further locally agree codes):

  • SHHAPT = TS "Microscopy (gonorrhoea or syphilis), Microscopy was used indicating a symptomatic test, to be used with T2, T3 or T4."
  • SHHAPT = TT "3 Site Testing (chlamydia and gonorrhoea, with T1, T2, T3 or T4)."
  • SHHAPT = DT "Dual Site Test for T2, T3 or T4."
  • SHHAPT = AT "Assisted Self-Sample for STI tests. This code is to be used where an adequate sample, using an e-Services STI test kit, has been dispatched to pathology and a member of staff has directly (not remotely) supported the patient in taking the sample. This code is only to be used in connection with STI tests delivered through online e-Services."
  • SHHAPT = T20 "Shigella Test" 

Data Preparation
There is no need to consolidate data into a single file for a submission.  Multiple files can be uploaded to cover the month of submission, for example for different clinics or covering GUMCAD and SRHAD data.  There is no need to collate GUMCAD and SRHAD data into one file, the Grouper will automatically collate patient episode/visits.

Data should be saved in an MS Excel file with an .xsl or xlsx extension or a comma separated variable format with a .csv file name extension is acceptable (but not recommended).  File names should only contain one period ('.') and the file should contain one worksheet of data, the worksheet name must not contain punctuation.

Files should contain data in the first worksheet only, the column headings should be in row one and start at cell A1 and run contiguously.  Data should start in row 2 and each record should be in the contiguous row to the previous record ie no row and no column gaps in cluding gaps in hidden columns.

Once data has been prepared it should be uploaded to the secure Grouper service, see How to Upload

Field Name Description NHS Data Dictionary Element Variable Length Mandatory Validation List
Organisation ID Organisation Code of the provider service - no longer required from Nov 15' ORGANISATION CODE AN(6)   Organisations
[GUMCAD] Depricated from 1 Apr 15 - If this clinic uses full GUMCAD (Level 3) then insert '1'   N(1)   GUMCAD
Clinic ID Clinic ID Code SITE CODE (suggested) AN(15)
Icon Check Green
 
Patient ID Patient Identifier LOCAL PATIENT IDENTIFIER AN(12)
Icon Check Green
 
Gender Gender PERSON GENDER CURRENT AN(1)
Icon Check Green
Gender
Age Age attendance date in years AGE AT ATTENDANCE DATE N(3)
Icon Check Green
 
Ethnicity Patient's ethnic category ETHNIC CATEGORY CODE AN(2)
Icon Check Green
Ethnicity
Sexual Orientation Sexual orientation code of patient SEXUAL ORIENTATION CODE N(1)   Sexual Orientation
Country of Birth Patient's country of birth COUNTRY CODE (BIRTH) AN(3)    
[LA District of Residence] We recommend you do NOT use this now and allow the Grouper to use LSOA
Local Authority Disctrict of residence of the patient, GSS code of Local Authority
ORGANISATION CODE (LA DISTRICT OF RESIDENCE) AN(9)   Organisations
LSOA Lower Super Output Area (ONS location code eg E01029623) LOWER LAYER SUPER OUTPUT AREA (RESIDENCE) ANNNNNNNN  Icon Check Green  
[Local Contract Code]  This field is forlocal contract codes issued by Pathway Analytics   AN(5)     
[PCT of GP Registration] Depricated from 1 Apr 2015 - The PCT Code of the Patient's GP, this is the responsible commissioner ORGANISATION CODE (PCT OF REGISTRATION) AN(9)   Organisations
Date patient 1st contacted Often not collected, this is from the GUMAMM report . yyyy-mm-dd    
Date clinic 1st offered Often not collected, this is from the GUMAMM report .. yyyy-mm-dd    
First Attendance This indicates whether a patient is making a first or follow-up attendance. FIRST ATTENDANCE N(1)   First Attendance
SHHAPT 1 Perviously referred to as a 'KC60' code, SH and HIV episode code GENITOURINARY EPISODE TYPE  AN(5)   SHHAPT
SHHAPT 2   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 3   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 4   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 5   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 6   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 7   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 8   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 9   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 10   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 11   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
SHHAPT 12   GENITOURINARY EPISODE TYPE AN(5)   SHHAPT
Attendance Date Date of Attendance ATTENDANCE DATE yyyy-mm-dd
Icon Check Green
 
Activity Location Type Where the patient consulatation /treatment took place LOCATION TYPE CODE AN(3)   Location Type
Contraceptive Main Method Status Type of Contraception Consultation CONTRACEPTION METHOD STATUS N(1)   Contr. Main Method Status
Contraceptive Main Method Main method of contraception on the patient CONTRACEPTION PRINCIPAL METHOD AN(2)   Contraceptive Main Method
Contraceptive Other Method 1 Other method of contraception on the patient CONTRACEPTION OTHER METHOD 1 AN(2)   Contraceptive Main Method
Contraceptive Other Method 2 Other method of contraception on the patient CONTRACEPTION OTHER METHOD 2 AN(2)   Contraceptive Main Method
Contraception Method Post Coital 1 Emergency contraception method CONTRACEPTION  METHOD POST COITAL 1 N(1)   Contrac. Method Post Coital
Contraception Method Post Coital 2 Emergency contraception method CONTRACEPTION  METHOD POST COITAL 2 N(1)   Contrac. Method Post Coital
SRH Care Activity 1 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 1 AN(3)   SRH Care Activity
SRH Care Activity 2 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 2 AN(3)   SRH Care Activity
SRH Care Activity 3 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 3 AN(3)   SRH Care Activity
SRH Care Activity 4 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 4 AN(3)   SRH Care Activity
SRH Care Activity 5 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 5 AN(3)   SRH Care Activity
SRH Care Activity 6 Sexual & Reproductive Health Care Activity SRH CARE ACTIVITY 6 AN(3)   SRH Care Activity

You are not able to post comments until you have registered / logged in.