Sentinel CDM quick reference

Quick reference for Sentinel Common Data Model tables and fields used in EncodeBox.

Core identifiers

Identifier	Description	Used in
`PatID`	Unique patient identifier	All patient-related tables
`EncounterID`	Unique encounter identifier	Encounter, Diagnosis, Procedure, Lab, Vitals
`ProviderID`	Unique provider identifier	Diagnosis, Procedure, Dispensing
`FacilityID`	Unique facility identifier	Encounter

Enrollment

Field	Type	Description
`PatID`	Num	Patient identifier
`Enr_Start`	Date	Enrollment start date
`Enr_End`	Date	Enrollment end date
`MedCov`	Char(1)	Medical coverage (Y/N/U/A)
`DrugCov`	Char(1)	Drug coverage (Y/N/U)
`Chart`	Char(1)	Chart availability (Y/N)
`PlanType`	Char(1)	Plan type (F/H/E/P/S/M/O/U)
`PayerType`	Char(2)	Payer type (CO/MC/MD/OG/OT/UN)

Demographic

Field	Type	Description
`PatID`	Num	Patient identifier
`Birth_Date`	Date	Date of birth
`Sex`	Char(1)	Sex (A/F/M/U)
`Hispanic`	Char(1)	Hispanic ethnicity (Y/N/U)
`Race`	Char(1)	Race (0/1/2/3/4/5/M)
`PostalCode`	Char	Postal/ZIP code

Race codes: 0 unknown, 1 American Indian/Alaska Native, 2 Asian, 3 Black/African American, 4 Native Hawaiian/Pacific Islander, 5 White, M multi-racial.

Encounter

Field	Type	Description
`PatID`	Num	Patient identifier
`EncounterID`	Num	Encounter identifier
`ADate`	Date	Admission/encounter date
`DDate`	Date	Discharge date
`EncType`	Char(2)	Encounter type
`FacilityID`	Num	Facility identifier
`Discharge_Disposition`	Char(1)	A/E/S/U
`DRG`	Char(3)	Diagnosis Related Group

Encounter types: AV, ED, IP, IS, OA.

Diagnosis

Field	Type	Description
`PatID`	Num	Patient identifier
`EncounterID`	Num	Encounter identifier
`ADate`	Date	Service date
`DX`	Char	Diagnosis code
`DX_CodeType`	Char(2)	Code type
`PDX`	Char(1)	Principal diagnosis flag (P/S/X)

Code types: 09 ICD-9-CM, 10 ICD-10-CM, 11 ICD-11-CM, SM SNOMED CT.

Procedure

Field	Type	Description
`PatID`	Num	Patient identifier
`EncounterID`	Num	Encounter identifier
`ADate`	Date	Service date
`PX`	Char	Procedure code
`PX_CodeType`	Char(2)	Code type

Code types: 09 ICD-9-PCS, 10 ICD-10-PCS, C4 CPT-4, HC HCPCS, LC LOINC, RE Revenue.

Dispensing

Field	Type	Description
`PatID`	Num	Patient identifier
`RxDate`	Date	Dispensing date
`Rx`	Char	Drug code
`Rx_CodeType`	Char(2)	Code type
`RxSup`	Num	Days supply
`RxAmt`	Num	Amount dispensed

Code types: ND NDC, RN RxNorm, SN SNOMED CT.

Lab, vitals, death

Table	Key fields
Laboratory result	`Lab_Date`, `Lab_LOINC`, `Result_Num`, `Result_Unit`
Vital signs	`Measure_Date`, `HT`, `WT`, `Systolic`, `Diastolic`, `BMI`
Death	`Death_Date`, `Death_Source`, `Confidence`

EncodeBox query patterns

# Type 2 diabetes (ICD-10 E11*)
db.diagnosis.matching("E11", code_type="10", match="starts_with")

# Inpatient-related diagnosis position filter
db.diagnosis.matching("E11", code_type="10").in_position("primary")

# NDC dispensing
db.medication.matching("00006007431", code_type="ND", match="exactly")

Always specify code_type when matching codes, and verify enrollment covers your study window with db.enrollment.covering_index(...).

Getting started

Data model

Guides

API reference

Sentinel CDM quick reference

Core identifiers

Enrollment

Demographic

Encounter

Diagnosis

Procedure

Dispensing

Lab, vitals, death

EncodeBox query patterns

​Core identifiers

​Enrollment

​Demographic

​Encounter

​Diagnosis

​Procedure

​Dispensing

​Lab, vitals, death

​EncodeBox query patterns

Core identifiers

Enrollment

Demographic

Encounter

Diagnosis

Procedure

Dispensing

Lab, vitals, death

EncodeBox query patterns