ID

19206

Description

PCORnet Common Data Model (CDM) Prescribing PCORnet Common Data Model (CDM) A patient-centered approach to building an agile research platform is at the heart of PCORnet, and data serves as the backbone. Considering the large number and diverse types of organizations that are part of PCORnet, we all benefit from having a streamlined, efficient way to use the data produced by these organizations. Enter the PCORnet Common Data Model. The Common Data Model (or CDM) is a way of organizing data into a standard structure. The approach PCORnet is using to do this mirrors the approaches used by other large national research consortia. Each PCORnet partner network maps data to the same consistent format (i.e., with the same variable name, attributes, and other metadata). By undertaking this step, we create a platform that enables much more rapid responses to research-related questions. Contrast this with having to transform and prepare data each time we want to ask a new research question, and the efficiencies become clear. The PCORnet CDM is based on the FDA Sentinel Initiative Common Data Model (www.sentinelsystem.org) and has been informed by other distributed initiatives such as the Health Care Systems Research Network, the Vaccine Safety Datalink, various AHRQ Distributed Research Network projects, and the ONC Standards & Interoperability Framework Query Health Initiative. The PCORnet CDM leverages standard terminologies and coding systems for healthcare (including ICD, SNOMED, CPT, HCPSC, and LOINC) to enable interoperability with and responsiveness to evolving data standards. The PCORnet CDM (like other parts of PCORnet) will grow and evolve. Version 1.0 focused on a set of data items that are frequently available. Subsequent versions build in additional data elements which are analytically important for patient-centered outcomes research and feasible to standardize across sites.

Link

www.sentinelsystem.org

Keywords

Versions (3)
  1. 12/12/16 12/12/16 -
  2. 7/1/19 7/1/19 -
  3. 3/30/20 3/30/20 -
Uploaded on

December 12, 2016

DOI

To request one please log in.

License

Creative Commons BY-NC 3.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) Prescribing

English

PCORnet Common Data Model (CDM) Prescribing

1 forms  
Prescribing
Description

Prescribing

Alias
UMLS CUI-1
C3166216
UMLS CUI-2
C0033080
UMLS CUI-3
C0013227
Prescribing 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

integer

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

Arbitrary person-level identifier. Used to link across tables.

Data type

integer

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Arbitrary encounter-level identifier. This is an optional relationship; the ENCOUNTERID should be present if the prescribing activity is directly associated with an encounter.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1300638
RX Provider ID
Description

Provider code for the provider who prescribed the medication. The provider code is a pseudoidentifier with a consistent crosswalk to the real identifier.

Data type

integer

Alias
UMLS CUI [1,1]
C0807500
UMLS CUI [1,2]
C0033080
UMLS CUI [1,3]
C1300638
RX Order Date
Description

Order date of the prescription by the provider.

Data type

date

Alias
UMLS CUI [1,1]
C0033080
UMLS CUI [1,2]
C1272683
UMLS CUI [1,3]
C0011008
RX Order Time
Description

Order time of the prescription by the provider.

Data type

time

Alias
UMLS CUI [1,1]
C0033080
UMLS CUI [1,2]
C1272683
UMLS CUI [1,3]
C0040223
RX Start Date
Description

Start date of order. This attribute may not be consistent with the date on which the patient actually begin taking the medication.

Data type

date

Alias
UMLS CUI [1,1]
C0033080
UMLS CUI [1,2]
C1272683
UMLS CUI [1,3]
C0808070
RX End Date
Description

End date of order (if available).

Data type

date

Alias
UMLS CUI [1,1]
C0033080
UMLS CUI [1,2]
C1272683
UMLS CUI [1,3]
C0806020
RX Quantity
Description

Quantity ordered. Number precision and scale updated in v3.1.

Data type

float

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C1265611
RX Quantity Unit
Description

The unit associated with the quantity prescribed. New field added in v3.1.

Data type

text

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C1265611
UMLS CUI [1,3]
C1519795
RX Refills
Description

Number of refills ordered (not including the original prescription). If no refills are ordered, the value should be zero. Number precision and scale updated in v3.1.

Data type

float

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C0149761
RX Days Supply
Description

Number of days supply ordered, as specified by the prescription. Number precision and scale updated in v3.1.

Data type

integer

Alias
UMLS CUI [1,1]
C1561604
UMLS CUI [1,2]
C3166216
UMLS CUI [1,3]
C0449238
RX Frequency
Description

Specified frequency of medication.

Data type

text

Alias
UMLS CUI [1]
C3476109
RX Basis
Description

Basis of the medication order. The PRESCRIBING table can contain orders for many different activities, and this field is intended to connect the provider’s prescribing order with how the order was fulfilled (such as outpatient dispensing or administration by a healthcare professional). (Value set items updated and field definition expanded in v3.1.)

