Skip to main content

Drug information database and counselling tools (Beratung: ABDA-Datenbank, Aktuelle Informationen, Alternative Medizin, Arzneimittelprofile, Cross-Selling, Gefahrstoffe, Kampagnen, Kundeninformationen/-aufgaben)

1. Purpose and scope​

This chapter covers the "Counselling" (Beratung) menu of IXOS, excluding Contacts and E-Health, which belong to other chapters. It describes eight functional areas:

  1. Drug information database (ABDA-Datenbank) — a licensed national reference work embedded in the pharmacy system. It has five sub-modules: German finished medicinal products, international finished medicinal products, a pharmaceutical substance list, active-substance dossiers (monographs) and an interaction check. It also provides a "comparison search" for therapeutic alternatives and patient-risk ("CAVE") filtering.
  2. Current information (Aktuelle Informationen) — a searchable feed of safety and regulatory notices linked to articles, products, substances and suppliers.
  3. Alternative medicine (Alternative Medizin) — a symptom-driven finder for homeopathic remedies and mineral-salt remedies, linked to sellable articles.
  4. Drug profiles (Arzneimittelprofile) — a substance-level quick-reference of icons and dosing hints taken from a third-party reference book.
  5. Cross-selling — configuration of rules that make the point of sale suggest add-on articles.
  6. Hazardous substances (Gefahrstoffe) — an embedded third-party program for chemical-safety compliance and dispensing of hazardous chemicals.
  7. Campaigns (Kampagnen) — predefined campaigns that prompt staff at the till to offer paid pharmaceutical services to matching customers.
  8. Customer information / tasks (Kundeninformationen / -aufgaben, "KIA") — a rule engine for customer-targeted notes, tasks and questions that surface at the till, with automatic follow-up actions.

The reference content itself is a licensed German product. This chapter records only the functional shape of the knowledge base: which entities, attributes, classifications and links a central drug directory needs so that the described searches and displays can work. No reference content is reproduced.

Who uses it: dispensing staff during a sale (lookup of the article being sold, printing information for the customer, finding an alternative), pharmacists doing research away from the till, and managers who configure cross-selling, campaigns and customer tasks.

2. Key concepts and terms​

German termEnglishMeaning
ABDA-DatenbankDrug information databaseLicensed national drug information system; content is the publisher's responsibility, the software vendor only reformats and redistributes it.
Fertigarzneimittel (FAM)Finished medicinal productA product (trade name + dosage form + supplier), independent of pack size. One product has one or more packs (articles).
Deutsche FAM / Internationale FAMGerman / international product directoryTwo separate product directories with the same search method; international products carry fewer attributes (no indications).
Artikel, PZNArticle (pack), national pack numberThe sellable pack with price and stock. Belongs to the article master, linked to a product.
Taxe-AnsichtPack-level price-list viewJump from product research to the list of packs (with prices) of the found products.
KomponenteComponentA product can consist of several components (e.g. two different tablets in one pack); each has its own composition and dosage-form data.
Wirkstoff / HilfsstoffActive substance / excipientRoles of a substance within a component.
EntsprichtstoffEquivalent ("corresponds-to") substanceThe substance a declared ingredient is equivalent to (for example the base that a salt corresponds to); used to match products whose ingredient is declared as a different salt or derivative.
Salze/DerivateSalts / derivativesSubstances chemically derived from a main substance.
Hauptstoff (H) / Folgestoff (F)Main substance / follow-up substanceMonograph hierarchy: for chemically defined substances the acid or base is the main substance and its salts and derivatives are follow-ups; for plants, animals and micro-organisms the follow-ups are parts or preparations. Empty when not classifiable.
DarreichungsformDosage formTablet, drops, cream and so on.
Galenische GrundformBasic galenic formThe pharmaceutical-technological preparation form of a component inside its packaging; coarser than the dosage form.
FreisetzungsverhaltenRelease behaviourCoded speed of release of the active substance from the form, relative to a standard application.
ApplikationApplicationA way the product is used, described by four criteria: use form (Anwendungsform), route (Applikationsweg), site (Applikationsort), type (Applikationsart). A product can have several applications.
AbgabeformDispensing formCoded attribute of how the product is supplied (search criterion; not explained further in the help).
ATC-Code (WHO) / ATC-Code (deutsch)ATC classification, WHO and national variantHierarchical therapeutic-chemical classification; both variants are stored and searchable, each with a keyword index.
IndikationsschlüsselIndication keyPublisher's hierarchical classification of indications, with keyword index; a product has a main indication.
TherapierichtungTherapy directionAllopathic, herbal, homeopathic, anthroposophic.
StandardhinweiseStandard hintsCoded short counselling hints attached to products; a pharmacy-chosen subset is shown at the till.
PatientenhinweisePatient hintsHints worded for the patient; printable.
Anbruchshinweis / AufbewahrungshinweiseOpened-pack hint / storage hintsStorage rules, including after first opening.
FertigarzneimitteltexteProduct textsLong structured text monograph per product, by topic; derived from, but not identical to, the official professional information.
FachinformationProfessional information (SmPC)Original manufacturer document, shown as PDF.
PackungsbeilagePackage leafletOriginal patient leaflet, shown as PDF.
Rote-Hand-Brief"Red hand" letterOfficial urgent safety letter from a manufacturer to professionals.
InformationsbriefInformation letterLess urgent manufacturer letter.
SchulungsmaterialTraining materialOfficially required educational material for a product; has type, addressee, version, "harmonised" flag.
CAVEPatient-risk checkProduct-level statements about suitability for patient characteristics: age, sex, disease, allergy, body weight, kidney function.
MIV (medikationsrelevanter Individualparameter)Medication-relevant individual parameterKeyed vocabulary of patient characteristics (diseases, allergies) with synonyms, preferred terms, definitions and a hierarchy.
Hauptbegriff / Folgebegriff / EinzelbegriffMain term / follow-up term / stand-alone termHierarchy of disease terms: unspecific, refined and self-sufficient.
AnwendungsrisikoApplication riskOne concrete patient characteristic entered as a risk criterion (for example "age 68 years").
BedingungCondition (suitability level)Five-step rating of a product for a risk: unrestricted suitable, intermediate 1, restricted suitable, intermediate 2, contraindicated.
Pharmazeutische StofflistePharmaceutical substance listDirectory of substances with identifiers, chemistry, legal status, relations.
ASK-Nummer, CAS-Reg.-Nummer, SNOMED CTSubstance identifiersNational substance key, Chemical Abstracts number, SNOMED code.
Wirkstoffdossier / MonografieActive-substance dossier / monographPharmacological monograph for a substance, readable through situation-specific views.
SchlagwortKeywordIndexed term of a dossier, attached to a section of the dossier.
InteraktionscheckInteraction checkLookup of interactions between products, substances, substance groups and foods.
InteraktionsgruppeInteraction groupGroup of substances that share an interaction behaviour.
LeitmaßnahmeLead measureThe primary recommended action for an interaction.
DatenlageState of evidenceQuality of evidence behind an interaction rating.
VergleichssucheComparison searchSearch for products similar to a given source product.
SchnellsucheQuick searchPredefined six-level similarity search.
Sondengängigkeit / SondenapplikationTube suitability / tube administrationWhether and how a product can be given through a feeding tube.
Teilbarkeit, KerbeDivisibility, score lineWhether a tablet may be split into equal doses; score-line count, shape and splitting behaviour.
Besondere VerabreichungSpecial administrationStandardised administration measures classed as allowed, to be avoided or forbidden.
Aktuelle Informationen, MeldungsartCurrent information, message typeNotices from the data publisher, typed and dated.
AMKDrug commission of the pharmacistsNational body whose safety notices are part of the feed.
Alternative MedizinAlternative medicineModule for homeopathy and Schüßler salts.
Einzelmittel / KomplexmittelSingle remedy / complex remedyHomeopathic preparation with one or several starting substances.
Schüßler-Salze / Schüßler-KurMineral-salt remedies / cureMineral salts in homeopathic potency; a cure combines up to three salts.
Gängiges PräparatCommon preparationOften recommended, well-known remedy; preferred for self-medication; default filter.
Krankheitsbild, Anwendungsgebiet, SymptomClinical picture, area of use, symptomThree-level tree used to find remedies.
Arzneimittelprofile (nach Dr. Framm)Drug profilesSubstance-level icon and dosing-hint summaries from a third-party book.
Cross-SellingCross-sellingAdd-on sale recommendations at the till.
AusgangsgruppeSource group (trigger group)Defines which sold articles trigger a recommendation: a goods-classification group or one specific pack.
EmpfehlungsgruppeRecommendation groupOrdered list of articles to recommend, with a hint text and an icon.
ABDA-WarengruppeNational goods classification groupHierarchical product-category key from the article master.
Filial- und Partnerverbund (FuP)Branch and partner groupSeveral pharmacies exchanging data.
Quellen priorisierenPrioritise sourcesChoose and rank whose cross-selling data is used.
GefahrstoffeHazardous substancesChemicals regulated by hazardous-substances law.
Gefährdungsbeurteilung, Betriebsanweisung, Gefahrstoffverzeichnis, Sicherheitsdatenblatt, ExplosionsschutzdokumentRisk assessment, operating instruction, hazardous-substance register, safety data sheet, explosion-protection documentOccupational-safety documents.
Abgabewunsch, Empfangsschein, UnterweisungDispensing request, receipt slip, instructionGuided sale of a hazardous chemical with customer acknowledgement.
PDL (pharmazeutische Dienstleistungen)Pharmaceutical servicesRemunerated services: antitumour therapy counselling, blood-pressure measurement, inhalation technique, polymedication review.
KampagneCampaignPredefined pairing of a question and a follow-up task targeted at a customer selection.
KIA (Kundeninformationen / -aufgaben)Customer information / tasksModule for customer-targeted information, tasks and questions.
Kundeninfo auf einen BlickCustomer info at a glanceTill window listing a customer's active entries.
KundenselektionCustomer selectionA dynamic report query or a fixed customer list used to assign customers.
Einschlüsse / AusschlüsseInclusions / exclusionsSelections that add or remove customers from the target set.
TurnusRecurrence cycleRepetition settings for tasks and questions.
Notes-AufgabeInternal to-do taskTask in the staff task/calendar module.
LaufkundeWalk-in customerAnonymous customer without a customer record.
Artikel-Info ProfiPremium article-information licencePaid licence that unlocks leaflets, general documents, identification data, tube data and their printing.

