canton.gov Table: fact_validator_onboarding_request_expirations Type: Base Table
What
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 | 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 |
| EXPIRATION_TYPE | TEXT | EXPIRATION_TYPE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| CHILD_EVENT_IDS | VARIANT | CHILD_EVENT_IDS column |
| CONSUMING | BOOLEAN | CONSUMING column |
| EXPIRED_REQUEST_CID | TEXT | EXPIRED_REQUEST_CID column |
| SV_PARTY | TEXT | SV_PARTY column |
| ONBOARDING_REQUEST_CONTRACT_ID | TEXT | ONBOARDING_REQUEST_CONTRACT_ID column |
| EXERCISE_RESULT | TEXT | EXERCISE_RESULT 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_EXPIRATION_ID | TEXT | FACT_SV_ONBOARDING_EXPIRATION_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |