Public procurement migration

600 official public records moving through validation, review and controlled release.

Verified this session11:34 UTC · analyst review required

3 selected exception cases remain before release assessment.

Reconciliation passed. Quality warnings remain traceable and require documented analyst disposition.

Records read0

300 notices · 300 awards

Loaded0

No rejected source records

Quality signals0

47 duplicates · 113 linkage

Selected reviews complete0

0 of 3 · prototype adjudication scope

Regions represented0

Africa · regional operations

Record coverage by country

Countries represented in the evidence index for this migration run. Stronger color indicates more records; Madagascar carries an open review case.

Indexed evidence Open exception
No matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched recordsNo matched records
Verified record flow

Every record remains accounted for

600 source records · 160 signals · 3 selected decisions

Source snapshot600300 notices · 300 awards
Quality gate160Signals preserved for review
Human review3Selected cases still open
Curated layer600Release held until ready

Source and target counts agree

Passed
Source snapshot600records
Standardized600records
Curated600records
  • ✓Primary keys remain unique
  • ✓Required identifiers normalized
  • ✓Source payloads and checksums retained

Quality controls requiring attention

Reproducibility and lineage

Run ID
79f796ab-c3dd-4922-9d8a-3337803c106f
Raw checksum
SHA-256 verified
Schema fingerprint
267cc6ae…e40fc9d3
Pipeline version
0.1.0
Execution
13 seconds · completed

Migration acceptance evidence

The evidence package ties the release recommendation to this exact run, its controls and its recorded analyst decisions.

Conditional
Read600Official source records
Loaded600Accepted into the curated layer
Quarantined0Held with record-level evidence
Rejected0Technical transformation failures
Passed
REC-001Record accounting balances

600 read = 600 loaded + 0 quarantined + 0 rejected

Passed
QUA-001Excluded records are traceable

No records entered quarantine or technical rejection

Passed
MAP-001Mapping contracts are pinned

Notice 1.1.0 and award 1.0.0 retained with the run

Pending
REV-001Selected analyst decisions are complete

0 of 3 selected exception cases decided

Balance delta 0Evidence fingerprint SHA-256 verified

Source-to-target mapping

Approved field handling applied to procurement notices in this run.

Active · country codes standardized before loadingContract fingerprint 3bfe54a2…ff6b502c
Sourceid
Convert to text
Targetnotice_id
Required
Sourceproject_id
Validate and standardize
Targetproject_id
Required
Sourcebid_description
Trim surrounding space
Targettitle
Required
Sourcecountry_name
Trim surrounding space
Targetcountry
Optional
Sourcecountry_code
Convert to uppercase
Targetcountry_code
Optional
Sourcepublication_date
Standardize as YYYY-MM-DD
Targetpublication_date
Optional
Sourcedeadline_date
Standardize as YYYY-MM-DD
Targetdeadline_date
Optional
Sourcesource record
Retain without loss
Targetraw_json
Required
13 mapped fields · 0 unmapped required targetsExact contract retained with the ingestion run