Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove TEDCANID from Bid and TEDCNID from Tender #15

Closed
georgiana-b opened this issue Apr 3, 2020 · 0 comments
Closed

Remove TEDCANID from Bid and TEDCNID from Tender #15

georgiana-b opened this issue Apr 3, 2020 · 0 comments

Comments

@georgiana-b
Copy link
Owner

Initially, we added the field xTEDCANID to Bid because we thought it would be helpful to keep the connection between the records in our DB and the original publication in TED.
We were extracting the TEDCANID from the array of publications, picking up the ID of the Contract Award Notice. However, it turns out some contracts have multiple corresponding Contract Award Notices and we have no way based on the data to understand which Contract Award Notice corresponds to which Bid.

Here is a good example where we have 4 different Contract Award Notices for the same lots:

["http://ted.europa.eu/udl?uri=TED:NOTICE:451835-2016:TEXT:EN:HTML", "http://ted.europa.eu/udl?uri=TED:NOTICE:066459-2017:TEXT:EN:HTML", "http://ted.europa.eu/udl?uri=TED:NOTICE:029190-2017:TEXT:EN:HTML", "http://ted.europa.eu/udl?uri=TED:NOTICE:451831-2016:TEXT:EN:HTML"]

Same thing happens for Tenders. According to the latest data, some tenders have multiple Contract Notices associated with them.
To continue with the example above, the parent tender has 3 Contract Notices in publications:

["http://ted.europa.eu/udl?uri=TED:NOTICE:210719-2016:TEXT:EN:HTML", "http://ted.europa.eu/udl?uri=TED:NOTICE:181988-2016:TEXT:EN:HTML", "http://ted.europa.eu/udl?uri=TED:NOTICE:210231-2016:TEXT:EN:HTML"]

Therefore we should remove both these fields since we don't tell the "full truth".
We will instead link to the tender records on OpenTender where users can see all the original TED publications.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant