canton.gov Table: fact_validator_onboarding_events Type: Base Table
What
Description
Tracks successful validator onboarding events for both regular validators (DsoRules_OnboardValidator) and super validators (DsoRules_ConfirmSvOnboarding). Represents the final confirmation step in validator onboarding.Key Use Cases
- Monitoring successful validator onboardings
- Distinguishing between validator and super validator onboardings
- Tracking validator party identifiers and names
- Analyzing onboarding timing and actors
Important Relationships
- Final step after
gov__fact_validator_onboarding_requests - Links to
gov__fact_validator_offboarding_eventsfor complete lifecycle - Core table in
gov__ez_validator_onboarding_lifecyclecomprehensive view
Commonly-used Fields
onboarding_type: ‘validator’ or ‘super_validator’validator_party: Party ID of the onboarded validatorvalidator_name: Name of the validatorsv_party: Party ID if onboarding as super validatorsv_onboarding_confirmed: Contract ID from SV onboardingnew_dso_rules_contract_id: Updated DSO rules contract
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 |
| ONBOARDING_TYPE | TEXT | ONBOARDING_TYPE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| CHILD_EVENT_IDS | VARIANT | CHILD_EVENT_IDS column |
| CONSUMING | BOOLEAN | CONSUMING column |
| VALIDATOR_PARTY | TEXT | VALIDATOR_PARTY column |
| VALIDATOR_NAME | TEXT | VALIDATOR_NAME column |
| CONTACT_POINT | TEXT | CONTACT_POINT column |
| SPONSOR | TEXT | SPONSOR column |
| VERSION | TEXT | VERSION column |
| VALIDATOR_LICENSE | TEXT | VALIDATOR_LICENSE column |
| SV_PARTICIPANT_ID | TEXT | SV_PARTICIPANT_ID column |
| SV_PARTY | TEXT | SV_PARTY column |
| SV_NAME | TEXT | SV_NAME column |
| SV_REWARD_WEIGHT | NUMBER | SV_REWARD_WEIGHT column |
| SV_ONBOARDING_REASON | TEXT | SV_ONBOARDING_REASON column |
| SV_ONBOARDING_CONFIRMED | TEXT | SV_ONBOARDING_CONFIRMED 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_ONBOARDING_EVENT_ID | TEXT | FACT_VALIDATOR_ONBOARDING_EVENT_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |