Sentinel Common Data Model Diagnosis

Beschrijving

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.

Datatype

text

Alias

UMLS CUI [1]

C2348585

Beschrijving

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

Datatype

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Beschrijving

Encounter or admission date.

Datatype

date

Alias

UMLS CUI [1]

C1302393

Beschrijving

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.

Datatype

text

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Beschrijving

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

Datatype

text

Alias

UMLS CUI [1,1]

C0545082

UMLS CUI [1,2]

C0332307

Beschrijving

For ICD codes this variable can include decimal points or not. Remove site specific suffixes and prefixes. Other codes should be listed as recorded in the source data. Note: For ICD codes, some Data Partners will have a decimal point in the DX variable and others will not. We recommend that users of the data strip the decimal point during data analyses.

Datatype

text

Alias

UMLS CUI [1]

C1550350

Beschrijving

Diagnosis code type. This field combined with the DX field should be used to capture any type of diagnosis or clinical concept available in the source data. We provide values for ICD and SNOMED code types. Other code types will be added as new terminologies are used. Note: For those who collect SNOMED CT codes as part of routine care, those codes can be stored in this table, using the "SM" DX_CodeType.

Datatype

text

Alias

UMLS CUI [1,1]

C1550350

UMLS CUI [1,2]

C0449913

Beschrijving

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

Datatype

text

Alias

UMLS CUI [1]

C3874295

Beschrijving

Principal discharge diagnosis flag. Relevant only on IP and IS encounters. For ED, AV, and OA encounter types, mark as missing. One principal diagnosis is expected, although in some instances more than one diagnosis may be flagged as principal.

Datatype

text

Alias

UMLS CUI [1,1]

C1555319

UMLS CUI [1,2]

C1542147

Beschrijving

Indicates whether the diagnosis code is indicative of a condition present at admission. Note: Only one Sentinel Data Partner is expected to populate the PAdmit field.

Datatype

text

Alias

UMLS CUI [1]

C1628992