Sentinel Common Data Model Procedure

Procedure
Description

Procedure

Alias
UMLS CUI-1
C2700391
Patient ID
Description

Unique member identifier. Arbitrary person-level identifier. Used to link across tables. Note: PatID is a pseudoidentifier with a consistent crosswalk to the true identifier retained by the source Data Partner. For analytical data sets requiring patient-level data, only the pseudoidentifier is used to link across all information belonging to a patient.

Data type

text

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Unique encounter identifier. Arbitrary encounter-level identifier. Used to link the Encounter, Diagnosis, and Procedure tables. Note: For efficiency medical utilization data is captured in 3 tables: Encounter: the encounter record that characterizes the outpatient visit or hospital stay Diagnosis: the diagnosis code(s) associated with the encounter record Procedure: the procedure code(s) associated with the encounter record These 3 tables and the Inpatient Pharmacy, Inpatient Transfusion, and Vital Signs table are linked by EncounterID. All diagnoses and procedures for an encounter should have the same EncounterID. It is allowable to have "orphan" diagnosis or procedure records with EncounterIDs that do not have a match in the Encounter table.

Data type

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1300638
Admission Date
Description

Encounter or admission date.

Data type

date

Alias
UMLS CUI [1]
C1302393
Provider ID
Description

Unique provider identifier. Provider code for the provider who is most responsible for this encounter. For encounters with multiple providers choose one so the encounter can be linked to the diagnosis and procedure tables. As with the PatID, the provider code is a pseudoidentifier with a consistent crosswalk to the real identifier.

Data type

text

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

Ambulatory Visit = Includes visits at outpatient clinics, same day surgeries, urgent care visits, and other same-day ambulatory hospital encounters, but excludes emergency department encounters. Emergency Department = Includes ED encounters that become inpatient stays (in which case inpatient stays would be a separate encounter). Excludes urgent care visits. ED claims should be pulled before hospitalization claims to ensure that ED with subsequent admission won't be rolled up in the hospital event. Ipatient Hospital Stay = Includes all inpatient stays, same-day hospital discharges, hospital transfers, and acute hospital care where the discharge is after the admission date. Non-Acute Institutional Stay = Includes hospice, skilled nursing facility (SNF), rehab center, nursing home, residential, overnight non-hospital dialysis and other non-hospital stays. Other Ambulatory Visit = Includes other non overnight AV encounters such as hospice visits, home health visits, skilled nursing facility visits, other non-hospital visits, as well as telemedicine, telephone and email consultations.

Data type

text

Alias
UMLS CUI [1,1]
C0545082
UMLS CUI [1,2]
C0332307
Procedure Code
Description

Convert local codes to standard codes.

Data type

text

Alias
UMLS CUI [1]
C1550373
Procedure code type.
Description

Procedure code type.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0332307
Original Procedure Code
Description

Original procedure code from source table, if different. Used if Data Partner has to map internal codes to standard codes.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0205313

Similar models

Sentinel Common Data Model Procedure

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Procedure
C2700391 (UMLS CUI-1)
PatID
Item
Patient ID
text
C2348585 (UMLS CUI [1])
EncounterID
Item
Encounter ID
text
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
ADate
Item
Admission Date
date
C1302393 (UMLS CUI [1])
Provider
Item
Provider ID
text
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Item
Encounter Type
text
C0545082 (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
Inpatient Hospital Stay (IP)
CL Item
Non-Acute Institutional Stay (IS)
CL Item
Other Ambulatory Visit (OA)
PX
Item
Procedure Code
text
C1550373 (UMLS CUI [1])
Item
Procedure code type.
text
C1550373 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Code List
Procedure code type.
CL Item
ICD-9-CM (09)
CL Item
ICD-10-CM (10)
CL Item
ICD-11-CM (11)
CL Item
CPT Category II (C2)
CL Item
CPT Category III (C3)
CL Item
CPT-4 (i.e., HCPCS Level I) (C4)
CL Item
HCPCS Level III (H3)
CL Item
HCPCS (i.e., HCPCS Level II) (HC)
CL Item
LOINC (LC)
CL Item
Local homegrown (LO)
CL Item
NDC (ND)
CL Item
Other (OT)
CL Item
Revenue (RE)
Orig_PX
Item
Original Procedure Code
text
C1550373 (UMLS CUI [1,1])
C0205313 (UMLS CUI [1,2])