User Tools

Site Tools


documentation:cdm:dose_era

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:cdm:dose_era [2014/12/06 17:06]
cgreich
documentation:cdm:dose_era [2017/09/25 15:09] (current)
clairblacketer
Line 1: Line 1:
 ===== DOSE_ERA table ===== ===== DOSE_ERA table =====
 +**THIS IS OUTDATED. All documentation is now on the [[https://​github.com/​OHDSI/​CommonDataModel/​wiki|github wiki]]. Please refer there or to the [[projects:​workgroups:​cdm-wg|CDM working group]] for more information**
 +
 A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient. ​ A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient. ​
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
Line 10: Line 12:
 |dose_era_end_date|Yes|date|The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.| |dose_era_end_date|Yes|date|The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.|
 ==== Conventions ==== ==== Conventions ====
-  * Dose Eras will be derived from records in the DRUG_EXPOSURE table and the Dose information from the DRUG_DOSE ​table using a standardized algorithm. +  * Dose Eras will be derived from records in the DRUG_EXPOSURE table and the Dose information from the DRUG_STRENGTH ​table using a standardized algorithm. 
-  * Each Dose Era corresponds to one or many Drug Exposures that form a continuous interval and contain the same Drug Ingredient (active compound) at the same effective dose. +  * Each Dose Era corresponds to one or many Drug Exposures that form a continuous interval and contain the same Drug Ingredient (active compound) at the same effective ​daily dose. 
-  * Dose Form information is not taken into account. So, if the patient changes between different formuations,​ or different manufacturers with the same formuation, the Dose Era is still spanning the entire time of exposure to the Ingredient.+  * Dose Form information is not taken into account. So, if the patient changes between different formuations,​ or different manufacturers with the same formulation, the Dose Era is still spanning the entire time of exposure to the Ingredient. 
 +  * The daily dose is calculated for each DRUG_EXPOSURE record by calculating the total dose of the record and dividing by the duration. 
 +  * The total dose of a DRUG_EXPOSURE record is calculated with the help of the DRUG_STRENGTH table containing the dosage information for each drug as following:​ 
 + 
 +^  1     ^ Tablets and other fixed amount formulations ^  
 +^ :::​|//​Example:​ Acetaminophen (Paracetamol) 500 mg, 20 tablets.//​| 
 +^ DRUG_STRENGTH ​ | The denominator_unit is empty | 
 +^ DRUG_EXPOSURE ​ | The quantity refers to number of pieces, e.g. tablets ​   | 
 +^ :::|//In the example: 20//| 
 +^ ''​Ingredient dose=''​|''​quantity x amount_value [amount_unit_concept_id]''​| 
 +^ :::​|''//​Acetaminophen dose = 20 x 500mg = 10,​000mg//''​| 
 +| | | 
 +^  2     ^ Puffs of an inhaler ^  
 +^ :::|Note: There is no difference to use case 1 besides that the DRUG_STRENGTH table may put {actuat} in the denominator unit. In this case the strength is provided in the numerator.| 
 +^ DRUG_STRENGTH ​ | The denominator_unit is {actuat}| 
 +^ DRUG_EXPOSURE ​ | The quantity refers to the number of pieces, e.g. puffs | 
 +^ ''​Ingredient dose=''​|''​quantity x numerator_value [numerator_unit_concept_id]''​| 
 +| | | 
 +^  3     ^ Quantified Drugs which are formulated as a concentration ^  
 +^ :::​|//​Example:​ The Clinical Drug is Acetaminophen 250 mg/mL in a 5mL oral suspension. The Quantified Clinical Drug would have 1250 mg / 5 ml in the DRUG_STRENGTH table. Two suspensions are dispensed.//​| 
 +^ DRUG_STRENGTH ​ | The denominator_unit is either mg or mL. The denominator_value might be different from 1. | 
 +^ DRUG_EXPOSURE ​ | The quantity refers to a fraction or, multiple of the pack. | 
 +^ :::|// Example: 2// | 
 +^ ''​Ingredient dose=''​|''​quantity x numerator_value [numerator_unit_concept_id]''​| 
 +^ :::​|''//​ Acetaminophen dose = 2 x 1250mg = 2500mg//''​| 
 +| | | 
 +^  4     ^ Drugs with the total amount provided in quantity, e.g. chemotherapeutics ^  
 +^ :::​|//​Example:​ 42799258 "​Benzyl Alcohol 0.1 ML/ML / Pramoxine hydrochloride 0.01 MG/MG Topical Gel" dispensed in a 1.25oz pack.//| 
 +^ DRUG_STRENGTH ​ | The denominator_unit is either mg or mL.| 
 +^ :::|// Example: Benzyl Alcohol in mL and Pramoxine hydrochloride in mg// | 
 +^ DRUG_EXPOSURE ​ | The quantity refers to mL or g.| 
 +^ :::|// Example: 1.25 x 30 (conversion factor oz -> mL) = 37// | 
 +^ ''​Ingredient dose=''​|''​quantity x numerator_value [numerator_unit_concept_id]''​| 
 +^ :::​|''//​ Benzyl Alcohol dose = 37 x 0.1mL = 3.7mL//''​| 
 +^ :::​|//''​Pramoxine hydrochloride dose = 37 x 0.01mg x 1000 = 370mg''//​| 
 +^ :::|//Note: The analytical side should check the denominator in the DRUG_STRENGTH table. As mg is used for the second ingredient the factor 1000 will be applied to convert between g and mg.//| 
 +| | | 
 +^  5     ^ Compounded drugs ^  
 +^ :::​|//​Example:​ Ibuprofen 20%/​Piroxicam 1% Cream, 30ml in 5ml tubes.//| 
 +^ DRUG_STRENGTH ​ | We need entries for the ingredients of Ibuprofen and  Piroxicam, probably with an amount_value of 1 and a unit of mg.| 
 +^ DRUG_EXPOSURE ​ | The quantity refers to the total amount of the compound. Use one record in the DRUG_EXPOSURE table for each compound.| 
 +^ :::|// Example: 20% Ibuprofen of 30ml = 6mL, 1% Piroxicam of 30ml = 0.3mL// | 
 +^ ''​Ingredient dose=''​|Depends on the drugs involved: One of the use cases above.| 
 +^ :::​|''//​ Ibuprofen dose = 6 x 1mg x 1000 = 6000mg//''​| 
 +^ :::​|//''​Piroxicam dose = 0.3 x 1mg x 1000 = 300mg''//​| 
 +^ :::|//Note: The analytical side determines that the denominator for both ingredients in the DRUG_STRENGTH table is mg and applies the factor 1000 to convert between mL/g and mg.//| 
 +| | | 
 +^  6     ^ Drugs with the active ingredient released over time, e.g. patches ^  
 +^ :::​|//​Example:​ Ethinyl Estradiol 0.000833 MG/HR / norelgestromin 0.00625 MG/HR Weekly Transdermal Patch//| 
 +^ DRUG_STRENGTH ​ | The denominator units refer to hour.| 
 +^ :::​|//​Example:​ Ethinyl Estradiol 0.000833 mg/h / norelgestromin 0.00625 mg/h//| 
 +^ DRUG_EXPOSURE ​ | The quantity refers to the number of pieces.| 
 +^ :::|// Example: 1 patch// | 
 +^ ''​Ingredient rate=''​|''​numerator_value [numerator_unit_concept_id]''​| 
 +^ :::​|''//​ Ethinyl Estradiol rate = 0.000833 mg/​h//''​| 
 +^ :::​|//''​norelgestromin rate 0.00625 mg/​h''//​| 
 +^ :::|//Note: This can be converted to a daily dosage by multiplying it with 24. (Assuming 1 patch at a time for at least 24 hours)//| 
  
documentation/cdm/dose_era.1417885581.txt.gz · Last modified: 2014/12/06 17:06 by cgreich