$TXT Created by K. at MNTVBB.FO-WASH.DOMAIN.EXT (KIDS) on Friday, 12/08/17 at 13:34 ============================================================================= Run Date: FEB 05, 2020 Designation: PRC*5.1*198 Package : PRC - IFCAP Priority: Mandatory Version : 5.1 SEQ #188 Status: Released Compliance Date: MAR 07, 2020 ============================================================================= Associated patches: (v)PRC*5.1*63 <<= must be installed BEFORE `PRC*5.1*198' (v)PRC*5.1*81 <<= must be installed BEFORE `PRC*5.1*198' (v)PRC*5.1*108 <<= must be installed BEFORE `PRC*5.1*198' (v)PRC*5.1*159 <<= must be installed BEFORE `PRC*5.1*198' (v)PRC*5.1*163 <<= must be installed BEFORE `PRC*5.1*198' Subject: NIF/IFCAP ITEM MASTER FILE INTERFACE ENHANCEMENT Category: - Routine - Enhancement (Mandatory) - Input Template - Other - Data Dictionary - Print Template Description: ============ At present each of the over 140 VHA facilities needs to maintain its own copy of its VistA instance's IFCAP Item Master File (IMF). The IMF is used to identify an item, the source vendor(s), and the item/vendor specific information including any national contracts. The Procurement and Logistics (P&L) Office has established a National Item File (NIF) database of standardized items and assigned NIF Item Numbers to be used as a common identifier for reporting across VA databases. At present the P&L Office can send the NIF Item Number and standardized values of short and extended descriptions to IFCAP for populating the corresponding entry in its Item Master File (#441). Every five years VHA negotiates new contracts for the Medical/Surgical Prime Vendor (MSPV) program. In support of the new Medical/Surgical Prime Vendor Next Generation (MSPV-NG) contract the P&L Office wants to bulk load approximately 10,000 items along with their vendor/item specific data into the Item Master File of each VistA instance in order to eliminate required manual entry and to improve data quality. This process may result in the insertion of new items or update of existing items. Many more fields need to be populated than is supported by the existing NIF/IFCAP interface. This patch implements the following to enhance data quality: 1. A new item interface with more data fields, populated in the ANSI X.12 832 Price/Sales Catalog transaction format. 2. Bulk loading of a new standardized file of manufacturers to be referenced by a new manufacturer field in the Item Master (#441) file. Access to option Manufacturer Bulk Load [PRCHITEM MANUFACTURER LOAD] is locked by new security key PRCHITEM SUPER. There is also new option Manufacturer File Edit [PRCHITEM MANUFACTURER E/E] locked by this key. 3. Bulk loading of items standardized by the P&L Office's NIF Maintenance Office. Access to option Load Items From Host File [PRCHITEM_BULK_LOAD_VIA_HFS] is locked by security key PRCHITEM SUPER. 4. In background creation and update of standardized items via e-mail delivery to each IFCAP instance. 5. Creation of a restricted range of Item Master File Numbers (IMF#), whose entries are editable only by the interface or those users assigned the security key PRCHITEM SUPER. 6. Creation of a restricted range of Vendor Numbers whose entries may only be created or updated by users assigned the new security key PRCHVEN. 7. Reporting of interface filing exceptions locally to members of the ISM mail group and centrally to the NIF Maintenance Office. This identifies entries requiring subsequent update once the issue is resolved. Patch Components: ----------------- Files & Fields Associated: File Name (Number) Field Name (Number) New/Modified/Deleted ------------------ ------------------- -------------------- ITEM MASTER (441) NUMBER (.01) Modified ITEM MASTER (441) DATE UPDATED BY NIF (53) New ITEM MASTER (441) MANUFACTURER (25) New ITEM MASTER (441) NIF ITEM NUMBER (51) Modified ITEM MASTER (441) NIF UPDATE DATE (54) New ITEM MASTER (441) SOURCE MFG PART New NO. (19.1) ITEM MASTER (441), NDC (4) Modified VENDOR subfile (441.01) ITEM MASTER (441), SOURCE VENDOR New VENDOR subfile STOCK # (3.1) (441.01) MANUFACTURER (440.4) New SOURCE MFG/STOCK New NUMBER (440.45) VENDOR (440) NUMBER (.001) Modified Forms Associated: Form Name File # New/Modified/Deleted --------- ------ -------------------- N/A Mail Groups Associated: Mail Group Name New/Modified/Deleted --------------- -------------------- N/A Options Associated: Option Name Type New/Modified/Deleted ----------- ---- -------------------- PRCHITEM_LOAD server New PRCHITEM_BULK_LOAD_VIA_HFS run routine New PRCHITEM MANUFACTURER E/E edit New PRCHITEM MANUFACTURER LOAD run routine New PRCHITEM MANUFACTURER PRINT print New PRCO EDI VENDOR edit Modified Protocols Associated: Protocol Name New/Modified/Deleted ------------- -------------------- N/A Security Keys Associated: Security Key Name ----------------- PRCHITEM SUPER PRCHVEN Templates Associated: Template Name Type File Name (Number) New/Modified/Deleted ------------- ---- ------------------ -------------------- PRCHITEM Input ITEM MASTER (#441) Modified PRCHITEM2 Input ITEM MASTER (#441) Modified PRCHITEM MANUFACTURER print MANUFACTURER (#440.4) New New Service Requests (NSRs): ---------------------------- N/A Patient Safety Issues (PSIs): ----------------------------- None Defect Tracking System Ticket(s) & Overview: -------------------------------------------- None Test Sites: ---------- The following sites participated in testing this software. * Albany Stratton VA Medical Center * Cincinnati VA Medical Center * Tomah VA Medical Center Software and Documentation Retrieval Instructions: ---------------------------------------------------- The software is delivered via a KIDS distribution in a message generated from the National Patch module. Documentation describing the new functionality introduced by this patch is available. The preferred source of documentation files is download.vista.domain.ext. This transmits the files from the first available server. Sites may also elect to retrieve files directly from a specific server. Sites may retrieve the documentation directly using Secure File Transfer Protocol (SFTP) from the ANONYMOUS.SOFTWARE directory at the following OI Field Offices: Hines: domain.ext Salt Lake City: domain.ext Documentation can also be found on the VA Software Documentation Library at: https://www.domain.ext/vdl/ Title File Name FTP Mode ----------------------------------------------------------------------- Accounting Technician IFCP5_1ACCOUNTING_TECH.PDF binary User's Guide Application Coordinator IFCP5_1APPLICATION_COORD.PDF binary User's Guide Purchasing Agent User's IFCP5_1PURCHASING_AGENT.PDF binary Guide Technical Manual IFCP5_1TECH_MANUAL.PDF binary Patch Installation: Pre/Post Installation Overview: ------------------------------- After patch installation, the environment check routine PRC51198 may be deleted. Pre-Installation Instructions: ------------------------------ This patch may be installed with users on the system although it is recommended that it be installed during non-peak hours to minimize potential disruption to users. This patch should take less than 30 minutes to install. If installed during the normal workday, it is recommended that the following selections in the OPTION (#19) file and all of their descendants be disabled to prevent possible conflicts during the installation. Other VistA users will not be affected. EDI Vendor Edit [PRCO EDI VENDOR] Item File Edit [PRCHPC ITEM EDIT] P&C Utilities Menu [PRCHPC UTL] Vendor File Edit [PRCFA VENDOR FILE EDIT] This patch should take fewer than 30 minutes to install. Installation Instructions: -------------------------- 1. Choose the PackMan message containing this patch. 2. Choose the INSTALL/CHECK MESSAGE PackMan option. 3. From the Kernel Installation and Distribution System Menu, select the Installation Menu. From this menu, you may elect to use the following options. When prompted for the INSTALL NAME enter the patch #(ex. PRC*5.1*198): a. Backup a Transport Global - This option will create a backup message of any routines exported with this patch. It will not backup any other changes such as DDs or templates. b. Compare Transport Global to Current System - This option will allow you to view all changes that will be made when this patch is installed. It compares all components of this patch routines, DDs, templates, etc. c. Verify Checksums in Transport Global - This option will allow you to ensure the integrity of the routines that are in the transport global. 4. From the Installation Menu, select the Install Package(s) option and choose the patch to install. 5. When prompted 'Want KIDS to Rebuild Menu Trees Upon Completion of Install? NO//' answer NO unless your system does not do this in a nightly TaskMan process. 6. When prompted 'Want KIDS to INHIBIT LOGONs during the install? NO//' answer NO 7. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//' answer YES. When prompted 'Enter options you wish to mark as 'Out of Order':' enter the following options: EDI Vendor Edit [PRCO EDI VENDOR] Item File Edit [PRCHPC ITEM EDIT] P&C Utilities Menu [PRCHPC UTL] Vendor File Edit [PRCFA VENDOR FILE EDIT] When prompted 'Enter protocols you wish to mark as 'Out of Order':' press . 8. If prompted 'Delay Install (Minutes): (0 - 60): 0//' respond 0. Post-Installation Instructions: ------------------------------- 9. Using option Edit options [XUEDITOPT] or VA FileMan's option Enter or Edit File Entries [DIEDIT] link the existing resource device PRCHITEM to the SERVER DEVICE (#227) field of the new option PRCHITEM_LOAD as follows: Select Menu Management Option: EDIT OPTions Select OPTION to edit: PRCHITEM_LOAD Server processing 832 txn to load Item Master File NAME: PRCHITEM_LOAD// ^SERVER DEVICE SERVER DEVICE: nnn// PRCHITEM NA PRCHITEM ZTSK RETENTION DAYS: ^ Select OPTION to edit: Or Select VA FileMan Option: enter or Edit File Entries Input to what File: OPTION// (10414 entries) EDIT WHICH FIELD: ALL// SERVER DEVICE THEN EDIT FIELD: Select OPTION NAME: PRCHITEM_LOAD Server processing 832 txn to load Item Master File SERVER DEVICE: nnn// PRCHITEM NA PRCHITEM Select OPTION NAME: ************************************************************************* * Note: The Procurement and Logistics Office will coordinate with sites * * when to assign the security keys and load entries from host files. * ************************************************************************* Routine Information: ==================== The second line of each of these routines now looks like: ;;5.1;IFCAP;**[Patch List]**;OCT 20, 2000;Build 6 The checksums below are new checksums, and can be checked with CHECK1^XTSUMBLD. Routine Name: PRC51198 Before: n/a After: B1736077 **198** Description of Changes: This is the environment check routine for the KIDS Distribution installation. Routine Name: PRCFAC3 Before: B19663832 After: B21588455 **81,198** Description of Changes: This routine was edited at E10A1 and E10B1 to add the logic: S DIC("S")="I (+Y<950000)!$D(^XUSEC(""PRCHVEN"",DUZ))" so that only privileged users assigned the PRCHVEN security key will be able to select a vendor with an ien of 950000 or higher. Routine Name: PRCHE Before: B72223463 After: B73438080 **1,28,39,81,63,144,163,198** Description of Changes: Modification of module EN1 for changes to permissions for editing items. A DIC("S") screen was added to the ^DIC look up input parameters so that unless the user has been assigned the PRCHITEM SUPER security key, the user won't be able to select for editing an item with an ien (IMF#) greater than 19999999. Another modification was made so that the holder of this security key is also offered for update the Short Description and (long) Description, in addition to the other fields. Routine Name: PRCHE1 Before: B23958557 After: B28018038 **7,59,55,81,198** Description of Changes: Edits were made to protect vendor entries with iens greater than 949999 from edits by users not assigned the PRCHVEN security key. Routine Name: PRCHEA1 Before: B23232021 After: B24918554 **81,198** Description of Changes: Added the following screens for ^DIC item lookup to prevent selection of item with ien of 20,000,000 or higher unless the user holds the PRCHITEM SUPER security key. DIC("S")="I (+Y<20000000)!$D(^XUSEC(""PRCHITEM SUPER"",DUZ))" Routine Name: PRCHITM3 Before: n/a After: B60839011 **198** Description of Changes: This routine controls the selection of the host file containing the X.12 832 Price/Sales Catalog transaction, reads the contents and parses out the data. For each item entry it calls the filer routine PRCHITM5. Routine Name: PRCHITM4 Before: n/a After: B29878524 **198** Description of Changes: This routine is invoked by the Server type option PRCHITEM_LOAD when a MailMan message is received with an X.12 832 Price/Sales Catalog transaction. It reads the lines of the message and parses out the data. It then invokes the filer routine PRCHITM5. Routine Name: PRCHITM5 Before: n/a After:B101744279 **198** Description of Changes: This routine is called by either PRCHITM3 or PRCHITM4 and files the parsed data into the Item Master file (#441) header file and vendor subfile entry. Routine Name: PRCHITM6 Before: n/a After: B37937541 **198** Description of Changes: Manufacturer load routine Routine Name: PRCHNPO5 Before: B38701458 After: B38743024 **113,159,198** Description of Changes: In module EN11 replaced Write statement with a call to EN^DDIOL(). This module is referenced in the input transform of the CONTRACT field (#2) in the Vendor subfile (#441.01) of the Item Master file (#441). Routine Name: PRCHNPT Before: B1872539 After: B1982655 **108,198** Description of Changes: Replaced Write statement at EN1+2^PRCHNPT in input transform for NSN with a call to EN^DDIOL(). Routine Name: PRCVITMU Before: B7776696 After: B8640883 **81,198** Description of Changes: The TRANS section was modified to prevent users from adding new items with ien greater than 19999999, while allowing the NIF interface to do so. Routine list of preceding patches: 108, 159, 163 ============================================================================= User Information: Entered By : Date Entered : NOV 15, 2016 Completed By: Date Completed: FEB 05, 2020 Released By : Date Released : FEB 05, 2020 ============================================================================= Packman Mail Message: ===================== $END TXT