305H ProClarity for Pharmacy

1
305H ProClarity for Pharmacy

• Alan Celestino, R.Ph.
• Research Pharmacy Specialist
• Pharmacy Benefits Management Services

2
Learning Objectives

• Understand how to access ProClarity data cubes
  and have a knowledge of the terminology used
• Understand how to create custom members and sets
• Understand how to create views and Briefing Books

3
Learning Objectives (contd)

• Understand how to export data from ProClarity to
  other Microsoft applications (i.e. Excel /
  PowerPoint)
• Understand the PBM data cube structure
• Understand the PBM Briefing Books

4
Organization

• ProClarity definitions
• Brief ProClarity UI overview
• Create custom reports with ProClarity
• PBM data cube structure
• PBM Briefing books
• Create more custom reports based the PBM Briefing
  Books

5
Definitions
6
Definitions

• Data Cube
• Collection of data that is organized for rapid
  query response and designed for analysis
• Derived from relational tables or a data
  warehouse
• OLAP Client
• Application that enables browsing and analysis of
  data cubes (e.g. ProClarity)

7
Definitions

• Briefing Book
• File that contains saved views (reports)
  organized into folders
• Interactive and updates automatically
• Enables those with little or no knowledge of
  ProClarity to view and modify reports
• ProClarity Analytics Server (PAS)
• Software that stores briefing books centrally
• Provides connection to data cubes
• Enables access with a web browser

8
Definitions

• Dimension
• A descriptive category by which the numeric data
  of a cube is analyzed, e.g. Time, Location, Drug
• The how or by portion of the analysis, e.g.
  by Station by Month by Drug
• Measure
• The numeric values you want to analyze
• The what portion of the analysis, e.g. Total
  Cost, Total Quantity, Total Rxs, etc.

9
Definitions

• Hierarchy
• The organization of data within a dimension
  grouped in levels of most general to most
  specific, e.g. All Time, Year, Quarter, Month
• Level
• A specific layer in a hierarchy, e.g. Month
• Member
• A specific value within a level, e.g. January

10
ProClarity Client

• ProClarity Enterprise Agreement (EA)
• Desktop Professional
• Software (latest version 6.3)
• Only versions 6.1 or higher work with SQL 2005
  cubes
• Web Professional
• Web access (rich client)
• Software not required
• Download plug-in if software not installed
• Same functionality as Desktop Professional
• Web Standard
• Web access (thin client)
• Software not required

11
PBM ProClarity Access

• VISN Formulary Leader Approval
• VISN and National access
• Requests sent to Alan.Celestino_at_va.gov
• Signed Data Use Agreement must be scanned and
  emailed back and/or mailed back

12
Web Access
13
PBM Data Cube Structure
14
Outpatient Cube Dimensions

• VISN
• Nation, VISN, Facility, Clinic
• Time
• Fiscal Year, Fiscal Quarter, Month
• Drug
• General Class, VA Class, Generic Name, VA Product
• Complexity
• Replaced MCG levels

15
Outpatient Cube Dimensions

• RxType
• Legend, OTC, Brand, Generic
• Fill
• 30-day fill, 60-day fill, 90-day fill
• Mail/Window
• CMOP/Local
• New/Refill/Partial
• National Formulary
• Local Formulary

16
Measures Basic

• Rxs
• Day30Rxs
• Unique Patients
• Day Supply
• Quantity
• Cost

17
Measures Calculated

• Cost/Day
• Cost/Day30Rx
• Cost/Unique Patient
• Cost/Rx
• Cost/Unit
• Day30Rxs/Unique Patient
• Rxs/Unique Patient

18
Measures Calculated

• Day30RxsAll Drug
• Day30Rxs for selected drug as a of Day30Rxs for
  all drugs in the Drug dimension.
• Day30RxsParent
• Day30Rxs for selected drug as a of Day30Rxs for
  its parent in the Drug dimension.

19
Measures Calculated

• Unique PatientsAll Drug
• Unique Patients for selected drug as a of
  Unique Patients for all drugs in the Drug
  dimension.
• Unique PatientsParent
• Unique Patients for selected drug as a of
  Unique Patients for its parent in the Drug
  dimension.

20
Measures Calculated

• RxsAll Drug
• Actual Rxs for selected drug as a of Actual Rxs
  for all drugs in the Drug dimension.
• Total CostAll Drug
• Total Cost for selected drug as a of Total Cost
  for all drugs in the Drug dimension.
• Dose/Day
• (QuantityStrength)/Day Supply for oral tablets
  and capsules only

21
Inpatient Cubes

• Unit Dose cube (PharmacyUD)
• - Data from April 2004 to present
• IV cube (PharmacyIV)
• -Data from October 2002 to present

22
Unit Dose Cube Dimensions

• VISN
• Nation, VISN, Facility
• Time
• Fiscal Year, Fiscal Quarter, Month
• Drug
• General Class, VA Class, Generic Name, VA Product

23
Unit Dose Cube Measures

• Orders
• Total Cost
• Total Qty
• Unique Patients
• Cost per Unit

24
IV Cube Dimensions

• VISN
• Nation, VISN, Facility
• Time
• Fiscal Year, Fiscal Quarter, Month
• Drug
• General Class, VA Class, Generic Name, VA
  Product,
• VA Product Dispensed Unit
• IV Type
• Admixture, Chemo, Hyperal, Piggyback, Syringe

25
IV Cube Measures

• Bags
• Orders
• Total Cost
• Unique Patients
• Cost/Bag
• Cost/Unique Patient
• Cost/Unit
• Total Qty

26
PBM ProClarityBriefing Books
27
Briefing Books Overview

• FY08 National Monitors (15 views)
• Deputy Under Secretary for Health for Operations
  and Management Monitors For FY 2008.
• Global Measures (25 views)
• Views of overall drug utilization, such as
  cost/30-day Rx by month and top 25 drugs by total
  cost for a quarter.

28
Briefing Books Overview

• Drug Utilization (94 views)
• Views of specific drug utilization as 30-day Rxs
  of drug class or of all drugs as appropriate.
• Tablet Splitting (28 views)
• Views of adherence to tablet splitting and
  related measures for specific drugs.
• Contract Adherence (28 views)
• Views of adherence to Specific VA Contracts.

29
Drug UtilizationBriefing Book
30
Drug Utilization Views

• (Drug) Day30Rxs Class
• (Drug) Day30Rxs All Drug
• Day30Rxs
• Corrects for differences in multi-month
  dispensing
• All Drug
• Provides a common denominator for comparing
  VISNs/Facilities of different sizes
• Class
• Corrects for differences in patient populations

31
Drug Utilization Contents

• ACEs
• Alpha Antagonists
• ARBs
• Atypical Antipsychotics
• CCBs
• COX-2s
• HMGs
• NSAHs

• Ophthalmic Prostaglandins
• Opioids
• PDE-5s
• PPIs
• SSRIs
• Triptans
• TZDs
• Misc

32
Tablet SplittingBriefing Book
33
Tablet Splitting Formulas

• Split Rxs
• Formula ½ tab once daily (qty/days supplylt1)
• Rxs that are currently being split (exactly in
  half to get the dose)
• Non-Split Rxs
• Formula 1 tab once daily (qty/days supply1)
• Rxs that are not currently being split, but can
  potentially be split (exactly in half to get the
  dose)
• Splittable Rxs
• Formula (Split Rxs Non-Split Rxs)
• Rxs that can potentially be split (exactly in
  half to get the dose)
• Adherence
• Formula Split Rxs /(Split Rxs Non-Split Rxs)

34
Tablet Splitting Limitations

• Must assume all are Once Daily
• Example Once Daily drug dosed Twice Daily
• Qty 30, Days Supply 30 (Tablet Splitting)
• Counts as Non Split
• Exception Carvedilol
• Assume all are Twice Daily
• Similar problem occurs if dosed Once Daily

35
Tablet Splitting Contents

• Atorvastatin
• Carvedilol
• Citalopram
• Losartan
• Paroxetine
• Sertraline
• Simvastatin

36
Tablet Splitting Views

• Views are centered around the percent adherence
  to tablet splitting
• Includes information needed to decide how
  aggressively to pursue a tablet splitting
  strategy
• Percentage of all Rxs that are splittable
• e.g. If one drug has 40 of its Rxs splittable
  and another drug has 80 of its Rxs splittable,
  want to pursue drug with more splittable Rxs
• Savings per Rx by tablet splitting
• Volume of the drug (from cube)

37
Tablet Splitting Views

• (Drug) Split Day30RxsSplittable
• This is Adherence to Tablet Splitting, which is
  Day30Rxs that are currently being split /
  Day30Rxs that can potentially be split (exactly
  in half to get the dose).
• (Drug) Splittable Day30RxsAll (Drug)
• Since not all Rxs will be able to be split in
  half to get the desired dose, this shows the
  Day30Rxs that can potentially be split / All
  Day30Rxs for the Drug.

38
Tablet Splitting Views

• (Drug) Split vs. Non-Split Cost/Day30Rx
• This shows the Cost/Day30Rx for Split and
  Non-Split Rxs (nationally).
• (Drug) Cost/Day30Rx Difference
• This shows the difference (savings) for a Split
  Day30Rx vs. Non-Split Day30Rx (nationally).

39
Future Development

• ICD-9 Cube
• Lab Cube
• Allergy Cube
• CMOP Costs Cube

40
Miscellaneous

• OLAP Online Analytical Processing
• VA ProClarity software download link
  http//vhaaacapp3.vha.med.va.gov/proclarityea/
• MDX Reference book Fast Track to MDX