Difference between revisions of "PD App"
Line 70: | Line 70: | ||
===ADMINISTRATION=== |
===ADMINISTRATION=== |
||
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) |
|||
2 Administration (where, timing)after |
|||
3 Re-constitution/dilution to a concentration of x in |
|||
4 Compatible infusion solutions list |
|||
Revision as of 10:54, 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
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) 2 Administration (where, timing)after 3 Re-constitution/dilution to a concentration of x in 4 Compatible infusion solutions list
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]