Skip to main content
Schema: canton.gov Table: fact_validator_onboarding_requests Type: Incremental

​
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_expirations for expired requests
  • Part of gov__ez_validator_onboarding_lifecycle comprehensive view

​
Commonly-used Fields

  • candidate_name: Name of the validator candidate
  • candidate_party: Party ID of the candidate
  • reason_url: URL with reason for onboarding
  • reason_body: Text description of reason
  • onboarding_token: Token for the onboarding process
  • onboarding_request_contract_id: Contract ID of the created request

​
Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state.
MIGRATION_IDTEXTCanton migration identifier. Used to track different phases or migrations in the Canton network’s evolution.
RECORD_TIMETEXTTimestamp when the update was recorded in the system.
EFFECTIVE_ATTEXTTimestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events.
EVENT_IDTEXTUnique identifier for the event within the Canton blockchain.
EVENT_INDEXTEXTOrdering index of events within an update. Events within the same update are sequentially numbered starting from 0.
CHOICETEXTThe choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc.
ACTING_PARTIESTEXTArray of party identifiers who are executing this action/choice.
CANDIDATE_NAMETEXTName of a validator candidate in an onboarding request.
CANDIDATE_PARTYTEXTParty identifier for a validator candidate.
REASON_URLTEXTURL providing additional information or justification for an action.
REASON_BODYTEXTText body explaining the reason for an action.
ONBOARDING_TOKENTEXTToken used in the validator onboarding process.
ONBOARDING_REQUEST_CONTRACT_IDTEXTContract ID for a validator onboarding request.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
FACT_SV_ONBOARDING_REQUEST_IDTEXTSurrogate key generated from event_id
INSERTED_TIMESTAMPTEXTTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTEXTTimestamp when the record was last modified in this table (Snowflake SYSDATE).