Skip to main content
Schema: canton.core Table: fact_app_reward_coupons Type: Incremental

​
Description

Tracks the creation of app reward coupons for application providers. These coupons are created during mining rounds and represent rewards earned by app providers.

​
Key Use Cases

  • Analyzing app provider reward distribution
  • Tracking featured vs unfeatured app rewards
  • Understanding per-round reward allocation
  • Monitoring app provider incentive economics

​
Important Relationships

  • Links to rounds via round_number
  • Can be joined to core__fact_round_opens or core__fact_round_closes
  • Related to core__fact_app_rewards (expiration of coupons)

​
Commonly-used Fields

  • coupon_amount: The reward amount in this coupon
  • app_provider: The party receiving the reward
  • beneficiary: The beneficiary of the coupon
  • is_featured_app: Whether this is for a featured application
  • round_number: Which mining round this coupon was created in

​
Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state.
MIGRATION_IDTEXTCanton migration identifier. Used to track different phases or migrations in the Canton network’s evolution.
RECORD_TIMETEXTTimestamp when the update was recorded in the system.
EFFECTIVE_ATTEXTTimestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events.
EVENT_IDTEXTUnique identifier for the event within the Canton blockchain.
EVENT_INDEXTEXTOrdering index of events within an update. Events within the same update are sequentially numbered starting from 0.
COUPON_AMOUNTTEXTAmount (in amulets) represented by a reward coupon.
APP_PROVIDERTEXTParty identifier for an application provider receiving rewards.
BENEFICIARYTEXTParty identifier for the beneficiary of a reward or coupon.
IS_FEATURED_APPTEXTBoolean indicating whether an application has featured status, which typically grants higher reward rates.
ROUND_NUMBERTEXTSequential number identifying a mining round in the Canton network.
DSO_PARTYTEXTParty identifier for the DSO (Digital Synchronizer Operator) that manages network governance and operations.
EVENT_TYPETEXTType of event: ‘created_event’ for contract creation or ‘exercised_event’ for method execution on existing contracts.
COUPON_CONTRACT_IDTEXTContract ID for the app reward coupon
PACKAGE_NAMETEXTThe Canton package name containing the contract template.
TEMPLATE_IDTEXTThe template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’
CREATED_ATTEXTTimestamp when the contract was created.
SIGNATORIESTEXTArray of party identifiers who are signatories to the contract.
OBSERVERSTEXTArray of party identifiers who can observe the contract but are not signatories.
EVENT_JSONTEXTFull JSON object containing all event data. Useful for detailed analysis and accessing fields not explicitly extracted.
FACT_APP_REWARD_COUPON_IDTEXTSurrogate key generated from event_id
INSERTED_TIMESTAMPTEXTTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTEXTTimestamp when the record was last modified in this table (Snowflake SYSDATE).