CPRD DRUG_EXPOSURE Quantity Field Data Type

Implementers
1

CDM4 defines Quantity field in DRUG_EXPOSURE as NUMBER(4). As per my understanding, Number(4) doesn’t take decimal values. However, “Quantity” field in “Therapy” source table field in CPRD which maps DRUG_EXPOSURE quantity field contains decimal values.Please provide guidance on how to handle this case.

Thanks,
Mitesh

2

@mitesh:

You are totally right. It was assumed that quantity means an integer number of drug units (tablets etc.), but of course it could be liquids or parts of a unit, too. In V5, we fixed that (http://www.ohdsi.org/web/wiki/doku.php?id=documentation:cdm:drug_exposure). So, turn it into a float.

And go V5. A lot of these small improvements are incorporated. You don’t want to be the last one. :slight_smile:

3

Thanks Christian! I will make a note on V5 improvements :-).