ID

19208

Description

PCORnet Common Data Model (CDM) Dispensing 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

  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.

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

PCORnet Common Data Model (CDM) Dispensing

Dispensing
Description

Dispensing

Alias
UMLS CUI-1
C0947323
UMLS CUI-2
C0334946
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

integer

Alias
UMLS CUI [1,1]
C0334946
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
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

integer

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

integer

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 v3.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 v3.1.

Data type

integer

Alias
UMLS CUI [1]
C0805077
RAW NDC
Description

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

Data type

integer

Alias
UMLS CUI [1]
C1708005

Similar models

PCORnet Common Data Model (CDM) Dispensing

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Dispensing
C0947323 (UMLS CUI-1)
C0334946 (UMLS CUI-2)
Dispensing ID
Item
Dispensing ID
integer
C0334946 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
integer
C2348585 (UMLS CUI [1])
Prescribing ID
Item
Prescribing ID
integer
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
integer
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])
RAW NDC
Item
RAW NDC
integer
C1708005 (UMLS CUI [1])

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

Fields marked with * are required.

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