Data Warehouse Share - Customer Guides

Welcome to the Aclaimant Data Warehouse Share (DWS) documentation. Choose the guide that matches your Aclaimant account version.

Which version am I on?

💡: Not sure which version you're on? Ask your Aclaimant Customer Experience Manager or look at your Snowflake share:
• If you see an incidents table → you're on v2
• If you see per-workflow tables (e.g., workers_comp_incident_workflow) → you're on v3

Choose Your Guide

v2 — Incident-Based Model

Your data is organized around a central incidents table with incident_id joins. Pertinent person fields live directly on the incident record.

Key tables: incidents, events, claims, safety_reports

DWS Customer Guide (v2)
 

v3 — Workflow-Based Model

Each workflow gets its own table (e.g., workers_comp_incident_workflow). People are tracked via the subjects table with OSHA flags. Joins use model_id ↔ parent_model_id.

Key tables: per-workflow tables, subjects, events, claims

Aclaimant DWS Customer Guide (v3)

What's in Each Guide

Both guides cover:

• Getting Started — connecting to your Snowflake share
• Data Model & Table Reference — every table, column descriptions, entity relationships
• Module-Dependent Tables — which tables require enablement
• SQL Recipes — OSHA days-away calculations, Form 300A stats, TRIR, claims financials, trend analysis, task aging
• Tips & Best Practices — join patterns, performance, data freshness

Snowflake Resources

New to Snowflake? These docs cover the most common tasks when setting up your share:

• Consume imported data — creating a database from a share, viewing available shares, querying shared data
• User management — creating and managing Snowflake users
• Access control overview — understanding roles, privileges, and how Snowflake authorization works
• GRANT privileges — SQL reference for granting access to databases, schemas, and tables

Questions?

Reach out to your Aclaimant Customer Experience Manager or email support@aclaimant.com.