documentation:next_cdm:denominator_units
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:next_cdm:denominator_units [2015/12/29 11:48] klaus_bonadt |
documentation:next_cdm:denominator_units [2017/03/07 02:04] cgreich |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| === Options: === | === Options: === | ||
| - | - We could agree on using mg instead of g for the quantity in case 1c. However, this would require additional conventions and steps for the ETL process: We would use mL for liquids and products with different denominator units (for example 42799258 "Benzyl Alcohol 0.1 ML/ML / Pramoxine hydrochloride 0.01 MG/MG Topical Gel"). However, we would use mg for products which exclusively use a mass unit. Thus, we would need to check all corresponding entries in the DRUG_STRENGTH table beforehand in order to know whether we can apply mg or mL. | + | - We could agree on using mg instead of g for the quantity in case 1c. However, this would require additional conventions and steps for the ETL process: We would use mL for liquids and products with different denominator units (for example 42799258 "Benzyl Alcohol 0.1 ML/ML / Pramoxine hydrochloride 0.01 MG/MG Topical Gel"). However, we would use mg for products which exclusively use a mass unit. Thus, we would need to check all corresponding entries in the DRUG_STRENGTH table beforehand in order to know whether we can apply mg or mL. __I don't recommend this.__ |
| - | - We could use an additional field quantity_unit_concept_id to denote the unit. However, this would also require additional sets of conventions to avoid incompatible entries between quantity_unit_concept_id and denominator_unit_concept_id. | + | - We could use an additional field quantity_unit_concept_id to denote the unit. However, this would also require additional sets of conventions to avoid incompatible entries between quantity_unit_concept_id and denominator_unit_concept_id. __I don't recommend this.__ |
| - | - In the DRUG_STRENGTH table we could allow additional units for masses (besides mg), or volumes (besides mL) or time (besides h). However, this would add not only additional complexity for the conversions but also for the checks to decide whether a DRUG_STRENGTH entry belongs to a dose release over time, to a mass or a volume unit. | + | - In the DRUG_STRENGTH table we could allow additional units for masses (besides mg), or volumes (besides mL) or time (besides h). However, this would add not only additional complexity for the conversions but also for the checks to decide whether a DRUG_STRENGTH entry belongs to a dose release over time, to a mass or a volume unit. __I don't recommend this.__ |
| - | - In the DRUG_EXPOSURE table we could add a flag to indicate that this record is part of a compounding. | + | - We might want to distinguish between drugs used in compounding and normal drugs dispensed on the same day. In the DRUG_EXPOSURE table we could use a compounding_sequence (holding a sequence number for each compounding on the same day for the same patient) or a compound_sequence (holding a sequence number for each compound. The sequence will restart from 1 for all subsequent compounding). __I do recommend this, preferably the latter one.__ |
| === Use Cases === | === Use Cases === | ||
| - | ^ 1 ^ Tablets^ | + | ^ 1 ^ Solid preparations, preparations where dose cannot be split^ |
| + | ^ :::|//Example: All preparations where the dose is given in absolute amounts.//| | ||
| ^ DRUG_STRENGTH | The denominator_unit is empty | | ^ DRUG_STRENGTH | The denominator_unit is empty | | ||
| ^ DRUG_EXPOSURE | Quantity refers to number of pieces, e.g. tablets | | ^ DRUG_EXPOSURE | Quantity refers to number of pieces, e.g. tablets | | ||
| + | ^ :::|//20. Note that in non-US databases this number could also be take from the DRUG_STRENGTH.box_size field, however, the ETL should copy that to the quantity field.//| | ||
| ^ ''Ingredient dose=''|''quantity x amount_value [amount_unit_concept_id]''| | ^ ''Ingredient dose=''|''quantity x amount_value [amount_unit_concept_id]''| | ||
| + | ^ :::|''//Paracetamol dose = 20 x 500mg = 10,000mg//''| | ||
| | | | | | | | | ||
| ^ 2 ^ Puffs of an inhaler ^ | ^ 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. In this case the strength is provided in the numerator.| | ||
| ^ DRUG_STRENGTH | The denominator_unit is {actuat}| | ^ DRUG_STRENGTH | The denominator_unit is {actuat}| | ||
| ^ DRUG_EXPOSURE | Quantity refers to the number of pieces, e.g. puffs | | ^ DRUG_EXPOSURE | Quantity refers to the number of pieces, e.g. puffs | | ||
| Line 82: | Line 86: | ||
| ^ :::|//''Piroxicam dose = 0.3 x 1mg x 1000 = 300mg''//| | ^ :::|//''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.//| | ^ :::|//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 ^Dose release 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 | 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/next_cdm/denominator_units.txt · Last modified: 2017/07/07 15:20 by clairblacketer
Page Tools
