canton.core Table: fact_app_rewards Type: Incremental
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 | Unique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state. |
| MIGRATION_ID | TEXT | Canton migration identifier. Used to track different phases or migrations in the Canton network’s evolution. |
| RECORD_TIME | TEXT | Timestamp when the update was recorded in the system. |
| EFFECTIVE_AT | TEXT | Timestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events. |
| EVENT_ID | TEXT | Unique identifier for the event within the Canton blockchain. |
| EVENT_INDEX | TEXT | Ordering index of events within an update. Events within the same update are sequentially numbered starting from 0. |
| CHOICE | TEXT | The choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc. |
| ACTING_PARTIES | TEXT | Array of party identifiers who are executing this action/choice. |
| CLOSED_ROUND_CID | TEXT | Contract ID reference to a closed mining round. |
| REWARD_AMOUNT | TEXT | Amount of reward (in amulets) being distributed or processed. |
| IS_FEATURED_APP | TEXT | Boolean indicating whether an application has featured status, which typically grants higher reward rates. |
| CONTRACT_ID | TEXT | Unique identifier for the contract being created or exercised in this event. |
| TEMPLATE_ID | TEXT | The template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’ |
| FACT_APP_REWARD_ID | TEXT | Surrogate key generated from event_id |
| INSERTED_TIMESTAMP | TEXT | Timestamp when the record was inserted into this table (Snowflake SYSDATE). |
| MODIFIED_TIMESTAMP | TEXT | Timestamp when the record was last modified in this table (Snowflake SYSDATE). |