Chapter 5: Choose My Pharmacy® PMS Support
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/Patient Central ID |
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)
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.
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)
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.
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)
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.