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   o n 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 Patient Weight Formatted Patient Active Allergy List Patient Latest Serum Creatinine Lab Result *** Please note that when adding patient weight, you must select the option for "Patient Weight Formatted"  not "Patient Weight Ounces" otherwise our system will be unable to process the data*** 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. 1. Select Menu in the top right corner of the green results box. 2. Choose Export to Excel 3. Name and save 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.