Back to Top Skip to main content
Alert Arrow ALERT!!

There are emergency procedures in place for parts of world due to weather.

Get the latest information on emergency prescription refills and PCM referral waivers. 

Business Objects

One of the primary functions of the Pharmacy Analytics Support Section (PASS) Data Management Team (DMT) is to support Department of Defense (DoD) personnel throughout the Military Health System (MHS) by providing timely and accurate reports on the data maintained in the central repository within the Pharmacy Data Transaction Service (PDTS). The DMT uses the Business Objects software application to pull information from the PDTS Data Warehouse and presents the information to individuals in EXCEL or ACCESS format, depending on which format best supports the presentation of the data and the capabilities of the requester.

In addition to running a variety of ad hoc type reports that are unique to an individual request the DMT has also developed several standard reports that have been designed to provide detailed data on a specific Point of Service, Branch of Service, Catchment Area, MTF, Provider or Patient as needed. There are also overview type reports that can be used to monitor antibiotic utilization or drug use by therapeutic class, either AHFS or GC3. Below is a list of the Standard Reports available to the DoD Pharmacy Community.

PDTS Standard Report Templates

Below are PDTS Report Templates that may be downloaded by individuals who have received training in the PDTS Business Objects class and have valid password access. The reports are located in the Template Library in the Public Folder Section of Business Objects.

Each template includes preset variables in the header lines that return information specific to the report. For example, there is a variable that will return the date range the user specifies for the report and the date the report is ran. Some reports also include a variable that returns the name of the selected MTF or DMIS ID code under the title: Report Population. If you have any problems using these templates, have questions about the data they generate or you have suggestions for future templates, please feel free to contact a member of the Pharmacy Analytics Support Section’s (PASS) Data Management Team at link below or call the PASS at 1-866-275-4732 or 210-536-6650.

Email the PASS Team

  • 101 - Antibiotic Use by AHFS Report TemplateThis template allows the user to monitor oral antibiotic drug utilization within a specific MTF or multiple MTFs. The report runs two reports in one all off the MTF Site Name. The report provides an aggregate total of all new prescriptions filled and the number of unique users for the selected MTF(s) just below the report headers. Then below that, it will provide a list of all new prescriptions for oral antibiotics prescribed during the report period grouped under the selected MTF(s) name and the AHFS Code and its description. The list will contain the generic name, strength and dosage form of the drug along with the number of RXs, Total Quantity Dispensed, Average Quantity per RX and the number of Utilizers for that specific drug item. Prior to running the report you will need to edit Query 2 by changing the AHFS Matches pattern variable to the AHFS codes to be surveyed. If you need help with this process please contact someone from the Data Management Team using the link or phone numbers above. To run the report you will be asked to complete three prompts, the first date and the last date of the report period and to select a specific MTF. When you click on the prompt “Enter value(s) for Site MTF:” a list of MTFs will appear in a box on the left and you highlight the site you want and move it to the box on the right. You can repeat the process to select more than one MTF. The report output will separate the data for each selected MTF by the Site MTF name. As a reminder, this report template has been set up to show data from one AHFS Antibiotic Class, 0812. If you want data from a different antibiotic class you need to edit the AHFS Matches Pattern condition in query two to match your required output.Antibiotic Use by AHFS Report Template
  • 102 - Catchment Area Drug Use Report TemplateThis template allows the user to monitor drug utilization from within Retail and Mail Order of a specific MTF catchment area. The report runs two reports in one and is based on the site's DMIS ID code. The data is presented in two separate tabs, one with Retail data and one with Mail data. The Retail tab contains the drugs being dispensed by Retail pharmacies located within the site’s catchment area while the Mail tab has the drugs dispensed by the Mail Order pharmacy for patients living within the same catchment area. Each tab will contain the generic name, strength, and dosage form of the drug along with the number of RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply per RX, Total Submitted Amount Due and the number of Utilizers. To run the report you will be asked to enter the first date and the last date of the report period and then select a Pharmacy DMIS ID and a Patient DMIS ID. Remember, they are both the same DMIS ID code; they just refer the search to different files to pull the data. You select a DMIS ID by clicking on the prompts “Select Pharmacy DMIS:” and “Select Patient DMIS:” and a list of DMIS codes will appear. Highlight the one you want and move it to the box on the right. You can select just one DMIS ID per report.Catchment Area Drug Use Report Template
  • 103 - Corporate Report by DMIS ID Report TemplateThese templates allow the user to monitor prescription workload and expenditures for all points of service within a catchment area. The report runs multiple reports in one and is based on the site's DMIS ID. The data is presented in two separate tabs, one with MTF, Retail & VA (if available) data and one with Mail data. The MTF, Retail & VA tab contains the data pulled from the MTF, Retail and VA pharmacies located within the site’s catchment area while the Mail tab has the data pulled from the Mail Order pharmacies for patients living within the same catchment area. The report gives you a global look of your catchment area workload and expenditures. The data has been formatted so it is broken out by "All Ages”, “Under Age 65”, and “Age 65+”. In addition to the Service Category and Site MTF, each group shows the number of RXs, the Total Submitted Amount Due, the Average Days Supply, the Average Due per RX, the number of 30-day EQ RXs, the Average Due per 30-day EQ RX, the number of Utilizers and the Average Due per Utilizer.  On the MTF, Retail & VA tab, when there are multiple MTFs within the catchment area, each MTF will appear as a separate line entry in the output. To run the report you will be asked to enter a first date and a last date and then select a Pharmacy DMIS ID and a Patient DMIS ID. Remember, they are both the same DMIS ID codes; they just refer the search to different files to pull the data. You select a DMIS ID by clicking on the prompts “Select Pharmacy DMIS:” and “Select Patient DMIS:” and a list of DMIS codes will appear. Highlight the one you want and move it to the box on the right. You can select just one DMIS ID per report.Corporate Report by DMIS ID Report Template
  • 104 - Drugs Dispensed by MTF Report TemplateThis template allows the user to monitor the types of drugs dispensed at one MTF or a group of MTFs for a specific period of time. The report ranks the drug usage by prescription count and by dollar expenditures, greatest to least, and presents the output on separate tabs. Each tab shows the generic name, strength and dosage form of the drug along with the number of RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply, Total Submitted Amount Due and number of Utilizers. To run the report you will be asked to enter the first date and the last date of the report period and to select a specific MTF. You select the MTF by clicking on the prompt “Select MTF Site:” and a list of MTFs will appear. Highlight the MTF you want and move it to the box on the right. You can select more than one MTF, however, if you select two or more, the data will be expressed as an aggregate of all the selected MTFs. Drugs Dispensed by MTF Report Template
  • 105 - Drugs Dispensed by PoS Report TemplateThis template allows the user to monitor the types of drugs dispensed from a specific point of service (Service Category) over a specific period of time. Unlike the Catchment Area Drug Use Report that pulls Retail and Mail Order data from a selected catchment area, this report pulls all the data from either of the three primary points of service (MTF, Retail or Mail). The report ranks the drug usage by prescription count and by dollar expenditures, greatest to least, and presents the output on separate tabs. Each tab shows the generic name, strength and dosage form of the drug along with the number of RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply, Total Submitted Amount Due and number of Utilizers. To run the report you will be asked to enter the first date and the last date of the report period and to select a specific Service Category. You select the Service Category by clicking on the prompt “Select Claim Service Category:” and a list of Service Categories will appear. Highlight the Service Category you want and move it to the box on the right. You can select more than one Service Category, however, if you select two or more, the data will be expressed as an aggregate of all the selected Service Categories.Drugs Dispensed by PoS Report Template
  • 106 - Drug Use by GC3 Code and DMIS ID Report TemplateThis template allows the user to monitor drug utilization by therapeutic class within a selected MTF catchment area. The report will compile data based on selected therapeutic drug classes (GC3 Codes) while pulling it from a specific MTF catchment area (DMIS ID). The output is presented on separate tabs, one for each point of service and contains the following data elements: Service Category, Site MTF, GC3, GC3 Description, Age 65 Pre/Post, number of RXs, Total Submitted Amount Due, Average Days Supply, Average Due per RX, and number of Utilizers. The user has the opportunity to select one or more GC3 codes per report but must select only one DMIS ID. If there is more than one MTF located within the selected catchment area, the MTF report will list the GC3 utilization separately for each Site MTF. To run the report you will be asked to enter the first date and the last date of the report period and then select at least one GC3 code, a Pharmacy DMIS ID and a Patient DMIS ID. You select a GC3 code and DMIS ID by clicking on the appropriate prompt and a list of codes and DMIS IDs will appear. Highlight the one you want and move it to the box on the right. Remember, the Pharmacy and Patient DMIS ID are both the same codes; they just refer the search to different files to pull the data. You can select just one DMIS ID per report. Drug Use by GC3 Code and DMIS ID Report Template
  • 107 - DUR Edits and Level 1 DDI by MTF Report TemplateThis template allows the user to monitor ProDUR warning messages with emphasis on Level 1 Drug-Drug Interactions. The report runs three reports in one and is based on the MTF Site Name. Each report is presented on a separate tab with. The first tab is a summary of all the types of ProDUR warning messages reported by PDTS for the MTF during the report period and labeled DUR Summary. The second and third tabs concentrate on the Level 1 Drug-Drug Interactions showing the DDIs identified by each dispensing site within the MTF and then breaking them out by pharmacy and showing the medications involved in the interaction. To run the report you will be asked to enter the first date and the last date of the report period and to select a specific MTF. You select the MTF by clicking on the prompt “Select MTF Site:” and a list of MTFs will appear. Highlight the MTF you want and move it to the box on the right. You can select more than one MTF and the DUR Summary tab will separate the data by MTF. The second and third reports will still breakout the data out by pharmacy and the specific medications involved.DUR Edits and Level 1 DDI by MTF Report Template
  • 108 - Level 1 DDI Transaction Details by MTF Report TemplateThis template allows the user to see the specific details of each prescription involved in an overridden potential Level 1 Drug-Drug Interaction warning message during a specific period. The report supports the data collected in the DUR Edits and Level 1 DDI template discussed above but can be used independently to monitor Level 1 DDIs. There are two tabs in the template, one showing the raw data and a second (Reported Data) that displays the data in a table format based on the PDTS prescription number representing the transaction for the current medication. The report pulls together specific information on all the drugs identified as having a potential level 1 drug-drug interaction. Under the headings of “Current Medication”, the prescription being submitted at the time the ProDUR warning message is received and “Profiled Medication”, the medication already on the patient’s profile, the report shows the following data elements: RX Number, Drug Name, Dispensed Date, Metric Quantity, Days Supply, Provider ID number, Provider Name, Patient ID number (DEERS ID number), Pharmacy ID number, and Pharmacy Name. To run the report you will be asked to enter the first date and the last date of the report period and to select a specific MTF. You select the MTF by clicking on the prompt “Select MTF Site:” and a list of MTFs will appear. Highlight the MTF you want and move it to the box on the right. If you select more than one MTF, the only way to identify the transactions of each MTF is by the name of the dispensing pharmacy shown under the current medication data.Level 1 DDI Transaction Details by MTF Report Template
  • 109 - MTF Drug Usage by NDC Report TemplateThis template allows the user to monitor the drugs dispensed by a specific MTF or a group of MTFs for a specific period of time. It differs from Standard Report #104 by breaking the drugs down to the NDC number level. The report ranks the drug usage by prescription count and by dollar expenditures, greatest to least, and presents the output on separate tabs. For each drug dispensed the report shows its generic name, dosage form, strength and NDC number (as submitted by the site). Also, shown is the total number of RXs, the Total Quantity Dispensed (Metric Quantity as defined by First Data Bank), the Average Quantity per RX, the Average Days Supply per RX, the Total Submitted Amount Due (ingredient cost for MTFs), the Average Due per RX and the number of Utilizers for that specific drug. To run the report you will be asked to enter the first date and the last date of the report period and to select a specific MTF. You select the MTF by clicking on the prompt “Select MTF Site:” and a list of MTFs will appear. Highlight the MTF you want and move it to the box on the right. You can select more than one MTF, however, if you select two or more, the data will be expressed as an aggregate of all the sites selected.MTF Drug Usage by NDC Report Template
  • 110 - Patient Profile by DEERS ID Report TemplateThis template is designed to provide a patient profile that allows the user to obtain drug information over a greater period of time than what is available from the On-Line Patient Profile function in CHCS. The report provides the following data elements for each prescription that is active and on the patient’s profile during a given period of time: Date Dispensed, PDTS RX Number, drug generic name, strength and dosage form, Quantity Dispensed, Days Supply, Service Category, Site MTF, Pharmacy Name, Provider’s ID number and Name if a valid NPI or DEA number was submitted. If the number is invalid the provider name will appear as “Not on file”. There is a line above the data that returns the patient’s name and DEERS ID. To run the report you will be asked to enter the first date and the last date of the report period and to enter the patient’s DEERS ID. You enter the patient’s DEERS ID by clicking on the prompt “Select MTF Site:” You should enter just one DEERS ID per report. Note – the best format to run a patient profile is with the DEERS ID as that is the unique patient identifier in PDTS. If you do not have access to the DEERS ID you can use the patient’s SSN with the template below but there is the chance you may not pull all prescriptions for the patient as PDTS may not obtain the SSN on all transactions due to a potential time lag in validating patient eligibility and returning the information to the submitting pharmacy.Patient Profile by DEERS ID Report Template
  • 111 - Patient Profile by SSN Report TemplateThis template provides the same patient profile information discussed above but in lieu of the patient’s DEERS ID, the report is based on the patient’s SSN. The report provides the same data elements for each prescription that is active and on the patient’s profile during a given period of time: Date Dispensed, PDTS RX Number, drug generic name, strength and dosage form, Quantity Dispensed, Days Supply, Service Category, Site MTF, Pharmacy Name, Provider’s ID number and Name if a valid NPI or DEA number was submitted. If the number is invalid the provider name will appear as “Not on file”. There is a line above the data that returns the patient’s name, SSN and DEERS ID. To run the report you will be asked to enter the first date and the last date of the report period and to enter the patient’s SSN. Remember, this is the patient’s SSN, not their sponsor’s SSN. You should enter just one SSN per report. Note – as stated above, the best format to run a patient profile is with the DEERS ID as that is the unique patient identifier in PDTS. If you do not have access to the DEERS ID you can use the patient’s SSN but there is the chance you may not pull all prescriptions for the patient as PDTS may not obtain the SSN on all transactions due to a potential time lag in validating patient eligibility and returning the information to the submitting pharmacy.Patient Profile by SSN Report Template
  • 112 - Provider Profile Report TemplateThis template has been designed to generate a provider profile to allow the user to review all the medications filled against a specific provider ID number over a given period of time, regardless of the point of service. The report provides the following data elements: Date Dispensed, drug generic name, strength and dosage form, DEA Class, PDTS RX Number, Quantity Dispensed, Days Supply, Patient Name and DEERS ID, Service Category, Site MTF and Pharmacy Name. Also, there is a line above the data that returns the provider’s name and ID number. The name will appear only if the provider’s ID is a valid NPI or DEA number. Otherwise the phrase “Not of File” will appear in lieu of the provider’s name. To run the report you will be asked to enter the first date and the last date of the report period and to enter the provider’s ID number (NPI or DEA number). You enter the provider’s ID by clicking on the prompt “Enter value(s) for Prescriber Code”. You should enter just one provider ID per report.Provider Profile Report Template
  • 113 - AHFS Classes by PoS Report TemplateThis report allows the user to monitor the medications from within a specific point of service (Service Category) over a given period of time by the American Hospital Formulary Service (AHFS) therapeutic class. The report provides two tabs, one with the AHFS Classes ranked based on prescription count and the other ranked based on total submitted amount due. The template has been designed to exclude compounded prescriptions as they can misrepresent the data within a given class. Each tab presents the following data elements: AHFS code, AHFS description, total number of prescriptions, average days supply, total submitted amount due and the number of unique utilizers for each class. To run the report you will be asked to enter the first date and the last date of the report period and to select a Claim Service Category. You select the Service Category by clicking on the prompt “Select Claim Service Category:” and a list of Service Categories will appear. Highlight the Service Category you want and move it to the box on the right. You can select more than one Service Category, however, if you select two or more, the data will be expressed as an aggregate of all selected.AHFS Classes by PoS Report Template
  • 114 - GC3 Classes by PoS Report TemplateThis report allows the user to monitor the medications from within a specific point of service (Service Category) over a given period of time by First DataBank’s GC3 therapeutic class. The report provides two tabs, one with the GC3 Classes ranked based on prescription count and the other ranked based on total submitted amount due. The template has been designed to exclude compounded prescriptions as they can misrepresent the data within a given class. Each tab presents the following data elements: GC3 code, GC3 description, total number of prescriptions, average days supply, total submitted amount due and the number of unique utilizers for each class. To run the report you will be asked to enter the first date and the last date of the report period and to select a Claim Service Category. You select the Service Category by clicking on the prompt “Select Claim Service Category:” and a list of Service Categories will appear. Highlight the Service Category you want and move it to the box on the right. You can select more than one Service Category, however, if you select two or more, the data will be expressed as an aggregate of all selected.GC3 Classes by PoS Report Template
  • 115 - Header Info TemplateThis template is not designed to run a report. It is offered as a means to obtain specific header information that you can use to present at the beginning of each report you build yourself. The Title and Report population cells are left open for you to type in the appropriate information relative to the report you are running. The bottom three blank boxes will fill in automatically each time a report is completed based on some variable formulas that have been built into the template. Webi does not have the option to save a report as a template therefore have two options for using this template. You can call up the report each time you build a new report and edit the query panel and the Date Ran variable as needed or you can call up the report and add another query panel to what is already there. If you add a second query panel you will need to apply the changes when closing the query. At this time you need to select the option “Insert a table in the current report”. This will add the output from the second query on the tab with the preloaded headers. Either way, the appropriate fields (Date Range, Date Ran, User Name) will automatically fill in the headers.Header Info Template

Report Request Forms

Business Object Reference

  • Webi Business Objects 4.2 user guide is currently in development.

If you are interested in obtaining access to the Pharmacy OPS Business Objects, please send us an email. Information on how to obtain access will be emailed to you. For any questions, please contact the PASS at 1-210-536-6650 and ask for someone on the Data Management team.

DHA Address: 7700 Arlington Boulevard | Suite 5101 | Falls Church, VA | 22042-5101

Some documents are presented in Portable Document Format (PDF). A PDF reader is required for viewing: Download a PDF Reader or learn more about PDFs.