PD App

GENERAL

Maintenance

• Pt version new Contraindications may need to be translated into PD_App-speak
• Pt version Contraindications must always have "Hypersensitivity to active and excipients"

QUESTIONS:

• Do we want to change the wording of "Antibiotics" to be "Antimicrobials" or something else as Voriconazole is not an antibiotic?

AMI

Include Section 21 AMIs? e.g. bedaquiline

MG Does AMI name only come from [PD_App_Entities.Name] ?NOT Drugs.ATC description], or any Synonyms

VP

Show all VPs for an AMI incl combinations? e.g. Cloxacillin on its own and in combination with Ampicillin

Contraindications (PtApp)

Drug-drug combinations do not show up

Hypersensitivities/allergies do not show up

Indications

(PtApp) ICD10 code wording is very longwinded. Should we:

do a translation

add a simpler term

untick and add species to "Infection %s"

Notes:

• Not used anywhere: PD_App_Entities.isPD] = Y;N (it was just for us to prioritise data capture)

Adding a new AMI

To input a new AMI to the App you need to complete the following:

• [PD_App_Entities.URL] = the TradeID of the AMITrade
• [PD_App_Entities.ID] = DrugID for the AMI
• [PD_App_Entities.Type] = VProd
• [PD_App_Entities.Name] = freetext that shows up in the alphabetical list of Antibiotics
• [PD_App_Entities.Formulation] = text of O;IV;OIV determines which image to use as a background
• [PD_App_Entities.isPD] = Y;N

Searching

This is to search for an AMI in the App.

Use f_Translation_Drugs to add a new term with [Target_Lang=Search-0] (or -1 or -2 etc to add even more)

Data in [Translation_Details] where FK_Table=Drugs and FK_ID=DrugID and Target_Lang=Search-0 and Wording=whatuwant

To exclude an AMI from the search (e.g. ATC7 combinations), Target_Lang=Search-0 and Wording=...

Provider App

Name

Displays the following: [PD_App_Entities.Name]

To SEARCH on a different name it must be added to the translation

CLASS

Comes from [Drugs].[ATC_Description]

This is the pharmacological class which comes from the ATC level 5 description. To change the wording, use f_Translation_Drugs to add the desired wording to the AMI (ATC level 7 or 9) with target_Lang=DDUATC5

Data in t Translation_Details where FK_Table=Drugs and FK_ID=DrugID and Target_Lang=DDUATC5 and Wording=whatuwant

STRENGTH

This is the VP fMain Trades tab: VirtualProduct

Question - do we want to see combination VPs too? e.g. Cloxacillin"

DOSE

Hepatic/Renal warnings come from Conditions where PD_App - Hepatic Warning or PD_App - Renal Warning is present

TRADE NAMES

• RSA trades only i.e. [TradeNames.DataSet] = RSA
• discontinued trades must not show i.e. [TradeNames.DiscontinuedDate] = null
• Orders PD trades first. If [TradeName.Man]=PDY then put at the top
• Sorts alphabetically

Medicine Name

name

[TradeNames.Name]

strength and unit

[ATCtoTradeXMap.Strength] and [ATCtoTradeXMap.StrengthUnit]

formulation

3-digit [TradeNames.Form]

manufacturer

[Manufacturers.Manufacturer] where [TradeNames.Man]=[Manufacturers.man]

Pack size

[TradeNamePack.PackSize] where [TradeNamePack.TradeID] = [TradeNames.ID]

SEP incl VAT

[TradeNamePack.SEP] where [TradeNamePack.TradeID] = [TradeNames.ID]

Patient App

CONTRAINDICATIONS

• Hypersensitivity to active and excipients: must always show
• Porphyria: Data must be copied from the Porphyria tab to the Conditions tab
• Pregnancy: Data must be copied from the DDU Pregnancy tab to the Conditions tab
• Lactation: Data must be copied from the DDU Lactation tab to the Conditions tab
• Hepatic/Renal warnings only come through if they are contraindicated in Conditions
• Pulls distinct contraindications i.e. if same info at ATC9 and ATC7, it displays once only

where [Conditions.FrequencySupport] = Contraindicated and [Conditions.SuppressOutput] = 0

uses

[Conditions.DictionaryQualifierID]

[Conditions.DictionaryDescID]

[Conditions.DictionaryParams]

[Conditions.SuppressOutput = 0]

translation

[Translation_Details.Target_Lang = PD_App]