Wiki Article: Format for Pharmaceutical Item Data Upload in CareCode HIMS

The CareCode HIMS requires a standardised format for uploading pharmaceutical item data. This format ensures consistency and accuracy in inventory and prescribing systems. Below is the description of the columns and their expected contents in the Excel file format.


Columns and Definitions

Category

Dosage Form

AMP (Actual Medicinal Product)

VMP (Virtual Medicinal Product)

VTM (Virtual Therapeutic Moiety)

Strength

Strength Unit

Issue Unit


Guidelines for Preparing the Data

  1. Consistency: Ensure all data fields are consistently filled, particularly for VMP and VTM, to avoid duplication.
  2. No Blank Rows: Every row should contain valid data for all mandatory columns.
  3. Standardised Units: Use the approved abbreviations for strength units (e.g., mg, mcg).
  4. Accuracy: Double-check spelling, especially for VTM, to avoid incorrect mapping of therapeutic moieties.
  5. Category Allocation: Use meaningful categories to aid hospital workflow; these can vary based on the hospital’s preferences.

Example Dataset

Category | Dosage Form | AMP | VMP | VTM | Strength | Strength Unit | Issue Unit -- | -- | -- | -- | -- | -- | -- | -- General Medicine | Tablet | Acarb Tablet 50mg | Acarbose 50mg Tablet | Acarbose | 50 | mg | Tablet Emergency Stock | Tablet | Acetazolamide 250mg Tablets | Acetazolamide 250 mg Tablet | Acetazolamide | 250 | mg | Tablet Allergy Care | Tablet | Allegra 180mg Tablets | Fexofenadine Hydrochloride 180 mg Tablet | Fexofenadine Hydrochloride | 180 | mg | Tablet

Conclusion

The above format and guidelines provide a standardised approach to uploading pharmaceutical data into the CareCode HIMS. Following these ensures smooth integration of inventory and prescribing modules, ultimately enhancing hospital operations.

[Back](https://github.com/hmislk/hmis/wiki/Set-up)