3. Data model​

The help describes screens, not tables. The model below is what a system needs in order to offer the described functions; attribute lists come from the search criteria, list columns and detail pages. Items marked (inferred) are structural conclusions, not statements of the help.

3.1 Central drug directory​

Product (finished medicinal product) — one directory for the home market, one for international products.

  • Identity: trade name, supplier, dosage form; link to supplier master; links to its packs (articles).
  • Status flags (shown as icons with a fixed priority, see 6.1): out of trade, recalled, withdrawn, before market launch, not marketable, deleted variants of these; predecessor and successor product; special article (physician sample, sample article); self-created.
  • Legal/dispensing flags: prescription-only, narcotic, blood product, haemophilia product, non-prescription blood product, special-prescription type, general or conditional substitution exclusion, clinic pack component, pharmacy-only; an overlay flag "needs monitoring" for prescription and non-prescription drugs and narcotics.
  • Classification: ATC code (WHO), national ATC code, indication keys (hierarchical; one main indication), therapy direction, dispensing form.
  • Dosage-form structure per component: basic galenic form, release behaviour (fast, normal, pH-dependent, delayed, differentiated, constant, none), applications (each with use form, route, site, type).
  • Composition per component: substance, role (active, excipient), strength (amount + unit), equivalent substance and its strength, release-rate statement where relevant (e.g. patches).
  • Counselling data: standard hints (coded), patient hints, dosage, storage hints, opened-pack hint (single use, moisture protection, refrigerator, light protection, room temperature, immediate use).
  • Identification data: colour, two-colour flag and second colour, basic shape, top-view shape, side-view shape, diameter, length, width, height, mass, number of score lines, score shape, score-splitting statement, divisibility (into 2, 3, 4 or 6 equal-dose parts), pictures.
  • Special administration statements: measure + class (allowed, avoid, forbidden).
  • Tube administration data: per tube end position and per tube material a compatibility statement with source grade (yes per professional information; yes per manufacturer, off-label; conditionally compatible), minimum tube opening.
  • Patient-risk (CAVE) statements: per risk area (age range, sex, disease term, allergy term incl. cross-reactions, body-weight range, kidney-function range) a five-level suitability rating, with hint text, definition and source citation. Areas without data are "not checkable" for that product.
  • Texts: product text monograph divided into topics (properties, effects, indications and so on).
  • Documents: professional information, package leaflet, general supplementary documents, safety letters, information letters, training material, other documents (dietetic document, dietetic folding box, instructions for use, product information, dressing-material document).
  • Links: current-information messages, dossiers (through its substances), substance-list entries (through its substances), interactions (through its substances).

Pack / article — belongs to the article master (other chapter): pack number, pack size and unit, price, stock status, order status, import flag, stock-article flag. The drug database only links to it.

Substance

  • Publisher substance number, preferred name, synonyms (each flagged as synonym with pointer to preferred term), origin of the name (nomenclature source), molecular formula, CAS number, national substance key (ASK), SNOMED CT code.
  • Monograph relation: main (H) or follow-up (F), with the list of related substances per monograph family.
  • Substance groups and group types; "use" tags (active substance, excipient, substance in cosmetics, and so on).
  • Flags: prescription-only, narcotic, homeopathic, anthroposophic; precursor-control status.
  • Pages of data: characterisation (herbal substances), properties and use, chemical and physical data (formula, molar mass, solubility, spectroscopy, colour, density), legal information, substance-group information, a "transition assessment" (Überleitungsbewertung; not explained).
  • Allergy tree: the allergies this substance can trigger, each with hint text and risk definition.
  • Routes of administration available for the substance (needed by the interaction check).
  • Links: products containing it (both directories), dossiers, current-information messages.

Dossier (monograph)

  • Monograph title; assigned substances (many-to-many; when reached from a product each substance carries its role in that product).
  • Content blocks, each tagged with one or more situation views (see 4.19).
  • Keywords, each attached to a named dossier section, so a keyword search can report "keyword — section (count)".
  • Coded attributes for searching: application site, use group, affects ability to react (yes/no/unknown), dependency risk, passes into breast milk, dialysable, crosses the placenta, therapy direction.

Interaction

  • Interaction number; two partners, each a substance, a substance group, or a food with its food group; products inherit interactions through their substances and dosage form/strength.
  • Direction: none, one-way, two-way.
  • Classification (seven values, see 6.4), state of evidence, lead measure (ten values).
  • Text blocks: summary, warning data (partners and direction, assessment-relevant patient characteristics, affected substances, rating, lead measure, source rating, short pharmacological effect, side effects, possible symptoms, important notes, measures, risk factors), patient-individual factors, monitoring parameters, expert data (pharmacological plausibility, data basis, effect, mechanism, literature).
  • Documentation flag, including "documentation exists for a different dosage form or strength under the same interaction number".
  • Interaction groups: named sets of substances; one substance or product can belong to several groups.

Patient-parameter vocabulary (MIV)

  • Key, name, type (disease or allergy), synonym flag and preferred term, definition text, hierarchy role (main term, follow-up term with parent, stand-alone), sex specificity, environmental-allergy flag.
  • Allergy criteria can also be derived from a product or from a substance; each product and substance carries a flag whether it can be used as an allergy criterion.

Current-information message — message type, title, date, body text, search terms (many), optional links to substances, German products, international products, suppliers and articles.

Search vocabularies — pick-lists with their own keyword search for: trade names, suppliers, dosage forms, basic galenic forms, application sites and types, ATC codes (both variants), indication keys, standard hints, substance groups, molecular formulas, CAS numbers, dossier keywords, interaction groups, foods, special administration measures, training-material types and addressees, tube end positions and materials, colours and shapes.

3.2 Alternative medicine​

  • Preparation: name (usually with common potencies), kind (single remedy, complex remedy, mineral salt, cure of 2 or 3 salts), common flag, dosage form, suitability flags (pregnant women, infants, children), details (dosage, leading symptoms, starting material, composition, indication, further data), manufacturer (for complex remedies), components (for cures).
  • Category tree: area of use → clinical picture (with synonyms) → symptom. A preparation is always attached to symptoms.
  • Preparation ↔ article links to the article master (many articles per preparation; a cure needs articles for each component).
  • Separate trees for homeopathy and for mineral salts.

3.3 Drug profile​

Substance-level record: icons, dosing hints, keywords; products map to it through their active substances; plus two explanatory text collections (info, general hints).

3.4 Cross-selling​

  • SourceGroup: key (goods-group key or pack number), type (goods group / article), name, visible flag, origin (vendor / vendor-modified / self-created), owning source (vendor, own pharmacy, a branch or partner pharmacy).
  • RecommendationGroup: name, general hint text, icon, origin, owning source.
  • SourceGroup ↔ RecommendationGroup: ordered (position 1–4 is meaningful), visible flag per link.
  • RecommendationGroup ↔ Article: ordered, visible flag, note, product image. The article entry appears to stand for a product across pack sizes (inferred from the "at least one pack size is a stock article" indicator).
  • Source (for exchange): pharmacy or vendor, active flag, rank, "allows global editing" flag.
  • For vendor groups that were modified locally, the unmodified vendor original is kept so it can be shown and restored.

3.5 Campaigns and customer information/tasks​

  • Entry (KIA element): type (information, task, question), name, display text, till hint, validity start and optional end, assignment mode (customer selections / manual), allow-manual flag, refresh mode (automatic / manual), once-per-family flag, back-office-relevant flag, exchange mode and origin (in pharmacy groups), active flag, recurrence settings, extended functions.
  • Customer selection link: entry ↔ report query or fixed customer list, as inclusion or exclusion.
  • Answer option (questions): text, rating, order, optional preconditions and automatic actions; free-text-allowed flag on the question.
  • Assignment: entry ↔ customer, status (open, done, skipped), answer given, customer-individual text, delayed-action marker, origin (selection or manual, originating pharmacy).
  • Log event: entry, customer, event type (assigned, removed, done, undone, skipped, answered), timestamp, user, answer.
  • Campaign: name, status (in planning → active ⇄ paused), linked report query (with vendor default for reset), two actions (question, follow-up task).
  • Internal to-do link: entry ↔ staff task (series task, or auto-created when a minimum number of assignments is reached).

4. Features​

