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.
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
}
See also
FHIR type tree - Visualizing the hierarchy of FHIR data types and resources.