Chapter 5: Choose My Pharmacy® PMS Support

PioneerRx
ComputerRx
Liberty
Rx30
QS/1
MicroMerchant
BestRx
FSI Foundation Systems

PioneerRx

Prescription Report

1. Go to the Rx tab

2. Select the binocular icon in the Data Entry section

3. In the Completed Between line, enter the date range

4. Press Search (F12) to generate the report

Once the report has been generated, create a new report design layout.

1. In the drop-down box next to View, select Expanded with Comments

2. Select the Field Chooser icon on the left side of the screen

3. Check the boxes of the data fields you want to report

PioneerRx

Date Filled

Days Supply

Dispensed Item Name

Dispensed Item NDC

Dispensed Item Strength

Dispensed Quantity

Origin

Patient Age

Patient Ethnicity

Patient Gender

Patient Paid Amount

Patient Primary Address

Patient Primary Zip Code

Patient Race

Patient Serial Number

Pharmacy NCPDP

Primary ICD10 Code

Primary ICD10 Code Description

Refill Number

Rx Number

Sig Code

4. Select the blue plus sign next to the View drop-down box

5. Name the layout

6. Press Search (F12) to regenerate the report with new data fields

Export the report to an excel file.

2. Choose Export to Excel

3. Name and save Excel document

Patient Weight & Allergy Report

1. Go to Patient tab

2. Select the binocular icon in the Patient section

3. In the Activity Between, enter the same date range used to generate the prescription report

4. Press Search (F12) to generate the report

Once the report has been generated, use the steps to create a new report design layout from above that includes Serial Number, Weight, and Patient Active Allergy List and regenerate the report.

Export, name, and save the report as an Excel document.

Patient Serum Creatinine Report

**If your pharmacy does not collect serum creatinine, there is no need to submit a report**

Create a patient category.

1. Go to the System tab

2. Select the Category icon

3. In the Category Scope drop-down box, select Patient

4. Press the green plus sign on the right side to create a new category

5. Provide a name and description for the category

6. Choose Auto in the Type drop-down

7. In box B (Any of These), press the green plus sign

8. Choose Any Lab Greater Than as a filter

9. Choose Comprehensive Metabolic Panel – Creatinine, Serum (SCr) as the lab

E. Enter 0 in the Greater Than box

P. Press Save (F12)

1.. Make sure the status of the category is active and press Save (F12)

You must process the category for it to immediately work, or it will not become active until the next day.

.1. Select the Actions drop in the top right

2. Choose Process Category Auto Filter Rules and follow the prompts

Use the patient category to generate a patient report

... Go to Patient tab

2. Select the binocular icon in the Patient section

3. In the Activity Between line, enter the same date range used to generate the prescription report

4. From the Category drop-down, select the patient category.

5. Press Search (F12)

This will generate a report of all the patients in your system with a SCr value on file. Choose or create a layout that includes the Serial Number. Export the report to an Excel document.

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):

Patient Record (please be sure you are selecting Patient Record and not Patient ID, as they are different)
Date
Drug
NDC
Patient Age
Diag. Code 1
Rx Origin
Day Supply
Quan.
Sig
Patient Address
Patient Zip
Sex
Race
Ethnicity

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

1. Patient Allergies

2. Patient Serum Creatinine

3. Species

4. Patient Weight

5. ICD-10 Description

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”.

Liberty

Generating Reports for Liberty

Select “Reporting” on the top
Select “Rx Data”
Right Click Top Row on the pop up box
Select "Column Chooser”
Add requested Seguridad Data Elements

Customer ID
Date Dispensed
Drug Name
Drug NDC
Customer Age
ICD Code
ICD10 Description
Origin Code
Customer Allergies
Customer Weight
Customer SrCr
Day Supply
Qty
Sigs
Customer Address
Customer Zip
Customer Species
Customer Gender
Customer Race
Customer Ethnicity

Use ‘Advance’ to update the time range
Save As Excel on Desktop

Rx30