4.1 Drug database shell and entry points [GENERIC] (content is [DE-SPECIFIC])​

  • Purpose: one place to research almost any article listed by the national data publisher, for the pharmacist's own research and for customer counselling.
  • Underlying idea for other markets: a licensed or self-built national drug directory, kept separate from the pharmacy's own article master but linked to it by pack number.
  • Start screen: choice of the five sub-modules; the German product search is the default.
  • Contextual entry: from a sale line, from any article search result and from the article master, one function opens the database on the selected article. When opened from a sale, a selector lets the user step through all other articles of the current sale without going back.
  • Rule: some functions depend on the entry path. The pack-level price-list view is only offered when research started inside the database module; the "immediately with pack data" and "same pack unit" options of the comparison search are only editable when started from a sale.

4.2 Structured research with a query builder [GENERIC]​

  • Purpose: combine several criteria to find products, substances or dossiers.
  • Used in: German products, international products, substance list, dossiers.
  • Inputs: the user types the beginning of a term into a criterion field; a picker opens with matching vocabulary entries; the chosen entry is added as one row of the query. In some pickers several or all hits can be chosen at once.
  • Behaviour:
    • Each row has a link type: AND (default), OR, NOT. The link type must be chosen before the criterion is entered and cannot be changed afterwards.
    • AND narrows; OR widens; NOT removes results that match the new criterion from the current result.
    • Each row shows the number of hits for that criterion alone and the running total after combining all rows so far. This gives immediate feedback before any result list is opened.
    • The last criterion can be removed.
    • Criteria from all tabs of the search screen are combined when the result list is requested.
  • Output: a result list (4.10).

4.3 Product criteria, basic tab [GENERIC]​

Trade name; supplier; substance name (via substance picker, 4.4); dosage form; dispensing form; use form; route of administration; ATC code (WHO) by code or by keyword; indication key by key or by keyword; national ATC code by code or by keyword; standard hint.

4.4 Substance picker with role and strength [GENERIC]​

  • Purpose: choose one or several substances as a search criterion; also used by the till's active-substance search and when creating an article.
  • Search: by substance name or national substance key. The list is capped at the first 500 hits for performance; the user is expected to refine.
  • List content: name; prescription-only and narcotic flags; synonym flag; monograph role (main or follow-up); current-information marker; dossier button (opens the dossier directly); homeopathic and anthroposophic flags.
  • Multi-selection is possible, including "select all".
  • Role and strength extension (only in product research, not from the article master): the user ticks in which roles the substance should be looked for — as active substance, as equivalent substance, as salt/derivative, as excipient — and may give a strength as "equals X with tolerance Y"; the resulting lower and upper bounds are displayed. A strength can only be given when exactly one substance is selected.
  • Shortcut from the till: if the typed active-substance term matches one substance exactly, the picker is skipped; otherwise the picker opens pre-filled with candidates.

4.5 Special search criteria [GENERIC]​

Basic galenic form; release behaviour; application site; application type; opened-pack hint; therapy direction; tube suitability (4.7); professional information present (yes/no); package leaflet present (yes/no); training material (unrestricted or only harmonised; type; addressee); safety letter; information letter; other document by type. Without the premium licence only a reduced set is available.

4.6 Identification and handling search ("additional information" tab) [GENERIC]​

  • Purpose: identify an unknown tablet, or find products with particular handling properties.
  • Criteria: colour (with optional second colour for two-coloured items); basic shape; top-view shape; side-view shape; diameter, length, width, height (each matched with ±1 mm tolerance); mass in mg (±1 % tolerance); number of score lines; score shape; score-splitting statement; special administration measure, restrictable to allowed, to-be-avoided or forbidden measures; divisibility.
  • Rule (divisibility inclusion): searching "divisible into 2 equal-dose halves" also returns products divisible into 4 or 6 equal parts; searching "divisible into 3" also returns those divisible into 6.
  • Requires the premium licence.
  • Note: one help page places the special-administration field in the special search, another on this tab.

4.7 Tube-suitability search [GENERIC]​

  • Purpose: find products that can be given through a feeding tube.
  • Two modes: pick a concrete tube article (its properties are used), or enter manual specifications: tube end position, minimum tube opening, tube material.
  • Compatibility level (evaluated for the end position and, if a material was chosen, also for the material):
    1. Yes per professional information — at least one end position and the material are rated compatible according to the professional information.
    2. Yes per professional information or per manufacturer (off-label).
    3. Yes including "conditionally compatible".
  • If no material is chosen, material compatibility is ignored. The minimum-opening value is accepted but not yet evaluated because too few products carry the data.
  • The result list shows a reminder that measures to ensure a suitable particle size should be checked.
  • Requires the premium licence.

4.8 Patient-risk (CAVE) criteria [GENERIC]​

  • Purpose: restrict product research or a comparison search to products with a given suitability for a concrete patient.
  • Inputs: optional customer; a list of risk criteria. Each criterion has a risk type, a concrete value and a suitability condition.
  • Customer link: choosing a customer copies the stored data (age, sex, documented diseases, allergies, weight, kidney values) into the criteria list automatically.
  • Manual entry per risk type:
    • Age: date of birth (age is computed) or years and months.
    • Sex: option choice.
    • Disease: search the patient-parameter vocabulary; the list shows key, name (with sex specificity), hierarchy role, synonym flag and preferred term, and a definition for the selected row; entries already stored for the customer are marked. Choosing a main term immediately opens a second list of its follow-up terms so the user can refine. Synonyms can be hidden.
    • Allergy: three search modes — by allergy name (optionally only environmental allergies), by the triggering product, by the triggering substance (default). Product and substance rows show whether they can be used as an allergy criterion. The same picker is used in the customer record to store allergies.
    • Body weight: numeric value.
    • Kidney function: creatinine value or glomerular filtration rate (GFR). Entering creatinine converts it to GFR; because age enters this conversion, creatinine can only be entered when an age is known (from the customer or from the age criterion), otherwise the GFR must be entered directly.
  • Condition: every new criterion starts with "unrestricted suitable"; the user can change it to any of the five levels.
  • Scope of "disease": deliberately broad — illnesses, chronic conditions, past events (stroke, embolism), anatomical changes, life phases, abnormal laboratory values, susceptibilities, non-drug treatments (dialysis), circumstances and behaviour (smoker, pregnancy, competitive sport).
  • Scope of "allergy": all substance hypersensitivities, immunological or not; cross-reactions are modelled.
  • Output: criteria are combined with all other tabs. The comparison result list states when hits were hidden because of risk criteria.
  • Sold as a paid add-on.

4.9 Result-list filters [GENERIC]​

  • German products: include out-of-trade / pre-launch / not-marketable items; include imports; stock articles only; prescription-only only; non-prescription only (mutually exclusive with the previous); maximum and minimum number of active substances.
  • International products: include out-of-trade / pre-launch / not-marketable items (the marketability flag stored in the database decides); maximum and minimum number of active substances.
  • The filter dialog opens automatically before the result list (can be switched off) and can be reopened from the list. Default values per filter are configurable (7).

4.10 Result list [GENERIC]​

  • Header: number of hits; whether a filter hid hits; which substance characterisations (role, strength) were applied; tube-search reminder.
  • Columns: name, dosage form, supplier, status icons, dispensing icons, current-information marker (opens the message), document markers (current or expired safety letter, current or expired information letter, training material, other documents — each opens the document list), dossier marker (opens the dossier), patient-risk marker (opens the risk page).
  • Actions: open details; change filter; pack-level view (only when started in the database module); when the list was reached from a dossier, add further criteria to narrow it; print settings.

4.11 Product detail view [GENERIC]​

  • Header strip: name, dosage form, supplier, status icon, dispensing icon, current-information marker, "monograph linked" badge (at least one substance has a dossier), "risk data linked" badge (at least one substance has patient-risk data). The strip pages through the other hits.
  • Pages (offered only when data exists): basic info; dosage; dosage-form structure; standard hints; patient hints; additional information (divisibility, colour, shape, dimensions); tube administration; storage hints; patient risk (age and sex restrictions, diseases, allergies with cross-reactions, kidney function, body weight, with definitions and source citations); current information; product texts; comparison search; interactions (jumps to the interaction check); dossiers of the product's substances; substance-list entries of the product's substances; supplier.
  • Document functions: general supplementary information, professional information, package leaflet, documents on the product.
  • Disclaimer: wherever product texts are shown or printed, a notice states that they are not a direct reproduction of the official professional information but a text derived from it.

4.12 Product texts [GENERIC]​

Long text information exists for many medicines, drug-like medical devices and selected veterinary medicines. The user reads either the complete text or one topic at a time. Printable with topic selection (10.2).

4.13 Original documents [GENERIC] (document types are [DE-SPECIFIC])​

  • Types: professional information and package leaflet (from the data publisher), general supplementary documents, safety letters, information letters and training material (from manufacturers), other documents for non-drugs.
  • Underlying idea: attach regulator- or manufacturer-issued PDFs to products, with validity periods, and flag them in every list where the product appears.
  • Document list columns: type marker; name (type of training material, or title of the letter); harmonisation flag; addressee (target group); version/date, or validity period for letters; marker that explanations exist for the training material.
  • Harmonised means that several manufacturers supply an identical version, in content and format, for products with the same active substance, strength and dosage form.
  • Display: embedded PDF viewer with search; can be opened in a web browser instead.
  • Access paths: product details; special search by document criteria; markers in database and article result lists; the till's "additional article information" window (entries for professional information and package leaflet).
  • Marker lifetime: a safety or information letter counts as current during its validity period or for up to six months after publication; afterwards it is shown with an "expired" marker in the database lists. In article (pack) result lists outside the database the letter markers appear only for six months after publication.
  • Training-material criteria in the special search: no restriction or only harmonised material; type of material (list); addressee (list). Hits carry a training-material marker that opens the document list.
  • General supplementary information is reached from the product's "additional information" and "tube administration" pages and shows the publisher's general documents in tabs.
  • Leaflet and general documents need the premium licence.

