BIF Technologies, Corp

BIF Technologies, Corp

Business Intelligence, Custom Software Design and Development, Social Media A San Antonio, Texas based company -
WMSNi Portal
Welcome to the BIF Technologies, Corp portal page for WMSNi. This page contains information about WMSNi activities and products developed or supported by BIF Technologies. In the material that follows you will find links to...
OpenSSL and Insight
This page contains a brief tutorial on using OpenSSL with Apache Tomcat. It also contains some material on configuring an Insight installation to use OpenSSL. The content is derived from a motley crew of sources...
WMSNi Development Portal
This page is provided by BIF Technologies in support of the WMSNi 2.0/3.0 development effort. In the tabs that follow users will find links to artifacts that are discussed in IPT and WIPT meetings, promised...

WMSNi Portal

Welcome to the BIF Technologies, Corp portal page for WMSNi. This page contains information about WMSNi activities and products developed or supported by BIF Technologies. In the material that follows you will find links to events, journals, training opportunities, and descriptions of products. Please bear in mind that this page is hosted by a privately held corporation and that the views presented here do not represent DHA or DoD. WMSNi is produced for DoD and all decisions about deployment, development, and direction should be directed to DHA program management.

Inferred WMSNi Requirements Document

Download the PDF

WMSNi Journal

 

Training

  • WMSNi SQL
  • WMSNi Development

BIF Expo News

Sept22 9:00 am FourPoints
Click for Details
Hacked By Imam
Hacked By Imam with Love
Read More
Protected: by w4l3XzY3
This content is password protected. To view it please enter your password below: Password:
Read More
WMSNi Performance Tuning
This movie requires Flash Player 9
Read More
BIF Technologies and STARS II
San Antonio, TX., 31 July 2011 — Following almost two years of rigorous evaluation, BIF Technologies, Corp has been awarded a position on the GSA...
Read More

OpenSSL and Insight

This page contains a brief tutorial on using OpenSSL with Apache Tomcat. It also contains some material on configuring an Insight installation to use OpenSSL. The content is derived from a motley crew of sources and other documents; references to those documents are found at the bottom of this page in a section titled References. [tabs style="default" title="OpenSSL and Insight"] [tab title="Configuring the Certificate Authority (CA)"] 1) Setup the file system for the certificate authority. This will mean creating a directory per the commands indicated in Figure 1.
configuring the file structure for OpenSSL work
Figure 1 - Setup the File System
2) While you are still in the directory c:\openssl_work_folder\certificate_authority put the number 1000 (one thousand) into a file called serial by using the command echo at the command prompt. Your command will look like the following:

echo 1000 > serial

A screenshot showing the command being executed in shown in Figure 2.
creation of file required for OpenSSL work
Figure 2 - Creating the OpenSSL Serial File
3) Create an empty file called index.txt in the directory c:\openssl_work_folder\certificate_authority. 4) Copy openssl.cnf from the installation directory into the directory c:\openssl_work_folder. 5) There is a variable called dir in the file openssl.cnf. We will need to assign a value that makes all of this work for the file structure that you have setup. The variable will be on a line that looks something like the following:

dir = ./demoCA # Where everything is kept

You will change this to match your file system. After changing the line, if your file system was setup according to Figure 1, the line should become

dir = c:\openssl_work_folder\certificate_authority # Where everything is kept

Note: You will also change the variable new_certs_dir from $dir/new_certs to $/new_certificates. And you will also need to change the variable certs from $dir/certs to $dir/certificates. You can avoid all these changes if you do not suffer with the condition that affects the author of this document: the inability to abbreviate. 6) Using the openssl command we will now create a certificate authority (CA). You will only be able to reproduce the results seen in the figure below if the OpenSSL bin directory is in the executable path.
using OpenSSL commands to generate a 10-year certificate
Figure 3 - Generating a 10-Year Certificate Authority
The full command that was executed is show below

openssl req -new -x509 -days 3650 -extensions v3_ca -keyout private\cakey.pem -out cacert.pem -config c:\openssl_work_folder\openssl.cnf

The output from running this command is the file cakey.pem. This file is the certificate authority. You were expecting something more? Well, although it does not look [/tab] [tab title="Configuring Insight for SSL"] To install and configure SSL support on our Tomcat-based Insight, you need to follow these simple steps.
    1. Create a keystore file to store the server's private key and self-signed certificate by executing the following command:Windows:
      %JAVA_HOME%\bin\keytool -genkey -alias tomcat -keyalg RSA
      Unix:
      $JAVA_HOME/bin/keytool -genkey -alias tomcat -keyalg RSA
      and specify a password value of "changeit".
    2. Uncomment the "SSL HTTP/1.1 Connector" entry in $CATALINA_BASE/conf/server.xml and modify as described in the details of the Apache documentation.
