ComputerRx

1. Create a view for your data.

a) You’ll first want to create a “view” including all of the data-points you want, and none of the data-points you don’t want. Run a very limited dispense report (like filled today) by navigating to Reports>Dispensing Report>Detailed Dispensing.

i. ComputerRx will pull up your dispense report with your default view.

ii. In the top right of the screen, Press the blue + sign next to the view dropdown to create a new “view” - name it something like “Seguridad”

iii. Customize the view to match the data request, generally as follows:

1. Include columns (these are the specific data element names in ComputerRx):

Copay / Patient Pay

Date

Day Supply

Drug

Ethnicity

Fill Number

Margin

NDC

Patient Address

Patient Age

Patient Record

Patient Zip

Primary Payer BIN

Primary Payer Group No.

Primary Payer PCN

Quan.

Race

Refills Authorized

Retail

Rx Number

Rx Origin

Secondary Payer BIN

Secondary Payer Group No.

Secondary Payer PCN

Sex

Sig

Store NABP

2. Additional data elements that may not be available for download. Please find the closest match:

1. Dispensing Fee Paid

2. Dispensing Fee Submitted

3. Ingredient Cost Paid

4. Medication Strength

5. Primary Incentive Amount Paid

6. Primary Incentive Amount Submitted

7. Species (Animal, Human)

3. You may need a few more or a few less columns depending on the specific data request.

iv. Save the “view” as you have it set by clicking the Save button (floppy disk).

2. Pull the data requested

a) Put in filters for the specific request. For example:

i. In Start Date, put 1/1/2021, and End Date put 3/30/2021. (Quarterly results aid in data pull)

ii. The report will build (it may take some time).

b) Once the report has loaded and been filtered, press export at the bottom middle left of the screen to generate an excel file.

c) Name the excel appropriately per the work order, for example “Seguridad NABP DATE”.