Beskrivning

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.

Datatyp

text

Alias

UMLS CUI [1]

C2348585

Beskrivning

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.

Datatyp

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Beskrivning

Encounter or admission date.

Datatyp

date

Alias

UMLS CUI [1]

C1302393

Beskrivning

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.

Datatyp

text

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Beskrivning

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.

Datatyp

integer

Alias

UMLS CUI [1]

C0545082

Beskrivning

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.

Datatyp

text

Alias

UMLS CUI [1]

C1550350

Beskrivning

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

Datatyp

integer

Alias

UMLS CUI [1,1]

C1550350

UMLS CUI [1,2]

C0449913

Beskrivning

Used if Data Partner has to map internal codes to standard codes.

Datatyp

text

Alias

UMLS CUI [1]

C3874295

Beskrivning

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

Datatyp

boolean

Alias

UMLS CUI [1]

C1628992

Beskrivning

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.

Datatyp

integer

Alias

UMLS CUI [1,1]

C1555319

UMLS CUI [1,2]

C1542147