| Column |
Title |
Type |
Description |
| COUNTRY_NAME |
Country Name |
string |
The country name where the contract is located.
|
| REPORTING_YEAR |
Reporting Year |
date |
The financial year which the activity relate to. Year-end methodology will include all activity data (including amendments) collected from FP17s scheduled in any of the fifteen schedule months from April to June, where the date of completion is on or between 1 April and 31 March of the year. For example 2019-20 will include all activity data (including amendments) collected from FP17s scheduled in any of the fifteen schedule months from April 2019 to June 2020, where the date of completion is on or between 1 April 2019 and 31 March 2020. Where FP17s do not have a date of completion, e.g. where the patient has failed to return to complete the treatment, the date of acceptance is used.
|
| PERFORMER_NUMBER |
Performer Number |
integer |
This is a unique 6 character number which identifies a performer.
|
| PROVIDER_NUMBER |
Provider Number |
integer |
The provider number associated with the contact number i.e. the owner of the contract.
|
| PROVIDER_PERFORMER |
Provider Performer |
string |
This indicates if the Performer is a Provider Performer. Due to our not having a specific indicator this has been based based on the Performer number matching the Provider number.
|
| PERFORMER_START_DATE |
Performer Start Date |
integer |
The start date of the performer's (dentist) tenure on the contract
|
| PERFORMER_END_DATE |
Performer End Date |
integer |
The end date of the performer's (dentist) tenure on the contract
|
| NUMBER_OF_YEARS_AS_A_PERFORMER |
Number of Years as a Performer |
integer |
This if the number of years based on either current date minus the performers start date (Dentist Tenure) or End Date.
|
| CONTRACT_NUMBER |
Contract Number |
integer |
This is a unique 10 character number which identifies a contract.
|
| PPC_LOCATION_V_CODE |
V Code |
string |
V Code (ODS) based on Principle Practice and Correspondence (PPC) Location with the highest activity.
|
| PRINCIPAL_PRACTICE_ADDRESS_POSTCODE |
Principal Practice Address Postcode |
string |
This is postcode of the main address used for correspondence between the NHSBSA and the dental contract, it is not necessarily the address where treatment takes place.
|
| UDA |
UDA Delivered |
integer |
The units of dental activity scheduled for the time period selected relating to the financial year, where they were carried out by any performer.
|
| TOTAL_FP17S |
Total FP17s |
integer |
This is a count of the number of FP17s scheduled including adjustments for amended and deleted FP17s. Withdrawn FP17s are not included in the total count of FP17s. This figure may be zero or negative if deleted FP17s have been processed.
|
| FD_TENURE |
FD Tenure |
string |
This indicates if the Performer is a Foundation Dentist.
|