maiven gateway · online··
manifest · 3d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_gcs__mdt_pricing_line_items

staging view

Pricing line items, typed.

Lineage Builds
Definition

One row per cost-generating activity; amounts sum to the proposal's total_rom.

16 of 16
Column
Description
Tests · PII
line_item_id
UUID5 primary key.
2 tests
proposal_id
FK to stg_gcs__mdt_proposals.
smithers_employee PII2 tests
opportunity_id
FK to stg_gcs__mdt_opportunities.
smithers_employee PII2 tests
device_nickname
Device this cost line is for (or 'programme' for study-level).
description
What the line item covers.
category
Cost category.
1 test
related_test
Test name this line maps to, if per-test.
unit
Unit of measure (hours/days/per test/lump sum).
quantity
Number of units.
rate
Rate per unit. Confidential-commercial.
amount
Total cost for this line. Confidential-commercial.
1 test
confidence
Provenance of the cost.
1 test
basis
Prior-quote reference when HISTORICAL.
source_file_url
Airbyte _ab_source_file_url.
source_file_modified_at
Airbyte source object mtime.
airbyte_extracted_at
When Airbyte extracted this row.