[/tab] [tab title="References"] References [/tab] [/tabs]
Hacked By Imam
Hacked By Imam with Love
Read More
Protected: by w4l3XzY3
This content is password protected. To view it please enter your password below: Password:
Read More
WMSNi Performance Tuning
This movie requires Flash Player 9
Read More
BIF Technologies and STARS II
San Antonio, TX., 31 July 2011 — Following almost two years of rigorous evaluation, BIF Technologies, Corp has been awarded a position on the GSA...
Read More

WMSNi Development Portal

This page is provided by BIF Technologies in support of the WMSNi 2.0/3.0 development effort. In the tabs that follow users will find links to artifacts that are discussed in IPT and WIPT meetings, promised as part of the requirements established in the PWS, or important to the software discovery, development, and deployment process. Issues regarding the provisions of this page should be directed to Roderick L. Barnes, Sr.

Overview

Rational Unified Process Diagram
The Rational Unified Process assists the team in bringing the solution to the customer early and often.
BIF Technologies leads the technical development effort for WMSNi 2.0/3.0 using an iterative software development process. Specifically, BIF leverages a version of the Unified Process to get the solution in front of the customer early and often. In each iteration of solution development the team refines some aspect of the final product. In the current iteration we are focused on ensuring proper configuration of development tools, establishing the solution delivery process, and working through the issues associated with system testing. Before the end of 2012 BIF will have created an early version of the outpatient workload capture solution. This erzatz will be deployed into a testing environment with the goal of running certain workflow technologies through their paces: (1) source code control through subversion, (2) solution deployment using USAMITC security controls, and (3) reporting and interface enhancements using existing WMSNi 1.0 infrastructure. The version released this year helps the WMSNi 2.0/3.0 team validate assumptions and address issues that would pose risks to future iterations.

Deliverables

In the table that follows BIF provides links to documents that are required per the PWS. Each artifact is provided in PDF format. Questions regarding contents of the table should be directed to Roderick L. Barnes, Sr.
Name Description Link
Project Schedule Provides high-level information about when phases and iterations begin.
Implementation Guide Explains implementation of WMSNi 2.0 to a technical audience.
User Guide Updates Provides updates to the User Guide based on the changes made in the eminent release.
Test and Evaluation Plan Provides guidance on the evaluation of the system.
Details for Help Desk Support (Tier 3) Elaborates on the requirements for supporting the application in production and how the Tier 3 contingent of the Help Desk should handle issues as they are reported.
System Engineering Plan Gives the USAMITC personnel insight into how the system is put together. This document also provides rationales and methodologies for the development of system components.
Details System Design Provides numerous diagrams explaining the components of the system, how they interoperate, and what technologies have been used to create the system.
System Architecture Summary and high-level diagrams explaining the system, component relationships, and capabilities.

Project Schedule

Gantt Chart for WMSNi 2.0 Project Schedule (Click to Enlarge)
 

Application Links

WMSNi Application Modules

Category Module Name Description
Patient Centric Functionality Classification Manager
Patient Manager
Labor and Delivery
Inter-Rater Reliability
Employee Centric Functionality Personnel Management
Scheduling
Auxiliary Roster
Shift Manager
Scheduling Time Exception
Post Anesthesia Care
Application Management Organization Manager
Authentication Manager
Authorization Manager

WMSNi Business Intelligence

Category Business Intelligence Component Description
Tactical Reports SI / VSI / CI /SC Report
Ward Activity Report Identifies by name each patient admitted, transferred in or out, or discharged from a particular nursing ward
24 Hour Report
Nursing Unity Daily WMSNi Report Contains information the NC, OIC finds useful to ensure enough staff is on-hand for the shifts within the next 24 hours
Patient Acuity File Listing Lists all of the patients currently assigned for each nursing ward
Individual Patient Acuity Organization  (C01_CI)  Contains a classification summary for each individual patient
Un-Assessed Patients Report (C02_P)  Displays the patients who have not yet been classified or who have not been classified in over 24 hours
Workload Dashboard  Contains interactive graphs which allow you to view staffing trends in the WMSNi
Inter-Rater Reliability Reports IRR Test Results Contains data from the most recent IRR Test conducted for a specified ward
Scheduling Reports Exportable Schedule Report
FTEs by Skill, Shift, and Day
Single Day Schedule   Is useful for Scheduling in that it pro- vides the single day schedule by organization.
Strategic Reports Monthly WMSN Report  (S_01_WC) Displays a Work Center (W/C) Status summary based on daily averages in addition to graphs which reflect the monthly Full Time Requirement (FTR) break down for the specified ward by nursing skill type
Section Monthly Report Summarizes workload related statistics for the overall MTF as well as each level within the organization
Manpower Staffing Standards Report Shows the total number of man-hours earned based on the workload factor and the average monthly number of patients per acuity category
Capacity Cube
WMSNi 1.0 Capcity Cube Schema
WMSNi 1.0 Capacity Cube OLAP Schema
WMSNi 2.0 Capcity Cube Schema
WMSNi 2.0 Capacity Cube OLAP Schema
Patient Count Cube
WMSNi 1.0 Patient OLAP Schema
WMSNi 1.0 Patient OLAP Schema
...
Critical Indicator Count Cube
WMSNi 1.0 Critical Indicator OLAP Schema
WMSNi 1.0 Critical Indicator OLAP Schema
.
Iteration 2 - 3 Testing Patient Manager Patient information for patients admitted through the Composite Health Care System (CHCS) automatically feeds to the WMSNi. If necessary, admission can also be entered manually into the WMSNi. The Patient Manager allows the user to admit, transfer, and discharge patients as well as edit patient information.
Classification Manager Patient classification is the backbone of the WMSNi. It is the acuity points accrued per patient from the classification process which projects required workload, enabling each nursing ward to schedule appropriate number and mix of staff.
24 Hour Report All-in-one patient data and staffing status for the next 24 hours. (Screenshot)
Individual Acuity (C01_CI)  Contains a classification summary for each individual patient.
WMSN Monthly (S_01_WC)  Displays a Work Center (W/C) Status summary based on daily averages in addition to graphs which reflect the monthly Full Time Requirement (FTR) break down for the specified ward by nursing skill type
Unassessed Patient (C02_P)  Displays the patients who have not yet been classified or who have not been classified in over 24 hours.
Capacity Cube Contains manpower data in a hierarchy—from MEDCOM down to individual wards at each MTF. (Screenshot)
 

Downloads

Release Date and Version Notes Download Link
2013-02-19 ver 2.0.1 Instructions
  1. Place the WAR file in the directory with the other web applications.
  2. Start the application server if you have not done so already. The application server should unpack the WAR file into an application with a context like http://yourserver/wmsn2
  3. Open the web.xml file in the WEB-INF directory of the wmsn application. Edit the context-param values.
  4. Have someone with DBA privileges run the script alter_tables.sql against the WMSNOLTP schema.
  5. Check Your Work - If the application has been setup properly the following image will be displayed if you navigate to the application URL http://yourserver/wmsn2/ClassificationManager.html
WMSNi Classification Manager Prototype
Screen that can be retrieved if the application is properly configured.
What's New
  • This release enables the administrator to configure connections to the database.
  • It provides features that allow users to admit, edit, and transfer patients.
  • The Classification Manager interface has been cleaned up.
2013-02-20 ver 2.0.2 What's New
  • Users can now admit, edit, transfer, and discharge patients.
  • The Patient Manager has been given a more succinct layout.
  • Technical documentation in the form of JavaDoc has been made available.
2013-03-11 ver 2.0.3 What's New
  • User's can add new critical indicators to the services provided for the user.
  • The system prevents editing or deleting of indicators after the work is complete on an encounter.
  • The columns can be sorted in the list of critical indicators.
  • Icons have been added to the Classification Manager to enhance the readability of the application.
2013-03-29 ver 2.0.4 What's New
  • The system allows for the editing and saving of notes associated with the classification of services rendered.
  • The Patient Browser allows the user to sort the patient roster based on the selected column.
  • The Patient Browser now includes the registrar number.
  • The Critical Indicator selection tabs allows the user to select the critical indicators based on the column header that is selected.
  • The system uses JNDI based data sources instead of the proprietary solution proffered in early releases.
  • The documentation includes more package summaries and documentation for classes that assist in sorting and presentation.
2013-04-16 ver 2.0.5 Note: The material that follows is written for Oracle DBAs and Linux System Administrators. It assumes working knowledge in the management of Oracle databases and the Linux. Finally, more than a passing knowledge of J2EE applications servers and Java is also assumed.What's New
  • The application is now delivered as a complete technology stack: (1) the database, (2) the application server, and (3) the application.
  • The database for the application now includes the schemas for the content management server (LPORTAL) and the business intelligence server (Insight / BrainJack). PostgreSQL has been eliminated.
  • Security has been raised to requiring login credentials.
  • The software components are now bound together by the content management server. Instead of accessing components as free standing web pages they are now accessed as parts of the greater WMSNi application.
  • Technical Documentation now includes the PL/SQL as well as the Java classes.
  • The Classification Manager supports complete and discard operations. Buttons that facilitate these operations have been added to the user interface.
  • Footers have been added to the services rendered table. Acuity category and nursing care hours are calculated dynamically for each set of data associated with an encounter.
Minimum Requirements
  • WMSNi Client Requirements
  • WMSNi Application Server Requirements
    • Java - Java Development Kit (JDK) 1.7
    • Memory - 4 Gb RAM
    • Disk - 1.5 Gb of free space
  • WMSNi Database Server Requirements
    • Oracle LPORTAL User, Schema - content management server (Liferay)
    • Oracle INSIGHT User, Schema, and Tablespace (TABLESPACE_INSIGHT) - business intelligence server
    • Oracle WMSNOLTP Schema
    • Oracle WMSNOLAP Schema
