Tariff Grouper‎ > ‎How to Upload‎ > ‎

Tariff Dataset

The Data Framework is a technical guide that describes how to compile the data file for uploading data to the Grouper. It shows the field name, the data format and length of each field. Mandatory fields are marked with a . Some fields are constrained by a Validation Group which lists all the possible correct values. Wherever possible, we have conformed to the GUMCAD and SRHAD behavioural and technical guidance.

AN: Alphanumeric
N: Numeric

The field length is shown in parenthesis or explicitly eg ANNNN one alphanumeric character followed by four digits such as 'A1234'.

Date formats are described in standard ISO 8601:2000 notation eg yyyy-mm-dd represents the format 2011-12-30. Please also read the guidance note on dates and file formats.

Field NameDescriptionNHS Data Dictionary ElementVariable Length
Mandatory
Validation Group
Organisation IDOrganisation Code of the serviceORGANISATION CODEAN(6)
Organisations
GUMCADThis Clinic uses GUMCAD (not GUMCAD2)N(1)
GUMCAD
Clinic IDClinic ID CodeSITE CODEAN(15)
Patient IDPatient IdentifierLOCAL PATIENT IDENTIFIERAN(12)
GenderGenderPERSON GENDER CURRENTN(1)
Gender
AgeAge attendance date in yearsAGE AT ATTENDANCE DATEN(3)
EthnicityPatient's ethnic categoryETHNIC CATEGORYAN(2)
Ethnicity
Sexual OrientationN(1)
Sexual Orientation
Country of BirthAN(3)
PCT of ResidencePCT of residence of the patientORGANISATION CODE (PCT OF RESIDENCE)AN(3)
Organisations
LSOALOWER LAYER SUPER OUTPUT AREA (RESIDENCE)ANNNNNNNN
PCT of GP RegistrationORGANISATION CODE (PCT OF REGISTRATION)AN(3)
Organisations
Date patient 1st contactedyyyy-mm-dd
Date clinic 1st offeredyyyy-mm-dd
New GUM episodeFIRST ATTENDANCEN(1)
New Gum Episode
SHHAPT 1GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 2GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 3GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 4GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 5GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 6GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 7GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 8GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 9GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 10GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 11GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
SHHAPT 12GENITOURINARY EPISODE TYPEAN(5)
SHHAPT
Attendance DateDate of AttendanceATTENDANCE DATEyyyy-mm-dd
Location TypeWhere the patient consulatation /treatment took placeLOCATION TYPE CODEAN(3)
Location Type
Contraceptive Main Method StatusType of Contraception ConsultationCONTRACEPTION METHOD STATUSN(1)
Contr. Main Method Status
Contraceptive Main MethodMain method of contraception on the patientCONTRACEPTION PRINCIPAL METHODAN(2)
Contraceptive Main Method
Contraceptive Other Method 1Other method of contraception on the patientCONTRACEPTION OTHER METHOD 1AN(2)
Contraceptive Main Method
Contraceptive Other Method 2Other method of contraception on the patientCONTRACEPTION OTHER METHOD 2AN(2)
Contraceptive Main Method
Contraception Method Post Coital 1Emergency contraception methodCONTRACEPTION  METHOD POST COITAL 1N(1)
Contrac. Method Post Coital
Contraception Method Post Coital 2Emergency contraception methodCONTRACEPTION  METHOD POST COITAL 2N(1)
Contrac. Method Post Coital
SRH Care Activity 1Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 1AN(3)
SRH Care Activity
SRH Care Activity 2Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 2AN(3)
SRH Care Activity
SRH Care Activity 3Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 3AN(3)
SRH Care Activity
SRH Care Activity 4Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 4AN(3)
SRH Care Activity
SRH Care Activity 5Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 5AN(3)
SRH Care Activity
SRH Care Activity 6Sexual & Reproductive Health Care ActivitySRH CARE ACTIVITY 6AN(3)
SRH Care Activity
Comments