4.14 Pack-level view from research [GENERIC]​

From a result list or a product: show the packs. With one product the article list opens directly; with several the user chooses: only the selected product or all products of the list, optionally only stock articles, and with or without physician samples. From the article list the normal article details are reachable.

4.15 Comparison search — quick search [GENERIC]​

  • Purpose: find substitutes for a product with one action.
  • Behaviour: a fixed six-level search runs from the strictest to the loosest level and stops at the first level with hits. The header shows the hit count, the level and its criteria. The user can step to the next or previous level manually. If no level finds anything, a message says that only the source product was found.
  • Levels: see 6.2.
  • Invariants: hits always have the same number of components as the source; home-market sources return only home-market products, international sources only international ones; for international products the ATC code replaces the indication.

4.16 Comparison search — by specifications [GENERIC]​

  • Purpose: the user decides which properties of the source product must match.
  • Product tab — switches and refinements:
    • Same indication: a tree of the source's indication key; unticking a level removes it and everything below from the match requirement. The field then reads "yes" (identical key), "per selection" (identical only at a higher level) or empty (not required).
    • Same ATC code: same mechanism on the ATC hierarchy.
    • Same application: the source's applications, each broken into its four criteria, with tick boxes at both levels. Field reads "yes" (all), "per selection" (subset) or empty (ignored). Combination logic in 6.3.
    • Same active substances and same excipients: one row per substance and component with name and strength, and a mode: no entry (irrelevant), "with" (must be present), "without" (must be absent), "without (completely)" (absent in every component; only offered for multi-component products). Defaults: active substances "with", excipients no entry. One function toggles all rows between "ignore" and "include".
    • Same release rate: to find, for example, a patch with the same release rate but a different total content, set the strength row to "no entry" and require the release-rate row.
    • Immediately with pack data and same pack unit: only from a sale; skip the product list and open the pack list directly; pre-set from system parameters.
  • Risk tab: the patient-risk criteria of 4.8.
  • Output: the comparison result list (4.17).

4.17 Comparison result list with side-by-side panel [GENERIC]​

  • Header: hit count, quick-search level and criteria, notice when hits were hidden because of risk criteria, key data of the source product.
  • Below the list a two-column panel compares the source product with the selected hit on five tabs: ingredients, dosage (from the product texts), dosage-form structure (applications, use form, basic galenic form, release behaviour), indication keys, ATC code. Missing data is stated. The panel height is user-adjustable and remembered.

4.18 Pharmaceutical substance list [GENERIC]​

  • Purpose: reference data on substances used in medicine and pharmacy worldwide, plus practice-relevant substances such as pesticides and cosmetics ingredients.
  • What counts as a substance: chemical elements and compounds and their natural mixtures and solutions; plants, plant parts and constituents; animal bodies, body parts, constituents and metabolic products of humans or animals; micro-organisms including viruses and their constituents or products.
  • Search criteria: substance name, molecular formula, CAS number, substance group, substance-group type, use.
  • Coverage: substances relevant to pharmacy at home and abroad receive a publisher substance number and are documented; entries may carry molecular formula, density, classification and so on.
  • Query builder: as 4.2; in the pickers all hits may be taken over as criteria at once. Substance-group type and use are chosen from fixed lists (use examples: active substance, excipient, substance in cosmetics).
  • Result list: header names the directory searched, the hit count and whether a filter hid hits. Columns: name, origin of the name, monograph role, prescription and narcotic flags, homeopathic and anthroposophic flags, current-information marker, dossier button, allergy-information marker (opens the allergy page). Printable (10.3).
  • Detail header: substance name, origin of the name, monograph title, prescription, narcotic and current-information markers; paging through the other hits.
  • Detail pages: basic info; characterisation (herbal); properties and use; chemical and physical data; legal information; related substances (family list with the current substance highlighted, and for a chosen member its related substances, each openable); allergy tree with hint and definition per allergy (paid add-on); current information (paid add-on); jumps to home-market products, international products and dossiers for this substance.

4.19 Active-substance dossiers [GENERIC]​

  • Purpose: pharmacological monographs on substances mainly used in humans, complementing product-level information and searchable for counselling-relevant facts.
  • Search criteria: keyword (the picker shows for each keyword the dossier section it belongs to and the number of hits there; multi-select); substance name; application site; use group; affects ability to react; dependency risk; passes into breast milk; dialysable; crosses the placenta (each yes / no / not specified); therapy direction.
  • Result list: monograph titles; when reached from a product, each title also lists the product's substances concerned with their role (active or excipient).
  • Reading views: the complete dossier, or one of several situation views. Each view is a pre-assembled extract ordered by importance for that situation:
    • properties; side effects; hints;
    • advising health professionals (extracts for a conversation with the prescriber, mainly drug safety);
    • hospital pharmacy; overdose/intoxication;
    • paediatrics (use and dosing in children);
    • reproduction (pregnancy and breastfeeding);
    • quick info (overview of uses and pharmacology);
    • patient, prescription dispensing (uses, dosage, manner and duration of use, patient hints, food interactions, adverse effects);
    • patient, self-medication (focus on risks).
  • Jumps: to home-market products containing the dossier's substances (the list can then be narrowed with further criteria) and to the substances assigned to the dossier.

4.20 Interaction check [GENERIC]​

  • Purpose: find interactions between medicines, and between medicines and food, alcohol, stimulants and addictive substances; over-the-counter and herbal medicines are included.
  • Inputs: any number of items of three kinds — product or substance, interaction group, food. The picker for products and substances shows name, dosage form, kind and whether interactions are stored; it can be limited to items with interactions. For a substance with more than one route of administration the user must choose the route.
  • Criteria list: per item its name (a substance shows the chosen route in brackets) and the total number of interactions stored for it. "New search" discards all items; deleting a single item asks for confirmation.
  • Entry points: the database start screen, the product detail view (interactions page) and medication management for a customer (other chapter).
  • Behaviour:
    • With one item: all interactions stored for it are listed.
    • With several items: the interactions among the entered items are listed.
    • A separate function lists food interactions; it needs at least one product, substance or food, because an interaction group alone is ambiguous (items can belong to several groups).
    • Called from medication management for a customer, the list is pre-filled with the customer's medication and only that is evaluated.
  • Result list: hit count; one entry per interaction, sorted by severity (most severe first), identical interactions merged into one hit and shown per substance group. Each entry shows partner 1 (product name and dosage form, or the triggering substance or substance group; for food interactions the food and its food group), the classification as a colour-coded short label with direction arrows (one-way, two-way, none for undirected), the state of evidence in the same colour, the lead measure, partner 2 and a documentation marker (a variant marker when documentation exists only for a different dosage form or strength under the same interaction number; no marker for food interactions).
  • Summary tab texts come from a named interaction-check content service; the operator's contact details are reachable from the tab.
  • Detail tabs for the selected interaction: summary; warning; individual factors (only in a patient-specific check); monitoring; expert knowledge (see 3.1).
  • Further functions: filter by own criteria; print the list.
  • Classifications and measures: see 6.4.

4.21 Selection of standard hints for the till [GENERIC]​

  • Purpose: the database holds many standard hints; the pharmacy picks the subset shown in the till's information area so that staff see only the most important ones.
  • Behaviour: a checklist with a vendor preselection; one function restores the vendor default.
  • Reuse: the same selection can restrict the standard hints printed on the product-details printout.

4.22 Current information [DE-SPECIFIC]​

  • Underlying idea: a dated, typed feed of drug-safety and regulatory notices, each linked to the master data it concerns, searchable and reachable from every place the affected item is shown.
  • Standard search: search term (partial allowed), date range (default: last three months), message type (default: all).
  • Result list: search term, title, message type, date. Sortable by column or by a predefined multi-level order (for example search term, then date, then message type).
  • Extended search: additionally a "message reference": all messages; only general messages; messages about an article (optionally only stock articles or only non-stock articles; article picker); about a supplier; about a substance; about a product. Parameters of a preceding standard search are carried over.
  • Message view: type, basic data and text; paging through the other hits; jumps — offered only when the link exists — to the linked substance, international product, home-market product, supplier (contacts) or article (article master), with a choice when several are linked; and a list of the search terms linked to the message.
  • Markers: products, substances and articles with a current message carry a marker in lists and headers; in article lists the marker is shown for messages not older than six months.
  • Paid add-on.

