Additional Info

Field Value
Data last updated 16 October 2024
Metadata last updated 16 October 2024
Created 16 October 2024
Format text/csv
Licence OGL-UK-3.0

Data Dictionary

Column Title Type Description
REFERENCE_NUMBER Reference number string The unique reference number which NHSBSA has allocated to commercial activity noted on the pipeline for internal NHSBSA use (this will not be included in any advertised opportunities or contract notices)
CONTRACT_TITLE Contract title string The planned or published commercial activity name
SHORT_DESCRIPTION Short description string Brief description of the procurement
PROCUREMENT_PROCESS Procurement status string The stage best describing the project Draft - The need is being understood and the likely commercial requirements are not yet known. Pipeline - The need is understood and high level specification being developed. We can predict with some confidence indicative key dates for the project. Pre-Procurement - Intention to go to market in near future. Procurement - Procurement in progress.
COMMERCIAL_STRATEGY Commercial Strategy string The anticipated commercial strategy or approach for the commercial activity
PLANNED_PROCUREMENT_SOURCING_ROUTE Planned Procurement Sourcing Route string The planned/expected procurement vehicle being used to source the contract
ESTIMATED_CONTRACT_LENGTH Estimated contract length integer Estimated contract length expressed in months Blanks indicate that the estimated contract length is to be confirmed
VALUE_BAND Value Band string Estimated contract value band A - £10,000 or greater and less than £100,000 B - £100,000 or greated and less than £250,000 C - £250,000 or greater and less than £500,000 D - £500,000 or greater and less than £1,000,000 E - £1,000,000 or greater and less than £5,000,000 F - £5,000,000 or greater and less than £10,000,000 G - £10,000,000 or greater and less than £25,000,000 H - £25,000,000 or greater and less than £50,000,000 I - £50,000,000 or greater and less than £100,000,000 J - £100,000,000 or greater and less than £250,000,000 K - £250,000,000 or greater
ESTIMATED_COMMERCIAL_ACTIVITY_START_DATE Estimated commercial activity start date 'yyyy-mm-dd' date The date commercial activity is expected to commence (including pre-tender market engagement)
ESTIMATED_PROCUREMENT_START_DATE Estimated procurement start date 'yyyy-mm-dd' date The planned date of official commencement of the procurement e.g. release of tender or commencement of a further competition under a framework agreement
ESTIMATED_CONTRACT_COMMENCEMENT_DATE Estimated contract commencement date 'yyyy-mm-dd' date The date the new contract is expected to commence
PRIMARY_CPV_CATEGORY Primary CPV Category string Primary Common Procurement Vocabulary category relating to the commercial activity
PRIMARY_CPV_CODE Primary CPV Code integer 9 character Primary Common Procurement Vocabulary code relating to the commercial activity
EXISTING_CONTRACT_NAME Existing Contract Name string Name of the contract the commercial activity is replacing (where commercial strategy is re-procurement)
EXISTING_CONTRACT_END_DATE Existing Contract End Date 'yyyy-mm-dd' date The date the contract the commercial activity is replacing will end excluding unexercised extensions (where commercial strategy is re-procurement) Blanks indicate that there is no current contract in place.
MAXIMUM_CONTRACT_END_DATE Maximum Contract End Date 'yyyy-mm-dd' date The date the contract the commercial activity is replacing will end if all permitted extensions are exercised (where commercial strategy is re-procurement) Blanks indicate that there is no current contract in place.
EXISTING_CONTRACT_CF_AWARD_NOTICE Existing Contract CF Award Notice string Link to Contracts Finder award notice for contract the commercial activity is replacing (where commercial strategy is re-procurement and a CF award was published)