PioneerRx Support Center Knowledge Base Article ID: 2948
Subject: Installers - Common Report Design Data Field Scripting
Support Category: Software - PioneerRx
Support Item: Reports/Advanced Search
Functional Area: Edit a Report
There are many common requests that we get on a weekly basis, that are compiled here for easy access.
MM/DD/YYYY (Date entered in Data Entry Lot Expiration OR Fill Date + 1 Year)
=TexasDoNotUseBeyond.Substring(17,10).ToString().ToUpper()
Expires: MM/DD/YYYY (Date entered in Data Entry Lot Expiration OR Fill Date + 1 Year)
="Expires: "+TexasDoNotUseBeyond.Substring(17,10).ToString().ToUpper()
XX ?(First 2 letters of Patient last name)
=PatientLastName.Substring(0,2).ToString().ToUpper()
RPh/tech: XXX/xxx
="RPh/tech: "+PharmacistInitials+"/"+TechInitialsLowerCase
Rx#0000000 X (The X will be replaced with N for new fills (00), R for refills (01+), and O for on hold scripts)
="Rx#"+RxNumber+" "+ScriptType.Substring(0,1).ToString().ToUpper()
Rx# 0000000 X RR (Above, PLUS the "RR" will be the refill number.
="Rx# "+RxNumber+" "+ScriptType.Substring(0,1).ToString().ToUpper()+RxNumberWithFillNumber.Substring(7,3).ToString().ToUpper()
^ Only works with 7 digit Rx Numbers. For 8 digit, switch the 7 to an 8.
QR Code for Stamps.com
=PatientDeliveryName2+”\r"+PatientDeliveryAddress2+”\r“+PatientDeliveryCityStateZip2
QR Code for UPS Worldship: Reads Patient Mailing Address from Prescription Label (before POS)
=PatientName+"\r \r \r"+PatientMailingAddress+"\r \r \r \r"+PatientDeliveryZip2+"\r"+PatientCurrentLocationCity+"\r"+PatientCurrentLocationState+"\r"+PatientCurrentLocationPhone+"\r"+PatientEmail
Lot: XXXX Exp: MM/DD/YYYY
="Lot: "+LotNumber+" Exp: "+TexasDoNotUseBeyond.Substring(17,10).ToString()
Patient Education - Drug Name, Drug Print Name
=PatientEducationHeader.Replace("Patient Education - ","")
Requires Patient Education: On Label in Location Options
Hazardous Drug: True: "Hazardous"
=IsHazardousDrug == "Yes"? "Hazardous":""
^When IsHazardousDrug == Yes, print, "Hazardous". When ==false, print <blank>.
DEA Schedule: 2: "CONTROLLED SUBSTANCE. DANGEROUS UNLESS USED AS DIRECTED."
=DeaSchedule == "2"? "CONTROLLED SUBSTANCE. DANGEROUS UNLESS USED AS DIRECTED.":""
^ If the medication is a C2, print the above message.
DEA Schedule: 2,3,4,5: "CONTROLLED SUBSTANCE. DANGEROUS UNLESS USED AS DIRECTED."
=DeaSchedule == "0"? "":"CONTROLLED SUBSTANCE. DANGEROUS UNLESS USED AS DIRECTED."
^ If the medication is >>NOT<< a LEGEND, print the above message.
DifferentItemBetweenFillsWarningBasedOnManufacturer: "Look of drug may have changed since last fill: THIS IS THE SAME MEDICATION YOU HAVE BEEN GETTING. COLOR, SIZE, OR SHAPE MAY APPEAR DIFFERENT."
=DifferentItemBetweenFillsWarningBasedOnManufacturer == "Look of drug may have changed since last fill"? "THIS IS THE SAME MEDICATION YOU HAVE BEEN GETTING. COLOR, SIZE, OR SHAPE MAY APPEAR DIFFERENT.":""
^If the medication has changed manufacturers since the previous fill, print the above message.
if CycleFillStartDate: not blank or null: return DateFilled.; if CyclleFillStartDate: exists: return CycleFillStartDate
=CycleFillStartDate != null && CycleFillStartDate != ""? CycleFillStartDate : DateFilled
^If the CycleFillStartDate is not populated, it will return the DateFilled. If the CycleFillStartDate is populated, it will return the CycleFillStartDate.