4.23 Alternative medicine finder [GENERIC] (content is market-specific)​

  • Purpose: advise on homeopathic remedies and mineral-salt remedies; find a remedy from symptoms or from a known remedy name; find an alternative to a conventional article; then sell a matching article.
  • Inputs: a search term for either a clinical picture or a preparation; a choice between the two schools (homeopathy or mineral salts); filters.
  • Search rules: see 6.6.
  • Display:
    • a category tree (area of use → clinical picture → symptom) — complete at first, afterwards reduced to nodes that contain hits; selecting a node narrows the result;
    • a result list of preparations with kind marker, name, dosage form, suitability (pregnant women, infants, children) and the clinical pictures they are normally used for; a preparation is shown in bold when at least one linked article is in stock (for a cure: at least one article per component);
    • a detail area with two tabs: preparation details (plus the applicable clinical pictures and symptoms, alphabetical), and an article overview listing all matching articles (in-stock first, then alphabetical) with status and dispensing icons, name, dosage form, pack size, information marker, pack number, supplier, selling price and stock/order status.
    • The information marker distinguishes current information (not older than six months), the pharmacy's own article information and other information (herbal-tea data, product information, supplier information).
    • The status column shows order-status markers first (open order, sent order, not deliverable, open or returned return, scheduled order, in back-order, in a disposition order), then stock flags (dispense preferentially, expiring, slow mover, discontinued, no-sale marker, two markers abbreviated POR and POS that the page does not explain), and the quantity reserved by open pickups.
  • Kind markers in the result list: common single remedy, complex remedy, common complex remedy, mineral salt, common (main) mineral salt, cure of two or three salts (common or not); no marker = non-common single remedy.
  • Filters: preparations for a given article; dosage form; only common preparations (default on); suitable for a customer group; only preparations with an article in stock; homeopathy: single remedies, complex remedies, manufacturer of complex remedies. Filters are temporary and reset when the module closes; one action clears all filters including the "common only" default.
  • Actions: view or add article information; open article details and order directly; when the module was opened from a sale, take the selected article(s) into the sale as a replacement or as an additional sale; print (10.5).
  • Paid add-on.

4.24 Drug profiles [GENERIC] (content is a licensed third-party book)​

  • Purpose: a compact substance profile (icons and dosing hints) for quick counselling.
  • Search: by active substance, keyword or trade name, each with a picker. For a product, its active substances are listed and the profile of the selected substance is shown.
  • Extras: explanatory pages (information, general hints); print of the displayed profile. The same icons are shown in the till window (other chapter).
  • Paid add-on.

4.25 Cross-selling configuration [GENERIC]​

  • Purpose: define which add-on articles the till proposes when certain articles are sold.
  • Concept: a source group says "when an article of this goods group, or exactly this pack, is in the sale"; recommendation groups attached to it say "propose these articles". One source group can hold several recommendation groups, and one recommendation group can be attached to several source groups.
  • Till limits and order (6.7): up to four recommendation groups per source group and up to five articles per recommendation group are proposed; the order of the attachments sets the tile position at the till, the order of the articles sets their order in the recommendation window.
  • Source-group management:
    • Create from a goods-classification group or from a concrete article. If a group for the same key already exists (own or vendor-supplied), the system asks whether to edit the existing one (for goods groups a new one may also be created).
    • Edit name, attach or detach recommendation groups, set each attachment visible or invisible, order the attachments.
    • Set the whole source group visible or invisible (invisible = no recommendations at the till).
    • Preview the till display.
    • Delete (self-created only); reset (vendor-modified only: deletes the local copy, restores the vendor original and asks whether the restored group should be visible or invisible); show the vendor original's composition.
    • Overview table: key (goods-group key or pack number), name, visible flag, source marker; alphabetical. Selecting a source group shows its recommendation groups (visible flag, source marker) and, for the selected recommendation group, its articles (name, dosage form, visible flag).
  • Recommendation-group management:
    • Fields: name, general hint text, icon from a searchable icon library, ordered article list. Per article: note, visible flag, product image (own images can be assigned, also for self-created articles), stock indicator.
    • Shows which source groups use the group (split into visible and invisible) and, per article, in which recommendation groups it appears.
    • Preview, delete, reset and vendor-original functions as for source groups. From the article list the drug database can be opened for the selected article.
    • The product-image column uses different symbols depending on prioritisation and editing state (not detailed).
  • Overview filters: name; origin (self-maintained, vendor-maintained, vendor-modified); source (no restriction, own pharmacy, all branches and partners except own, or one specific pharmacy — the last three only in a pharmacy group with an active foreign source); visibility; source-group type.
  • Extended search, from either tab, across all three levels: source group (name, visibility, origin, type), recommendation group (name, visibility within source groups, origin), article (name, visibility within recommendation groups, marketability status, stock status).
  • Vendor content: the vendor ships predefined groups, which may occasionally contain paid industry placements.
  • Exchange in a pharmacy group and self-created articles: see 6.7 and 6.8.
  • Source prioritisation (a settings function of the module): per source an activate flag, a rank, pharmacy name and short code, a kind marker (vendor or branch/partner pharmacy) and an editing-mode marker (global editing by all exchanging pharmacies / source not active / local editing only in the originating pharmacy); a flag "allow joint editing" lets the other pharmacies of the group change and delete this pharmacy's data.
  • Permissions: see 8.
  • Paid add-on.