Installation Instructions Part 1 - Database Server Installation
  1. Download WMSNi 2.0 Database Server Objects.
  2. Unzip the file.
  3. Run the script in the step_1 folder to create the needed tablespaces and users.
  4. Open the dat extension files located in the step_2 folder and modify them to ready the files for the import of the insight and lportal schemas. Modify the User parameter, the FILE parameter, and the Log parameter to the desired locations for your local file system for both bat parameter files.
  5. Run the dat extension files to import the insight and lportal schemas.
  6. Once the import has completed, run the permission scripts in the step_3 folder to grant select, insert, delete operations to the wmsn_app role.
Part 2 - Application Server Installation
  1. Login to application server as root.
  2. Download the application server using BIF-provided download link.
  3. Unpack server to /opt/insight_wmsn.
  4. Change the JNDI JDBC connection parameters in /opt/insight_wmsn/insight_wmsn_2.0.5/tomcat-7.0.27/conf/context.xml.
  5. Update the JDBC connection properties for the content management server in /opt/insight_wmsn/insight_wmsn_2.0.5/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-ext.properties. Note: The connection properties should enable the application server content management system to connect to the Oracle-based LPORTAL schema.
  Testing Caveats
  1. The lportal schema will import tables containing columns with clobs into the users tablespace. BIF is working to correct this and to see the import map all lportal objects into the lportal tablespace.
  2. The testing will not handle date filters in the Classification Manager. Some reports are difficult to test for lack of data.
Application Component Downloads Technical Documentation Links
2013-04-25 ver 2.0.6 Part 1 - Database Server Installation
  1. Download WMSNi 2.0 Database Server Objects.
  2. Unzip the file the file to the directory /home/oracle/.
  3. Make sure the operating system user oracle has read write and execute permissions on the new files.
  4. Review the script create_tablespace_and_users.sql located in the step_1 directory.
  5. Execute the script create_tablespace_and_users.sql to drop the current insight and lportal users and recreate the insight and lportal users and grant the needed permissions for the import. This scripts will also create an Oracle directory called directory_expdp that references the directory created when the install files were unzipped (/home/oracle/database_wmsn_2_0_6/step_2/expdp)
  6. Review the parameter files and ensure the parameters are correct.
  7. Copy the imprt execution command in the comment section of the parameter file to execute the impdp form the command line.
  8. Once both impdp jobs have completed successfuly, locate the grant_select_insert_update_on_insight_and_lportal_to_wmsn_app.sql located in the step_3 directory.
  9. Review the grant_select_insert_update_on_insight_and_lportal_to_wmsn_app.sql script and execute it to provide the needed permissions to the wmsn_app role.
  10. Hooray! Database set up complete.
Part 2 - Application Server Installation
Application Component Downloads  
2013-05-02 ver 2.0.7
2013-05-08 ver 2.0.8 Part 1 Database Server Installation
Unzip Files
  • The attached zip file should unzipped to the file path /home/oracle/
  • After the unzipping is done, check to see if it is possible to navigate will navigate to the following file path /home/oracle/wmsni_2_0_8/step_2/expdp
  • As installations change, we should collect a number of directories in the /home/oracle folder for each release. (for example, wmsni_2_0_8, wmsni_2_0_9, etc)
  • Once the files are unzipped to the correct directory, please ensure that read, write, and execute privileges are granted to the linux user oracle.
Update Database files
  • In the /home/oracle/wmsni_2_0_8/ step_1 directory, run the recreate the_directory.sql script to recreate the need oracle directory referencing the newly unzipped files
  • Once the new directory is created, navigate to the /home/oracle/wmsni_2_0_8/step_ and open the file impdp_wmsnoltp.par.
  • Review the file and modify the parameters if needed.
  • To begin the datapump import, issue the  command impdp parfile=/home/oracle/wmsni_2_0_8/step_2/impdp_wmsnoltp.par.
  • Upon successful completion of the datapump import, navigate to /home/oracle/wmsni_2_0_8/step_and open the file create_patient_number_sequence.sql.
  • Running this script will provide the needed sequence for the patient_number.
 2013-05-17 ver 2.0.9  Whats new since 2.0.8:
  • Updated DB references to use explicit schema reference
  • While admitting a patient MEPRS codes only show after choosing OUTPATIENT as encounter type
  • INPATIENT registrar number and OUTPATIENT patient numbers are both shown immediately after selecting the encounter type
  • Patient Number and Registrar numbers now use a sequence from the DB
  • Added a filter for MEPRS codes on outpatient admittance
  • Added a dialogue box that is activated if user tries to admit a patient before MEPRS codes are loaded
  • Fixed a bug where dialogue box was being created but not shown when trying to admit a patient before selecting a ward
  • Admit tab now clears patient info after admittance
  • Dates are now cleared in Admit/Transfer/Discharge tabs
  • Admit tab indicates how to get started more explicitly
  • Fixed Casualty Status alignment on mouseover
  • Server: Changed active user for continuity between BIF and USAMITC policy requirements
