canton.gov Table: fact_validator_onboarding_request_expirations Type:
Incremental
Description
Tracks onboarding request expirations through both DSO-initiated expiration (DsoRules_ExpireSvOnboardingRequest) and contract consumption (SvOnboardingRequest_Expire). Handles parent-child event relationships.Key Use Cases
- Monitoring expired onboarding requests
- Understanding expiration types (DSO-initiated vs contract-consumed)
- Tracking which requests didn’t complete onboarding
- Analyzing expiration timing and patterns
Important Relationships
- Links to
gov__fact_validator_onboarding_requestsvia contract IDs - Part of
gov__ez_validator_onboarding_lifecyclefor incomplete onboardings
Commonly-used Fields
expiration_type: ‘dso_initiated’ or ‘contract_consumed’expired_request_cid: Contract ID of the expired requestreason_url: URL explaining expiration (DSO-initiated only)reason_body: Text description of expiration (DSO-initiated only)effective_at: When expiration occurred
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | Unique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state. |
| MIGRATION_ID | TEXT | Canton migration identifier. Used to track different phases or migrations in the Canton network’s evolution. |
| RECORD_TIME | TEXT | Timestamp when the update was recorded in the system. |
| EFFECTIVE_AT | TEXT | Timestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events. |
| EVENT_ID | TEXT | Unique identifier for the event within the Canton blockchain. |
| EVENT_INDEX | TEXT | Ordering index of events within an update. Events within the same update are sequentially numbered starting from 0. |
| CHOICE | TEXT | The choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc. |
| ACTING_PARTIES | TEXT | Array of party identifiers who are executing this action/choice. |
| EXPIRATION_TYPE | TEXT | Type of expiration: ‘dso_initiated’ for DSO-triggered expiration or ‘contract_consumed’ for automatic contract expiration. |
| EXPIRED_REQUEST_CID | TEXT | Contract ID of an expired onboarding request. |
| REASON_URL | TEXT | URL providing additional information or justification for an action. |
| REASON_BODY | TEXT | Text body explaining the reason for an action. |
| CONTRACT_ID | TEXT | Unique identifier for the contract being created or exercised in this event. |
| FACT_SV_ONBOARDING_EXPIRATION_ID | TEXT | Surrogate key generated from event_id |
| INSERTED_TIMESTAMP | TEXT | Timestamp when the record was inserted into this table (Snowflake SYSDATE). |
| MODIFIED_TIMESTAMP | TEXT | Timestamp when the record was last modified in this table (Snowflake SYSDATE). |