canton.gov Table: fact_vote_requests Type: Base Table
What
Description
Tracks DSO governance vote requests/proposals through DsoRules_RequestVote events. Captures proposals for various DSO actions including granting featured app rights, updating rules, and other governance decisions.Key Use Cases
- Monitoring governance proposals and voting activity
- Analyzing proposal types and actions being requested
- Tracking requester patterns and proposal timing
- Understanding governance participation
Important Relationships
- Parent table to
gov__fact_votes(proposals receive votes) - Links to
gov__fact_vote_resultsvia vote_request_cid - Action details drive governance changes
Commonly-used Fields
requester: Party proposing the votetarget_effective_at: When proposal should take effectvote_timeout_microseconds: How long voting is openaction: High-level action tagdso_action: Specific DSO action if applicableamulet_rules_action: Specific amulet rules action if applicablereason_body: Explanation of the proposalreason_url: URL with more detailsvote_request_cid: Contract ID of the vote request
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 |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| REQUESTER | TEXT | REQUESTER column |
| TARGET_EFFECTIVE_AT | TIMESTAMP_NTZ | TARGET_EFFECTIVE_AT column |
| VOTE_TIMEOUT_MICROSECONDS | NUMBER | VOTE_TIMEOUT_MICROSECONDS column |
| ACTION | TEXT | ACTION column |
| DSO_ACTION | TEXT | DSO_ACTION column |
| DSO_ACTION_VALUE | VARIANT | DSO_ACTION_VALUE column |
| AMULET_RULES_ACTION | TEXT | AMULET_RULES_ACTION column |
| AMULET_RULES_VALUE | VARIANT | AMULET_RULES_VALUE column |
| REASON_BODY | TEXT | REASON_BODY column |
| REASON_URL | TEXT | REASON_URL column |
| VOTE_REQUEST_CID | TEXT | VOTE_REQUEST_CID column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| FACT_VOTE_REQUEST_ID | TEXT | FACT_VOTE_REQUEST_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |