Back to Top Skip to main content

Business Objects

When the Pharmacy Data Transaction Service (PDTS) was first developed, one of its objectives was to establish a method to report on the data maintained in the central repository. While the Pharmacy Analytics Support Section (PASS) has had this capability from the beginning, it is now available to managers at various levels of DoD Pharmacy by way of using Business Objects software via an Internet Web Server.

To assist individuals in learning Business Objects, the PASS offers training sessions at Fort Sam Houston. The classes run for two days with each session consisting of one day of classroom presentations and working with the software. Then, one day orientation in the PASS to observe how Business Objects is being utilized. Pharmacists and Certified Pharmacy Technicians will receive 4 hours of ACPE approved CE. Individuals interested in attending a session will need approval from their service consultant and must obtain local funding. The PASS continues to provide reports upon request to sites where there is no one trained in Business Objects.

PDTS Standard Reports List

Below is a listing of PDTS Standard Reports available to the DoD Pharmacy Community. If you wish to have one of the standard reports done, please fill out the PDTS Reports Request Form and submit it via email as directed. If you have access to the PDTS data warehouse via Business Objects you can down load the report template and run the report yourself. The templates are located in the Corporate Document folder in Business Objects. 

If you have questions regarding the standard reports or their templates, feel free to contact the PASS and a member of the Data Management Team can assist you. If you don't find a standard report to meet your needs, you can ask for an adhoc report to be run based on the specific data needed.

  • 101 - Antibiotic Use by AHFSThese templates allow the user to monitor oral antibiotic drug utilization within a specific MTF. 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. Then it will provide a list of all new prescriptions for oral antibiotics prescribed during the report period and grouped under the AHFS Code and its description. The list will contain the GCN number, generic name, strength and dosage form of the drug along with the # of RXs, Total Quantity Dispensed, Average Quantity per RX and the # of Unique Utilizers for that specific drug item. To run the report you will be asked to enter a start date and an end date and to select a specific MTF. You select an MTF by clicking on the Value button to the right of the box. A list of MTFs will appear and you highlight the site you want. You can select more than one MTF. However, if you select more than one, the data will be expressed as an aggregate of all the sites selected. For those using the Webi template your list of MTFs is already shown so you simply select the appropriate MTF.Antibiotic Use by AHFS
  • 102 - Catchment Area Drug UseThese templates allow the user to monitor drug utilization from within Retail and Mail Order of a specific 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 Network pharmacies located within the site´s catchment area while the Mail tab has the drugs dispensed by the Mail Order pharmacies for patients living within the same catchment area. Each tab will contain the GCN number, generic name, strength, and dosage form of the drug along with the # of RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply per RX, Total Submitted Amount Due and the # of Unique Utilizers. To run the report you will be asked to enter a start date and an end date and then select a Patient DMIS ID and a Pharmacy DMIS ID. You select a DMIS ID by clicking on the Value button to the right of the box. A list of DMIS codes will appear and you highlight the one you want. Remember, the Patient and Pharmacy DMIS ID are both the same code; they just refer the search to different files to pull the data. You can select only one DMIS ID per report. For those using the Webi template your list of DMIS IDs is already shown so you simply select the appropriate number.Catchment Area Drug Use
  • 103 - Corporate Report by DMIS IDThese templates allow the user to monitor prescription workload and expenditures for all three 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 data and one with Mail data. The MTF & Retail tab contains the data pulled from all the MTFs and Retail Network 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+". Within each group you have the # of RXs, Total Submitted Amount Due, Average Days Supply, Average Due per RX, # of Unique Utilizers and the Average Due per Utilizer. On the MTF & Retail tab, when there are multiple MTFs within the catchment area, they each will appear as a separate line entry in the output. To run the report you will be asked to enter a start date and an end date and then select a Patient DMIS ID and a Pharmacy DMIS ID. You select a DMIS ID by clicking on the Value button to the right of the box. A list of DMIS codes will appear and you highlight the one you want. Remember, they are both the same DMIS ID code; they just refer the search to different files to pull the data. You can select only one DMIS ID per report. For those using the Webi template your list of DMIS IDs is already shown so you simply select the appropriate number.Corporate Report by DMIS ID
  • 104 - Drugs Dispensed by MTFThis 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 and presents the output on separate tabs. Each tab shows the GCN number, generic name, strength and dosage form of the drug along with the # RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply, Total Submitted Amount Due and # of Utilizers. To run the report you will be asked to enter a start date and an end date and to select a specific MTF from a pick list. You can select more than one MTF. However, if you select more than one, the data will be expressed as an aggregate of all the sites selected.>/p>Drugs Dispensed by MTF
  • 105 - Drugs Dispensed by PoSThis 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 points of service (MTF, Retail or Mail). The report ranks the drug usage by prescription count and by dollar expenditures and presents the output on separate tabs. Each tab shows the GCN number, generic name, strength and dosage form of the drug along with the # RXs, Total Quantity Dispensed, Average Quantity per RX, Average Days Supply, Total Submitted Amount Due and # of Utilizers. To run the report you will be asked to enter a start date and an end date and to select a specific Service Category from a pick list. You can select more than one Service Category if desired however, if you select more than one, the data will be expressed as an aggregate of all the Service Categories selected.Drugs Dispensed by PoS
  • 106 - Drug Use by GC3 Code and DMIS IDThese templates allow the user to monitor drug utilization by therapeutic class. The report will compile data based on selected therapeutic drug classes (GC3 Codes) while pulling it from a specific MTF catctment 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, # RXs, Total Submitted Amount Due, Average Days Supply, Average Due per RX, and # 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 a start date and an end date and then select at least one GC3 code, a Patient DMIS ID and a Pharmacy DMIS ID. You select a GC3 code and DMIS ID by clicking on the Value button to the right of the box. A list of codes will appear and you highlight the one you want. You can select more than one GC3 by holding down the Control key while selecting the next code. Remember, the Patient and Pharmacy DMIS ID are both the same code; they just refer the search to different files to pull the data. You can select only one DMIS ID per report. For those using the Webi template your list of GC3 Codes and DMIS IDs are already shown so you simply select the appropriate number.Drug Use by GC3 Code and DMIS ID
  • 107 - DUR Edits and Level 1 DDI by MTFThese templates allow 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 the same tab, one below the other. The top report is a summary of all the types of ProDUR warning messages reported by PDTS for the MTF during the report period. The second and third reports 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 a start date and an end date and to select a specific MTF. You select an MTF by clicking on the Value button to the right of the box. A list of MTFs will appear and you highlight the site you want. You can select more than one MTF by holding down the Control key while selecting the site. However, if you select more than one MTF the data in the top report will be expressed as an aggregate of all the sites selected. The second and third reports will still breakout the data out by pharmacy and the specific medications involved. For those using the Webi template your list of MTFs is already shown so you simply select the appropriate MTF.DUR Edits and Level 1 DDI by MTF
  • 108 - Level 1DDI Transaction Details by MTFThese templates allow 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 the same tab, one below the other. The top report is a summary of all the types of ProDUR warning messages reported by PDTS for the MTF during the report period. The second and third reports 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 a start date and an end date and to select a specific MTF. You select an MTF by clicking on the Value button to the right of the box. A list of MTFs will appear and you highlight the site you want. You can select more than one MTF by holding down the Control key while selecting the site. However, if you select more than one MTF the data in the top report will be expressed as an aggregate of all the sites selected. The second and third reports will still breakout the data out by pharmacy and the specific medications involved. For those using the Webi template your list of MTFs is already shown so you simply select the appropriate MTF.Level 1DDI Transaction Details by MTF
  • 109 - MTF Drug UsageThis template allows the user to monitor the drugs dispensed by a specific MTF during a given period of time. 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 prescriptions for each drug, the total quantity dispensed (Metric Quantity as defined by First Data Bank), the average days supply for those prescriptions, the total submitted amount due (ingredient cost for MTFs) and the number of unique utilizers for that specific drug. The data is presented in two tabs, one sorts the data by the prescription count listing greatest to least while the other sorts by total submitted amount due, also greatest to least. To run the report you will be asked to enter a start date and an end date and to select a specific MTF. You select an MTF by clicking on the Value button to the right of the box. A list of MTFs will appear and you highlight the site you want. You can select more than one MTF by holding down the Control key while selecting the site. However, if you select more than one MTF the data will be expressed as an aggregate of all the sites selected.MTF Drug Usage
  • 110 - Patient Profile by DEERS IDThis 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, Pharmacy Name and NCPDP number, Provider´s ID number and Name if a valid DEA number was submitted. If the DEA number is invalid or the provider is from an MTF, the provider name will appear as "Not on file". There is a line above the data that returns the patient´s DEERS ID and name. To run the report you will be asked to enter a start date and an end date and to enter the patient´s DEERS ID. You should enter 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 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
  • 111 - Patient Profile by SSNThis 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, Pharmacy Name and NCPDP number, Provider´s ID number and Name if a valid DEA number was submitted. If the DEA number is invalid or the provider is from an MTF, the provider name will appear as "Not on file". There is a line above the data that returns the patient´s DEERS ID and name. To run the report you will be asked to enter a start date and an end date and to enter the patient´s DEERS ID. You should enter 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 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
  • 112 - Provider ProfileThese templates have 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 used by the patient. 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 SSN, Pharmacy Name and NCPDP number and Service Category. Also, there is a line above the data that returns the provider´s ID number and name. The name will appear only if the provider´s ID is a valid 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 a start date and an end date and to enter the provider´s ID number. You should enter one provider ID per report.Provider Profile
  • 113 - Top 10 AHFS Classes by PoSThis 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 a start date and an end date and to select a Claim Service Category. You select the Service Category by clicking on the Value button to the right of the box. A list with Mail Order, MTF and Retail will appear and you highlight the category you want. You can select more than one Service Category by holding down the Control key while clicking on the next category. However, if you select more than one category the data will be expressed as an aggregate of all selected. Note – the top 10 ranking can be changed to any other number by editing the ranking pre set within the report. Open the template and click on the "Slice and Dice" icon and then double click on the icon looking like a camera shown on the AHFS data element. Now you can change the number by typing in a new number and clicking OK and then Apply. You will need to follow the same procedure on both tabs. For those using the Webi template your list of Service Categories is already shown so you simply select the appropriate one. Also, the Webi format does not allow the user to select a specific number for the Top ranking so the output shows all the classes ranked from greatest to least. Future updates to Business Objects will provide the ranking capability.Top 10 AHFS Classes by PoS
  • 114 - Top 10 GC3 Classes by PoSThis 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 Data Bank´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 a start date and an end date and to select a Claim Service Category. You select the Service Category by clicking on the Value button to the right of the box. A list with Mail Order, MTF and Retail will appear and you highlight the category you want. You can select more than one Service Category by holding down the Control key while clicking on the next category. However, if you select more than one category the data will be expressed as an aggregate of all selected. Note – the top 10 ranking can be changed to any other number by editing the ranking pre set within the report. Open the template and click on the "Slice and Dice" icon and then double click on the icon looking like a camera shown on the GC3 data element. Now you can change the number by typing in a new number and clicking OK and then Apply. You will need to follow the same procedure on both tabs. For those using the Webi template your list of Service Categories is already shown so you simply select the appropriate one. Also, the Webi format does not allow the user to select a specific number for the Top ranking so the output shows all the classes ranked from greatest to least. Future updates to Business Objects will provide the ranking capability.Top 10 GC3 Classes by PoS
  • 115 - Top 200 Drugs by PoSThis 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 Data Bank´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 a start date and an end date and to select a Claim Service Category. You select the Service Category by clicking on the Value button to the right of the box. A list with Mail Order, MTF and Retail will appear and you highlight the category you want. You can select more than one Service Category by holding down the Control key while clicking on the next category. However, if you select more than one category the data will be expressed as an aggregate of all selected. Note – the top 10 ranking can be changed to any other number by editing the ranking pre set within the report. Open the template and click on the "Slice and Dice" icon and then double click on the icon looking like a camera shown on the GC3 data element. Now you can change the number by typing in a new number and clicking OK and then Apply. You will need to follow the same procedure on both tabs. For those using the Webi template your list of Service Categories is already shown so you simply select the appropriate one. Also, the Webi format does not allow the user to select a specific number for the Top ranking so the output shows all the classes ranked from greatest to least. Future updates to Business Objects will provide the ranking capability.Top 200 Drugs by PoS

Report Request Forms

Business Object References

If your facility is interested in having personnel attend one of our Business Objects training session, please contact the PASS at 1-210-536-6650, or email your training request.

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.