canton.gov Table: fact_validator_offboarding_events Type: Base Table
What
Description
Tracks when validators are removed from the network through DsoRules_OffboardSv events. Captures the offboarding decision and resulting state changes.Key Use Cases
- Monitoring validator exits from the network
- Understanding offboarding reasons and actors
- Tracking DSO rule updates from offboardings
- Analyzing validator lifecycle completion
Important Relationships
- Final step in validator lifecycle from
gov__fact_validator_onboarding_events - Part of
gov__ez_validator_onboarding_lifecyclecomprehensive view - Links to validator activity tables via offboarded_sv_party
Commonly-used Fields
offboarded_sv_party: Party ID of the offboarded validatorreason_url: URL explaining offboarding reasonreason_body: Text description of offboarding reasonnew_dso_rules_contract_id: Updated DSO rules after offboardingeffective_at: When offboarding occurred
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 |
| CHILD_EVENT_IDS | VARIANT | CHILD_EVENT_IDS column |
| CONSUMING | BOOLEAN | CONSUMING column |
| OFFBOARDED_SV_PARTY | TEXT | OFFBOARDED_SV_PARTY column |
| NEW_DSO_RULES_CONTRACT_ID | TEXT | NEW_DSO_RULES_CONTRACT_ID column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| PACKAGE_NAME | TEXT | PACKAGE_NAME column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| INTERFACE_ID | TEXT | INTERFACE_ID column |
| EVENT_JSON | VARIANT | EVENT_JSON column |
| FACT_VALIDATOR_OFFBOARDING_EVENT_ID | TEXT | FACT_VALIDATOR_OFFBOARDING_EVENT_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |