← Back to opportunities

Update the MuleSoft and Salesforce Solution to change the primary key for citizen contact creation from email to Niche occurance

The Police and Crime Commissioner for Humberside

Buyer Contact Info

Buyer Name: The Police and Crime Commissioner for Humberside

Buyer Address: The Lawns, Harland Way, Cottingham, UKE12, HU16 5SN, United Kingdom

Contact Email: abbie.lewis@humberside.police.uk

Status
complete
Procedure
Below threshold - unknown
Value
54500.0 GBP
Published
09 Oct 2025, 14:04
Deadline
n/a
Contract Start
03 Sep 2025, 23:00
Contract End
04 Sep 2025, 22:59
Category
n/a
CPV
72000000 - IT services: consulting, software development, Internet and support
Region
n/a
Awarded To
INFOMENTUM LIMITED
Official Source
Open Find a Tender

Description

Update the MuleSoft and Salesforce solution to change the primary key for citizen contact creation from email to Niche Occurrence. 1 The MuleSoft query to identify victim has a loophole that allows a Suspect classified as "16: VICTIM DECLINES/WITHDRAWS SUPPORT" to be classified as a Victim if they are added to the occurrence first and the Victim has not added a portal account. This results in the potential for Suspects to create accounts and see report case data for other citizens. 2 OICs using Niche may, during the lifecycle of the case, update the primary victim in a case. This results in the new victim being allowed to register for the portal and see details of the case on the portal. This means that two person accounts are associated with the case account. If the original victim had previous occurrences related to this account, these would be visible to the new primary victim. 3 Within the Force there is intermittent use of generic emails for nominal creation in Niche; this means that when the subsequent report case is created in Salesforce an account contact with a generic email address is created. Subsequent nominal creation using this generic email address means that the contact details will rotate across multiple users and become associated with multiple occurrences. There is also a small risk that the generic emails can be used to create a user account providing access to citizen data 4 Currently, in the iHub Data model, Victim's Email is a mandatory field for iHub, so for any victim that doesn't have an email, the request will not be accepted by iHub and the API will reject the request. Humberside requirements are to have email as an optional field and having the mobile number as mandatory. The following changes have been impact assessed to achieve the following: • Infomentum to pass a static dummy value in the email field to get through the iHub Data Model. • iHub has existing logic in the Process API transformation to handle the dummy email iHub needs to ensure account and contact records on the case are updated when passing data to Salesforce.

Linked Documents

No linked documents found for this notice.

Opportunity Context

Lots

Lot 1 Status: complete

Raw Notice JSON

