Rules

Email must match RFC-5322 pattern and have a valid registered TLD.

policy_version_id must reference a row in policy_versions.

SKU must be unique per product. ETL must use INSERT...ON DUPLICATE KEY UPDATE.

card_last4 expected for all non-bank-transfer transactions.

city must be in canonical Colombian city list (Bogotá, Medellín, Cali, Barranquilla, Cartagena, Bucaramanga, ...).

KS test on revenue_usd vs 30-day baseline. Alert D > 0.15.

Mahalanobis distance on (revenue, line_items, ship_distance) must be <= 3.0.

supplier country_code required for export compliance.

warehouse_zone should be populated for all active products.

transaction_id must be 100% unique — primary key invariant.

amount_cop must be >= 0 (refunds represented separately in chargebacks).

merchant_id must exist in merchants table.

Colombian cédula must be globally unique per customer row.

consent_timestamp must not be null — required by Habeas Data (Art. 9 Ley 1581).

order_id must be 100% unique in fct_orders.

consent_timestamp must not be null. Habeas Data Art. 9 requirement.

subject_id must be a valid Colombian cédula format.

consent_id must be globally unique.

currency IN ('COP','USD','EUR') only.

KS test vs 7-day rolling baseline. Alert if D > 0.15.

Phone must match +57 3XX XXX XXXX pattern.

policy_version must be one of the 4 active versions (v1, v2, v3, v4).

address.customer_id must reference a valid customers row.

Email should be unique per customer (household accounts excepted with consent flag).

line_items must be >= 0.

customer_id in fct_orders must exist in dim_customers.

product_code must be unique in dim_products.

consent_timestamp must not be in the future.

price_cop must be > 0 for active (non-discontinued) products.

quantity_available must be >= 0.

inventory.product_id must reference a valid products row.

Benford's Law first-digit test. Alert if χ² > 0.05.

Age derived from date_of_birth must be between 0 and 120.