maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Cleaned mirror of `raw_gcs.rfx_proposals`. Coerces the CSV's `Nullable(String)` columns into typed equivalents (decision_date, eval_score, source_uri, and cycle_time_days stay Nullable to model pending/withdrawn proposals) and enforces FKs to `stg_gcs__rfx_opportunities` and `stg_gcs__rfx_sme_directory`.
17 of 17
Column
Description
Tests · PII
rfx_id
Foreign key to stg_gcs__rfx_opportunities — the opportunity this proposal responds to.
2 tests
version
Proposal revision number 1..3. Coerced from String → UInt8.
2 tests
submitted_date
Date the proposal was submitted. Coerced from String → Date.
1 test
decision_date
Date the buyer decided. Nullable — null while the proposal is pending.
outcome
Proposal outcome.
2 tests
total_price
Total quoted price. Coerced from String → Decimal(14,2).
1 test
total_cost
Total internal cost to deliver. Coerced from String → Decimal(14,2).
1 test
margin_pct
Margin percent — (price − cost) / price × 100. Coerced from String → Decimal(6,2).
1 test
lead_author_sme_id
Foreign key to stg_gcs__rfx_sme_directory — the lead-author SME.
2 tests
eval_score
Buyer evaluation score 0..100. Nullable — null while pending. Coerced from String → Nullable(Decimal(5,2)).
competitor
Winning / competing vendor named in the decision. Free-text.
source_uri
Deterministic `gs://…/unstructured/historical-proposals/<proposal_id>.md` URI for won + lost proposals; null for pending / withdrawn.
cycle_time_days
Days from submission to decision (decision_date − submitted_date). Nullable — null while pending. Coerced to Nullable(UInt16).
source_file_url
Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.
source_file_modified_at
Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.
airbyte_extracted_at
When Airbyte extracted this row from GCS.