Data type

text

Alias
UMLS CUI [1,1]
C0392360
UMLS CUI [1,2]
C0033080
UMLS CUI [1,3]
C1272683
RXNorm CUI
Description

Where an RxNorm mapping exists for the source medication, this field contains the RxNorm concept identifier (CUI) at the highest possible specificity. v3.1 modification: field types changed to character because the National Library of Medicine specifies this variable as a character type.

Data type

text

Alias
UMLS CUI [1,1]
C2348662
UMLS CUI [1,2]
C3166216
RAW RX Med Name
Description

Optional field for originating, full textual medication name from the source.

Data type

text

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C0027365
UMLS CUI [2,1]
C0013227
UMLS CUI [2,2]
C0027365
RAW RX Frequency
Description

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

Data type

text

Alias
UMLS CUI [1]
C3476109
Raw RXNorm CUI
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C2348662
UMLS CUI [1,2]
C3166216
RAW RX Quantity
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C1265611
RAW RX NDC
Description

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

Data type

text

Back to the top of the page

Similar models

PCORnet Common Data Model (CDM) Prescribing

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Prescribing
C3166216 (UMLS CUI-1)
C0033080 (UMLS CUI-2)
C0013227 (UMLS CUI-3)
Prescribing ID
Item
Prescribing ID
integer
C3166216 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
integer
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
integer
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
RX Provider ID
Item
RX Provider ID
integer
C0807500 (UMLS CUI [1,1])
C0033080 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
RX Order Date
Item
RX Order Date
date
C0033080 (UMLS CUI [1,1])
C1272683 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
RX Order Time
Item
RX Order Time
time
C0033080 (UMLS CUI [1,1])
C1272683 (UMLS CUI [1,2])
C0040223 (UMLS CUI [1,3])
RX Start Date
Item
RX Start Date
date
C0033080 (UMLS CUI [1,1])
C1272683 (UMLS CUI [1,2])
C0808070 (UMLS CUI [1,3])
RX End Date
Item
RX End Date
date
C0033080 (UMLS CUI [1,1])
C1272683 (UMLS CUI [1,2])
C0806020 (UMLS CUI [1,3])
RX Quantity
Item
RX Quantity
float
C3166216 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
Item
RX Quantity Unit
text
C3166216 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
C1519795 (UMLS CUI [1,3])
RX Quantity Unit
Code List
RX Quantity Unit
CL Item
Pill (PI)
CL Item
Tablet (TA)
CL Item
Vial (VI)
CL Item
Liquid (LI)
CL Item
Solution (SO)
CL Item
Suspension (SU)
CL Item
Ointment (OI)
CL Item
Cream (CR)
CL Item
Powder (PO)
CL Item
Patch (PA)
CL Item
Inhaler (IN)
CL Item
Kit (KI)
CL Item
Device (DE)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
RX Refills
Item
RX Refills
float
C3166216 (UMLS CUI [1,1])
C0149761 (UMLS CUI [1,2])
RX Days Supply
Item
RX Days Supply
integer
C1561604 (UMLS CUI [1,1])
C3166216 (UMLS CUI [1,2])
C0449238 (UMLS CUI [1,3])
Item
RX Frequency
text
C3476109 (UMLS CUI [1])
RX Frequency
Code List
RX Frequency
CL Item
Every day (01)
CL Item
Two times a day (BID) (02)
CL Item
Three times a day (TID) (03)
CL Item
Four times a day (QID) (04)
CL Item
Every morning (05)
CL Item
Every afternoon (06)
CL Item
Before meals (07)
CL Item
After meals (08)
CL Item
As needed (PRN) (09)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
RX Basis
text
C0392360 (UMLS CUI [1,1])
C0033080 (UMLS CUI [1,2])
C1272683 (UMLS CUI [1,3])
RX Basis
Code List
RX Basis
CL Item
Order to Dispense (01)
CL Item
Order to administer (02)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
RXNorm CUI
Item
RXNorm CUI
text
C2348662 (UMLS CUI [1,1])
C3166216 (UMLS CUI [1,2])
RAW RX Med Name
Item
RAW RX Med Name
text
C3166216 (UMLS CUI [1,1])
C0027365 (UMLS CUI [1,2])
C0013227 (UMLS CUI [2,1])
C0027365 (UMLS CUI [2,2])
RAW RX Frequency
Item
RAW RX Frequency
text
C3476109 (UMLS CUI [1])
Raw RXNorm CUI
Item
Raw RXNorm CUI
text
C2348662 (UMLS CUI [1,1])
C3166216 (UMLS CUI [1,2])
RAW RX Quantity
Item
RAW RX Quantity
text
C3166216 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
RAW RX NDC
Item
RAW RX NDC
text
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