Sentinel Common Data Model

Beschreibung

Arbitrary person-level identifier. Used to link across tables. A new enrollment period generates a new record, but the same person should have the same PatID on subsequent records. 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.

Datentyp

text

Alias

UMLS CUI [1]

C2348585

Beschreibung

A unique combination of PatID, ADate, Provider and EncType. Used to link the Encounter, Diagnosis, and Procedure tables. Note: Medical utilization data is captured in 3 tables: Encounter: the encounter record that characterizes the outpatient visit or hospital stay Diagnosis: the diagnosis or other clinical 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.

Datentyp

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Beschreibung

Unique transfusion administration identifier. Retain b/c useful to map back to source data

Datentyp

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0600091

Beschreibung

Code value for an infusion product. Must be paired with the correct TransCode_Type

Datentyp

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

Beschreibung

Transfusion product code type. This variable combined with the TransCode variable should be used to capture any type of Inpatient Infusion product in the source data. Other code types will be added as new terminologies are used.

Datentyp

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

UMLS CUI [1,3]

C0332307

Beschreibung

Original product name/mneumonic. Name of product within Data Partner

Datentyp

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0205313

UMLS CUI [1,3]

C1514468

Beschreibung

Blood type and Rh factors, left-justified. Convert any text Rh factor to symbols (e.g., “pos” to “+”, “negative” to “-“). Rh factor can be blank. A, B, O, AB (upper case) with RH factor (+, -, or null only). Example: AB+

Datentyp

text

Alias

UMLS CUI [1]

C0005810

Beschreibung

Administration start date.

Datentyp

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0808070

Beschreibung

Administration start time

Datentyp

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1301880

Beschreibung

Administration end date

Datentyp

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0806020

Beschreibung

Administration end time

Datentyp

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1522314

Beschreibung

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.

Datentyp

text

Alias

UMLS CUI [1,1]

C0545082

UMLS CUI [1,2]

C0332307