canton.gov Table: fact_validator_onboarding_requests Type: Base Table
What
Description
Tracks when super validators initiate the onboarding process by executing DsoRules_StartSvOnboarding. Captures the initial request with candidate information and onboarding tokens.Key Use Cases
- Monitoring new validator onboarding requests
- Tracking onboarding request timing and actors
- Analyzing candidate information and reasons
- Linking requests to eventual onboarding events
Important Relationships
- First step in validator lifecycle, links to
gov__fact_validator_onboarding_events - Can link to
gov__fact_validator_onboarding_request_expirationsfor expired requests - Part of
gov__ez_validator_onboarding_lifecyclecomprehensive view
Commonly-used Fields
candidate_name: Name of the validator candidatecandidate_party: Party ID of the candidatereason_url: URL with reason for onboardingreason_body: Text description of reasononboarding_token: Token for the onboarding processonboarding_request_contract_id: Contract ID of the created request
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 |
| CANDIDATE_NAME | TEXT | CANDIDATE_NAME column |
| CANDIDATE_PARTICIPANT_ID | TEXT | CANDIDATE_PARTICIPANT_ID column |
| CANDIDATE_PARTY | TEXT | CANDIDATE_PARTY column |
| SPONSOR | TEXT | SPONSOR column |
| ONBOARDING_TOKEN | TEXT | ONBOARDING_TOKEN column |
| ONBOARDING_REQUEST_CONTRACT_ID | TEXT | ONBOARDING_REQUEST_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_SV_ONBOARDING_REQUEST_ID | TEXT | FACT_SV_ONBOARDING_REQUEST_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |