bridge_payment_to_payment_run


Description

Connects payment runs with payments. Each row represents one payment-run item and its corresponding payment. The payment_run_id joins to fct_payment_run.payment_run_id, and payment_id joins to fct_payment.payment_id. The payment-run-item to payment connection is one-to-one.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
payment_to_payment_run_id varchar 32 null

Surrogate primary key for a payment-run and payment relationship.
payment_id varchar 32 √ null
fct_payment.payment_id erp_v2_bridge_payment_to_payment_run_payment_id__erp_v2_fct_payment_payment_id_fkey_237755775dad R

The transaction-resolved payment associated with the payment-run booking. Join this key to fct_payment.payment_id.
payment_run_id varchar 32 √ null

The payment-run result associated with the normalized booking. Join this key to fct_payment_run.payment_run_id.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation