Custom Updates

relmgr_customupdatetab2.png

The Custom Updates tab is used by a Release Manager to generate a zip file containing files for each Order Check in the FDB update file format. Both updates files are created by clicking the "Create New Update" button.

Note: Due to a DATUP limitation, only one set of custom updates can be created per calendar day.

The existing Custom Updates are compartmentalized by Year and Month. Click the Year to display the custom updates for that year, then click a month to display the custom updates performed during that month. The custom updates for more than one month can be displayed simultaneously. Clicking a month a second time will collapse (hide) the display of that month's custom updates.

Custom Update Display Expanded

 

Create Custom Update

To run a custom update

  1. Log in to PECS as a Release Manager.
  2. Click the Custom Updates tab.

    Custom Updates Tab

  3. Click Create New Update.

    Create New Update Button

  4. After processing, the two new update files will appear in the list. The dates in the Created Date column should match the current date.

    Newly-created Custom Update Files

  5. If an error message is received, report it to PECS Administrator.

Update Files Explained

The custom update files that are run include both a full update and an incremental update. It is rare that a Release Manager will ever have to view these files, but if they do, here is an explanation.

A Custom Update file will always follow the same file naming standard.  This standard is:

CstmUpdFile_{FDB Version}.{PECS Generated Version Number}_{Date/Time Stamp}.zip

For example, the CstmUpdFile_3.2.751_20120503154622.zip has an FDB Version number of "3.2," a PECS-generated Version Number of "751," and was created on May 3, 2012 at 15:46:22 (military time).  The contents of the zip file will determine if this is an Incremental or a Full update.

Incremental Update File

The Incremental Update File contains just the updates delivered by FDB. The files contained in the .zip file are:

FDBCUSTOMDDIM.UPD

FDBCUSTOMDDIMINTERACTION.UPD

FDBCUSTOMDDIMSTRINGS.UPD

FDBCUSTOMDOSERANGE.UPD

FDBCUSTOMDUPLICATETHERAPY.UPD

FDBCUSTOMMONOGRAPH.UPD

FDBUPDCONTROL.DAT

proddefinition.xml

The proddefinition.xml file is an file from FDB that defines the table structures for the FDB tables in an XML format.  The FDBUPDCONTROL.DAT file contains control information used by the FDB Data Updater software when determining if this Incremental update should be applied to a database.  The UPD files contain data updates for a particular FDB table in the database.

Here is a sample: Note that the “D”, “C”, and “A” in the left column mean Delete, Change, and Add, respectively.

H|fdb_custom_ddim|26|4|40|3.2|W|20120416|USA

F|10|1|rtgenid1|2|rtgenid2|3|interactionid|4|seqno|5|uicategory1|6|uicategory2|7|uicategory3|8|uicategory4|9|uicategory5|10|uicategory6

P|4|1|2|3|4

D|1052533|1050026|2020134|1

D|1050026|1052533|2020134|2

D|10489717|1050028|2020134|1

D|1050028|10489717|2020134|2

D|1052533|1050027|2020134|1

D|1050027|1052533|2020134|2

Full Update File

The Full Update File contains the complete FDB distribution. The files are:

CTVERSION.TXT

FDBCUSTOMDDIM.TXT

FDBCUSTOMDDIMINTERACTION.TXT

FDBCUSTOMDDIMSTRINGS.TXT

FDBCUSTOMDOSERANGE.TXT

FDBCUSTOMDUPLICATETHERAPY.TXT

FDBCUSTOMMONOGRAPH.TXT

FILECOUNTS.DAT

proddefinition.xml

Sample of the Drug Drug Interaction file.

1048627|1050000|2004892|1|VA|||||

1050000|1048627|2004892|2|VA|||||

1048627|1050001|2004892|1|VA|||||

1050001|1048627|2004892|2|VA|||||

1048627|1050014|2004892|1|VA|||||

1050014|1048627|2004892|2|VA|||||

1048627|1050015|2004892|1|VA|||||

1050015|1048627|2004892|2|VA|||||

1048627|1052651|2004892|1|VA|||||

1052651|1048627|2004892|2|VA|||||

1048627|23070090|2004892|1|VA|||||

23070090|1048627|2004892|2|VA|||||

 

Release Manager