Add table: Flagged bidders with information from the contracting process

[sabahfromlondon]

Table details:

• [ ] Title: Flagged bidders with information from the contracting process
• [ ] Description: A full list of flagged suppliers and bidders and the contracting process associated. Filter by ocid, Buyer Name, Supplier, Item Category or by the procurement method.

Filters:

• [ ] Ocid
• [ ] Buyer name
• [ ] Date range
• [ ] Procurement method
• [ ] Supplier/bidder

Columns:

Column Heading | Field Description | Requirements -- | -- | -- OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process | Each field should link to the specific contracting process, viewable in the Individual Contracting Process dashboard. Buyer | The name of the entity procuring the goods/services. The OCDS field buyerName. Alternatively use tender/procuringEntity. | Users can click on the buyer name to go to the Individual Buyers Dashboard. Users can filter for a specific buyer Date | The timestamp for the red flag using the OCDS field tender/startDate. | Users can filter the contracting processes by selecting a date range. Tender title | The title of the contract as per the OCDS field tender/title. | Each field should link to the specific contracting process, viewable in the Individual Contracting Process dashboard. Procurement method | Method used to procure goods/services from the closed method codelist. Methods are: ‘open’, ‘selective’, ‘limited’, ‘direct’. | Users can filter by method using a dropdown with the four options. Tender value | The value of the contract and the currency. OCDS fields tender/valueAmount and tender/valueCurrency. | Users can sort by value amount e.g. highest to lowest. Supplier/Bidder name | The name of the bidder. The OCDS field is parties/name. The field award/supplier/name may also be used. | Users can filter for a specific name using search and select. Role | The role of the party that was either a supplier or bidder from the party role codelist. The OCDS field is parties/roles. | Users can filter by role using a dropdown with the four options. Number of bidder red flags | The count of red flags for the bidder in that contracting process | Users can sort by value amount e.g. highest to lowest. Bidder red flag name | This indicates if the red flag is present. A column for each flag should be added | The column headings to have names for each flag

[Camilamila]

Instead of tender/title can we use the field tender/description?

[vgeryarbc]

Changed to tender/description.

[Camilamila]

The tender value in the table seems to be empty for all procedures, can we use the contract or award value column instead?

[vgeryarbc]

Tender values replaced with contract values. Is it OK ? (I see that Tender values exist for ~ 1/3 of contracting processes in 2023-2024.)

[Camilamila]

Change ocid filter to tender/id. If possible, can we remove the characters after the last '-'. For example:

If the tender/id is: 001-LICS-HGFO-2023-54538, the value shoulde be 001-LICS-HGFO-2023

In Spanish the translatation should be: Código del proceso

[vgeryarbc]

Changed