Alternate IDs

Owned by Rick Eggleston (Unlicensed)
Last updated: Jul 14, 2021

Overview

  1. The Lot Number, Serial Number, and NDC Number have been merged into the Product and Inventory 'Alternate ID' functionality.
  2. Users can now define their own Alternate ID Types.
  3. In order to facilitate existing functionality, the User-defined Alternate ID Types can be mapped to, and used in place of, the existing system-defined Lot Number, Serial Number, and NDC Number fields.
  4. The National Drug Code database can now be imported and associated with Products.
  5. Alternate ID Types can also be defined as:
    1. A 'Unique Inventory Attribute' and used for Inventory Aggregation.
    2. A 'Barcode' to be used for Barcode Scanning.
    3. An 'Inventory' Alternate ID Type, to be assigned only to Inventory.
    4. A 'Product' Alternate ID Type to be assigned only to Products.
    5. A 'Prescription' Alternate ID Type to be assigned only to Prescriptions.


VetView Wiki

Most recent releases of VetView:  Version 5.0.2 and 4.2.8 Hotfix (Released 12/20/2024) 

This page may contain functionality not found in the current version of VetView.
Contents

Functionality

 Alternate ID Type Setup...
  1. Navigate to the 'Hospital Setup' screen via the 'Navigation Menu'.
  2. Navigate to the 'Inventory Setup' tab.
  3. Navigate to the 'Alternate ID Type Setup' subtab.
  4. Add or Edit Alternate ID Types for:
    • Inventory
      • Use for Inventory - the Alternate ID Type will appear when an Alternate ID is needed, or displayed, for Inventory.
    • Prescriptions
      • Use for Rx - the Alternate ID Type will appear when an Alternate ID is needed, or displayed, for Prescriptions.
    • Products
      • Use for Product - the Alternate ID Type will appear when an Alternate ID is needed, or displayed, for Products.
    • Existing Alternate ID Types
      • Maps To - provides the ability to map the old enumerated TYPE (Serial Number, Lot Number, NDC Number, etc.), to the User-defined Alternate ID Type.
        • An Alternate ID Type can be defined to replace each of the existing enumerated Types:
          • TYPE (HOSPITAL_PRODUCT_ALTERNATE_ID):
            • 'Barcode Order' (BARCODE_YN = 'Y')
            • 'Barcode Sales' (BARCODE_YN = 'Y')
            • 'Barcode Stock' (BARCODE_YN = 'Y')
            • 'CDM Product Code'
            • 'Lab Product'
            • 'Lot Number'
            • 'NDC Number'
            • 'Other'
            • 'Serial Number'
        • And, similar attributes of other tables:
          • LOT_NUMBER (HOSPITAL_INVENTORY)
          • LOT_NUMBER (HOSPITAL_INVENTORY_TRANS)
          • NDC (HOSPITAL_PRODUCT_MASTER
          • SERIAL (HOSPITAL_INVENTORY)
          • SERIAL (HOSPITAL_INVENTORY_TRANS)
          • SERIAL_NUMBER (HOSPITAL_PRODUCT_ALTERNATE_ID)
        • Each enumerated value must be unique; so for example, 'Lot Number' can Map To only one Alternate ID Type.
    • Barcode
      • Barcode flag - is a boolean field that designates the Alternate ID Type as a Barcode, causing it to appear in the list of Alternate IDs that can be printed as a Barcode label.
    • Unique Inventory Attribute
      • Aggregate On - if this option is selected, the Alternate ID Type will become one of the Unique Inventory Attributes used to Aggregate Inventory.


 Alternate ID Setup...
  1. Navigate to the 'Product Setup' screen via the 'Navigation Menu'.
    1. Search for, and select, a Product.
    2. The 'Product Info' screen will open.
  2. Navigate to the 'Alternate ID Setup' tab.
  3. Add or Edit Alternate IDs for the Product.


Definitions

  • Following is a table of definitions for the screens (Components), components of screens (Subcomponents), fields (UI Element labels, names and entities), controls (names and entities), DB columns, adjustment types, privileges, attributes, and specs that have a direct, or indirect, connection to the term 'Alternate ID'.
  • Use the controls at the top of the table to change the sort, grouping, and row height.
  • To see more of the cell content, click on the cell expansion control located at the top-right corner of a selected cell.

Open Issues

key summary type priority status fixversions
Refresh