ID

37076

Descrizione

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/

collegamento

http://www.pcornet.org/pcornet-common-data-model/

Keywords

  1. 10/12/16 10/12/16 -
  2. 02/07/19 02/07/19 -
  3. 30/03/20 30/03/20 -
Titolare del copyright

PCORnet

Caricato su

2 luglio 2019

DOI

Per favore, per richiedere un accesso.

Licenza

Creative Commons BY-NC 3.0

Commenti del modello :

Puoi commentare il modello dati qui. Tramite i fumetti nei gruppi di articoli e articoli è possibile aggiungere commenti a quelli in modo specifico.

Commenti del gruppo di articoli per :

Commenti dell'articolo per :

Per scaricare i modelli di dati devi essere registrato. Per favore accesso o registrati GRATIS.

PCORnet Common Data Model (CDM)

Procedures V4.1

  1. StudyEvent: ODM
    1. Procedures V4.1
Procedures
Descrizione

Procedures

Alias
UMLS CUI-1
C2700391
Procedures ID
Descrizione

Arbitrary identifier for each unique record.

Tipo di dati

integer

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

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

Tipo di dati

integer

Alias
UMLS CUI [1]
C2348585
Encounter ID
Descrizione

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

Tipo di dati

integer

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

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

Tipo di dati

text

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

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

Tipo di dati

date

Alias
UMLS CUI [1]
C1302393
Provider ID
Descrizione

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

Tipo di dati

text

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

Date the procedure was performed.

Tipo di dati

date

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

Procedure code.

Tipo di dati

integer

Alias
UMLS CUI [1]
C1550373
PX Type
Descrizione

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.

Tipo di dati

text

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

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

Tipo di dati

text

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

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.

Tipo di dati

text

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

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

Tipo di dati

text

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

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

Tipo di dati

text

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

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

Tipo di dati

text

Alias
UMLS CUI [1,1]
C0205225
UMLS CUI [1,2]
C0087111
UMLS CUI [1,3]
C1708067
UMLS CUI [1,4]
C0205313

Similar models

Procedures V4.1

  1. StudyEvent: ODM
    1. Procedures V4.1
Name
genere
Description | Question | Decode (Coded Value)
Tipo di dati
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])
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])
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])
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])
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])

Si prega di utilizzare questo modulo per feedback, domande e suggerimenti per miglioramenti.

I campi contrassegnati da * sono obbligatori.

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