FDB Comparison Reports

The FDB Comparison Reports display the changes to existing data included in the Incremental FDB updates. The reports inform an approver or administrator of the latest FDB changes for the Duplicate Therapy, Drug-Drug Interaction, Drug Pair, and Dose Range concepts and provide data that helps an approver or administrator decide whether to change a custom record. The FDB Comparison Reports help an approver or administrator keep PECS customizations in sync with FDB changes.

FDB Comparison Reports display:

Structure of the FDB Comparison Reports

FDB Comparison Report

Each FDB Comparison Report lists the "FDB Update Received" date, which is the date listed in the Incremental FDB Update file.

Each report lists comparison sets of VA and FDB data.  Each comparison set consists of at least three rows separated by a blue line.  The three rows are:

VA Custom Data in the Custom VA record. If the corresponding FDB record has not been customized, a "Not customized" message will be in the Action Status column and the rest of the row will be blank.
FDB After Update Data in the Incremental FDB Update File. This data will be in the PECS database shortly after the incremental FDB update.
FDB Before Update Data in the PECS FDB record. This data will be replaced by the 'FDB After Update' data. If the FDB After Update and FDB Before Update data of the same type are different, they are marked with an asterisk (*) and colored red. Records that do not have any differences between the FDB Before Update and FDB After Update data of the same type are not listed in the report.

Each FDB Comparison Report has the following columns:

Action Status The state of the associated VA record based on the most recent action performed. PECS compares FDB data with VA customizations in any Action Status, including Rejected or Deleted.
Action Date The date the current action (Action Status) was taken.
DATUP will delete YES in this column Indicates the associated FDB record will be deleted by DATUP. If the column is blank, the associated FDB record will not be deleted by DATUP.
If the FDB record will be deleted by DATUP, only the FDB Interaction ID and DATUP will delete columns will be filled out in the FDB After Update row. All the other columns will be blank.

 

The reports are organized by type and the date of the FDB Incremental Update. Links to the reports are kept for eight weeks on the Reports page.

To run an FDB Comparison report, click the appropriate FDB Incremental Update date under the appropriate Report Heading.

rpt_fdbcomparison_clicklink.png

If there are no differences between the FDB After Update and FDB Before Update data of the same type in any of the records, a "No Data Found" message is printed on the FDB Comparison Report.

No Data Found

FDB Comparison Report - Drug-Drug Interaction

FDB Comparison Report - Duplicate Therapy