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]