Expand raw payload
{
  "awards": [
    {
      "id": "1",
      "items": [
        {
          "additionalClassifications": [
            {
              "description": "IT services: consulting, software development, Internet and support",
              "id": "72000000",
              "scheme": "CPV"
            }
          ],
          "deliveryAddresses": [
            {
              "country": "GB",
              "countryName": "United Kingdom",
              "region": "UKE1"
            }
          ],
          "id": "1",
          "relatedLot": "1"
        }
      ],
      "mainProcurementCategory": "services",
      "relatedLots": [
        "1"
      ],
      "status": "active",
      "suppliers": [
        {
          "id": "GB-COH-06306839",
          "name": "INFOMENTUM LIMITED"
        }
      ]
    }
  ],
  "buyer": {
    "id": "GB-PPON-PWLD-8931-TXBR",
    "name": "The Police and Crime Commissioner for Humberside"
  },
  "contracts": [
    {
      "aboveThreshold": false,
      "awardID": "1",
      "dateSigned": "2025-09-04T00:00:00+01:00",
      "documents": [
        {
          "datePublished": "2025-10-09T15:04:14+01:00",
          "description": "Contract details notice on Find a Tender",
          "documentType": "contractNotice",
          "format": "text/html",
          "id": "063803-2025",
          "noticeType": "UK7",
          "url": "https://www.find-tender.service.gov.uk/Notice/063803-2025"
        }
      ],
      "id": "1",
      "period": {
        "endDate": "2025-09-04T23:59:59+01:00",
        "startDate": "2025-09-04T00:00:00+01:00"
      },
      "status": "active",
      "value": {
        "amount": 54500.0,
        "amountGross": 65400,
        "currency": "GBP"
      }
    }
  ],
  "date": "2025-10-09T15:04:14+01:00",
  "id": "063803-2025",
  "initiationType": "tender",
  "language": "en",
  "ocid": "ocds-h6vhtk-05abcd",
  "parties": [
    {
      "address": {
        "country": "GB",
        "countryName": "United Kingdom",
        "locality": "Cottingham",
        "postalCode": "HU16 5SN",
        "region": "UKE12",
        "streetAddress": "The Lawns, Harland Way"
      },
      "contactPoint": {
        "email": "abbie.lewis@humberside.police.uk"
      },
      "details": {
        "classifications": [
          {
            "description": "Public authority - sub-central government",
            "id": "publicAuthoritySubCentralGovernment",
            "scheme": "UK_CA_TYPE"
          }
        ]
      },
      "id": "GB-PPON-PWLD-8931-TXBR",
      "identifier": {
        "id": "PWLD-8931-TXBR",
        "scheme": "GB-PPON"
      },
      "name": "The Police and Crime Commissioner for Humberside",
      "roles": [
        "buyer"
      ]
    },
    {
      "additionalIdentifiers": [
        {
          "id": "PGQV-7926-JWJT",
          "scheme": "GB-PPON"
        }
      ],
      "address": {
        "country": "GB",
        "countryName": "United Kingdom",
        "locality": "London",
        "postalCode": "EC4N 7HR",
        "region": "UKI31",
        "streetAddress": "68 King William Street"
      },
      "contactPoint": {
        "email": "vikram@infomentum.co.uk"
      },
      "details": {
        "scale": "sme",
        "url": "http://www.infomentum.com",
        "vcse": false
      },
      "id": "GB-COH-06306839",
      "identifier": {
        "id": "06306839",
        "scheme": "GB-COH"
      },
      "name": "INFOMENTUM LIMITED",
      "roles": [
        "supplier"
      ]
    }
  ],
  "tag": [
    "award",
    "contract"
  ],
  "tender": {
    "description": "Update the MuleSoft and Salesforce solution to change the primary key for citizen contact creation from email to Niche Occurrence.\n1 The MuleSoft query to identify victim has a loophole that allows a Suspect classified as \"16: VICTIM DECLINES/WITHDRAWS SUPPORT\" to be classified as a Victim if they are added to the occurrence first and the Victim has not added a portal account. This results in the potential \nfor Suspects to create accounts and see report case data for other citizens. \n2 OICs using Niche may, during the lifecycle of the case, update the primary victim in a case. This results in the new victim being allowed to register for the portal and see details of the case on the portal. This means that two person accounts are associated with the case account. If the original victim had previous occurrences related to this account, these would \nbe visible to the new primary victim.\n3 Within the Force there is intermittent use of generic emails for nominal creation in Niche; this means that when the subsequent report case is created in Salesforce an account contact with a generic email address is created. Subsequent nominal creation using this generic email \naddress means that the contact details will rotate across multiple users and become associated with multiple occurrences. There is also a small risk that the generic emails can be used to create a user account providing access to citizen data\n4 Currently, in the iHub Data model, Victim\u0027s Email is a mandatory field for iHub, so for any victim that doesn\u0027t have an email, the request will not be accepted by iHub and the API will \nreject the request. Humberside requirements are to have email as an optional field and having the mobile number as mandatory. The following changes have been impact assessed \nto achieve the following:\n\u2022 Infomentum to pass a static dummy value in the email field to get through the iHub Data \nModel.\n\u2022 iHub has existing logic in the Process API transformation to handle the dummy email\niHub needs to ensure account and contact records on the case are updated when passing data to \nSalesforce.",
    "id": "STA HP 1547",
    "legalBasis": {
      "id": "2023/54",
      "scheme": "UKPGA",
      "uri": "https://www.legislation.gov.uk/ukpga/2023/54/contents"
    },
    "lots": [
      {
        "id": "1",
        "status": "complete"
      }
    ],
    "procurementMethodDetails": "Below threshold - unknown",
    "status": "complete",
    "title": "Update the MuleSoft and Salesforce Solution to change the primary key for citizen contact creation from email to Niche occurance"
  }
}