=============================================================================
Run Date: DEC 16, 2020                     Designation: PREN*3.1*4
Package : PREN - PHARMACY PRODUCT SYS-NATL    Priority: Mandatory
Version : 3.1         SEQ #3                    Status: Released
                  Compliance Date: JAN 15, 2021
=============================================================================


Subject: PPS-N 3.1 VIEW UPDATE on DATABASE

Category: 
  - Informational
  - Other

Description:
============

 The Pharmacy Product System - National (PPS-N) is a Web-based application
 that provides the ability to manage pharmacy-specific data across the VA
 enterprise ensuring that all facilities are using the same base data
 for their operations. It allows approved national VA personnel to easily,
 quickly, and safely manage the VA National Formulary which directs which
 products (such as medications and supplies) are to be purchased and used
 by the VA hospital system. 
  
 Rational item
 -----------------
 Number: 1253920 
  
 Problem
 -----------
 Bad data in Patient Medication Information (PMI) file prevented creating 
 .DAT file on Vista. If First Databank (FDB) schema updates with 
 multi-lined title for monograph, PPS-N National Drug File (NDF) Process 
 is not able to handle the multi-lined title and is preventing/failing to
 create NDF file from PPSN on to VistA.
  
 Resolution
 -----------
 The issue of multi-lined title from FDB is resolved by updating the PPS-N 
 Schema VIEW that is responsible for NDF process. View has been updated to 
 handle FDB multi-lined to single line title. 
  
 Defect Tracking System Ticket(s) & Overview:
 ============================================
 INC10408348 - Bad data in PMI file prevented update PPS_55PRV_56NEW.DAT 
 from being uploaded.
  
 Test Sites:
 -----------
 Testing for patch completed in SQA and lower environments. No IOC 
 testing.
  
 Software and Documentation Retrieval Instructions:
 ------------------------------------------------- 
 The PREN*3.1*4 Informational Patch is available on FORUM. The PREN*3.1*4 
 documentation can be found on the VA Documentation Library (VDL) at: 
 https://www.domain.ext/vdl/
  
 Documentation Title                             File 
 Name                     
 ---------------------------------------------------------------------
 PPS-N v3.1 Deployment, Installation,            pren_3_1_p4_dibr.docx
 Backout & Rollback Guide             
  
 Installation Instructions:
 --------------------------
 NO installation is required at Local sites.

Routine Information:
====================
No routines included.

=============================================================================
User Information:
Entered By  :                               Date Entered  : JUN 08, 2020
Completed By:                               Date Completed: DEC 16, 2020
Released By :                               Date Released : DEC 16, 2020
=============================================================================


Packman Mail Message:
=====================

No routines included