maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
One row per incoming RFP/RFQ in the intake queue, with status + requested scope.
28 of 28
Column
Description
Tests · PII
rfp_id
UUID5 primary key.
2 tests
reference_id
RFQ/client reference (real Smithers ref, or synthetic RFP-YYYY-NNN for net-new).
1 test
client_name
Client/prospect legal entity. Confidential-commercial.
client_region
Client region.
entity
Target Smithers legal entity.
1 test
channel
Intake channel.
1 test
received_date
Date the RFP arrived.
study_type
Study type requested.
testing_purpose
Flattened testing-purpose list.
device_summary
Devices mentioned in the request (free text).
requested_tests
Tests requested (flattened free text).
target_start_date
Client target study-start date.
report_due_date
Client-required report date.
regulatory_pathway
Submission pathway, if stated.
budget_indication
Client-stated budget indication. Confidential-commercial.
nda_required
Whether an NDA is required (0/1).
quality_system
Quality-system requirement.
questionnaire_provided
Whether a filled questionnaire was provided (0/1).
intake_status
Intake-pipeline stage.
2 tests
priority
Intake priority.
1 test
bdm_owner
Smithers BDM owning the intake. Identity PII.
PII
linked_opportunity_id
FK to stg_gcs__mdt_opportunities when the RFP became a quoted opportunity; NULL for net-new prospects.
1 test
source_uri
gs:// URI of the RFQ doc blob in the mdt-rfqs corpus, if any.
created_at
Record creation timestamp.
received_month
First day of received month (toStartOfMonth of received_date) — intake 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.