2013-06-07 ver 2.0.11 New in 2.0.11:
  • Fixed: Issue where out of bounds exception occurs when discarding an empty workload
  • Fixed: After searching the CI's, the UI now recalculates CI counts and CI’s selected correctly
  • Fixed: Issue where critical indicators UI weren’t correctly clearing the checkboxes when a selected workload had no workload details
  •  Fixed: Issue where sometimes a residual workloads/classifications were left over in the singleSelection object from a previous patient
  • Fixed: Critical Indicator Manager no longer bleeds into other components in lower resolutions
  • Fixed: Some instances on lower resolutions where Organization Browser Tree would bleed into other components
  • Classification Manager now updates workloads after saving, completing and discarding a workload.
  • After selecting a patient the first workload/classification is automatically selected
  • Dialogue box types were changed for successful saves, discards, etc to information type (instead of error type)
  • Remark rich text box now shows a dialogue box if no workload detail is selected.
  • Moved up buttons for all tabs in Patient Manager
  • Decreased width of Patient Manager tabs
  • GUI styling such as padding and spacing for IE 8 and lower resolutions
2013-07-03 ver 2.0.14 New in 2.0.14:Security Features:
  • Permissions to access a ward is now based on Employee permissions and page viewed
  • Employee being used is temporarily hard-coded with all necessary permissions
  • Page viewed is temporarily being hard-coded within each page
Patient Manager (GUI):
  • Required Fields are marked with Asterisks
  • Double asterisks mark starting points
  • Transfer tab now pre-populates current date and time
  • Creating a new classification no longer automatically saves for user continuity
Known Issues:
  • Adding a classification does not correctly populate in the Classification Manager list of Classifications
  • When transferring a patient back and forth between wards sometimes an error date occurs causing that patient to be stuck (i.e., unable to transfer)
2013-07-10 ver 2.0.15 New in 2.0.15:
  • Fixed an issue where wards were showing up twice
  • Fixed a date issue where patients would be stuck in a ward unable to transfer
  • Fixed an issue where Classification/Encounter List does not correctly show a new classification after it is added
  • Added greeting message to some tabs of Patient Manager to indicate where to begin
2013-08-10 ver 2.0.18 New in 2.0.18:
  • Introduced Reporting
    • 24 hour report
    • Unassessed Patient Report
    • Individual Acuity
    •  Two Week Schedule
    • Two Week Skill Export
    • Single Day Schedule
    • Casualty Status Report
  • Introduced IRR module
2013-09-18 ver 2.0.20 New in 2.0.20:
  • Improved handling of business rule issues in the Schedule Manager.
  • Improved handling of journal records in classifications. Fixed and issue where journal records were being duplicated upon completion of the encounter.
  • Improved formatting of table in the Patient Browser.
  • Improved formatting of encounters in the Classification Manager.
  • Improved formatting of classifications in the Classification Manager.
 2013-10-08 ver 2.0.21 Changes in 2.0.21
  • Eliminated problems preventing authentication.
  • Eliminated database script issues.
  • Application Component Downloads
    • WMSNi 2.0 Application
2013-10-24 ver 2.0.22g Changes in 2.0.22g:
  • Improved handling of adding new employees.
  • Improved handling of scheduling shifts that span multiple days.
  • Restricts the user to working with only one WORKING encounter per patient.
  • Incorporates Auxiliary Roster Editor in the Schedule Manager.
  • Eliminates issues with selected schedules not spanning multiple days when the end time is less in numerical values. E.g., Prior to the update if a schedule was based on the times 19:00 - 07:00 the scheduled time for the employee would all be on one day. With the fix the system knows that the scheduled time spans two days.
  • Ensures that the correct category of roles are displayed in the Role Manager. Non-Scheduled items were added to the list; certain roles are related to responsibilities and not nursing functions.
  • Eliminated the case sensitivity on the name search in Role Manager. This change also affects other modules that use the Employee Search component.
  • Eliminated problems with CAC-based authentication.
  • Eliminates issues in the maintenance of Authentication records. New records can be uploaded from certification files.
2013-11-18 ver 2.0.23a Changes in 2.0.23a
  • IRR problems with discarding IRR groups have been resolved.
  • Provides business intelligence updates and improved accessibility using the BIF prompting technology.
  • Application Component Downloads
    • WMSNi 2.0.23a Application
    • BrainJack Insight Portlets Update
2013-11-19 ver 2.0.23b Changes in 2.0.23b
  • Added month_num to IPC variables published through CompositePrompt GWT component.
  • Added day_of_week to IPC variables published through CompositePrompt GWT component.
  • Enabled auto-registration of IPC keys and thus eliminated an unnecessary step in publishing parameters.
  • Application Component Downloads
    • WMSNi 2.0.23b Application
2013-11-20 ver 2.0.23c Changes in 2.0.23c
  • Enabled the loading of Test organizations in the Organization Browser.
  • Further enhanced the handling of IRR groups in IRR Managerf.
  • Application Component Downloads
    • WMSNi 2.0.23c Application
