Difference between revisions of "PD App"
| (35 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==  | 
  ==GENERAL==  | 
||
===Maintenance of data for the app===  | 
|||
''Questions:''  | 
  |||
*Pt version new Contraindications may need to be translated into PD_App-speak   | 
|||
* Do we want to include Section 21 AMIs? e.g. bedaquiline  | 
  |||
*Pt version Contraindications must always have "Hypersensitivity to active and excipients"  | 
|||
* Do we want to show VPs for an AMI? e.g. Cloxacillin on its own and in combination with Ampicillin  | 
  |||
''QUESTIONS:''  | 
|||
* Do we want to change the wording of "Antibiotics" to be "Antimicrobials" or something else as Voriconazole is not an antibiotic?  | 
  * 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:  | 
|||
The provider app version comprises the following sections:  | 
  |||
===AMI===  | 
  |||
* [PD_App_Entities.URL] = the TradeID of the AMITrade  | 
  * [PD_App_Entities.URL] = the TradeID of the AMITrade  | 
||
* [PD_App_Entities.ID] = DrugID for the AMI  | 
  * [PD_App_Entities.ID] = DrugID for the AMI  | 
||
| Line 15: | Line 31: | ||
* [PD_App_Entities.Formulation] = text of O;IV;OIV determines which image to use as a background  | 
  * [PD_App_Entities.Formulation] = text of O;IV;OIV determines which image to use as a background  | 
||
* [PD_App_Entities.isPD] = Y;N  | 
  * [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====  | 
  ====Name====  | 
||
Displays the following:   [PD_App_Entities.Name]  | 
|||
[PD_App_Entities.Name]  '''MG to check that it does NOT use Drug.ATC description, or any Synonyms'''  | 
  |||
To '''SEARCH''' on a different name it must be added to the translation  | 
|||
===CLASS===  | 
  ===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  | 
  |||
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===  | 
  ===STRENGTH===  | 
||
| Line 30: | Line 64: | ||
===DOSE===  | 
  ===DOSE===  | 
||
Hepatic/Renal warnings come from Conditions where PD_App - Hepatic Warning or PD_App - Renal Warning is present  | 
|||
===INDICATION===  | 
  ===INDICATION===  | 
||
| Line 36: | Line 70: | ||
===ADMINISTRATION===  | 
  ===ADMINISTRATION===  | 
||
Uses [Drug_Memos.MemoText] where [Drug_Memos.MemoType = Administration] and [Drug_Memos.checked = -1]  | 
|||
References to be used:  | 
|||
a.BNF 70;   | 
|||
b.SAMF;   | 
|||
c.Trissel Handbook of Injectable Drugs monograph;   | 
|||
d.Australian Handbook of Injectable drugs   | 
|||
e.http://www.globalrph.com/  | 
|||
f.and the package inserts which we have available  | 
|||
Format:  | 
|||
1 Route (negative)Do not administer/not recommended as a bolus, IM, SC, IV  | 
|||
2 Administration: where i.e. confirm the correct route (e.g. intravenous infusion, Y-site), timing (intermittently, rapid, slow, over 3 hours) after  | 
|||
3   | 
|||
Re-constitution/dilution with ... to a concentration of x   | 
|||
4 Compatible infusion solutions list  | 
|||
5 IN-compatible solutions if very NB  | 
|||
6 Reasons to discard (colour, particles, cloudy)  | 
|||
7 Warnings (drugs that should not be used in same IV line, syringe etc)  | 
|||
Standard format of list:  | 
|||
Compatible RECONSTITUTION solutions:  | 
|||
Water for Injection  | 
|||
Sterile water for injection  | 
|||
Bacteriostatic water for injection  | 
|||
Sodium Chloride 0.9%  | 
|||
Dextrose 5%  | 
|||
Dextrose 10%  | 
|||
Lignocaine 0.5/1% (without epinephrine)   | 
|||
Ringer’s Lactate / Sodium Lactate / Hartmann’s solution / Compound Sodium Lactate Intravenous Infusion BP  | 
|||
Ringer’s solution  | 
|||
Compatible secondary diluent solutions:  | 
|||
Water for Injection  | 
|||
Sterile water for injection  | 
|||
Bacteriostatic water for injection  | 
|||
Sodium Chloride 0.9%  | 
|||
Dextrose 5%  | 
|||
Dextrose 10%  | 
|||
Dextrose 20%  | 
|||
Dextrose 5% in Ringer’s Lactate  | 
|||
Dextrose 5% in Ringer’s  | 
|||
Dextrose 5% in Sodium Chloride 0.2%  | 
|||
Dextrose 5% in Sodium Chloride 0.3%  | 
|||
Dextrose 5% in Sodium Chloride 0.45%  | 
|||
Dextrose 5% in Sodium Chloride 0.9%  | 
|||
Dextrose 2.5% in Sodium Chloride 0.45%  | 
|||
Dextrose 5% in Potassium Chloride 0.15%  | 
|||
Dextrose 5% in Sodium bicarbonate 0.02%  | 
|||
Dextran 40 in normal saline  | 
|||
Dextran 6% in Dextrose 5%  | 
|||
Hydroxyethyl starch 6 to 10%  | 
|||
IonosolR B with Dextrose 5%  | 
|||
IonosolR G with Dextrose 10%  | 
|||
IsolyteR M with Dextrose 5% and NormosolR-R  | 
|||
Inverted Sugar 10%  | 
|||
Invert sugar 5% in sterile Water  | 
|||
Invert sugar 10% in sterile Water  | 
|||
Laevulose 5%  | 
|||
Mannitol 2.5 %  | 
|||
Mannitol 5 %  | 
|||
Mannitol 10 %  | 
|||
Normasol-M in Dextrose 5%  | 
|||
Normasol-R in Dextrose 5%  | 
|||
Plasma-Lyte with Dextrose 5%  | 
|||
Plasma-LyteR-M with Dextrose 5%  | 
|||
Potassium Chloride in Dextrose  | 
|||
Ringer’s Lactate /Sodium Lactate/Hartmann’s solution/Compound Sodium Lactate IV Infusion BP  | 
|||
Ringer’s solution  | 
|||
Sodium bicarbonate 5% / Sodium hydrogen carbonate 4.2%  | 
|||
Sodium bicarbonate 1.4%  | 
|||
Sodium bicarbonate 2.74% m/v  | 
|||
Sodium Chloride and Glucose Intravenous Infusion BP   | 
|||
Sodium Lactate (M/6 Sodium Lactate)  | 
|||
===TRADE NAMES===  | 
  ===TRADE NAMES===  | 
||
* RSA trades only i.e. [TradeNames.DataSet] = RSA  | 
  * RSA trades only i.e. [TradeNames.DataSet] = RSA  | 
||
* discontinued trades must not show i.e. [TradeNames.DiscontinuedDate] = null  | 
  * discontinued trades must not show i.e. [TradeNames.DiscontinuedDate] = null  | 
||
* section 21 trades ???  | 
  |||
* Orders PD trades first. If [TradeName.Man]=PDY then put at the top   | 
  * Orders PD trades first. If [TradeName.Man]=PDY then put at the top   | 
||
* Sorts alphabetically  | 
  * Sorts alphabetically  | 
||
| Line 63: | Line 175: | ||
==Patient App==  | 
  ==Patient App==  | 
||
''Questions:''  | 
  |||
* Indications: ICD10 code wording is very longwinded. Should we:  | 
  |||
**do a translation  | 
  |||
**add a simpler term  | 
  |||
**untick and add species to "Infection %s"  | 
  |||
| Line 77: | Line 184: | ||
===CONTRAINDICATIONS===  | 
  ===CONTRAINDICATIONS===  | 
||
* Hypersensitivity to active and excipients: must always show  | 
|||
* Porphyria:  Data must be copied from the Porphyria tab to the Conditions tab  | 
  * 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  | 
  * 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  | 
  * 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  | 
  where [Conditions.FrequencySupport] = Contraindicated  | 
||
| Line 86: | Line 197: | ||
:[Conditions.DictionaryQualifierID]  | 
  :[Conditions.DictionaryQualifierID]  | 
||
:[Conditions.DictionaryDescID]  | 
  :[Conditions.DictionaryDescID]  | 
||
:[Conditions.DictionaryParams]  | 
  :[Conditions.DictionaryParams]  | 
||
:[Conditions.SuppressOutput = 0]  | 
|||
;translation  | 
|||
:[Translation_Details.Target_Lang = PD_App]  | 
|||
===SIDE EFFECTS===  | 
  ===SIDE EFFECTS===  | 
||
Latest revision as of 12:01, 19 February 2018
GENERAL
Maintenance of data for the app
- 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
INDICATION
ADMINISTRATION
Uses [Drug_Memos.MemoText] where [Drug_Memos.MemoType = Administration] and [Drug_Memos.checked = -1]
References to be used:
a.BNF 70; 
b.SAMF; 
c.Trissel Handbook of Injectable Drugs monograph; 
d.Australian Handbook of Injectable drugs 
e.http://www.globalrph.com/
f.and the package inserts which we have available
Format: 1 Route (negative)Do not administer/not recommended as a bolus, IM, SC, IV 2 Administration: where i.e. confirm the correct route (e.g. intravenous infusion, Y-site), timing (intermittently, rapid, slow, over 3 hours) after 3
Re-constitution/dilution with ... to a concentration of x
4 Compatible infusion solutions list
5 IN-compatible solutions if very NB
6 Reasons to discard (colour, particles, cloudy)
7 Warnings (drugs that should not be used in same IV line, syringe etc)
Standard format of list: Compatible RECONSTITUTION solutions:
Water for Injection Sterile water for injection Bacteriostatic water for injection Sodium Chloride 0.9% Dextrose 5% Dextrose 10% Lignocaine 0.5/1% (without epinephrine) Ringer’s Lactate / Sodium Lactate / Hartmann’s solution / Compound Sodium Lactate Intravenous Infusion BP Ringer’s solution
Compatible secondary diluent solutions:
Water for Injection Sterile water for injection Bacteriostatic water for injection Sodium Chloride 0.9% Dextrose 5% Dextrose 10% Dextrose 20% Dextrose 5% in Ringer’s Lactate Dextrose 5% in Ringer’s Dextrose 5% in Sodium Chloride 0.2% Dextrose 5% in Sodium Chloride 0.3% Dextrose 5% in Sodium Chloride 0.45% Dextrose 5% in Sodium Chloride 0.9% Dextrose 2.5% in Sodium Chloride 0.45% Dextrose 5% in Potassium Chloride 0.15% Dextrose 5% in Sodium bicarbonate 0.02% Dextran 40 in normal saline Dextran 6% in Dextrose 5% Hydroxyethyl starch 6 to 10% IonosolR B with Dextrose 5% IonosolR G with Dextrose 10% IsolyteR M with Dextrose 5% and NormosolR-R Inverted Sugar 10% Invert sugar 5% in sterile Water Invert sugar 10% in sterile Water Laevulose 5% Mannitol 2.5 % Mannitol 5 % Mannitol 10 % Normasol-M in Dextrose 5% Normasol-R in Dextrose 5% Plasma-Lyte with Dextrose 5% Plasma-LyteR-M with Dextrose 5% Potassium Chloride in Dextrose Ringer’s Lactate /Sodium Lactate/Hartmann’s solution/Compound Sodium Lactate IV Infusion BP Ringer’s solution Sodium bicarbonate 5% / Sodium hydrogen carbonate 4.2% Sodium bicarbonate 1.4% Sodium bicarbonate 2.74% m/v Sodium Chloride and Glucose Intravenous Infusion BP Sodium Lactate (M/6 Sodium Lactate)
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
STRENGTH
INDICATIONS
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]