Fact App Rewards

core.fact_app_rewards

Schema: 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 reward
• is_featured_app: Whether this was for a featured app
• closed_round_cid: Reference to the closed mining round
• contract_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).