maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per proposal — status, entity, ROM, review path, cycle time.
28 of 28
Column
Description
Tests · PII
proposal_id
UUID5 primary key.
3 tests
reference
Proposal reference (opportunity ref + suffix).
1 test
title
Proposal title.
entity
Issuing Smithers legal entity.
1 test
proposal_status
Lifecycle status.
2 tests
currency
ISO currency code.
1 test
total_rom
Base ROM ex-VAT ex-contingency. Confidential-commercial.
contingency_pct
Contingency percentage (typically 10).
total_with_contingency
ROM + contingency. Confidential-commercial.
review_path
Review path.
1 test
escalation_triggers
Flattened escalation triggers, if any.
prepared_date
Date the proposal was prepared.
issued_date
Date the proposal was issued.
decision_date
Date the client decided (won/lost).
lost_reason
Loss reason (in_house/competitor/budget/timeline), if lost.
po_reference
Purchase-order reference, populated on won.
cycle_time_days
Days from request to issued.
ukas_applicable
Whether UKAS applies (Shawbury UK only), 0/1.
bdm_lead
Smithers commercial/BDM lead. Identity PII.
PII
te_lead
Smithers technical lead. Identity PII.
PII
pm_lead
Smithers project-manager lead. Identity PII.
PII
source_uri
gs:// URI of the issued proposal blob in the mdt-proposals corpus.
created_at
Record creation timestamp (deterministic build stamp).
issued_month
First day of issued month (toStartOfMonth of issued_date) — pipeline grain key.
source_file_url
Airbyte _ab_source_file_url.
source_file_modified_at
Airbyte source object mtime.
airbyte_extracted_at
When Airbyte extracted this row.