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.
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.
Note: Due to a DATUP limitation, only one set of custom updates can be created per calendar day.
To create a custom update:
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.
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
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|||||