59 of 312 nodes

Every source, model, and metric in the manifest. Drill into a row to see columns, tests, lineage, and a policy-enforced preview.

Certified only

Clear filters(1)

Schema: raw_postgres

Model	Layer	Owner	Cols	PII
addresses Customer shipping/billing addresses with a validity window.	source raw_postgres	—	14	6
agents Support agents — humans handling tickets.	source raw_postgres	—	8	2
ap_payment_applications Bridge applying AP payments to the vendor bills they settle.	source raw_postgres	—	5	—
ap_payments AP payments (cash out). Statutory financial record keyed to a vendor.	source raw_postgres	—	16	—
approvals Polymorphic approval steps over finance objects. `object_id` is a soft FK keyed by object_type.	source raw_postgres	—	10	—
ar_receipt_applications Bridge applying AR receipts to the customer invoices they settle.	source raw_postgres	—	5	—
ar_receipts AR receipts (cash in). Statutory record keyed to the ecommerce `customer` subject.	source raw_postgres	—	16	—
audit_log Append-only audit log over finance objects. old_value/new_value are free-text PII (retain_aggregate).	source raw_postgres	—	10	2
bank_accounts Bank-account dimension. Each maps to a GL cash account and optionally a legal entity.	source raw_postgres	—	11	—
bank_transactions Bank-statement transactions. `counterparty_name` is incidental financial PII.	source raw_postgres	—	16	1
bill_lines Vendor-bill line items (AP). `description` is incidental free-text PII.	source raw_postgres	—	14	1
budget_lines Budget amounts per (budget, gl_account, cost_center, period).	source raw_postgres	—	8	—
budgets Budget headers (FP&A). Statutory-adjacent planning record kept 7 years.	source raw_postgres	—	11	—
chat_channels Chat-channel metadata (Slack/Teams). `topic` is free-text PII. Comms — legitimate_interest + 365d.	source raw_postgres	—	11	1
chat_messages Chat-message metadata + body. `body_text` is free-text PII. Comms — legitimate_interest + 365d.	source raw_postgres	—	15	1
communication_links Polymorphic bridge "show me all comms about entity X". Both sides are soft FKs.	source raw_postgres	—	10	—
consent_events Append-only consent ledger — one row per (customer × purpose) state change. Drives lawful-basis enforcement: queries that touch a customer must check `mart_consent_current` for an active grant on the relevant purpose. Withdrawals create a new row with event_type='withdrawn'.	source raw_postgres	—	9	—
cost_centers Cost-center org dimension. Self-referencing parent hierarchy; optional owner employee.	source raw_postgres	—	9	—
customer_invoices Customer invoices (AR). Statutory record keyed to the existing ecommerce `customer` subject.	source raw_postgres	—	19	—
customers One row per customer in the operational DB.	source raw_postgres	—	9	3
depreciation_schedule Per-period depreciation schedule per fixed asset. Source of recurring depreciation JEs.	source raw_postgres	—	8	—
email_message_participants Email participants (to/cc/bcc). participant_email + participant_display_name are contact PII.	source raw_postgres	—	10	2
email_messages Email-message metadata + inline body. subject/body_text/sender_email/sender_display_name are PII.	source raw_postgres	—	21	4
email_threads Email-thread metadata. `subject` is free-text PII. Comms — legitimate_interest + 365d.	source raw_postgres	—	13	1
events Customer-facing web events (page views, cart, checkout). Not currently consumed by staging models — kept around for future engagement-funnel marts.	source raw_postgres	—	8	2
expense_report_lines Expense-report line items. `merchant_name` + `description` are behavioral PII.	source raw_postgres	—	13	2
expense_reports Expense-report headers. Keyed to the submitting `employee`. `report_title` is behavioral PII.	source raw_postgres	—	14	1
finance_employees Finance employee identity table — the `employee` data subject. Carries identity / contact / financial PII.	source raw_postgres	—	14	5
finance_notes Finance notes. `title` + `body_text` are free-text PII. Comms — legitimate_interest + 365d.	source raw_postgres	—	16	2
fiscal_periods One row per fiscal period — period_code (e.g. FY2025-M07), fiscal year/month, start/end dates, and close status (open / closed / locked).	source raw_postgres	—	9	—
fixed_assets Fixed-asset register. Statutory financial record.	source raw_postgres	—	16	—
forecast_lines Forecast amounts per (forecast, gl_account, cost_center, period).	source raw_postgres	—	8	—
forecasts Forecast headers (FP&A). Planning record.	source raw_postgres	—	12	—
fx_rates FX rate table — one row per (from, to, date, type). Translates txn currency to functional USD.	source raw_postgres	—	7	—
gl_accounts Chart of accounts. `is_control_account` flags the AR/AP control accounts subledgers tie to.	source raw_postgres	—	10	—
gl_journal_entries GL journal-entry headers. Statutory financial record.	source raw_postgres	—	13	—
gl_journal_lines GL journal lines (double-entry). Exactly one of debit/credit is non-zero per line. Statutory record.	source raw_postgres	—	10	—
invoice_lines Customer-invoice line items (AR). Optionally links to an ecommerce product.	source raw_postgres	—	14	—
legal_entities Reporting legal entities (e.g. US-INC, EU-GMBH). Entity dimension on GL / periods / cost centers / planning.	source raw_postgres	—	8	—
marketing_campaigns Outbound campaign catalog. Optional FK to a promotion.	source raw_postgres	—	7	—
marketing_sends Per-customer touchpoint with engagement timestamps. Grain (campaign, customer) is UNIQUE on the source. Sends are gated upstream on `consent_events.purpose='marketing'` — mid-window withdrawals are NOT reflected here.	source raw_postgres	—	10	1
order_items Line items per order. Joins to `orders.order_id` and `products.product_id`.	source raw_postgres	—	7	—
order_promotions Orders ↔ promotions junction with the captured `discount_amount`. UNIQUE (order_id, promotion_id).	source raw_postgres	—	5	—
orders One row per customer order.	source raw_postgres	—	8	—
payment_methods Tokenised payment instruments per customer. Raw PAN never stored.	source raw_postgres	—	11	2
payments One row per payment transaction. Auth → capture → optional refund/void.	source raw_postgres	—	10	1
product_inventory_snapshots Daily inventory positions per (product, warehouse). UNIQUE on the source.	source raw_postgres	—	8	—
products Product catalog.	source raw_postgres	—	8	—
promotions Discount catalog. Standalone; joined to orders via `order_promotions`.	source raw_postgres	—	9	—
reconciliation_items Reconciliation match lines tying bank transactions and/or GL lines to a reconciliation.	source raw_postgres	—	8	—

1–50 of 59

1 / 2