canton.gov Table: fact_validator_activity Type: Base Table
What
Description
Tracks validator liveness and activity reporting events. Captures both super validator activity reports (ValidatorLicense_ReportActive) and regular validator liveness activity (ValidatorLicense_RecordValidatorLivenessActivity).Key Use Cases
- Monitoring validator liveness and activity
- Distinguishing between super validator and regular validator activity
- Tracking activity patterns and frequency
- Analyzing validator performance and participation
Important Relationships
- Links to validator onboarding tables via validator parties
- Activity data used for reward calculations
- Related to validator reward distribution
Commonly-used Fields
validator_type: ‘super_validator’ or ‘validator’round_number: Mining round when activity occurredvalidator_party: Party reporting activityeffective_at: When activity was reported
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 |
| VALIDATOR_PARTY | VARIANT | VALIDATOR_PARTY column |
| VALIDATOR_TYPE | TEXT | VALIDATOR_TYPE column |
| OPEN_ROUND_CID | TEXT | OPEN_ROUND_CID column |
| CLOSED_ROUND_CID | TEXT | CLOSED_ROUND_CID column |
| COUPON_CID | TEXT | COUPON_CID column |
| LICENSE_CID | TEXT | LICENSE_CID column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| EVENT_JSON | VARIANT | EVENT_JSON column |
| FACT_VALIDATOR_ACTIVITY_ID | TEXT | FACT_VALIDATOR_ACTIVITY_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |