stg_postgres__payment_methods

staging view 2 PII columns

Payment methods, with soft-delete surfaced.

Definition

Per-customer payment instruments (cards, wallets, bank transfers). Soft-delete propagates as `is_active = deleted_at IS NULL` so downstream marts can filter without re-deriving. Raw PAN is never stored — `last4` + `card_brand` + `exp_*` are the only card fields and are tagged financial PII.

13 of 13

Column

Description

Tests · PII

payment_method_id

Primary key — UInt64.

2 tests

customer_id

FK to `stg_postgres__customers.customer_id`. NOT NULL.

customer +17 PII2 tests

method_type

Instrument kind — `card`, `bank_transfer`, `paypal`, `apple_pay`, `google_pay`.

1 test

card_brand

Card brand (`visa`/`mastercard`/`amex`/`discover`) when `method_type='card'`. Nullable.

PII

last4

Last 4 digits of the PAN. Quasi-identifier when combined with `card_brand` + `exp_*`. Nullable for non-card methods.

PII

exp_month

Card expiry month. Nullable.

exp_year

Card expiry year. Nullable.

is_default

True for the customer's default payment method.

added_at

Time the method was added. DateTime64(6).

deleted_at

Soft-delete timestamp. Null = still active.

is_active

Derived — `deleted_at IS NULL`. True for currently usable methods.

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.