ID

37062

Description

PCORnet Common Data Model (CDM) Prescribing V4.1 Provider orders for medication dispensing and/or administration. These orders may take place in any setting, including the inpatient or outpatient basis. 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. http://www.pcornet.org/pcornet-common-data-model/

Link

http://www.pcornet.org/pcornet-common-data-model/

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

July 1, 2019

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)

English

Prescribing V4.1

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

Prescribing

Alias
UMLS CUI-1
C3166216
UMLS CUI-2
C0033080
UMLS CUI-3
C0013227
Prescribing ID
Description

Arbitrary identifier for each unique PRESCRIBING record.

Data type

text

Alias
UMLS CUI [1,1]
C3166216
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
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. All ENCOUNTERIDs in this table must be present in the ENCOUNTER table.

Data type

text

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. All PROVIDERIDs in this table must be present in the PROVIDER table.

Data type

text

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

Order date of the prescription by the provider. If RX_ORDER_DATE is not known, a permissible substitution is the RX_START_DATE (if known) or the date the order was signed 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 Dose Ordered
Description

Dose of a given mediation, as ordered by the provider. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

float

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C1705178
RX Dose Ordered
Description

Units of measure associated with the dose of the medication as ordered by the provider. 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

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C0869039
RX Quantity
Description

Quantity ordered. Number precision and scale updated in v4.1. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

float

Alias
UMLS CUI [1,1]
C3166216
UMLS CUI [1,2]
C1265611
RX Dose Form
Description

The unit associated with the quantity prescribed. This is equivalent to RxNorm Dose Form. 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]
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 v4.1. If value is non-numeric, leave field blank and populate RAW_RX_REFILLS with originating source value. Do not impute or derive. Populate only if captured in the source system as a discrete value.

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 v4.1. Do not impute or derive. Populate only if captured in the source system as a discrete value.

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. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

text

Alias
UMLS CUI [1]
C3476109
RX PRN Flag
Description

Flag to indicate that all or part of medication frequency instructions includes “as needed.” Select Yes if medication order includes instructions to take medication “as needed” or with any other frequency “as needed” (e.g., Two times a day, as needed). This field is a derived attribute, and is not expected to be an explicit data field within a source system.

Data type

boolean

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0815189
RX Route
Description

Route of medication delivery. The value set for Route is derived from SNOMED and may include values that are more granular than what is present in the source system. If a direct mapping is available, use the appropriate SNOMED code. If there is any possible ambiguity, use “OT” and then store the source value in RAW_RX_ROUTE. For example, an Injection could map to Subcutaneous or Intramuscular or Intraocular, depending on the drug, so that would best be mapped to “OT.” Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

text

Alias
UMLS CUI [1]
C0013153
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. The ordering strategy for RxNorm Term Types has been updated to indicate a preference of brand name CUIs over generics, when available. It has also been expanded to include addition RxNorm Term Types. Please see Reference Table 4 for more information. Do not assign a RxNorm Term Type that is not supported by the source data (i.e., if the medication order in source system is missing strength information, do not use any of the RxNorm Term Types that incorporate the strength component). This field may be a derived attribute, and is not necessarily expected to be an explicit data field within a source system. Expected format of RXNORM_CUI codes: Length of 2-7, no alphabetical characters. Do not assign more than one RxCUI per order. Ensure that a single prescribing record is not assigned multiple RxCUIs.

Data type

text

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

Source of the prescribing information. This field is a derived attribute, and is not expected to be an explicit data field within a source system. Use “OD” for medication orders entered into the EHR or for electronic prescriptions. Use “DR” for all medication orders that are derived or imputed through analytical procedures (e.g., natural language processing). This does not apply to medication orders mapped from a superset terminology or drug database (e.g., MediSpan, FDB). For those records, use “OD” (General Guidance #4).

Data type

text

Alias
UMLS CUI [1,1]
C0683836
UMLS CUI [1,2]
C3166216
RX Dispense as Written
Description

Flag to indicate whether the provider indicated that the medication order was to be dispensed as written. his information is typically captured within EHRs or e- prescribing as part of the ordering process. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Data type

text

Alias
UMLS CUI [1]
C1880360
RAW RX Med Name
Description

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

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

Data type

text

Alias
UMLS CUI [1]
C3476109
Raw RXNorm CUI
Description

Field for originating value, 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

Field for originating value, 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

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

Data type

text

Alias
UMLS CUI [1]
C1708005
RAW RX Dose Ordered
Description

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

Data type

text

Alias
UMLS CUI [1]
C3166216
RAW RX Dose Ordered Unit
Description

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

Data type

text

Alias
UMLS CUI [1]
C0869039
RAW RX Route
Description

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

Data type

text

Alias
UMLS CUI [1]
C0013153
RAW RX Refills
Description

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

Data type

text

Alias
UMLS CUI [1]
C0149761
Back to the top of the page

Similar models

Prescribing V4.1

1 forms
  1. StudyEvent: ODM
    1. Prescribing V4.1
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
text
C3166216 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
text
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
text
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
RX Provider ID
Item
RX Provider ID
text
C1138603 (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 Dose Ordered
Item
RX Dose Ordered
float
C3174092 (UMLS CUI [1,1])
C1705178 (UMLS CUI [1,2])
RX Dose Ordered Unit
Item
RX Dose Ordered
text
C3174092 (UMLS CUI [1,1])
C0869039 (UMLS CUI [1,2])
RX Quantity
Item
RX Quantity
float
C3166216 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
RX Dose Form
Item
RX Dose Form
text
C3166216 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
C1519795 (UMLS CUI [1,3])
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
Every evening  (09)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
CL Item
Once (10)
RX PRN Flag
Item
RX PRN Flag
boolean
C0013227 (UMLS CUI [1,1])
C0815189 (UMLS CUI [1,2])
RX Route
Item
RX Route
text
C0013153 (UMLS CUI [1])
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])
Item
RX Source
text
C0683836 (UMLS CUI [1,1])
C3166216 (UMLS CUI [1,2])
RX Source
Code List
RX Source
CL Item
Order/EHR  (OD)
CL Item
Derived  (DR)
CL Item
No information  (NI)
CL Item
Unknown  (UN)
CL Item
Other (OT)
Item
RX Dispense as Written
text
C1880360 (UMLS CUI [1])
RX Dispense As Written
Code List
RX Dispense as Written
CL Item
Yes (Y)
CL Item
No (N)
CL Item
No information  (NI)
CL Item
Unknown  (UN)
CL Item
Other (OT)
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
C1708005 (UMLS CUI [1])
RAW RX Dose Ordered
Item
RAW RX Dose Ordered
text
C3166216 (UMLS CUI [1])
RAW RX Dose Ordered Unit
Item
RAW RX Dose Ordered Unit
text
C0869039 (UMLS CUI [1])
RAW RX Route
Item
RAW RX Route
text
C0013153 (UMLS CUI [1])
RAW RX Refills
Item
RAW RX Refills
text
C0149761 (UMLS CUI [1])
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