PCORnet CDM Browser
This tool is an interactive browser for the PCORnet Common Data Model.
The logical model behind each table in the PCORnet CDM is displayed as a TypeScript-like type definition. You can view the description of each column by clicking on the purple links. The inverse relationships are added automatically and displayed in light purple.
PCORnet CDM version
Tables
Demographic
Demographics record the direct attributes of individual patients.
type = {}
: string,
?: date,
?: time,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: ,
: []
Enrollment
Enrollment is a concept that defines a period of time during which a person is expected to have complete data capture. This concept is often insurance-based, but other methods of defining enrollment are possible.
type = {}
: ,
: date,
?: date,
?: string,
: string
Encounter
Encounters are interactions between patients and providers within the context of healthcare delivery.
type = {}
: string,
: ,
: date,
?: time,
?: date,
?: time,
?: ,
?: string,
: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
: [],
: [],
: [],
: [],
: [],
: [],
: [],
: []
Diagnosis
Diagnosis codes indicate the results of diagnostic processes and medical coding within healthcare delivery. Data in this table are expected to be from healthcare-mediated processes and reimbursement drivers.
type = {}
: string,
: ,
?: ,
?: string,
?: date,
?: ,
: string,
: string,
?: date,
: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
Procedures
Procedure codes indicate the discreet medical interventions and diagnostic testing, such as surgical procedures and lab orders, delivered within a healthcare context.
type = {}
: string,
: ,
?: ,
?: string,
?: date,
?: ,
?: date,
: string,
: string,
?: string,
?: string,
?: string,
?: string,
?: string,
: []
Vital
Vital signs (such as height, weight, and blood pressure) directly measure an individual’s current state of attributes.
type = {}
: string,
: ,
?: ,
: date,
?: time,
: string,
?: number,
?: number,
?: number,
?: number,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
Dispensing
Prescriptions filled through a community, mail-order or hospital pharmacy. Outpatient dispensing may not be directly captured within healthcare systems.
type = {}
: string,
: ,
?: ,
: date,
: string,
?: string,
?: number,
?: number,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
LabResultCm
This table is used to store quantitative and qualitative measurements from blood and other body specimens.
type = {}
: string,
: ,
?: ,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: date,
?: date,
?: time,
: date,
?: time,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
Condition
A condition represents a patient’s diagnosed and self-reported health conditions and diseases. The patient’s medical history and current state may both be represented.
type = {}
: string,
: ,
?: ,
?: date,
?: date,
?: date,
?: string,
: string,
: string,
: string,
?: string,
?: string,
?: string,
?: string
ProCm
This table is used to store responses to patient-reported outcome measures (PROs) or questionnaires. This table can be used to store item-level responses as well as the overall score for each measure.
type = {}
: string,
: ,
?: ,
: date,
?: time,
?: string,
?: string,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: number,
?: number,
?: number,
?: number,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string
Prescribing
Provider orders for medication dispensing and/or administration. These orders may take place in any setting, including the inpatient or outpatient basis.
type = {}
: string,
: ,
?: ,
?: string,
?: date,
?: time,
?: date,
?: date,
?: number,
?: string,
?: number,
?: string,
?: number,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
: []
PcornetTrial
Patients who are enrolled in PCORnet clinical trials and PCORnet studies.
type = {}
: string,
: string,
: string,
?: string,
?: date,
?: date,
?: date,
?: string
Death
Reported mortality information for patients.
type = {}
: ,
?: date,
?: string,
: string,
?: string
DeathCause
The individual causes associated with a reported death.
type = {}
: ,
: string,
: string,
: string,
: string,
?: string
MedAdmin
Records of medications administered to patients by healthcare providers. These administrations may take place in any setting, including inpatient, outpatient or home health encounters.
type = {}
: string,
: string,
?: string,
?: string,
?: string,
: date,
?: time,
?: date,
?: time,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
Provider
Data about the providers who are involved in the care processes documented in the CDM.
type = {}
: ,
?: string,
?: string,
?: number,
?: string,
?: string,
: [],
: [],
: [],
: []
ObsClin
Standardized qualitative and quantitative clinical observations about a patient, including vital signs.
type = {}
: string,
: string,
?: string,
?: string,
?: date,
?: time,
?: date,
?: time,
?: string,
?: string,
?: string,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
ObsGen
Table to store everything else.
type = {}
: string,
: string,
?: string,
?: string,
?: date,
?: time,
?: date,
?: time,
?: string,
?: string,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
HashToken
Encrypted hash tokens that are used to match patient records across DataMarts using privacy-preserving record linkage methods.
type = {}
: ,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
LdsAddressHistory
Longitudinal record of a patient’s address that adheres to the requirements of a Limited Data Set.
type = {}
: string,
: string,
: string,
: string,
: string,
?: string,
?: string,
?: string,
?: string,
?: date,
?: date
Immunization
Records of immunizations that have been delivered within the health system as well as reports of those administered elsewhere.
type = {}
: string,
: ,
?: ,
?: ,
?: ,
?: date,
?: date,
: string,
: string,
: string,
?: string,
?: string,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: date,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string
Harvest
Attributes associated with the specific PCORnet datamart implementation, including data refreshes.
type = {}
: string,
?: string,
: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: string,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date,
?: date
LabHistory
Table for storing historical information about units of measure and reference ranges for laboratory test results.
type = {}
: string,
?: string,
?: string,
?: string,
?: string,
?: number,
?: number,
?: string,
?: string,
?: string,
?: string,
?: string,
?: date,
?: date,
?: string,
?: string,
?: string