SilverInternal
98.9
Rewards Ledger
Loyalty
Points earned and redeemed by category, keyed to cardholder and program. Feeds rewards liability and redemption analytics.
Owner
Loyalty Engineering
SLA / freshness
Daily T+1
Rows
~12,000
Classification
Internal
Data contract
7 fields| Field | Type | Sensitivity | Quality rule | Clear to | Purpose |
|---|---|---|---|---|---|
| id | bigint | - | unique, not null | Every persona with access | - |
| customer_id | int | - | fk customers, not null | Every persona with access | - |
| points_earned | int | - | >= 0 | Every persona with access | - |
| points_redeemed | int | - | >= 0 | Every persona with access | - |
| category | text | - | not null | Every persona with access | - |
| ts | timestamptz | - | not null | Every persona with access | - |
| partner_scope | text | - | in (nova, general) | Every persona with access | - |
- id bigint
Rule: unique, not null
Clear to: every persona with access
- customer_id int
Rule: fk customers, not null
Clear to: every persona with access
- points_earned int
Rule: >= 0
Clear to: every persona with access
- points_redeemed int
Rule: >= 0
Clear to: every persona with access
- category text
Rule: not null
Clear to: every persona with access
- ts timestamptz
Rule: not null
Clear to: every persona with access
- partner_scope text
Rule: in (nova, general)
Clear to: every persona with access
Lineage
Preview, scoped to a persona
Querying…
masked
No rows returned.