Skip to main content
The PHD enriched layer provides 20 denormalized views organized into five logical groups. Each view is self-contained for common queries, but foreign key columns allow you to join across views when needed.
These views mirror the data available through the PHD REST API (Connect). Column names and structures are designed to be compatible across both access methods.
Every view includes:
  • A primary key column (e.g., order_id, patient_id)
  • A last_updated timestamp for incremental loading
  • A vetcove_corporate_id for corporate group identification
  • An is_deleted flag for soft-delete awareness

​
Shared Models

These are the foundational dimension tables referenced by most other views.

​
Orders and Billing

Transactional views covering purchasing, invoicing, subscriptions, and discounts.

​
Clinical Care

Views covering appointments, medical records, prescriptions, and care reminders.

​
Care Plans

Views covering care plan definitions, benefits, clinic-specific pricing, and patient enrollments.

​
Inventory

Views covering organization-level and clinic-level inventory codes, preferences, and stock quantities.