INSTALLATION NOTES FOR BDW - IHS DATA WAREHOUSE EXPORT PATCH #6 =================================================================== PREFIX: BDW CURRENT VERSION: 1 PATCH#: 6 RELEASE DATE: June 2019 =================================================================== ********NOTE************NOTE************NOTE************NOTE******* ******************************************************************* * READ THE ENTIRE NOTES FILE PRIOR TO ATTEMPTING ANY INSTALLATION * ******************************************************************* ********NOTE************NOTE************NOTE************NOTE******* 1. GENERAL INFORMATION ***NOTE: The post init will populate each pharmacy defined in the Outpatient Site file into the BDW SITE file. For each of these pharmacy divisions you must provide an answer to the question as to whether that pharmacy division wants to export prescription data. The default is set to NO, DO NOT ENABLE EXPORT. Enabling this data export will assist local sites with extracting data to create an opioid surveillance strategy to monitor local opioid prescribing and leverage utilization of timely, actionable data to inform strategies and interventions. Federal sites are REQUIRED to change the NO to a YES, ENABLE EXPORT. Tribal and Urban sites must verify with site leadership/Health Director prior to installing this patch to determine which pharmacy division operating on this database chooses to export data to the national prescription reporting database at the data warehouse, if any. Tribal and Urban pharmacies that want to export prescription data, are required to change the NO to a YES, ENABLE EXPORT. ***NOTE: You must be logged into the division that is setup in the BDW SITE file to install the patch. This patch contains the following software changes: CR10668 - Add DBH/Prescription Export requirements to BDW/NDW extract a) Add Routines, Options, GIS Messaging to support the HOPE initiative. b) Verifies Infant Feeding Choice backload and resets if it did not complete in patch 5. 2. CONTENTS OF DISTRIBUTION a) bdw_0100.06k - patch 6 kids build see routine list at the end of this notes file. b) bdw_0100.06b - GIS INXPORT global, contains HL7 structure c) bdw_0100.06n – This notes file d) bdw_0100.06u.pdf BDW Version 1.0 Patch 6 User Manual e) bdw_0100.06t .pdf BDW Version 1.0 Patch 6 Technical Manual 3. REQUIREMENTS a) Kernel (XU) v8.0 patch 1018 or later b) Fileman (DI) v22.0 patch 1018 or later c) IHS Data Warehouse Export System (BDW) Version 1.0 patch 5 d) GIS patch 16 - gis*0301*16 4. INSTALLATION INSTRUCTIONS In all UCIs running BDW - IHS DATA WAREHOUSE EXPORT: a) From a programmer prompt K ^INXPORT b) Import the bdw_0100.06b global using the global import in Ensemble system explorer, or using the %GI utility from an Ensemble programmer prompt. c) Load the Distribution into KIDS using option 1 on the KIDS Installation menu. The distribution was released in a file named bdw_0100.06k. d) Verify the load using option 2 on the KIDS Installation menu. e) Consider using options 3 and 4 on the KIDS Installation menu to print and compare the Transport global. f) Install the distribution using option 6 on the Installation menu. g) For results, use the KIDS "Install File Print" option to view/print the "BDW*1.0*6" entry. h) Two new security keys are contained in this patch: BDWHZMENU - This unlocks the main HOPE export menu BDWHMENU. This key should be given to any personnel who will be tasked with performing or monitoring the HOPE exports. BDWHZ RESET - This unlocks the Reset HOPE Log Entry option. This key should only be given to IT staff that may need to reset a log entry after an error occurs during the export process. 5. SAMPLE INSTALL DEVA>K ^INXPORT DEVA>D ^%GI Global input Device: x:\export\bdw_0100.06b Parameters? "RS" => Globals were saved on 24 Jan 2019 3:14 PM Cache with description: Input option: A ^INXPORT DEVA>D ^XPDKRN KIDS 8.0 Select KIDS OPTION: LOAD A DISTRIBUTION Enter a Host File: X:\export\bdw_0100.06k KIDS Distribution saved on Feb 20, 2019@13:44:42 Comment: DATA WAREHOUSE EXPORT V1.0 PATCH 6 This Distribution contains Transport Globals for the following Package(s): BDW*1.0*6 Distribution OK! Want to Continue with Load? YES// y YES Loading Distribution... Build BDW*1.0*6 has an Environmental Check Routine Want to RUN the Environment Check Routine? YES// BDW*1.0*6 Will first run the Environment Check Routine, BDW10P6 Patch "GIS*3.01*16" is Present. Patch "BDW*1.0*5" is Present. Use INSTALL NAME: BDW*1.0*6 to install this Distribution. DEVA>d ^XPDKRN KIDS 8.0 Select KIDS OPTION: INSTALL PACKAGE(S) Select INSTALL NAME: BDW*1.0*6 Loaded from Distribution Loaded from D istribution 2/20/19@13:52:53 => DATA WAREHOUSE EXPORT V1.0 PATCH 6 ;Created on Feb 20, 2019@13:44:42 This Distribution was loaded on Feb 20, 2019@13:52:53 with header of DATA WAREHOUSE EXPORT V1.0 PATCH 6 ;Created on Feb 20, 2019@13:44:42 It consisted of the following Install(s): BDW*1.0*6 Checking Install for Package BDW*1.0*6 Will first run the Environment Check Routine, BDW10P6 Patch "GIS*3.01*16" is Present. Patch "BDW*1.0*5" is Present. Install Questions for BDW*1.0*6 Incoming Files: 90212.1 BDW SITE FILE Note: You already have the 'BDW SITE FILE' File. 90213.1 BDW PRESCRIPTION EXPORT LOG Note: You already have the 'BDW PRESCRIPTION EXPORT LOG' File. Want KIDS to Rebuild Menu Trees Upon Completion of Install? NO// Want KIDS to INHIBIT LOGONs during the install? NO// qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq Install Started for BDW*1.0*6 : Feb 20, 2019@13:53:05 Build Distribution Date: Feb 20, 2019 Installing Routines: Feb 20, 2019@13:53:05 Running Pre-Install Routine: PRE^BDW10P6 Installing Data Dictionaries: Feb 20, 2019@13:53:05 Installing PACKAGE COMPONENTS: Installing SECURITY KEY Installing FORM Installing OPTION Feb 20, 2019@13:53:05 Running Post-Install Routine: POST^BDW10P6 Importing GIS HL Supplement DW1HOPE, developing site IHS Generation for message: HL IHS DW1HOPE O13..................... The following scripts were generated: Generated: HL IHS DW1HOPE O13-O Compiling Script: Generated: HL IHS DW1HOPE O13-O .. MUMPS section.... DATA section.................................................... ............ END section. Compile completed with 0 warnings and 0 errors. Linking... Filing generated routines... Routine IS00060 ...Filed Routine IS00060A ...Filed?? Generation for message: HL IHS DW1HOPE HEADER................ The following scripts were generated: Generated: HL IHS DW1HOPE HEADER-O Compiling Script: Generated: HL IHS DW1HOPE HEADER-O .. MUMPS section.... DATA section.......................... END section. Compile completed with 0 warnings and 0 errors. Linking... Filing generated routines... Routine IS00062 ...Filed?? Generation for message: HL IHS DW1HOPE TRAILER............ The following scripts were generated: Generated: HL IHS DW1HOPE TRAILER-O Compiling Script: Generated: HL IHS DW1HOPE TRAILER-O .. MUMPS section.... DATA section........................... END section. Compile completed with 0 warnings and 0 errors. Linking... Filing generated routines... Routine IS00063 ...Filed Finished Importing GIS Supplement For each Pharmacy in the Pharmacy Outpatient Site file you must provide a response as to whether the pharmacy will enable prescription data to be exported to the national reporting database at the National Data Warehouse to support the Heroin, Opioids and Pain Efforts (HOPE) and other opioid initiatives. Enabling this data export will assist local sites with extracting data to create opioid surveillance strategy to monitor local opioid and leverage utilization of timely, actionable data to inform strategies and interventions. Federal sites MUST set the parameter to YES - Enable the export. Tribal and Urban sites must verify with site leadership/Health Director prior to setting the parameter to Yes. If you are NOT sure, please set the parameter to NO - Do not enable export. Press ENTER to continue: PHARMACY OUTPATIENT SITE ENABLE PRESCRIPTION EXPORT? 1) PARKER INDIAN HOSP YES, ENABLE EXPORT 2) PEACH SPRGS HLTH CTR NO, DO NOT ENABLE EXPORT 3) SUPAI HEALTH STATION NO, DO NOT ENABLE EXPORT 4) CHEM NO, DO NOT ENABLE EXPORT 5) SHERMAN YES, ENABLE EXPORT Select one of the following: E Edit a Pharmacy's Parameter Setting Q Quit Which action: E// Quit Updating Routine file... Updating KIDS files... BDW*1.0*6 Installed. Feb 20, 2019@13:53:09 Install Completed 6. POINT OF CONTACT OIT User Support (IHS) Phone: 1-888-830-7280 Web: http://www.ihs.gov/Helpdesk/ Email: support@ihs.gov 7. Routine Summary List Routine Summary Checksums shown are NEW Checksums The following routines are included in this patch. The second line of each of these routines now looks like: ;;1.0;IHS DATA WAREHOUSE;**[Patch List]**;JAN 23, 2006;Build 60 Checksums Routine Old New Patch List BDW10P6 27324542 69782900 **6** BDWBAN 2830363 2830363 **6** BDWHBAN 2006295 2006295 **6** BDWHBHL 38213280 38606571 **6** BDWHBHL1 4314518 4307685 **6** BDWHDDR 39991733 43354734 **6** BDWHDLOG 14358216 51720883 **6** BDWHEVNT 4096727 4096727 **6** BDWHFLDS 1778989 1778989 **6** BDWHRDI2 34449242 38605223 **6** BDWHRDR 89695467 91012397 **6** BDWHRDRI 13800106 14777353 **6** BDWHREDO 31233879 34298274 **6** BDWHRSET 5911832 5911941 **6** BDWHUTL 7150225 7150225 **6**