---
title: All views
slug: redshift/all-views
icon: {"lucideIcon":"Eye"}
docTags: 
createdAt: 2026-10-01T12:31:18.029Z
---

### List of all views accessible via non-materialized views

Corrected against the current schema (previous list had a few typos, noted below). Each is prefixed with your client code except the global reference tables at the bottom.

**Financial** — see [Financial Data](docId\:zMph6r43D_fDJUlOI24gW)
`sale` · `charges` · `payments` · `new_invoice` · `predefined_discounts` · `sale_discount_mapping` · `treatments` · `sold_service_packages` · `sold_service_package_products`

**Stock & Services** — see [Stock & Services](docId\:up9_3heKVh32jzLj4BwZH)
`products` · `product_stocks` · `product_categories` · `product_reminders` · `service_packages` · `service_categories` · `reception_notes`

**Clients** — see [Clients](docId\:QF5XusJAIcCUsjZ2gk1uU)
`users` · `clients` · `userpetmapping` · `uservetmapping` · `user_clinic_observations`

**Patients** — see [Patients](docId\:DTYDzxTH4Dn9kWhVIGJRd)
`pet` · `patients` · `vetpetmapping` · `vetpetarchive`

**Medical** — see [Medical](docId:7J5uaR_3YkDF8a2rKt1hg)
`new_file_cases` · `diagnostics` · `prescriptions` (previous list had this as "presrciptions") · `new_checkup_groups` · `new_fields` · `new_field_values` · `new_field_options` · `new_group_rows`

**Operational** — see [Operational](docId\:ihfOVSdsrTypRZRuq0DWW)
`clinicvetmapping` · `roles_for_vet_permissions` · `rooms` · `custom_events` · `diary_categories` · `notification_periods` · `clinic_notification_periods`

**Appointments** — see [Appointments](docId\:jbkn-M_XeIg45t-mOe6qM)
`appointment` (previously listed as "appointments") · `appointment_requests` · `appointment_services` · `appointments_reschedules` (previously misspelled "reshedules") · `available_services`

**Global reference tables** (not client-prefixed)
`species` · `breeds` · `blood_types` · `countries` · `product_categories` · `service_categories` · `measurement_units` · `measurement_unit_types` · `measurement_unit_conversions` · `diary_categories`

:::hint{type="warning"}
`clinics`, `reminder_protocol_usage`, and `reminder_protocol_usage_items` are referenced on the Operational and Reminders pages but don't appear in this list. Either they should be added here, or those pages are documenting fields you don't actually have client-side access to — flagging for confirmation with the data team rather than guessing.
:::

Due to the sensitive nature of certain data and privacy considerations, we can't provide access to all Digitail tables. Contact us if you want to expand your access — this is considered case by case.