{
    "tag": [
        "compiled"
    ],
    "id": "ocds-r6ebe6-0000683727-2022-03-23T00:00:00Z",
    "date": "2022-03-23T00:00:00Z",
    "ocid": "ocds-r6ebe6-0000683727",
    "initiationType": "tender",
    "parties": [
        {
            "id": "org-83",
            "name": "NHS Education for Scotland",
            "identifier": {
                "legalName": "NHS Education for Scotland"
            },
            "address": {
                "streetAddress": "2nd Floor, Westport, 102 Westport",
                "locality": "EDINBURGH",
                "region": "UKM75",
                "postalCode": "EH3 9DN"
            },
            "contactPoint": {
                "email": "tenders@nes.scot.nhs.uk",
                "telephone": "+44 1316563200",
                "url": "http://www.publictendersscotland.publiccontractsscotland.gov.uk"
            },
            "roles": [
                "buyer",
                "centralPurchasingBody"
            ],
            "details": {
                "classifications": [
                    {
                        "id": "Body governed by public law",
                        "scheme": "TED_CA_TYPE"
                    },
                    {
                        "id": "07",
                        "description": "Health",
                        "scheme": "COFOG"
                    }
                ],
                "url": "http://www.nes.scot.nhs.uk"
            }
        },
        {
            "id": "org-31",
            "name": "Edinburgh Sheriff Court",
            "identifier": {
                "legalName": "Edinburgh Sheriff Court"
            },
            "address": {
                "streetAddress": "27 Chambers Street",
                "locality": "Edinburgh"
            },
            "contactPoint": {
                "url": "http://"
            },
            "roles": [
                "reviewBody"
            ]
        },
        {
            "id": "org-6",
            "name": "NHS Education for Scotland",
            "identifier": {
                "legalName": "NHS Education for Scotland"
            },
            "address": {
                "streetAddress": "2nd Floor, Westport, 102 Westport",
                "locality": "EDINBURGH",
                "region": "UKM75",
                "postalCode": "EH3 9DN"
            },
            "contactPoint": {
                "email": "tenders@nes.scot.nhs.uk",
                "telephone": "+44 1316563200",
                "url": "http://"
            },
            "roles": [
                "buyer"
            ],
            "details": {
                "classifications": [
                    {
                        "id": "Body governed by public law",
                        "scheme": "TED_CA_TYPE"
                    },
                    {
                        "id": "07",
                        "description": "Health",
                        "scheme": "COFOG"
                    }
                ],
                "url": "http://www.nes.scot.nhs.uk"
            }
        },
        {
            "id": "org-199",
            "name": "Numbertelling ltd",
            "identifier": {
                "legalName": "Numbertelling ltd"
            },
            "address": {
                "streetAddress": "Codebase, Argyle House, 3 Lady Lawson Street",
                "locality": "Edinburgh",
                "region": "UKM75",
                "postalCode": "EH3 9DR"
            },
            "contactPoint": {
                "telephone": "+44 7707699565"
            },
            "roles": [
                "supplier"
            ],
            "details": {
                "scale": "sme",
                "url": "http://"
            }
        },
        {
            "id": "org-5",
            "name": "Edinburgh Sheriff Court",
            "identifier": {
                "legalName": "Edinburgh Sheriff Court"
            },
            "address": {
                "streetAddress": "Sheriff Court House, 27 Chambers Street",
                "locality": "Edinburgh",
                "postalCode": "EH1 1LB"
            },
            "contactPoint": {
                "url": "http://"
            },
            "roles": [
                "reviewBody",
                "mediationBody",
                "reviewContactPoint"
            ]
        }
    ],
    "buyer": {
        "name": "NHS Education for Scotland",
        "id": "org-6"
    },
    "tender": {
        "id": "C001940",
        "title": "C001940 - NES People Data Platform Data Services Support",
        "description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
        "status": "complete",
        "items": [
            {
                "id": "1",
                "additionalClassifications": [
                    {
                        "id": "72222300",
                        "scheme": "CPV"
                    }
                ],
                "deliveryAddresses": [
                    {
                        "region": "UKM"
                    },
                    {
                        "region": "UKM"
                    }
                ],
                "relatedLot": "1"
            }
        ],
        "procurementMethod": "open",
        "procurementMethodDetails": "Open procedure",
        "mainProcurementCategory": "services",
        "submissionMethod": [
            "electronicSubmission"
        ],
        "submissionMethodDetails": "http://www.publictendersscotland.publiccontractsscotland.gov.uk",
        "tenderPeriod": {
            "endDate": "2022-03-09T13:00:00Z"
        },
        "awardPeriod": {
            "startDate": "2022-03-09T13:00:00Z"
        },
        "documents": [
            {
                "id": "FEB441017",
                "documentType": "contractNotice",
                "title": "C001940 - NES People Data Platform Data Services Support",
                "description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
                "url": "https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=FEB441017",
                "format": "text/html"
            },
            {
                "id": "economic",
                "documentType": "economicSelectionCriteria"
            },
            {
                "id": "technical",
                "documentType": "technicalSelectionCriteria"
            },
            {
                "id": "MAR444179",
                "documentType": "awardNotice",
                "title": "C001940 - NES People Data Platform Data Services Support",
                "description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.",
                "url": "https://www.publiccontractsscotland.gov.uk/search/show/search_view.aspx?ID=MAR444179",
                "format": "text/html"
            }
        ],
        "lots": [
            {
                "id": "1",
                "description": "NHS Education for Scotland (NES) is looking to redesign and review its current Workforce dashboards, associated data pipeline and infrastructure. The review and redesign process aims to provide relevant, up to date Workforce data to end-users. The priority is to review and automate current ETL (Extract, Transform, Load) processes for all the dataflows within the People Data Platform and provide dashboards with low-level security to view data at organisational, departmental and supervisor levels. This project will concentrate on incorporating and a full review of the current ETL process and dashboards, assessing key indicators, and redesigning the Workforce dashboards provided through Microsoft Power BI.. The value of the initial contract period is 39,000 GBP. Should the options to extend (2 x 12 months) be taken then the maximum value over the 3years would not exceed 109,000GBP.",
                "status": "complete",
                "hasOptions": false,
                "submissionTerms": {
                    "variantPolicy": "notAllowed"
                },
                "contractPeriod": {
                    "startDate": "2022-03-21T00:00:00Z",
                    "endDate": "2023-03-31T00:00:00Z"
                },
                "hasRenewal": true,
                "renewal": {
                    "description": "NES propose to award the contract for the period from March 2022 to 31st March 2023 with the option to extend by 2 x 12 months, subject to identification of further priorities and associated budget."
                }
            }
        ],
        "bidOpening": {
            "date": "2022-03-09T13:00:00Z"
        },
        "coveredBy": [
            "GPA"
        ],
        "submissionTerms": {
            "languages": [
                "en"
            ]
        },
        "classification": {
            "id": "72222300",
            "scheme": "CPV"
        },
        "hasRecurrence": false
    },
    "language": "EN",
    "description": "(SC Ref:687669)",
    "links": [
        {
            "rel": "canonical",
            "href": "https://api.publiccontractsscotland.gov.uk/v1/Notice?id=ocds-r6ebe6-0000683727"
        },
        {
            "rel": "canonical",
            "href": "https://api.publiccontractsscotland.gov.uk/v1/Notice?id=ocds-r6ebe6-0000683727"
        }
    ],
    "noticetype": "PCS Notice - Website Contract Award Notice",
    "awards": [
        {
            "id": "C001940",
            "suppliers": [
                {
                    "id": "org-199",
                    "name": "Numbertelling ltd"
                }
            ],
            "relatedLots": [
                "1"
            ]
        }
    ],
    "contracts": [
        {
            "id": "C001940",
            "awardID": "C001940",
            "status": "active",
            "value": {
                "amount": 109000,
                "currency": "GBP"
            },
            "dateSigned": "2022-03-21T00:00:00Z"
        }
    ],
    "bids": {
        "statistics": [
            {
                "id": "583",
                "measure": "bids",
                "value": 3,
                "relatedLot": "1"
            },
            {
                "id": "584",
                "measure": "smeBids",
                "value": 3,
                "relatedLot": "1"
            },
            {
                "id": "585",
                "measure": "foreignBidsFromEU",
                "value": 0,
                "relatedLot": "1"
            },
            {
                "id": "586",
                "measure": "foreignBidsFromNonEU",
                "value": 3,
                "relatedLot": "1"
            },
            {
                "id": "587",
                "measure": "electronicBids",
                "value": 3,
                "relatedLot": "1"
            }
        ]
    }
}