canton.gov Table: ez_validator_onboarding_lifecycle Type: View
What
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, andgov__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 validatorvalidator_party: Party ID of the validatorvalidator_name: Name of the validatoronboarding_type: ‘validator’ or ‘super_validator’requested_at: When onboarding was requestedonboarded_at: When onboarding was confirmedoffboarded_at: When validator was offboarded (if applicable)most_recent_timestamp: Most recent activity timestamp for this validator
Columns
| Column Name | Data Type | Description |
|---|---|---|
| VALIDATOR_PARTY | TEXT | VALIDATOR_PARTY column |
| VALIDATOR_NAME | TEXT | VALIDATOR_NAME column |
| VALIDATOR_TYPE | TEXT | VALIDATOR_TYPE column |
| ONBOARDING_REQUEST_CONTRACT_ID | TEXT | ONBOARDING_REQUEST_CONTRACT_ID column |
| REQUEST_CREATED_AT | TIMESTAMP_NTZ | REQUEST_CREATED_AT column |
| REQUEST_SPONSOR | TEXT | REQUEST_SPONSOR column |
| REQUEST_EVENT_ID | TEXT | REQUEST_EVENT_ID column |
| ONBOARDED_AT | TIMESTAMP_NTZ | ONBOARDED_AT column |
| CONTACT_POINT | TEXT | CONTACT_POINT column |
| ONBOARDING_SPONSOR | TEXT | ONBOARDING_SPONSOR column |
| VERSION | TEXT | VERSION column |
| VALIDATOR_LICENSE | TEXT | VALIDATOR_LICENSE column |
| SV_REWARD_WEIGHT | NUMBER | SV_REWARD_WEIGHT column |
| ONBOARDING_EVENT_ID | TEXT | ONBOARDING_EVENT_ID column |
| EXPIRED_AT | TIMESTAMP_NTZ | EXPIRED_AT column |
| EXPIRATION_TYPE | TEXT | EXPIRATION_TYPE column |
| EXPIRATION_CHOICE | TEXT | EXPIRATION_CHOICE column |
| EXPIRATION_EVENT_ID | TEXT | EXPIRATION_EVENT_ID column |
| OFFBOARDED_AT | TIMESTAMP_NTZ | OFFBOARDED_AT column |
| OFFBOARDING_EVENT_ID | TEXT | OFFBOARDING_EVENT_ID column |
| VALIDATOR_STATUS | TEXT | VALIDATOR_STATUS column |
| DAYS_FROM_REQUEST_TO_ONBOARDING | NUMBER | DAYS_FROM_REQUEST_TO_ONBOARDING column |
| DAYS_ACTIVE_BEFORE_OFFBOARDING | NUMBER | DAYS_ACTIVE_BEFORE_OFFBOARDING column |
| DAYS_ACTIVE_CURRENT | NUMBER | DAYS_ACTIVE_CURRENT column |
| MOST_RECENT_TIMESTAMP | TIMESTAMP_NTZ | MOST_RECENT_TIMESTAMP column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| IS_CURRENT | BOOLEAN | IS_CURRENT column |
| EZ_VALIDATOR_ONBOARDING_LIFECYCLE_ID | TEXT | EZ_VALIDATOR_ONBOARDING_LIFECYCLE_ID column |