canton.gov Table: fact_validator_rewards Type: Base Table
What
Description
Tracks validator reward claims via AmuletRules_Transfer events where metadata contains validator-rewards information. Captures reward amounts, burned amounts, and net rewards.Key Use Cases
- Analyzing validator reward distribution
- Calculating net rewards after burns
- Tracking reward timing by mining round
- Monitoring validator economics and incentives
Important Relationships
- Links to mining rounds via round_number
- Links to validators via validator_party
- Related to
gov__fact_validator_activity(activity enables rewards)
Commonly-used Fields
validator_party: Party receiving the rewardreward_amount: Gross reward amount from metadataburned_amount: Amount burned in the processnet_reward_amount: Calculated field (reward_amount - burned_amount)mining_round: Round number associated with rewardround_number: Round from exercise result
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 |
| VALIDATOR_RIGHTS | VARIANT | VALIDATOR_RIGHTS column |
| ISSUING_MINING_ROUNDS | VARIANT | ISSUING_MINING_ROUNDS column |
| MINING_ROUND | VARIANT | MINING_ROUND column |
| VALIDATOR_PARTY | TEXT | VALIDATOR_PARTY column |
| EXERCISE_RESULT | VARIANT | EXERCISE_RESULT column |
| REWARD_AMOUNT | NUMBER | REWARD_AMOUNT column |
| BURNED_AMOUNT | NUMBER | BURNED_AMOUNT column |
| NET_REWARD_AMOUNT | NUMBER | NET_REWARD_AMOUNT column |
| ALL_META_VALUES | VARIANT | ALL_META_VALUES column |
| TRANSFER_SUMMARY | VARIANT | TRANSFER_SUMMARY column |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| FACT_VALIDATOR_REWARD_ID | TEXT | FACT_VALIDATOR_REWARD_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |