A decentralized university medical center pharmacy requires a year-end physical inventory with specialized reporting for expired product, pre-expired product, control drugs and therapeutic formulary classifications. Due to the decentralized environment many pharmaceuticals are in repackaged containers or in dispensing "picking" stations.
A decentralized university medical center pharmacy requires a year-end physical inventory with specialized reporting for expired product, pre-expired product, control drugs and therapeutic formulary classifications. Due to the decentralized environment many pharmaceuticals are in repackaged containers or in dispensing "picking" stations.
THE CHALLENGE
Perform a Physical Inventory of the main pharmacy storage location and the ancillary pharmacy and satellite locations. Incorporate the collected data into a reporting system for the analytics required.
THE APPROACH
Perform a physical inventory using PDTs programmed for the collection of the required data elements, allow for barcode or manual input as required. Utilize portable dictation equipment as required for data collection in active work stations with limited product labeling.
Using HISI's proprietary WIZARDc data normalization system, the pharmacy’s purchasing & contract data from multiple sources is uploaded to the HISI database. All Unit of Measure information is verified and converted as necessary for accurate valuation and all descriptive data is washed for normalization.
Cutoffs are established; the physical count is completed according to a predetermined schedule and transmitted to an HISI processing center. The inventory data is valued from the data base upload described above and the reports are generated in the required electronic formats utilizing HISI’s Business Objects reporting system.
THE RESULT
An accurate, clean, valued and certified year-end fiscal inventory report for financial reporting.
A complete physical inventory detail report for pharmacy management.
An expired product report recapped by manufacturer for returns processing with drill down location features.
A pre-expired product report detailing all product 90 days from expiration with drill down location features.
Supplemental control drug reports in consolidated and location specific formats sorted by class for government reporting requirements.
Consolidated Therapeutic Classification reports for the university formulary committee review.
A decentralized university medical center pharmacy requires a year-end physical inventory with specialized reporting for expired product, pre-expired product, control drugs and therapeutic formulary classifications. Due to the decentralized environment many pharmaceuticals are in repackaged containers or in dispensing "picking" stations.