Skip to main content
Schema: canton.gov Table: ez_validator_onboarding_lifecycle Type: View

​
Description

Comprehensive EZ view providing a complete picture of validator lifecycle from request through onboarding and potential offboarding. Uses FULL OUTER JOIN to capture all validators regardless of request status, and includes an is_current flag for active validators.

​
Key Use Cases

  • Understanding complete validator journey
  • Analyzing active vs inactive validators
  • Tracking onboarding success rates and timing
  • Monitoring validator status changes over time
  • Reporting on current validator set

​
Important Relationships

  • Joins gov__fact_validator_onboarding_requests, gov__fact_validator_onboarding_events, gov__fact_validator_offboarding_events, and gov__fact_validator_onboarding_request_expirations
  • Comprehensive view suitable for dashboards and reporting

​
Commonly-used Fields

  • is_current: Boolean flag indicating if this is the current record for the validator
  • validator_party: Party ID of the validator
  • validator_name: Name of the validator
  • onboarding_type: ‘validator’ or ‘super_validator’
  • requested_at: When onboarding was requested
  • onboarded_at: When onboarding was confirmed
  • offboarded_at: When validator was offboarded (if applicable)
  • most_recent_timestamp: Most recent activity timestamp for this validator

​
Columns

Column NameData TypeDescription
ONBOARDING_REQUEST_CONTRACT_IDTEXTContract ID for a validator onboarding request.
VALIDATOR_PARTYTEXTParty identifier for a validator.
VALIDATOR_NAMETEXTHuman-readable name for a validator.
VALIDATOR_TYPETEXTType of validator: validator or super_validator
REQUEST_CREATED_ATTEXTTimestamp when onboarding request was created
REQUEST_SPONSORTEXTSponsor party for the onboarding request
REQUEST_EVENT_IDTEXTEvent ID of the onboarding request
ONBOARDED_ATTEXTTimestamp when onboarding was completed.
CONTACT_POINTTEXTContact point for the validator
ONBOARDING_SPONSORTEXTSponsor party at time of onboarding
VERSIONTEXTVersion information
VALIDATOR_LICENSETEXTValidator license information
SV_REWARD_WEIGHTTEXTSuper validator reward weight
ONBOARDING_EVENT_IDTEXTEvent ID of the onboarding event
EXPIRED_ATTEXTTimestamp when expiration occurred.
EXPIRATION_TYPETEXTType of expiration: ‘dso_initiated’ for DSO-triggered expiration or ‘contract_consumed’ for automatic contract expiration.
EXPIRATION_CHOICETEXTChoice that triggered the expiration
EXPIRATION_EVENT_IDTEXTEvent ID of the expiration event
OFFBOARDED_ATTEXTTimestamp when offboarding occurred.
OFFBOARDING_EVENT_IDTEXTEvent ID of the offboarding event
VALIDATOR_STATUSTEXTCurrent status: active, offboarded, request_expired, request_pending, or unknown
DAYS_FROM_REQUEST_TO_ONBOARDINGTEXTNumber of days between request creation and onboarding completion
DAYS_ACTIVE_BEFORE_OFFBOARDINGTEXTNumber of days validator was active before offboarding
DAYS_ACTIVE_CURRENTTEXTNumber of days validator has been active (for currently active validators)
MOST_RECENT_TIMESTAMPTEXTMost recent timestamp across multiple possible event types for an entity.
IS_CURRENTTEXTBoolean flag indicating whether this is the current/active record for an entity (used in lifecycle/timeline views).