Skip to content

Main content

Medicine Reconciliation Duplicate Package Key Tool

Find repeated complete product/lot/serial keys without numeric coercion.

Loading tool…

Description

Locate duplicate medicine-package record keys.

Pharmacy administration distinguishes medicine and document identifiers, service records, stock balances and payment conventions from decisions about care. Literal labels and supplied status flags help reconcile records, while medicine identity, appropriate treatment and actual availability require independent verification.

Locate duplicate medicine-package record keys.

When to use this tool

Use Medicine Reconciliation Duplicate Package Key when reconciling the stated pharmacy record, inventory, timing or financial convention.

How to use the tool and how it works

  1. Enter productIds, serials, lots. Follow any array-alignment requirements below. Use the units and conventions below.
  2. Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
  3. Read keys, duplicateIndices. Use the output convention below.

Locate duplicate medicine-package record keys. Require aligned productIds/serials/lots; serialize [product,lot,serial] per row, return keys and indexes of every repeated key after its first occurrence.1

Input fieldMeaning and unitsAccepted input
productIdsProduct IdsRequired. Array of text; maximum UTF-16 length 8192; maximum items 256.
serialsSerialsRequired. Array of text; maximum UTF-16 length 8192; maximum items 256.
lotsLotsRequired. Array of text; maximum UTF-16 length 8192; maximum items 256.
Output fieldInterpretationReturned shape
keysKeysRequired. Array of text; maximum UTF-16 length 8192; maximum items 256.
duplicateIndicesDuplicate IndicesRequired. Array of safe integer; maximum items 256.
json
{
  "input": {
    "productIds": [
      "P",
      "P",
      "P"
    ],
    "serials": [
      "001",
      "002",
      "001"
    ],
    "lots": [
      "L",
      "L",
      "L"
    ]
  },
  "output": {
    "keys": [
      "[\"P\",\"L\",\"001\"]",
      "[\"P\",\"L\",\"002\"]",
      "[\"P\",\"L\",\"001\"]"
    ],
    "duplicateIndices": [
      2
    ]
  }
}

Limitations and assumptions

  • Literal duplicate metadata does not establish duplicate dispensing, physical authentication or a reconciliation decision.
  • Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.

Alternative or Complementary methods

Inspect verified medicine and service records and the applicable professional procedures; use appropriate clinical systems and qualified professional judgment for care or supply decisions.

References

  1. Calculation and input contract: clinical-pharmacy/medicine-reconciliation-duplicate-package-key — tool.io

Similar or alternative tools