4.26 Hazardous substances [DE-SPECIFIC]​

  • Underlying idea: a compliance assistant for chemicals a pharmacy stores and sells — a register of hazardous stock, mandatory safety documents, a guided and documented sale with eligibility checks, and compliant labels.
  • Nature: a third-party program (from a pharmacists' specialist publisher) embedded in the pharmacy system, with its own login (user picks or types a name), its own substance database, knowledge section, forms and PDF manual. It reflects the hazardous-substances ordinance as amended on 1 December 2010. It can be started on a till, server or back-office workstation, but not on several workstations at the same time.
  • Program blocks:
    • Occupational safety: compile the activities involving hazardous substances; view or print the hazardous-substance register, safety data sheets, explosion-protection documents and operating instructions; view or create risk assessments. Wizards guide through risk assessments and explosion-protection documents.
    • Dispensing request: a wizard that adapts to the entered substance and asks for everything required for it; checks include whether the substance may be supplied at all, for example to private persons; prints the instruction notes and a receipt slip the customer signs; records the legally required dispensing data.
    • Print: hazard labels for containers (10.7). The pharmacy address must be stored first.
    • Settings: reusable data such as the pharmacy address and options for the dispensing record.
  • Paid add-on.

4.27 Campaigns for pharmaceutical-service candidates [DE-SPECIFIC]​

  • Underlying idea: a data-driven prompt at the till — a saved customer query selects candidates, the till asks a scripted question when such a customer appears, and a positive answer creates a follow-up task.
  • Content: four predefined campaigns (antitumour therapy, blood pressure, inhalation technique, polymedication), delivered in status "in planning". Each is linked to a report query that finds candidates among the pharmacy's customers.
  • Structure of a campaign: action 1 is a question about interest in the service; action 2 is a task to arrange an appointment, assigned to customers who gave the answer "yes, appointment still to be arranged".
  • Functions: edit the target group (opens the linked query for adjustment, then adopt), reset it to the predefined query, activate (the campaign moves to the "active" list and its actions are shown at the till from then on), pause and resume (a paused campaign stays in the active list and its customer assignments keep being refreshed), view customer assignments per action with search and status filter, set an action done or not done for a customer in their absence, view the log (10.9).
  • Idea in one line: the pharmacy only activates the predefined campaign; regularly refreshed queries find candidates, the till prompts staff to ask, interest is documented, and the appointment task is created automatically for completion at the customer's next visit.
  • Till behaviour: when a candidate is entered in a sale, the customer-task window opens automatically with the question; a button on the till signals open items. Staff ask, record the answer and mark the item done; done items can be reopened from the history area.
  • Needs the pharmaceutical-services licence.

4.28 Customer information, tasks and questions (KIA) [GENERIC]​

  • Purpose: attach information, tasks or questions to customers so they appear at the till when the customer is served; drive follow-up actions from them. Campaigns (4.27) and birthday promotions are built on this.
  • Entry types: information (shown only), task (to be marked done), question (answered from predefined options, optionally free text).
  • Till display: when a customer with an active assigned entry is entered in a sale, the entry appears in the "customer info at a glance" window (which can open automatically), where staff process tasks and questions or add information. A checkbox there, "including family members", controls whether entries of the customer's family members are shown too.
  • Module screen: text search and type filter; entries grouped by validity into current (validity has started and has not ended), future (validity not yet started) and archive (validity ended); a detail area with up to four tabs; functions to create, edit, delete/archive, manage assignments, add predefined entries, create or delete an internal to-do, open the log.
  • Predefined entries: a set of predefined information and task entries is created at first installation; more can be added from a checklist. They default to manual assignment.
  • Creating an entry: from an empty entry of a chosen type, or from an existing entry as template. Settings:
    • display text (shown in the at-a-glance window) and till hint (shown at the till and in contact management);
    • validity start and optional end;
    • exchange mode and origin in pharmacy groups (6.10);
    • customer assignment mode (6.9);
    • "assign only once per family";
    • for tasks and questions: recurrence (execution, series pattern, activation, display duration; follow-up dates can be computed from a start date);
    • for questions: answer options with text, rating and order; free text allowed or not;
    • extended functions (below).
  • Extended functions:
    • For tasks, two mutually exclusive sections: data maintenance or automatic actions.
      • Check master data (precondition): phone number, date of birth and/or digital address (customer app or e-mail) must be on file before the task can be completed; otherwise the system offers a jump to the contact record.
      • Coupon issue: a personalised coupon is issued automatically to assigned customers when the task is activated or when it is completed.
      • Digital message: a message is sent automatically on activation or completion, through the pharmacy's customer app, or by e-mail for customers without the app; files can be attached (for example a greeting card or a flyer); a consent filter can restrict sending to customers with a signed consent (general consent declaration, consent to digital advertising, or consent to advertising in general) — the system can only check this when consents are managed in it; the text comes from a default template that is maintained with the print forms and can be edited per entry.
    • For questions, the same precondition and actions can be attached to each answer option.
    • Entries with extended functions are marked. Entries with automatic coupon or message actions are created inactive and must be activated explicitly.
    • Actions that could not run (for example no e-mail address) are marked as delayed on the assignment and can be triggered manually once the obstacle is removed.
  • Assignment management per entry: list of assigned customers with status (open, done, skipped); inactive or deceased customers greyed; add or remove customers (only where manual assignment is allowed); open the customer record; set done or not done; skip one recurrence cycle for a customer; create, edit or delete a customer-individual text; catch up delayed coupon or message; open the log.
  • Assignment per customer: from the at-a-glance window or the customer's information texts, a checklist of all manually assignable entries (filterable to information only, tasks and questions only, back-office-relevant only) lets staff tick or untick entries for this customer and maintain individual texts.
  • Internal to-do for back-office work: for a task or question that needs back-office action, create either a normal (series) to-do, or an automatic to-do that is generated when a minimum number of customer assignments is reached — shown immediately or always at a set hour — with responsible user, deputy, subject, priority and description. The entry then shows a to-do marker linked to it. Executing the to-do opens the entry's assignment list; the to-do is then marked done in the task module. Examples given: monthly greeting cards for customers over 16 whose birthday falls next month and who could not be congratulated in person; evaluating a delivery-service satisfaction question once enough answers exist. Recurring to-dos are also suggested as reminders to review manually refreshed selections and fixed lists.
  • Manual refresh of a selection: in the entry editor a "refresh assignments" function lists customers to be added (now meeting the criteria) and customers to be dropped (no longer meeting them); individual customers can be excluded from either list before confirming.
  • Reporting integration: customer report queries offer fields to find customers with at least one information entry, an undone task or an unanswered question; customers with a specific task or question (done or undone); entries with customer-individual text; and individual texts that do or do not contain given words.
  • Log: assignment, removal, done, undone, skipped, answers; filter by customer, event type and period.
  • Walk-in customers: only a reduced function set (8).
  • Needs the customer-relationship licence.

5. Workflows​

5.1 Counselling lookup during a sale​

  1. Staff enter articles in a sale and select one line.
  2. They open the drug database for that line; it opens on the product behind the pack.
  3. A selector strip lets them step through all other articles of the same sale without leaving the database.
  4. They read the relevant pages (dosage, standard and patient hints, storage, patient risk, product texts, current information, documents).
  5. Optionally they print product details or product texts for the customer; the customer name is pre-filled when the sale has a customer (10.1, 10.2).

5.2 Structured research​

  1. Open the database (German products is the default sub-module).
  2. For each criterion: choose the link type (AND/OR/NOT) first, type the beginning of a term, pick the vocabulary entry. The criteria list shows hits for that criterion and the running total.
  3. Add criteria from other tabs (special search, patient risk, additional information) as needed; remove the last criterion if it over-narrows.
  4. Request the result list; the filter dialog opens first (unless switched off) with the configured defaults.
  5. Open a product's details; page through other hits from the header strip.
  6. Optionally jump to the packs (pack-level view, only when research began inside the database), to dossiers, substances, interactions or the comparison search.
  1. From a sale line (via the additional-information window) or from a product's details, open the comparison search.
  2. Either run the quick search: levels 1–6 are tried in order and the first level with hits is shown; step up or down a level manually.
  3. Or search by specifications: set indication/ATC depth, application match, active-substance and excipient modes (with / without / without completely / no entry), and optionally patient-risk criteria (customer or manual).
  4. From a sale, "immediately with pack data" or "same pack unit" skips the product list and opens the matching packs.
  5. In the result list compare source and selected hit side by side (ingredients, dosage, dosage-form structure, indication, ATC).
  6. Open the packs and sell the chosen one.

5.4 Patient-risk (CAVE) screening​

  1. On the risk tab, pick a customer (stored age, sex, diseases, allergies, weight, kidney values become criteria) or add criteria by hand.
  2. For a disease main term, refine with a follow-up term; for kidney function enter creatinine (needs an age) or GFR.
  3. Each criterion starts as "unrestricted suitable"; adjust the required suitability level per criterion.
  4. Run the search; the header states when hits were hidden because of risk criteria. In product details the risk page lists what the product says per area; when printing, areas without data can be listed as "not checked".

5.5 Interaction check​

  1. Add products or substances (choose the route when a substance has several), interaction groups and foods.
  2. Show interactions: one item → all its stored interactions; several → interactions among them. Food interactions need at least one product, substance or food.
  3. Read the list (most severe first); open an interaction for summary, warning, monitoring and expert tabs; print if needed.
  4. From medication management the list is pre-filled with the customer's medication and only that set is checked; the individual-factors tab is active.

5.6 Alternative-medicine advice​

  1. Open the module (from the menu or from a sale), choose homeopathy or mineral salts, type a clinical picture or a preparation name.
  2. Narrow by the tree (area of use → clinical picture → symptom) and filters (common only is on by default; stock only; customer group; dosage form; single or complex; manufacturer; preparations for a given article).
  3. Read preparation details; switch to the article overview (in-stock first).
  4. If opened from a sale, take the article into the sale as a replacement or an additional item; otherwise open article details or order directly.

5.7 Configuring cross-selling​

  1. Create a source group from a goods-classification group or a specific pack (or edit an existing one when the system reports one for the same key).
  2. Create or pick recommendation groups: name, hint text, icon, ordered articles with notes and images.
  3. Attach up to four recommendation groups to the source group in the desired tile order; set visibility per attachment and per article.
  4. Preview the till window; save.
  5. In a pharmacy group, rank and activate sources, and decide whether others may edit this pharmacy's data.

5.8 Running a pharmaceutical-service campaign​

  1. Open the campaign (status "in planning"); optionally adjust its candidate query or reset it to the predefined one.
  2. Activate it. Candidates are assigned by the regularly refreshed query.
  3. When a candidate is entered at the till, the customer-task window opens with the interest question; staff ask and record the answer.
  4. Customers answering "yes, appointment still to be arranged" get the follow-up task; at their next visit staff arrange the appointment and mark the task done.
  5. Pause or resume as needed; review assignments and the log.

5.9 Customer information, task or question​

  1. Create an entry (empty or from a template): type, display text, till hint, validity, assignment mode, recurrence, answers (for questions), extended functions.
  2. If coupons or messages are configured, the entry is saved inactive; activate it deliberately.
  3. Customers are assigned by selections (automatic or manually refreshed) and/or manually.
  4. At the till the entry appears for assigned customers; staff mark tasks done, record answers, or skip a cycle.
  5. Automatic actions run on activation or completion (or per answer); failed actions are flagged as delayed and can be re-triggered after fixing the cause.
  6. Back-office work is driven by linked internal to-dos; everything is logged.

5.10 Selling a hazardous chemical​

  1. Start the hazardous-substances program (one workstation at a time) and log in by name.
  2. Open a dispensing request and enter the substance; the wizard asks for everything required for that substance and checks whether it may be supplied to this buyer (for example to a private person).
  3. Print the instruction notes and the receipt slip; the customer signs.
  4. The legally required dispensing data are recorded.
  5. Label the container with a hazard label (10.7).

6. Business rules and calculations​

6.1 Status-marker priority on products​

  • One status marker is shown per product, chosen in this order: marketability status (out of trade, recalled, withdrawn, and their deleted variants) → safety letter → information letter → training material → predecessor/successor → self-created article.
  • Combinations exist as their own markers (for example "out of trade with successor", "recalled, deleted, with predecessor", "deleted self-created with successor"). Clicking a successor/predecessor marker opens an article search listing the successor and predecessor articles.
  • A safety or information letter is "current" during its validity period or up to six months after publication, otherwise "expired" (different marker).
  • Separate dispensing marker: prescription-only, narcotic, with an overlay for "needs monitoring"; the comparison list adds blood product, haemophilia product, both, non-prescription blood product, special-prescription type, general and conditional substitution exclusion, clinic-pack component and pharmacy-only.
LevelMust match the source product
1Active substance, its strength, dosage form
2Active or equivalent substance, its strength, dosage form
3Active or equivalent substance, dosage form
4Active or equivalent substance, basic galenic form
5Active or equivalent substance, route of administration
6Main indication and route (number of actives per component and the combination may differ)
  • Search stops at the first level with hits; the user may step to the next or previous level.
  • Always: same number of components; home-market source → home-market hits only, international → international only; for international products the ATC code replaces the indication.
  • Level-6 hits can be very heterogeneous for some indications.

6.3 Match rules in the comparison search by specifications​

  • Indication key / ATC code: the source's code hierarchy is shown as a tree; unticking a level drops it and all lower levels. Result: "yes" (identical), "per selection" (identical at a higher level), empty (not required).
  • Applications: AND within one application (all ticked criteria of it must match), OR between applications. Ticking an application ticks its four criteria. Result: "yes" (all), "per selection" (some), empty (ignored).
  • Substances (actives and excipients listed per component with strength): no entry = irrelevant; with = must be present; without = must be absent; without (completely) = absent in every component, only for products with more than one component, and it disables the same substance's rows in other components. Defaults: actives "with", excipients "no entry". Toggle-all per list.
  • Release rate: requiring the release-rate row while leaving the strength row at "no entry" finds products with the same release rate but a different total content (typical for patches).
  • Criteria of the product tab and the risk tab are combined.

6.4 Interaction classification and measures​

ClassificationMeaning
ContraindicatedMust not be combined
SeverePotentially life-threatening, or serious and possibly irreversible consequences
ModerateTherapeutically relevant consequences
MinorNo compelling therapeutic consequence; monitoring may be needed
Product-specific warningOnly a manufacturer's specific warning exists, usually from the professional information
No interaction expectedLiterature reports none, or none is expected from structure, pharmacokinetics or pharmacodynamics
No statement possibleNo assessment in the literature
  • The last three are shown with a neutral grey ring in the list and in their relevance colour in the detail.
  • Lead measures (ten): avoid combination; combination not recommended; dose adjustment; adjustment; staggered administration times; monitoring; watch for sufficient effect; watch for increased adverse effects; watch for altered effect; usually no action needed.
  • Direction: one-way, two-way, or none.
  • Sorting: by severity, most severe first; identical interactions merged per substance group.
  • Food-interaction function needs at least one product, substance or food, because an interaction group alone is ambiguous (items belong to several groups).

6.5 Patient-risk (CAVE) rules​

  • Suitability scale (five levels): unrestricted suitable → intermediate 1 → restricted suitable → intermediate 2 → contraindicated. New criteria start at "unrestricted suitable" (weight worded "unrestricted suitable at", kidney function "suitable at").
  • Creatinine is converted to GFR using the age, so creatinine entry requires a known age; otherwise GFR must be entered directly. The conversion formula is not stated.
  • Selecting a disease main term forces a choice among its follow-up terms (refinement to avoid false positives).
  • A product without data for a risk area is "not checkable" for that area; the product-details print can list such areas explicitly.
  • Allergy criteria can be an allergy term, a product or a substance; only products and substances flagged as usable become criteria; cross-reactions are part of the allergy data.

6.6 Search rules in alternative medicine​

  • The search term is shortened from the right until hits are found.
  • Synonyms of clinical pictures are searched; the tree is searched in both areas of use and symptoms.
  • Extensions of the term are honoured (an adjective for a clinical picture; name plus potency for a preparation).
  • Several clinical pictures cannot be combined in one search.
  • Bold preparation = at least one linked article in stock; for a cure, at least one article in stock for every component.
  • "Common" preparations: often recommended and proven for the picture, well known, frequently requested or textbook-recommended; preferred for self-medication; the main mineral salts count as common. Filter "common only" is on by default.
  • Filters are temporary and reset when the module closes.

6.7 Cross-selling till rules and group exchange​

  • Up to 4 recommendation groups per source group are used; position 1 = top-left tile, 2 = top-right, 3 = bottom-left, 4 = bottom-right.
  • Up to 5 articles per recommendation group are proposed, in list order.
  • Invisible source group → no recommendations for it; invisible attachment or article → not shown.
  • Creating a source group for a key that already exists (own or vendor) asks whether to edit the existing one; for goods groups a second group may be created.
  • Delete only self-created groups; vendor groups changed locally can only be reset to the vendor original.
  • In a branch/partner group, exchange runs automatically once configured. Sources are activated and ranked; only active sources' groups are used, in rank order. All sources, including own and vendor, can be deactivated, which switches cross-selling off.
  • If several active sources allow editing, saving a change asks for which pharmacy to save it; creating a group asks for which source.
  • Warning: with joint editing, other pharmacies can change or delete this pharmacy's records.

6.8 Self-created articles in exchanged cross-selling data​

  • Self-created articles can be triggers or recommendations. Recommendation: exchange self-created articles in the group at least as widely as cross-selling data, or avoid them in recommendation groups when joint editing is allowed.
  • Cross-selling exchanged but self-created articles not exchanged: a source group based on such an article may be invisible elsewhere; a recommended self-created article may be invisible elsewhere (the following articles move up); if joint editing is allowed and another pharmacy that cannot see the article saves the group, that article's assignment is silently deleted.
  • Self-created articles exchanged but one article not extended group-wide: the source group is visible elsewhere (harmless, the article cannot be sold there); the recommendation is visible in the configuration module elsewhere; at the till the group shows but the non-extended article is hidden.

6.9 Customer assignment (KIA)​

  • Mode "customer selections": dynamic report queries and/or fixed customer lists as inclusions; exclusions remove customers; optionally "allow manual assignment" for single extra customers.
  • Mode "manual": customers are assigned one by one; selections can only be used to exclude groups.
  • Refresh: automatic (re-evaluated at every customer contact) or manual (a snapshot that stays fixed as the basis for follow-up actions until refreshed deliberately). Caveats: manual refresh must be remembered; fixed lists need periodic review; manually assigned customers are never checked for relevance automatically.
  • Once per family: the entry is assigned to one family member only (usually the contact person).
  • Predefined entries default to manual assignment.
  • Walk-in customers: see 8.

6.10 Exchange of KIA entries in a pharmacy group​

  • "Yes, assignments local": the entry and its queries are shared; queries run on each pharmacy's local data; assignments, manual assignments and completion are per pharmacy.
  • "Yes, including assignments": entry and inclusion/exclusion queries are shared; queries still run locally; with automatic selection the assigned set is the union over all pharmacies (assigned in one = assigned in all; consistent for exchanged customers, though some assignments may concern customers another pharmacy cannot see); an exclusion applies only if the customer meets it in all pharmacies; inclusions override exclusions; with manually refreshed selections, refreshing removes globally only customers originally assigned by the own pharmacy; manual assignments and removals by any pharmacy act globally; a task or question needs to be done only once in the group.
  • Once exchange is switched on and saved it cannot be switched off.

6.11 Automatic actions safety rules (KIA)​

  • Tasks use either data maintenance (master-data check) or automatic actions, never both.
  • A master-data precondition blocks completion until the required data exist (phone, date of birth, digital address), with a jump to the contact record.
  • Entries with automatic coupon or message actions are saved inactive and need explicit activation (prevents accidental mass sending).
  • Failed actions are flagged as delayed and can be re-triggered per customer.
  • Consent filtering only works when consents are recorded in the system.

6.12 Identification-search tolerances​

  • Diameter, length, width, height: ±1 mm. Mass: ±1 %.
  • Divisibility inclusion: "into 2 equal doses" also matches products divisible into 4 or 6; "into 3" also matches 6.
  • Tube search: minimum tube opening is accepted but not evaluated; without a material, material compatibility is ignored.
  • Substance picker shows at most the first 500 hits.
  • Current-information default period: last three months; current-information markers in article lists: messages not older than six months.

7. Configuration and settings​

ParameterScopeEffectDefault
Standard hints shown at the tillPharmacy (drug-database settings)Which coded standard hints appear in the till's information area; can also restrict the product-details printoutVendor preselection; "vendor standard" function restores it
Comparison search: "immediately with pack data"System settings, drug database, comparison-search page, price-list groupPre-sets the option when a comparison search starts from a sale (skip product list, show packs)Not stated
Comparison search: "same pack unit"Same placePre-sets the option when started from a sale (packs with the same pack unit)Not stated
Filter dialog opens automatically before result listSystem settings, drug databaseShows the result-list filter before every listOn
Default per result-list filter (German products: out-of-trade/pre-launch/not marketable, imports, stock only, prescription-only, non-prescription only, min/max actives; international: out-of-trade etc., min/max actives)System settings, drug databaseInitial filter valuesNot stated
Comparison panel heightPer userSize of the side-by-side panel, rememberedUser-adjusted
Alternative-medicine filtersSessionTemporary; reset when the module closes"Common preparations only" on
Current-information search periodPer searchDate rangeLast three months
Cross-selling source activation, rank, "allow joint editing"Pharmacy, in a branch/partner groupWhich sources' groups are used, in which order; whether others may edit and delete own dataNot stated
Cross-selling group / attachment / article visibilityPer recordWhether shown at the tillVendor groups as shipped
KIA exchange modePer entry, in a pharmacy groupNo exchange / assignments local / including assignments; irreversible once savedNot stated
KIA assignment mode, allow manual, refresh mode, once per familyPer entrySee 6.9Predefined entries: manual
KIA recurrencePer task or questionExecution, series pattern, activation, display duration—
KIA message templatePrint forms, editable per entryText of automatic digital messagesVendor template
"Customer info at a glance" auto-openTill (other chapter)Opens the window automatically for customers with entriesNot stated
Hazardous-substances settingsEmbedded programPharmacy address (required before printing labels), dispensing-record options—
Campaign target queryPer campaignAdjustable candidate query; reset to vendor queryVendor query

8. Roles and permissions​

  • Licences (paid add-ons): premium article information ("Artikel-Info Profi": package leaflet, general documents, identification/additional-information search, colour criteria, tube suitability and their printing; without it the special search offers a reduced criteria set); patient-risk (CAVE) data (product risk search and substance allergy pages); current information; alternative medicine; drug profiles; cross-selling; hazardous substances; pharmaceutical-services licence (IXOS.PDL) for campaigns; customer-relationship licence (IXOS.Kunde) for KIA.
  • Cross-selling: creating and changing groups needs the role manager (Leiter) or cross-selling officer (Cross-Selling-Verantwortlicher); use of the module may additionally be governed by the workstation/user authorisation concept.
  • Hazardous substances: starting requires one of the permissions "start hazardous substances", pharmacist, pharmaceutical-technical assistant (PTA) or manager; inside the program the user logs in by name.
  • KIA: the permission "customer information/tasks: manage information, tasks and questions" is needed to create, edit and delete entries.
  • Walk-in (anonymous) customers: cannot receive information entries, questions, task assignments via customer selections, or task assignments from the KIA module; tasks can still be assigned through the at-a-glance window and the information texts.
  • Data responsibility: the data publisher is responsible for correctness and currency of reference data; the software vendor only prepares and passes it on.

9. Integrations, hardware and external services​

  • National drug-data publisher: licensed data feed for products (home and international), substances, dossiers, interactions, patient-risk data, product texts, professional information and leaflets, current-information messages, standard hints. Content is updated by the publisher; the vendor redistributes it.
  • Manufacturers: safety letters, information letters, training material and other documents arrive through the data feed as PDFs.
  • Interaction content service: the interaction summaries come from a named third-party checking service whose contact details are shown.
  • Third-party book content: drug profiles from a published reference book.
  • Embedded third-party program: hazardous-substances compliance (own database, wizards, forms, manual).
  • Customer app and e-mail: KIA digital messages go through the pharmacy's customer app, else by e-mail; coupons are issued in the coupon system (other chapter).
  • Task/calendar module ("Notes"): back-office to-dos linked to KIA entries.
  • Reports module: saved customer queries feed KIA selections and campaign targets; query fields expose KIA status.
  • PDF viewer and web browser: documents shown in an embedded viewer or opened in a browser.
  • Printers: A4 printers and label printers for hazard labels (10.7); normal printers with print preview for all other printouts.

10. Printouts, reports and exports​

All database prints share a pattern: a selection dialog with one checkbox per printable part (only parts with data are enabled; the part being viewed is preselected; "mark all" function), a customer name (free text or contact picker; pre-filled with the sale's customer when the database was opened from a sale with a customer, empty otherwise), number of copies (default 1), then print preview and print or send.

10.1 Product details​

  • Available for German and international products.
  • Parts: patient hints; basic info and the other detail pages; standard hints (default all, or "only hints activated in settings" — the till selection, 4.21); additional information including images (premium licence); tube administration (premium licence); patient risk, with the option "include non-checkable areas", which prints under a "no risk check" heading the areas for which the product has no data (for example age), so the reader knows what could not be checked; current information (paid add-on).

10.2 Product texts​

  • One checkbox per available text topic; customer name; copies.
  • The printout opens with a salutation followed by the mandatory notice that the text is derived from, not identical to, the official professional information.

10.3 Substance list​

  • Hit list print: option "print information for the customer" adds an anonymised salutation ("Dear customer"); customer name; copies.
  • Substance data print: one checkbox per part (preselected = viewed part); properties/use and legal information can be extended by substance-group information; basic info can be extended by the "transition assessment"; current information (paid); copies.

10.4 Dossiers​

  • Dossier print: "complete dossier" or individual sections (preselected = viewed section); customer name; copies.
  • Monograph-title list print: "print for customer" option with anonymised salutation; customer name; copies.

10.5 Alternative medicine​

  • Choose the preparation overview (the result list) and/or preparation details (selected preparation only or all); for details choose dosage form, dosage, clinical pictures, further information and article overview; customer name (text or contact picker); copies.

10.6 Drug profile and interaction list​

  • Drug profiles: prints the displayed profile.
  • Interaction check: print of the interaction list and print settings (details in a topic outside this slice).
  • Result lists of product research have print settings.

10.7 Hazard labels​

PrinterContainer up to 250 ml/gContainer from 250 ml/g
A4 sheet printer2 × 6 labels per sheet, 97 × 42.3 mm2 × 4 labels per sheet, 97 × 67.7 mm
Label printer36 × 89 mm54 × 101 mm
  • A4 printing can render hazard pictograms with their red border; label printers print black and white only.
  • The pharmacy address must be stored before labels can be printed.

10.8 Hazardous-substance documents​

  • Hazardous-substance register, safety data sheets, explosion-protection documents, operating instructions and risk assessments (view, print, create via wizards).
  • For each sale: instruction notes and a receipt slip for the customer's signature; the dispensing record.

10.9 Logs and reports (campaigns and KIA)​

  • Log per entry or campaign action: filters customer, event type (done; done and undone; assignments and removals), period. Rows: customer surname, first name, date of birth, postcode, town; timestamp; user; event type; answer for questions.
  • Customer report queries can select by KIA status (see 4.28).

11. Dependencies on other modules​

  • Point of sale: opens the database on a sale line and pages through the sale's items; additional-information window (comparison search, professional information, leaflet); takes alternative-medicine articles into a sale; shows standard hints, drug-profile icons, cross-selling recommendation tiles, campaign prompts and the "customer info at a glance" window; active-substance search uses the substance picker.
  • Article master and article search: pack data, prices, stock and order status; pack-level view, successor/predecessor search, physician-sample handling; substance picker when creating an article; self-created articles in cross-selling.
  • Contacts / customer records: customer data feed patient-risk criteria (age, sex, diseases, allergies, weight, kidney values); the allergy picker is shared with the customer's risk-management page; supplier contacts reachable from messages; consent records for KIA messages.
  • Medication management: launches the interaction check with the customer's medication and the patient-individual tab.
  • Reports: customer queries drive KIA selections and campaigns.
  • Task/calendar (Notes): back-office to-dos for KIA entries.
  • Coupons and customer app: automatic KIA actions.
  • Branch and partner group exchange: cross-selling sources and KIA entries.
  • Counselling menu: also holds Contacts and E-Health (insurance-card contact data, electronic medication plan, emergency data, logging), documented in other chapters.
  • System settings: drug-database parameters (filters, comparison-search defaults).

12. Portability notes​

FeatureTagIdea that carries over
Central drug directory (products, packs, substances, components, roles, strengths, equivalents, dosage forms, applications)[GENERIC] structure; content [DE-SPECIFIC]Shefa needs its own directory keyed to locally registered products; structure (product ↔ component ↔ substance with role and strength; product ↔ packs) is universal. Source content for Syria would be the national registry plus self-maintained data, not a licensed German set.
ATC (WHO) classification[GENERIC]Use the WHO ATC directly; a national ATC variant and a publisher indication key are optional extras.
Query builder with per-criterion and running hit counts[GENERIC]Strong UX pattern for any search over a reference directory.
Comparison search with graded levels[GENERIC]Substitution finder: same substance+strength+form → same substance+form → same substance+galenic family → same route → same indication. Works with any directory that stores equivalents and dosage-form hierarchy.
Patient-risk (CAVE) screening with five suitability levels[GENERIC]Contraindication screening against age, sex, conditions, allergies (with cross-reactions), weight and renal function; requires a curated vocabulary of conditions and per-product ratings.
Interaction check[GENERIC]Pairwise substance/group/food interactions with severity, direction, evidence and lead measure; open-source or licensed data sources differ per market.
Tablet identification and divisibility, tube suitability, special administration[GENERIC]Physical-identification and administration-handling attributes per product.
Product texts, professional information, leaflets, safety letters, training material[DE-SPECIFIC] (document types and legal notices)Attach regulator- and manufacturer-issued documents to products with validity periods and markers in every list.
Current information feed (national pharmacists' drug commission)[DE-SPECIFIC]Dated, typed safety/regulatory notices linked to products, substances, suppliers and articles, with "new" markers for six months.
Status priority (out of trade, recall, withdrawn, letters, successor)[GENERIC]Single prioritised status badge per product.
Alternative medicine finder[GENERIC] (content market-specific)Symptom tree → remedies → sellable articles; useful for herbal/traditional remedies common in Syria.
Drug profiles from a third-party book[DE-SPECIFIC] contentShort icon-based counselling cards per substance.
Cross-selling[GENERIC]Trigger (category or item) → ordered recommendation groups → ordered items, with till limits, vendor templates and group exchange.
Hazardous substances[DE-SPECIFIC]Chemical-safety register, safety data sheets, guided and documented sale with eligibility checks, hazard labels.
Pharmaceutical-service campaigns[DE-SPECIFIC]Query-driven candidate prompts at the till with a scripted question and an automatic follow-up task.
Customer information/tasks/questions with automatic actions[GENERIC]CRM rule engine: targeted notes, tasks and questions at the till, recurrence, preconditions, coupons and messages with consent checks, safe inactive-by-default activation.
Statutory legal flags (narcotic, special prescription, substitution exclusions, blood products, precursor control)[DE-SPECIFIC]Configurable regulatory flags per product and substance, displayed with priority.

13. Open questions​

  • The creatinine-to-GFR conversion formula and the units used are not stated; nor is how sex and weight enter it.
  • How the five suitability levels are matched against a product's ratings (exact level or "at least") is not explained.
  • The meaning and values of the dispensing form (Abgabeform) and of the "transition assessment" (Überleitungsbewertung) in the substance data are not explained.
  • Minimum tube opening is accepted but "not yet evaluated"; no plan is given.
  • Default values of the result-list filters and of the comparison-search pack options are not given.
  • The filter settings and print function of the interaction check are described in topics outside this slice.
  • Update frequency and mechanism of the reference data (and of current information) are not described.
  • For cross-selling, the tie-breaking when two source groups match the same sale (goods group and specific pack) is not described, nor how ranks combine groups from several sources.
  • The meaning of the "POR"/"POS" stock markers in the alternative-medicine article overview is not explained.
  • Whether a paused campaign still prompts at the till is implied (no) but not stated.
  • The help places the special-administration criterion once on the special-search tab and once on the additional-information tab.
  • What exactly the hazardous-substances wizard checks per substance is inside the third-party program and not documented here.

14. Source pages​