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.
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.
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.
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.
- 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
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"
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)||
|Patient ID||Patient Identifier||LOCAL PATIENT IDENTIFIER||AN(12)||
|Gender||Gender||PERSON GENDER CURRENT||AN(1)||
|Age||Age attendance date in years||AGE AT ATTENDANCE DATE||N(3)||
|Ethnicity||Patient's ethnic category||ETHNIC CATEGORY CODE||AN(2)||
|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|
|[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||
|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|