PD App

GENERAL

Maintenance

• Pt version new Contraindications may need to be translated into PD_App-speak

Questions:

• Do we want to include Section 21 AMIs? e.g. bedaquiline
• Do we want to show VPs for an AMI? e.g. Cloxacillin on its own and in combination with Ampicillin
• Do we want to change the wording of "Antibiotics" to be "Antimicrobials" or something else as Voriconazole is not an antibiotic?
• MG to check that the AMI name only comes from [PD_App_Entities.Name] and does NOT use [Drug.ATC description], or any Synonyms
• Indications: 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

• 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

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

uses

[Conditions.DictionaryQualifierID]

[Conditions.DictionaryDescID]

[Conditions.DictionaryParams] (check if this is true)

translation

[Translation_Details.Target_Lang = PD_App]