Card Transactions (Gold)
Settled, deduplicated transactions with merchant category and program code. The product analysts and data scientists build on.
Data contract
11 fields| Field | Type | Sensitivity | Quality rule | Clear to | Purpose |
|---|---|---|---|---|---|
| txn_id | bigint | - | unique, not null | Every persona with access | - |
| account_token | text | PII | tokenized, not null | Fraud analyst, Audit and model risk | Fraud prevention |
| pan_masked | text | PAN | last four only | Every persona with access | - |
| customer_id | int | - | fk customers, not null | Every persona with access | - |
| merchant_id | int | - | fk merchants, not null | Every persona with access | - |
| mcc | text | - | 4-digit, in MCC dimension | Every persona with access | - |
| amount | numeric | - | amount > 0 | Every persona with access | - |
| auth_status | text | - | in (approved, declined) | Every persona with access | - |
| is_fraud | boolean | - | not null | Data scientist, Fraud analyst, Audit and model risk, Platform admin | Fraud prevention |
| txn_ts | timestamptz | - | not null | Every persona with access | - |
| partner_scope | text | - | in (nova, general) | Every persona with access | - |
- txn_id bigint
Rule: unique, not null
Clear to: every persona with access
- account_token text PII
Rule: tokenized, not null
Clear to: Fraud analyst, Audit and model risk · under Fraud prevention
- pan_masked text PAN
Rule: last four only
Clear to: every persona with access
- customer_id int
Rule: fk customers, not null
Clear to: every persona with access
- merchant_id int
Rule: fk merchants, not null
Clear to: every persona with access
- mcc text
Rule: 4-digit, in MCC dimension
Clear to: every persona with access
- amount numeric
Rule: amount > 0
Clear to: every persona with access
- auth_status text
Rule: in (approved, declined)
Clear to: every persona with access
- is_fraud boolean
Rule: not null
Clear to: Data scientist, Fraud analyst, Audit and model risk, Platform admin · under Fraud prevention
- txn_ts timestamptz
Rule: not null
Clear to: every persona with access
- partner_scope text
Rule: in (nova, general)
Clear to: every persona with access