Format for Pharmaceutical Item Data Upload in CareCode HIMS - hmislk/hmis GitHub Wiki

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.

---

• Definition: A classification column that allows hospitals to categorise items based on their internal management needs, such as discounts, department-specific usage, or procurement types.
• Example Values:
  • General Medicine
  • Emergency Stock
  • Paediatric Use

• Definition: Specifies the pharmaceutical form of the product, indicating how it is administered.
• Example Values:
  • Tablet
  • Capsule
  • Syrup

• Definition: This is the brand name or trade name of the product as marketed by the manufacturer.
• Example Values:
  • Acarb Tablet 50mg
  • Acetazolamide 250mg Tablets
  • Aldactone 100mg Tablets

• Definition: Represents a standardised description of the medicinal product, inclusive of the strength, dosage form, and active ingredient(s).
• Example Values:
  • Acarbose 50mg Tablet
  • Acetazolamide 250 mg Tablet
  • Spironolactone 100 mg Tablet

• Definition: The generic name or active ingredient of the medicinal product. It helps group products with the same therapeutic moiety.
• Example Values:
  • Acarbose
  • Acetazolamide
  • Spironolactone

• Definition: The amount of active ingredient in each unit of the product. This should only contain the numeric value.
• Example Values:
  • 50
  • 100
  • 250

• Definition: The unit of measurement for the strength of the product. Commonly used units include mg (milligrams) or mcg (micrograms).
• Example Values:
  • mg
  • mcg

• Definition: The form in which the product is issued or dispensed.
• Example Values:
  • Tablet
  • Capsule
  • Sachet

---

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.

---

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

---

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