General Field Name	Rx30 Field Name
Date Dispensed	FILLDATE
Patient Date of Birth	PATDOB
Directions	DIRECTION 1
Directions	DIRECTION 2
Directions	DIRECTION 3
Directions	DIRECTION 4
Directions	DIRECTION 5
Gender	GENDER
Patient Address/Household	PATADD1
Patient Address/Household	PATADD2
Insurance Status	PAYTYPE
Medication Days Supply	DS
Medication Indication ICD10	RXDIAG 1
Medication Name	DRUG NAME
Medication Origin	RXORIGIN
NDC	NDC
Patient ID	PATKEY
Prescription Number	RXNBR
Quantity Dispensed	QTY DSP
Patient Zip Code	PATZIP

QS/1

QS/1 support is currently unavailable at this time. Please submit your data as best you can using the following generic terms to guide you. Depending on the pharmacy management system, reports may be a single file with all data elements or may be multiple files. Please generate your Seguridad Data Reports from the pharmacy management system and submit the data as xls, xlsx, or csv.

De-identified Patient ID (patient serial number, customer ID, patient record)
Date Dispensed
Drug Name
Drug NDC
Customer Age (patient age)
ICD-10 Code
ICD-10 Description
Origin Code (prescription origin status, walk-in, electronic, telephone)
Patient Allergies
Patient Weight
Patient Serum Creatinine
Days Supply
Quantity Dispensed
Sig/Directions
Patient Address
Patient Zip Code
Patient Species (Human, Cat, Dog)
Gender
Race (White, Black, Asian, etc)
Ethnicity (Hispanic, Non-hispanic)

If you are unable to pull a specific data field - that is ok. Some pharmacy management systems do not report or save all data elements. Pharmacy performance may be lower in some measures, but Seguridad will work with the pharmacy management system to make this a reportable data element in the future.

Once you have submitted your data, please reach out to support@choosemypharmacy.com stating your pharmacy's NCPDP number and which PMS you submitted data from. A member of our team will reach back out to your with further information.

MicroMerchant

MicroMerchant support is currently unavailable at this time. Please submit your data as best you can using the following generic terms to guide you. Depending on the pharmacy management system, reports may be a single file with all data elements or may be multiple files. Please generate your Seguridad Data Reports from the pharmacy management system and submit the data as xls, xlsx, or csv.

De-identified Patient ID (patient serial number, customer ID, patient record)
Date Dispensed
Drug Name
Drug NDC
Customer Age (patient age)
ICD-10 Code
ICD-10 Description
Origin Code (prescription origin status, walk-in, electronic, telephone)
Patient Allergies
Patient Weight
Patient Serum Creatinine
Days Supply
Quantity Dispensed
Sig/Directions
Patient Address
Patient Zip Code
Patient Species (Human, Cat, Dog)
Gender
Race (White, Black, Asian, etc)
Ethnicity (Hispanic, Non-hispanic)

BestRx

BestRx support is currently unavailable at this time. Please submit your data as best you can using the following generic terms to guide you. Depending on the pharmacy management system, reports may be a single file with all data elements or may be multiple files. Please generate your Seguridad Data Reports from the pharmacy management system and submit the data as xls, xlsx, or csv.

De-identified Patient ID (patient serial number, customer ID, patient record)
Date Dispensed
Drug Name
Drug NDC
Customer Age (patient age)
ICD-10 Code
ICD-10 Description
Origin Code (prescription origin status, walk-in, electronic, telephone)
Patient Allergies
Patient Weight
Patient Serum Creatinine
Days Supply
Quantity Dispensed
Sig/Directions
Patient Address
Patient Zip Code
Patient Species (Human, Cat, Dog)
Gender
Race (White, Black, Asian, etc)
Ethnicity (Hispanic, Non-hispanic)

FSI Foundation Systems

FSI Foundation Systems support is currently unavailable at this time. Please submit your data as best you can using the following generic terms to guide you. Depending on the pharmacy management system, reports may be a single file with all data elements or may be multiple files. Please generate your Seguridad Data Reports from the pharmacy management system and submit the data as xls, xlsx, or csv.

De-identified Patient ID (patient serial number, customer ID, patient record)
Date Dispensed
Drug Name
Drug NDC
Customer Age (patient age)
ICD-10 Code
ICD-10 Description
Origin Code (prescription origin status, walk-in, electronic, telephone)
Patient Allergies
Patient Weight
Patient Serum Creatinine
Days Supply
Quantity Dispensed
Sig/Directions
Patient Address
Patient Zip Code
Patient Species (Human, Cat, Dog)
Gender
Race (White, Black, Asian, etc)
Ethnicity (Hispanic, Non-hispanic)