Document Control Section Revision History Date Revised Pages Patch Number Description of Change July 2017 Page Page Page Page PREC*6.1*1 Made updates for PECS v6.1 which addresses 2FA Compliance and IAM SSOi intergration for PIV authentication. Pavani Mukthipudi/Anitha Alluri May 2016 All i, xvi 165 5, 6, 14, 46, 144 23, 81 126 39 135-139 4 6 7 3, 4 13 14 24 26-28 38 43 53 62 76 84, 85 94 95, 96, 122, 128 132 153 158 PREC*6.0*1 Removed periods from description, edited for 508 conformance Date, Footer updated, Corrected Page number Removed extra text Adjusted bullets on lists for consistency Removed blank page Added blank page Removed extra space Adjusted bullets Formatted cross-references as hyperlinks Updated punctuation on bulleted lists Capitalized drug names Added SFTP to acronyms Replaced FTP with SFTP Updated WebLogic version Adjusted hyphens, text edit Removed periods Added word, text edit Removed extra space Text edit Removed extra space, text edit Revised text to clarify Text edit Removed extra space Revised text to clarify Removed extra space Added apostrophe Revised text to clarify Removed extra space Brian Holihan, Susan Heiress 11/17/2014 x 70 96 99 123, 141, 169 PREC*5.0*1 Added blank page Updated internal document links Updated internal document links Updated missing linked screen capture Removed unnecessary link Brian Holihan
11/17/2014 8 16 63 66 68 112 117 163 PREC*5.0*1 Clarified sentence describing the and Production environments. Clarified sentence on Customize Settings; corrected missing linked screen capture. Added quotation marks to “Display in Query” for clarity. Removed extra space between sentence and period. Changed “an” to “a” Removed extra space between sentence and period. Clarified sentence . Removed extra period. Brian Holihan 11/17/2014 2 6 8 12 14 19 30 34 51, 60, 62 16 All 89, 124 47-49 All vii ix – xiv xv - xviii PREC*5.0*1 Updated link Removed extra text Removed extra text Removed asterisk Switched spell-out of DDI to first use Removed extraneous parenthetical statement Provided definition for DRC Provided list of options Updated reference links Removed extraneous section Page numbers updated Changed section names so that the text would fit on the TOC Removed strange section of linked text causing multiple instances of the same text and graphics Updated referenced page numbers All references to FDB MedKnowledge Framework were reverted to FDB-DIF to correct an inaccuracy; the product name does not change until the 4.x series, not the 3.3 version of the FDB product deployed with PECS v5.0. Added blank page so that TOC starts on an odd page, separate from Revision History Updated TOC page numbers Updated List of Figures page numbers Brian Holihan
When all criteria have been added, click the Query button. The results will display in the Results panel appropriate to the query being performed (VA or FDB). To see details of the record, click the link in the Select column. The links are either Active (current VA record), Historical (old version of an active VA record), or Open (FDB record). Query Filters The Advanced Query/Customization query function provides Filters that allow you to control what data is returned by the query. The filters are. Table 3: Query Filters Filter Name Filter Function Contains The contents of the Value field appears somewhere in the database row of the Field being queried. Used primarily for fields containing text data. Contains is the default Filter option. Contains = “25” would match 25, 125, and 250, but not 205. Equal To The contents of the Value field exactly matches the contents of the database row of the Field being queried. “Equal To” = “25” would match 25, but not 125, 250, or 205. Less than or Equal to The contents of the Value field is less than or equal to the contents of the database row of the Field being queried. Greater than or Equal to The contents of the Value field is greater than or equal to the contents of the database row of the Field being queried. Begins with The contents of the database row of the Field being queried starts with the contents of the Value field. Ends with The contents of the database row of the Field being queried ends with the contents of the Value field. Greater than The contents of the Value field is greater than the contents database row of the Field being queried. Less than The contents of the Value field is less than the contents database row of the Field being queried. Not equal to The contents of the Value field does not exactly match the contents of the database row of the Field being queried. And/Or Usage Examples To see approved records with an interaction description equal to "anti" or "Lido", build the query as follows: Table 4: And/Or Example 1 Field Filter Value And/Or Interaction description Equals anti And Status Equals approved Or Interaction description Equals Lido And Status Equals approved If you build the query below, you will get approved records with an interaction description = "anti", but you will get all records with an interaction description of "Lido", regardless of status.
Reverse Drug-Drug Interactions Multiple Drug-Drug Interaction records may exist for the same drugs listed in reverse order. For example, FDB Interaction ID 1234 is Drug A/Drug B and FDB Interaction ID 30766 is Drug B/Drug A. Information about reverse DDIs is displayed in the table at the top of the detail page. The screen shot below displays FDB record 1637, which has a DDI customization and a reverse DDI customization. Figure 82: FDB DDI with a Customization and a Reverse Customization If you click the link associated with the reverse DDI, you will see its detail page (next screen shot): Figure 83: Choosing the Reverse VA DDI Customization The detail page of the Reverse VA Customization is displayed: Figure 84: Reverse FDB Interaction ID Displaying the Reverse FDB DDI Interaction ID The Reverse FDB DDI Interaction ID is displayed in the VA custom DDI and DP Detail pages, in the results of DDI and Drug Pair queries and on the FDB Custom DDI Report. The Reverse FDB DDI Interaction ID is defined as the reverse of the FDB DDI ID and is obtained by executing this equation: 32,000 – (minus) FDB Monograph ID. For example: If FDB monograph ID is 2246, the reverse FDB DDI ID is 29745 (32,000 – 2246 = 29745) If FDB monograph ID is 29754, the reverse FDB DDI ID is 2246 (32,000 – 29754 = 2246) If FDB monograph ID is 0, the reverse FDB Interaction ID is 0 ( i.e., DDI was created from scratch using the Open Blank Form option) Displaying the reverse FDB DDI Interaction ID in the DDI and DP detail pages, query results, and reports enables you to find information about reverse DDIs easily. Working with Drug Pairs within the DDI Note that you can work with a drug pair only by starting from the Drug-Drug interaction page, and clicking the Drug Pairs button. See the Drug Pair Detail for additional information. Fields Table 11: DDI Fields Table Heading Name Table Heading Description Monograph ID The Professional Monograph ID associated with the drug interaction pair. Action Status Applicable to VA record only. The point this customization is at, within the VA Approval Workflow.
Finding Drug Pairs Drug pairs are usually found and processed directly from the Drug-Drug Interaction they are associated with. However, you can search for them directly using either Advanced Query/Customization or Drug Pair Lookup. When searching for drug pairs directly, what is displayed is dependent the record type (VA or FDB) and whether the associated Drug-Drug Interaction has been customized. In all cases, drug pair records cannot be edited directly; you must work through an associated Drug-Drug Interaction. If the results locate a customized VA Drug Pair, the VA Drug Pair detail page for that Drug Pair is displayed. The detail page contains a link to the associated Drug-Drug Interaction(s). If the results locate an FDB drug pair record that has been customized by VA, the FDB Drug Pair Detail page is displayed. The detail page contains a link to the FDB Drug-Drug Interaction and the customized VA Drug-Drug Interaction created from the FDB Drug-Drug Interaction. If the results locate an FDB drug pair record that has NOT been customized by VA, the associated FDB Drug-Drug Interaction detail page is displayed. Using Advanced Query/Customization To find a drug pair using Advanced Query/Customization: Click the Advanced Query/Customization tab. Select Drug Pair from the Select Concept List and select the appropriate drug pair type from the Select VA, FDB, or Both list. Build the query to find the appropriate drug pair and click Query. Click the link in the Select column to open the record. The record that is displayed depends on the record type. See Using Advanced Query/Customization for additional information. Using Drug Pair Lookup To find a drug pair using Drug Pair Lookup: Click the Drug Pair Lookup tab. Build the query to find the appropriate drug pair and click Query. Click the link in the Select column to open the record. The record that is displayed depends on the record type. See Drug Pair Lookup for additional information.
Reports The Reports page displays a list of available reports in PECS. PECS Reports are essentially exported Excel spreadsheets that can be manipulated and formatted as the user sees fit. Note: The Reports tab is not visible to Requestor or Release Manager users. Note to Assistive Technology Users: Please refer the documentation included with your screen reader for commands related to reading column and row headers. To run a report, click the link associated with it. You will be provided the option of opening the file directly or saving it to copy of the file to a location on your workstation (or accessible network location). Figure 109: List of Reports There are two types of Reports: Active Customization Reports FDB Comparison Reports Active Customization Reports The Active Customization Reports are: FDB Custom Dose Range Report FDB Custom Drug-Drug Interaction Report FDB Custom Duplicate Therapy Report FDB Custom Professional Monograph Report Deleted Monograph Customization Report Null Drug Pairs Customization Report The first four Active Customization Reports, FDB Custom Dose Range, FDB Custom Drug-Drug Interaction, FDB Custom Duplicate Therapy, and FDB Custom Professional Monograph, display concept records in an Approved status along with their corresponding FDB record data. See the sample below. Figure 110: Sample Active Customization Report The last two reports on the list, Deleted Monograph Customization Report and Null Drug Pairs Customization Report, look for problems. The Deleted Monograph Customization Report displays DDIs with an associated PM that has been deleted (e.g., the FDB update deleted an FDB PM, and that FDB PM is associated to a custom DDI). The Null Drug Pairs Customization Report displays custom DDIs that have an associated DP in which one or both routed generics is null because an FDB update deleted the routed generic(s). FDB Custom Dose Range Report