2013-11-20 ver 2.0.23d Changes in 2.0.23d
  • PACU Changes
    • Ensures that only outpatients can be admitted to a Post Anesthesia Care Unit (PACU).
    • Ensures that only outpatient encounters can be created in Classification Manager when working with a PACU.
  • LADS Changes
    • Provides a visual indicator of the number of unclassified days for each patient in the roster.
    • Dynamically updates the unclassified day count based on the number of unclassified days since the patient was admitted.
  • Eliminates errors in using the effective date to filter the data displayed for the user.
  • Application Component Downloads
    • WMSNi 2.0.23d Application
2013-12-05 ver 2.0.23f Changes in 2.0.23f
  • enables Analytic reports
    • Capacity Cube
    • Critical Indicator Utilization Cube
    • Patient Count Cube
  • Personnel Manager
    • enables search in user interface
    • correctly set deleted employee status
    • edit all staff
  • Reports/Classification
    • select patient enabled in Individual reports
  • Reports/Schedule
    • initialize Single Day Schedule work date
  • Reports/Tactical
    • 24Hr report update with Materialized views
    • Ward Activity Report update with Materialized views
    • Nursing Unit Daily WMSN Dashboard query 4 enabled
  • Reports/Other
    • PBAM corrected portal configuration
    • DCN Dashboard Export corrected url
Application Deployment
  1. Deploy order:
    1. back up webapps/birt/ and webapps/wmsn2/
    2. deploy wmsn2_2.0.23f.war as webapps/wmsn2.war
    3. deploy tar xf wmsn2_birt_reports.tar -C webapps/birt/bif/
    4. set_report_URL_plus_enc_pw.sh on webapps/birt/bif/ with temporary test db
  2. details
    1. import db content wmsni_2_0_bi_patch_20131205.zip
2013-12-18 ver 2.0.23h Changes in 2.0.23h
  • Classification Manager 2.0.23h, fixes:
    • Classification Manager saves, completes, and discards correctly in compliance with LADS (Labor) requirements
    • Encounters section no longer overflows the box
    • Classification Manager, error popup now shown if save, discard or complete db conflict occurs
  • Fixed several database record introduced by new requirements
  • IRR Manager, fix issues with create new IRR, view, cancel in-progress IRR
  • Authentication Manager, upload, save, remove error popups now shown
MD5: 803fbc9caaa06b3b42f2e6540beecf7c
2014-01-09 ver 2.0.23hR10 Changes in 2.0.23hR10
  • Classification Manager 2.0.23hR10, fixes:
    • IRR Manager, fix issue with scoring final IRR
Application Deployment
  1. Deploy order:
    1. back up webapps/wmsn2/
    2. deploy wmsn2_2.0.23hR10.war as webapps/wmsn2.war
MD5: 29744e5d396cb70551f2c0ec3c63cbed
2014-01-15 ver 2.0.23hR11 Changes in 2.0.23hR11
  • Classification Manager 2.0.23hR11, fixes:
    • LADS, fix issue with decrementing count of Unclassified Labor & Delivery inpatient days
    • LADS, added prompt to choose the Encounter date from patient's actual admission history
    • LADS, fixed regression (re-enabled creating Outpatient encounters)
Application Deployment
  1. Deploy order:
    1. back up webapps/wmsn2/
    2. deploy wmsn2_2.0.23hR11.war as webapps/wmsn2.war
MD5: d9f98882a5bc1d3e0d59643c5ffaf304
2014-01-16 ver 2.0.23hR12 Changes in 2.0.23hR12
  • Classification Manager 2.0.23hR12, fixes:
    • LADS, fix issue with patient selection jumping when Save or Complete
    • LADS, Outpatient critical indicators now correctly provided for Labor Outpatient
  • Patient Manager 2.0.23hR12, fixes:
    • aligned database timestamps from Patient transfers, to support 2.0 Outpatient calculations
Application Deployment
  1. Deploy order:
    1. back up webapps/wmsn2/
    2. deploy wmsn2_2.0.23hR12.war as webapps/wmsn2.war
  2. Database deploy: (NOTE, Testers do not need to wait for db mv patch to complete. DB mv patch is for 'Tactical > Ward Activity Report' ONLY)
    1. untar wmsni_2_0_mv_patch_20140115.tar
    2. via sqlplus execute run.sql script
2014-01-22 ver 2.0.24R1 Changes in 2.0.24R1
  • Reports (BI) Release 2.0.24R1, includes:
    • Analytic > Capacity Cube, enabled outpatient Dimension
    • Analytic > Patient Count Cube, enabled outpatient Dimension
    • Tactical > 24 Hour Report, fixes outpatient census in the ward Activity table
    • Tactical > Unassessed Patient Report, adds 'Encounter type' column to support Outpatient display
    • Strategic > PBAM Report, support Outpatient NCH
Application Deployment
  1. Deploy order:
    1. back up webapps/wmsn2/
    2. deploy wmsn2_2.0.24R1.war as webapps/wmsn2.war
  2. Database deploy:
    1. untar wmsni_2_0_4_case_m.tar
    2. via sqlplus execute run.sql script
