ID

40291

Description

PCORnet Common Data Model (CDM) Dispensing V4.1 Prescriptions filled through a community, mail-order or hospital pharmacy. Outpatient dispensing may not be directly captured within healthcare systems. Each record represents an outpatient pharmacy dispensing. Administered medications should NOT be stored in this table. They should be stored in the MED_ADMIN table. Evidence of medications administered in outpatient settings, such as infusions given in medical practices, or those administered in an inpatient setting may be present in the PROCEDURES table if that level of detail is available in the source procedure data. In the uncommon situation where one NDC is dispensed more than once for a given patient on a given day, it is acceptable to combine the values from the multiple dispensings for days supply and number of units. PCORnet Common Data Model (CDM) The PCORnet Common Data Model (CDM) is a specification that defines a standard organization and representationof data for the PCORnet Distributed Research Network. The PCORnet CDM is a key component of the PCORnet Distributed Research Network (DRN) infrastructure.

Keywords

Versions (3)
  1. 12/12/16 12/12/16 -
  2. 7/1/19 7/1/19 -
  3. 3/30/20 3/30/20 -
Copyright Holder

PCORnet

Uploaded on

March 30, 2020

DOI

To request one please log in.

License

Creative Commons BY-NC 4.0
Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Back to model comments
Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

PCORnet Common Data Model (CDM)

English

Dispensing V4.1

1 forms  
  1. StudyEvent: ODM
    1. Dispensing V4.1
Dispensing
Description

Dispensing

Alias
UMLS CUI-1
C0029921
UMLS CUI-2
C0947323
Dispensing ID
Description

Arbitrary identifier for each unique record. Does not need to be persistent across refreshes, and may be created by methods such as sequence or GUID.

Data type

text

Alias
UMLS CUI [1,1]
C0947323
UMLS CUI [1,2]
C1300638
Patient ID
Description

Arbitrary person-level identifier. Used to link across tables. All PATIDs must be present in the DEMOGRAPHIC table.

Data type

text

Alias
UMLS CUI [1]
C2348585
Prescribing ID
Description

This is an optional relationship to the PRESCRIBING table, and may not be generally available. One prescribing order may generate multiple dispensing records.

Data type

text

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C1300638
Dispense Date
Description

Dispensing date (as close as possible to date the person received the dispensing).

Data type

date

Alias
UMLS CUI [1,1]
C0947323
UMLS CUI [1,2]
C0011008
NDC
Description

National Drug Code in the 11-digit, no-dash, HIPAA format. Please expunge any place holders (such as dashes or extra digits).

Data type

text

Alias
UMLS CUI [1]
C1708005
Dispense SUP
Description

Days supply. Number of days that the medication supports based on the number of doses as reported by the pharmacist. This amount is typically found on the dispensing record. Integer values are expected. Important: Please do not calculate during CDM implementation. This field should only reflect originating source system calculations. Number precision and scale updated in v4.1.

Data type

integer

Alias
UMLS CUI [1,1]
C1561604
UMLS CUI [1,2]
C0947323
UMLS CUI [1,3]
C0449238
Dispense AMT
Description

Number of units (pills, tablets, vials) dispensed. Net amount per NDC per dispensing. This amount is typically found on the dispensing record. Positive values are expected. Important: Please do not calculate during CDM implementation. This field should only reflect originating source system calculations. Number precision and scale updated in v4.1.

Data type

integer

Alias
UMLS CUI [1]
C0805077
Dispense Dose
Description

Dose of a given mediation, as dispensed

Data type

integer

Alias
UMLS CUI [1,1]
C0947323
UMLS CUI [1,2]
C3174092
Dispense Dose
Description

Units of measure associated with the dose of the medication as dispensed. See Value Set Appendix for a list of acceptable values. Do not impute or derive. Populate only if captured in the source system as a discrete value. Choose the standardized unit of measure that is most reflective of the source data. The Value Set Appendix contains a list of the units most commonly associated with medication records. Partners can use this table to aid in their mapping efforts, but they should refer back to the full value set if they have a medication record with a unit of measure that is not present in this curated list. This is a mixed case value set and entries should be handled accordingly.

Data type

float

Alias
UMLS CUI [1,1]
C0947323
UMLS CUI [1,2]
C3174092
Dispense Dose
Description

.Route of delivery. See Value Set Appendix for a list of acceptable values. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

text

Alias
UMLS CUI [1,1]
C0947323
UMLS CUI [1,2]
C0449444
RAW NDC
Description

Optional field for originating value of field, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1]
C1708005
RAW Dispense Dose
Description

Field for originating value, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C0947323
RAW Dispense Dose Unit
Description

Field for originating value, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C0947323
UMLS CUI [1,3]
C0869039
RAW Dispense Route
Description

Field for originating value, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C0947323
UMLS CUI [1,3]
C0449444
Back to the top of the page

Similar models

Dispensing V4.1

1 forms
  1. StudyEvent: ODM
    1. Dispensing V4.1
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Dispensing
C0029921 (UMLS CUI-1)
C0947323 (UMLS CUI-2)
Dispensing ID
Item
Dispensing ID
text
C0947323 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
text
C2348585 (UMLS CUI [1])
Prescribing ID
Item
Prescribing ID
text
C3166216 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Dispense Date
Item
Dispense Date
date
C0947323 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
NDC
Item
NDC
text
C1708005 (UMLS CUI [1])
Dispense SUP
Item
Dispense SUP
integer
C1561604 (UMLS CUI [1,1])
C0947323 (UMLS CUI [1,2])
C0449238 (UMLS CUI [1,3])
Dispense AMT
Item
Dispense AMT
integer
C0805077 (UMLS CUI [1])
Dispense Dose DISP
Item
Dispense Dose
integer
C0947323 (UMLS CUI [1,1])
C3174092 (UMLS CUI [1,2])
Dispense Dose Unit
Item
Dispense Dose
float
C0947323 (UMLS CUI [1,1])
C3174092 (UMLS CUI [1,2])
Dispense Route
Item
Dispense Dose
text
C0947323 (UMLS CUI [1,1])
C0449444 (UMLS CUI [1,2])
RAW NDC
Item
RAW NDC
text
C1708005 (UMLS CUI [1])
Raw Dispense Dose
Item
RAW Dispense Dose
text
C3174092 (UMLS CUI [1,1])
C0947323 (UMLS CUI [1,2])
Raw Dispense Dose Unit
Item
RAW Dispense Dose Unit
text
C3174092 (UMLS CUI [1,1])
C0947323 (UMLS CUI [1,2])
C0869039 (UMLS CUI [1,3])
Raw Dispense Route
Item
RAW Dispense Route
text
C3174092 (UMLS CUI [1,1])
C0947323 (UMLS CUI [1,2])
C0449444 (UMLS CUI [1,3])
Back to the top of the page 

Contact

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial