ID

37076

Description

PCORnet Common Data Model (CDM) Procedures Procedure codes indicate the discrete medical interventions and diagnostic testing, such as surgical procedures and lab orders, delivered within a healthcare context. 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/10/16 12/10/16 -
  2. 7/2/19 7/2/19 -
  3. 3/30/20 3/30/20 -
Copyright Holder

PCORnet

Uploaded on

July 2, 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

Procedures V4.1

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

Procedures

Alias
UMLS CUI-1
C2700391
Procedures ID
Description

Arbitrary identifier for each unique record.

Data type

integer

Alias
UMLS CUI [1,1]
C2700391
UMLS CUI [1,2]
C1300638
Patient ID
Description

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

Data type

integer

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Arbitrary encounter-level identifier. Used to link across tables. All ENCOUNTERIDs in this table must be present in the ENCOUNTER table.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1300638
Encounter Type
Description

Please note: This is a field replicated from the ENCOUNTER table. See the ENCOUNTER table for definitions. Should be non-null for all records replicated from ENCOUNTER table (guidance added in v4.0).

Data type

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0332307
Admit Date
Description

Please note: This is a field replicated from the ENCOUNTER table. See ENCOUNTER table for definitions.

Data type

date

Alias
UMLS CUI [1]
C1302393
Provider ID
Description

Identifier of the PROVIDER most associated with the procedure order. All PROVIDERIDs must be present in the PROVIDER table.

Data type

text

Alias
UMLS CUI [1,1]
C0807500
UMLS CUI [1,2]
C1300638
PX Date
Description

Date the procedure was performed.

Data type

date

Alias
UMLS CUI [1,1]
C2700391
UMLS CUI [1,2]
C0011008
PX
Description

Procedure code.

Data type

integer

Alias
UMLS CUI [1]
C1550373
PX Type
Description

Procedure code type. We include a number of code types for flexibility, but the basic requirement that the code refer to a medical procedure remains. Revenue codes are a standard concept in Medicare billing and can be useful for defining care settings. If those codes are available they can be included. Medications administered by clinicians can be captured in billing data and Electronic Health Records (EHRs) as HCPCS procedure codes. Administration (infusion) of chemotherapy is an example. We are now seeing NDCs captured as part of procedures because payers are demanding it for payment authorization. Inclusion of this code type enables those data partners that capture the NDC along with the procedure to include the data. Please note: The “Other” category is meant to identify internal use ontologies and codes. Value set modified in v3.1 to combine CPT and HCPCS codes into one category; also, ICD-9 value set item typo corrected to ICD-9-PCS.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0332307
PX Source
Description

Source of the procedure information. Order and billing pertain to internal healthcare processes and data sources. Claim pertains to data from the bill fulfillment, generally data sources held by insurers and other health plans. If evaluation and management (E/M) or level of service (LOS) codes are available, they should be included. This field is a derived attribute, and is not expected to be an explicit data field within a source system. Use “OD” for procedures entered into the EHR that are associated with an Order. Use “OD” for any procedures associated with an encounter that is entered into the EHR by a provider. Use “BI” for all procedures that are generated through the physician and hospital billing process. Use “DR” for all procedure records that are derived or imputed through analytical procedures (e.g., natural language processing). This does not apply to procedures mapped from a superset terminology (General Guidance #4).

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0449416
Principal Procedure flag
Description

Value may be present for IP, IS, EI, and OS encounters. One principal procedure per encounter is expected, although in some instances more than one procedure may be flagged as principal.

Data type

text

Alias
UMLS CUI [1,1]
C0205225
UMLS CUI [1,2]
C0087111
UMLS CUI [1,3]
C1708067
RAW PX
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0205313
RAW PX Type
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0205313
RAW PPX
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C0205225
UMLS CUI [1,2]
C0087111
UMLS CUI [1,3]
C1708067
UMLS CUI [1,4]
C0205313
Back to the top of the page

Similar models

Procedures V4.1

1 forms
  1. StudyEvent: ODM
    1. Procedures V4.1
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Procedures
C2700391 (UMLS CUI-1)
Procedures ID
Item
Procedures ID
integer
C2700391 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
integer
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
integer
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Item
Encounter Type
text
C1512346 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Encounter Type
Code List
Encounter Type
CL Item
Ambulatory Visit (AV)
CL Item
Emergency Department  (ED)
CL Item
Emergency Department Admit to Inpatient Hospital Stay (permissible substitution)  (EI)
CL Item
Inpatient Hospital Stay  (IP)
CL Item
Non-Acute Institutional Stay  (IS)
CL Item
Observation Stay (OS)
CL Item
Institutional Professional Consult (permissible substitution) (IC)
CL Item
Other Ambulatory Visit  (OA)
CL Item
No information  (NI)
CL Item
Unknown  (UN)
CL Item
Other (OT)
Admit Date
Item
Admit Date
date
C1302393 (UMLS CUI [1])
Provider ID
Item
Provider ID
text
C0807500 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
PX Date
Item
PX Date
date
C2700391 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
PX
Item
PX
integer
C1550373 (UMLS CUI [1])
Item
PX Type
text
C1550373 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
PX Type
Code List
PX Type
CL Item
ICD-9-CM (09)
(Comment:en)
CL Item
ICD-10-PCS (10)
(Comment:en)
CL Item
ICD-11-PCS (11)
(Comment:en)
CL Item
CPT or HCPCS (CH)
(Comment:en)
CL Item
LOINC; ND=NDC (LC)
(Comment:en)
CL Item
Revenue (RE)
(Comment:en)
CL Item
No information (NI)
(Comment:en)
CL Item
Unknown (UN)
(Comment:en)
CL Item
Other (OT)
(Comment:en)
Item
PX Source
text
C1550373 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
PX Source
Code List
PX Source
CL Item
Order/EHR (OD)
(Comment:en)
CL Item
Billing (BI)
(Comment:en)
CL Item
Claim (CL)
(Comment:en)
CL Item
No information (NI)
(Comment:en)
CL Item
Unknown (UN)
(Comment:en)
CL Item
Other (OT)
(Comment:en)
CL Item
Derived (DR)
(Comment:en)
Item
Principal Procedure flag
text
C0205225 (UMLS CUI [1,1])
C0087111 (UMLS CUI [1,2])
C1708067 (UMLS CUI [1,3])
PPX
Code List
Principal Procedure flag
CL Item
Principal (P)
CL Item
Secondary  (S)
CL Item
No information  (NI)
CL Item
Unknown  (UN)
CL Item
Other (OT)
RAW PX
Item
RAW PX
text
C1550373 (UMLS CUI [1,1])
C0205313 (UMLS CUI [1,2])
RAW PX Type
Item
RAW PX Type
text
C1550373 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0205313 (UMLS CUI [1,3])
RAW PPX
Item
RAW PPX
text
C0205225 (UMLS CUI [1,1])
C0087111 (UMLS CUI [1,2])
C1708067 (UMLS CUI [1,3])
C0205313 (UMLS CUI [1,4])
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