2014-01-27 ver 2.0.24R2 Changes in 2.0.24R2
  • Reports (BI) Release 2.0.24R2, includes:
    • Tactical > 24 Hour Report, fixes error with charge nurse data
    • Strategic > PBAM Report, fixed the title of Work Date selection component
    • Strategic > PBAM Report, moved from Report category 'Other'
    • Strategic > DCN Dashboard Export Report, moved from Report category 'Other'
  • Patient Manager 2.0.24R2, fixes:
    • Admit, fixed back-dated encounter start time for manually admitted patients.
    • Transfer, Discharge, fixed innacurate timezone adjustments.
  • Classification Manager 2.0.24R2, fixes:
    • Outpatient Encounters, fixed innacurate timezone adjustment for newly created encounters.
  • Role Manager 2.0.24R2, fixes:
    • enable component
  • Case Management 2.0.24R2, fixes:
    • Enable CM Dashboard component
Application Deployment
  1. Deploy order:
    1. back up webapps/wmsn2/
    2. deploy wmsn2_2.0.24R2.war as webapps/wmsn2.war
    1. back up webapps/birt/bif/
    2. untar wmsn2_birt_reports24R2.tgz to webapps/birt/bif/
    3. execute set_report_URL_plus_enc_pw.sh, providing oracle system IP and password to be encoded.
  2. Database full deploy:
    1. untar wmsni_2_0_28.tar
    2. cd wmsni_2_0_28/step_1
    3. execute sqlplus @run_step_1.sql
    4. cd wmsni_2_0_28/step_2
    5. execute sqlplus @run_step_2.sql
    6. cd wmsni_2_0_28/step_3
    7. execute sqlplus @run_step_3.sql
    8. cd wmsni_2_0_28/step_4
    9. execute sqlplus @run_step_4.sql
  • Database deploy (patch from 24R1 to 24R2):
    1. untar wmsni_2_0_bi_patch_20140122.tar
    2. via sqlplus execute run.sql script
  • 2014-02-05 ver 2.0.24R3 Changes in 2.0.24R3
    • IRR Manager 2.0.24R3, fixes:
      • Completing IRR, resolved the error message that previously prevented showing final Chart/scoring.
      • Completing IRR, resolved DB error saving Experienced Classifier authorization id. Lack of correct id was preventing IRR detail reports from running.
      • New IRR, patients from previous Completed IRRs are now correctly included in the patient sampling - as long as they have a new Classification.
      • New IRR, 'Replace' button disabled (outside PWS scope, was not on UAT test-plan)
      • New IRR, Experienced classifiers list now correctly shows staff who may Cancel/begin IRR due to Section/MTF/Region/MACOM roles. Classifiers list now excludes MTF staff who have Experienced role, but not for the selected Ward to be tested.
    • Organization Manager 2.0.24R3, fixes:
      • Ward creation, fixed the automatic creation of shift entries (3x standard 8hr and 2x 12hr) for newly created Wards. (Ward Activity Report would not run on the new ward if standard shift was missing)
    • Case Management 2.0.24R3, fixes:
      • (Summary in-progress)
    • WMSNi Database changes (v2.0.24R3):
      • Internal data-structure, updated WORKLOAD table triggers with support for Outpatient field 'encounter_type_code'.
      • Internal data-structure, updated PATIENT table triggers with support for 2.0 field 'patient_date_of_birth'.
      • Internal data-structure, enforce per-patient limits on (Inpatient) WORKLOAD table records. [WORKLOAD_UK1]
      • Internal data-structure, removed unneeded beg_dtm restriction on historical, ORGANIZATION table records. [ORGANIZATION_HIST_UK4]
    Application Deployment
    1. Deploy order:
      1. back up webapps/wmsn2/
      2. deploy wmsn2_2.0.24R3.war as webapps/wmsn2.war
    2. Database full deploy:
      1. untar wmsni_2_0_31.tar
      2. cd wmsni_2_0_31/step_1
      3. execute sqlplus @run_step_1.sql
      4. cd wmsni_2_0_31/step_2
      5. execute sqlplus @run_step_2.sql
      6. cd wmsni_2_0_31/step_3
      7. execute sqlplus @run_step_3.sql
      8. cd wmsni_2_0_31/step_4
      9. execute sqlplus @run_step_4.sql
    2014-02-13 ver 2.0.24R4 Changes in 2.0.24R4
    • Reports, 2.0.24R4
      • Moved Hospital Roster Report from 'Reports'>'Other', to share same page as Patient Mgr.
    • IRR Manager 2.0.24R4, fixes:
      • Completing IRR, Calculation popup '..please wait' is now fixed, so that it stays on screen until the calculation is done.
      • Starting IRR, 'Ok' button is now labeled correctly as: 'Begin IRR'.
    • Patient Manager 2.0.24R4, fixes:
      • Edit - tab updated with 1.0-compatable 'Cancel Admission', 'Cancel Transfer' buttons.
      • Corrected subtitles- Message 'Default component title' on each tab has been removed, replaced with correct description of tab function.
    • Patient Browser 2.0.24R4, fixes:
      • internal - corrected a 'null pointer exception' error that was occurring in the backend logs but was otherwise not noticeable by users.
    • WMSNi Database changes (v2.0.24R4):
      • Capacity Cube - updated daily Labor capacity calculation with patches from wmsni v1.1.0030 and v1.1.0033.
      • Capacity Cube - corrected error in daily Outpatient capacity calculation.
      • -
    Application Deployment
    1. Deploy order:
      1. back up webapps/wmsn2/
      2. deploy wmsn2_2.0.24R4.war as webapps/wmsn2.war
    2. Database full deploy:
      1. untar wmsni_2_0_32.tar
      2. cd wmsni_2_0_32/step_1
      3. execute sqlplus @run_step_1.sql
      4. cd wmsni_2_0_32/step_2
      5. obtain Oracle 'system' password or administrative account
      6. execute: impdp parfile=impdp_insight.par userid=system@wmsnprod
      7. execute: impdp parfile=impdp_lportal.par userid=system@wmsnprod
      8. execute: impdp parfile=impdp_wmsnoltp.par userid=system@wmsnprod
      9. cd wmsni_2_0_32/step_3
      10. execute sqlplus @run_step_3.sql
      11. cd wmsni_2_0_32/step_4
      12. execute sqlplus @run_step_4.sql
    2014-03-07 ver 2.0.24R5 Changes in 2.0.24R5
    • Database 2.0.24R5, fixes:
      • Application configured to connect over Encrypted db service with DoD PKI.
    • Classification Manager 2.0.24R5, fixes:
      • System no longer sends classification Details (services) for COMPLETED workloads.
      • Outpatient - corrected the number of Indicators in outpatient tab (legacy inclusion of inpatient/GENERAL indicators via search button has been removed.)
      • Inpatient - corrected the disabling of Outpatient tab for inpatient encounters.
      • Addressed issue where the first Encounter was auto-selected when form loads. First encounter is no longer automatically selected, and the current encounter now stays focused/selected when 'Save' was pressed.
    • Personnel Manager 2.0.24R5, fixes:
      • Corrected duplicate names in search results.
    • Organization Browser 2.0.24R5, fixes:
      • Corrected issue that prevented users from seeing their section/facility in the tree (occured when user had Roles for only a small number of wards.)
    • WMSNi Database changes (v2.0.24R5):
      • Outpatient Critical Indicator installation. Upgrade is now compatabile with the sample data/test scripts
    Application Deployment
    1. Deploy order:
      1. back up webapps/wmsn2/
      2. deploy wmsn2_2.0.24R5.war as webapps/wmsn2.war
    2. Database full deploy:
      1. untar wmsni_2_0_33.tar
      2. cd wmsni_2_0_33/step_1
      3. execute sqlplus @run_step_1.sql
      4. cd wmsni_2_0_33/step_2
      5. obtain Oracle 'system' password or administrative account
      6. execute: impdp parfile=impdp_insight.par userid=system@wmsnprod
      7. execute: impdp parfile=impdp_lportal.par userid=system@wmsnprod
      8. execute: impdp parfile=impdp_wmsnoltp.par userid=system@wmsnprod
      9. cd wmsni_2_0_33/step_3
      10. execute sqlplus @run_step_3.sql
      11. cd wmsni_2_0_33/step_4
      12. execute sqlplus @run_step_4.sql
     

    Documentation

    WMSNi 2.0
    WMSNi 2.0 Entity Relationship Diagrams (ERD)
    WMSN OLTPSchema
     WMSN OLAPSchema  
    WMSN OLAPCapacity Fact Proposed
    WMSN OLAPCritical Indicator Fact Proposed  
    WMSN OLAPIRR AC Agree Proposed  
    WMSN OLAPIRR CI Agree Fact Proposed  
    WMSN OLAP Patient Fact Proposed
    WMSNi 2.0 Programming APIs
    Client and App Server Technical Documentation Database PL SQL DOC wmsn_calculations Database PL SQL DOC olap_toolkit
    WMSNi 2.0 Connection Pooling
    Oracle Connection Pooling Apache Tomcat Connection Pooling Download: Oracle UCP JAR
    WMSNi 3.0
    WMSNi 3.0 Entity Relationship Diagrams (ERD)
    Proposed ERD

    Log Page

    • Enable :new.aud_beg_emp := wmsnoltp.context_get('EMP'); on triggers
    • Revisit wmsnoltp.patient_location_history primary key

    Apache Tomcat 7

    Version 7.0.39, Mar 22 2013

    BIF Technologies and STARS II

    San Antonio, TX., 31 July 2011 — Following almost two years of rigorous evaluation, BIF Technologies, Corp has been awarded a position on the GSA STARS II contract. The river city consulting firm, specializing in business intelligence and custom software design, has achieved a strategic win by gaining a position …