Prescriptions by liuhongmei

VIEWS: 17 PAGES: 6

									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 /       Average cost per patient.
Patient Count

(g) Cost of Fill /       Average cost per prescription.
Number of Fills

(h) Cost of Fill / 30    Average cost per 30-day supply.
Day Equivalency

(i) Cost of Fill /       Average cost per unit.
Quantity of Fill

(j) Day Supply /         Average days supply per fill.
Number of Fills

(k) Days Supply           Days of supply of fill.

                         VISTA File: 52.1 File Name: DAYS SUPPLY
                         FLD

(l) 30 Day               VISTA File: 59.12 File Name: QTY FLD
Equivalency              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    Patient Enrollment Priory
                        Category      Group
                             VISTA File: 2 Field Name:
                             27.01

Drug Class      Drug Class   Class of Drug.

                Drug         Generic Drug Name.

                Dosage       Dosage of Drug.

                             VISTA File: 50 File Name: VA
                             DRUG CLASS CODE FLD

                             VISTA File: 50 File Name:
                             GENERIC NAME FLD

Formulary       Formulary    Is the drug on the
                             formulary or not.
                Non-
                Formulary    VISTA File: 50 Field Name:
                             NON-FORMULARY FLD

Fill            Fill         Original fill or Refill

                Fill Sort    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          Item & DEA Special
                             Handling Codes
                Schedule 2
                             VISTA File: 50 Field Name:
                Schedule 3   DEA SPECIAL HDLG

                Schedule 4
                     Schedule 5

                     Supply

Mail or Window       Mail or      Prescription filled at the
                     Window       pharmacy window or by
                                  mail.

                                  VISTA File: 52 Field Name:
                                  MAIL/WINDOW

Patients             Site Name    Station where the
                                  prescription was filled.
                     First Char
                     Last Name    Local Field based on Individual
                                  Site Number (e..g. 663)
                     Patient
                                  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              First Ethnic Ethnic background of the
Demographic          Background patient.

                     Second     VISTA File: 13-Feb Field Name:
                     Ethnic     Race FLD NUMBER
                     Background

Patient Geographic   State        State and county where the
                                  patient lives.
                     County
                                  VISTA File: 2 Field Name:
                                COUNTY FLD NUMBER:

                   Zip Code     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    Station where the
                                prescription was filled
                   First Char
                   Last Name    Local Field based on Individual
                                Site Number (e..g. 663)
                   Provider
                                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     Alliance where the
                                prescription was filled
                   Station
                                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 Year         Calendar year, quarter,
                                month the prescription was
Time.Fiscal_Year   Quarter       released.

                   Month         Fiscal year, quarter, month
                                 the prescription was
                                 released.

                                 VISTA File: 52.1 File Name:
                                 RELEASE DATE FLD NUMBER:
                                 .17

Patient Age        Age Group     Age range of the patient
                                 when the prescription was
                   Patient Age   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

								
To top