canton.core Table: fact_app_rewards Type: Base Table
What
Description
Tracks app reward coupon expirations when the DSO expires app reward coupons. These events occur when reward coupons reach their expiration and are processed by the DSO.Key Use Cases
- Monitoring app reward expiration patterns
- Analyzing reward amounts being expired
- Tracking which closed rounds trigger expirations
- Understanding featured vs unfeatured app reward differences
Important Relationships
- Links to closed rounds via
closed_round_cid - Related to
core__fact_app_reward_coupons(creation of coupons)
Commonly-used Fields
reward_amount: Amount of the expired rewardis_featured_app: Whether this was for a featured appclosed_round_cid: Reference to the closed mining roundcontract_id: The app reward coupon contract being expired
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | UPDATE_ID column |
| MIGRATION_ID | NUMBER | MIGRATION_ID column |
| RECORD_TIME | TIMESTAMP_NTZ | RECORD_TIME column |
| EFFECTIVE_AT | TIMESTAMP_NTZ | EFFECTIVE_AT column |
| EVENT_ID | TEXT | EVENT_ID column |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| CHOICE | TEXT | CHOICE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| CLOSED_ROUND_CID | TEXT | CLOSED_ROUND_CID column |
| REWARD_AMOUNT | NUMBER | REWARD_AMOUNT column |
| IS_FEATURED_APP | BOOLEAN | IS_FEATURED_APP column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| FACT_APP_REWARD_ID | TEXT | FACT_APP_REWARD_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |