Cube: Prescriptions
Information Included:
Any outpatient prescription filled and released from
October 2006 – January 2010.
Information Excluded:
Any outpatient prescription record where the issue date, site, provider, patient, drug identification, quantity were null.
Any patient whose last name begins with ‘ZZ’.
Any patient with the first or last name of ‘TEST’.
Structure
Measures / Description and Source(a) Patient Count / Count of unique patient across the VISN based on the VID identifier found in the VPatient table.
(b) Provider Count / Count of unique providers across the VISN based on the VID identifier found in the VStaff table.
(c) Number of Fills / Number of fills.
VISTA File: 52 File Name: IEN
(d) Quantity of Fill / Amount of medication that was dispensed.
VISTA File: 52.1 File Name: QTY FLD NUMBER: 1
(e) Cost of Fill / (CurrentUnitPrice) * (Quantity)
VISTA File: 52 File Name: UNIT PRICE OF DRUG FLD
VISTA File: 52.1 File Name: QTY FLD NUMBER: 1
(f) Cost of Fill / Patient Count / Average cost per patient.
(g) Cost of Fill / Number of Fills / Average cost per prescription.
(h) Cost of Fill / 30 Day Equivalency / Average cost per 30-day supply.
(i) Cost of Fill / Quantity of Fill / Average cost per unit.
(j) Day Supply / Number of Fills / Average days supply per fill.
(k) Days Supply / Days of supply of fill.
VISTA File: 52.1 File Name: DAYS SUPPLY FLD
(l) 30 Day Equivalency / VISTA File: 59.12 File Name: QTY FLD NUMBER: 9
Will standardize filling and cost data when multi-month dispensing is used (e.g. 90 day quantity fills).
Dimensions / Hierarchy / Description and Source
Enrollment / Enrollment Category / Patient Enrollment Priory Group
VISTA File: 2 Field Name: 27.01
Drug Class / Drug Class
Drug
Dosage / Class of Drug.
Generic Drug Name.
Dosage of Drug.
VISTA File: 50 File Name: VA DRUG CLASS CODE FLD
VISTA File: 50 File Name: GENERIC NAME FLD
Formulary / Formulary
Non-Formulary / Is the drug on the formulary or not.
VISTA File: 50 Field Name: NON-FORMULARY FLD
Fill / Fill
Fill Sort / Original fill or Refill
Part of primary key, generated by DW. 0 indicates first fill, 1 for first refill, etc.
Fill Type / Fill Type / Partial Fill or Refill
Specifies the source for this record. If FillType=R then data from Vista file 52.1 (refill); if FillType=P then data from file 52.2 (partial fill)
Item_DEA Code / OTC
Schedule 2
Schedule 3
Schedule 4
Schedule 5
Supply / Item & DEA Special Handling Codes
VISTA File: 50 Field Name: DEA SPECIAL HDLG
Mail or Window / Mail or Window / Prescription filled at the pharmacy window or by mail.
VISTA File: 52 Field Name: MAIL/WINDOW
Patients / Site Name
First Char Last Name
Patient / Station where the prescription was filled.
Local Field based on Individual Site Number (e..g. 663)
Patient who received the prescription
VISTA File: 52/2 File Name: PATIENT FLD NUMBER: 2 POINTS TO: VISTA PATIENT file - ^DPT(
Patient Gender / Gender / Sex of the Patient
VISTA File: 2 Field Name: SEX FLD NUMBER: .02
Patient Demographic / First Ethnic Background
Second Ethnic Background / Ethnic background of the patient.
VISTA File: 13-Feb Field Name: Race FLD NUMBER
Patient Geographic / State
County
Zip Code / State and county where the patient lives.
VISTA File: 2 Field Name: COUNTY FLD NUMBER:
VISTA File: 2 Field Name: STATE FLD NUMBER: .115
VISTA File: 2 Field Name: ZIPCODE FLD NUMBER: .116
Patient Status / Status / Patient Deceased
Patient Not Deceased
VISTA File: 2 Field Name: 0.351
Providers / Site Name
First Char Last Name
Provider / Station where the prescription was filled
Local Field based on Individual Site Number (e..g. 663)
Provider who is the responsible for prescription.
VISTA File: 52/200 File Name: PROVIDER FLD NUMBER: 4 POINTS TO: NEW PERSON file - ^VA(200,
Visn20 / Alliance
Station / Alliance where the prescription was filled
Local Field based on Individual Site Number (e..g. 663)
Station where the prescription was filled.
Local Field based on Individual Site Number (e..g. 663)
Time.Calendar_Year
Time.Fiscal_Year / Year
Quarter
Month / Calendar year, quarter, month the prescription was released.
Fiscal year, quarter, month the prescription was released.
VISTA File: 52.1 File Name: RELEASE DATE FLD NUMBER: .17
Patient Age / Age Group
Patient Age / Age range of the patient when the prescription was refill or refilled.
VISTA File: 2 Field Name: Date of Birth FLD NUMBER: .03
VISTA File: 52.1 File Name: REFILL DATE FLD NUMBER: .01