PCORnet Common Data Model (CDM)

Beschreibung

Arbitrary identifier for each unique PRESCRIBING record.

Datentyp

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1300638

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C2348585

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C0033080

UMLS CUI [1,3]

C1300638

Beschreibung

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.

Datentyp

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0011008

Beschreibung

Order time of the prescription by the provider.

Datentyp

time

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0040223

Beschreibung

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

Datentyp

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0808070

Beschreibung

End date of order (if available).

Datentyp

date

Alias

UMLS CUI [1,1]

C0033080

UMLS CUI [1,2]

C1272683

UMLS CUI [1,3]

C0806020

Beschreibung

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.

Datentyp

float

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C1705178

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C0869039

Beschreibung

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.

Datentyp

float

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

UMLS CUI [1,3]

C1519795

Beschreibung

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.

Datentyp

float

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C0149761

Beschreibung

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.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1561604

UMLS CUI [1,2]

C3166216

UMLS CUI [1,3]

C0449238

Beschreibung

Specified frequency of medication. Do not impute or derive. Populate only if captured in the source system as a discrete value.

Datentyp

text

Alias

UMLS CUI [1]

C3476109

Beschreibung

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.

Datentyp

boolean

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0815189

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1]

C0013153

Beschreibung

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.)

Datentyp

text

Alias

UMLS CUI [1,1]

C0392360

UMLS CUI [1,2]

C0033080

UMLS CUI [1,3]

C1272683

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C2348662

UMLS CUI [1,2]

C3166216

Beschreibung

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).

Datentyp

text

Alias

UMLS CUI [1,1]

C0683836

UMLS CUI [1,2]

C3166216

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1]

C1880360

Beschreibung

Field for originating, full textual medication name from the source.

Datentyp

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C0027365

UMLS CUI [2,1]

C0013227

UMLS CUI [2,2]

C0027365

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C3476109

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1,1]

C2348662

UMLS CUI [1,2]

C3166216

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1,1]

C3166216

UMLS CUI [1,2]

C1265611

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C1708005

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C3166216

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C0869039

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C0013153

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1]

C0149761