Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1]

C2348585

Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Descrição

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

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0600091

Descrição

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

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

UMLS CUI [1,3]

C0332307

Descrição

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

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0205313

UMLS CUI [1,3]

C1514468

Descrição

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+

Tipo de dados

text

Alias

UMLS CUI [1]

C0005810

Descrição

Administration start date.

Tipo de dados

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0808070

Descrição

Administration start time

Tipo de dados

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1301880

Descrição

Administration end date

Tipo de dados

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0806020

Descrição

Administration end time

Tipo de dados

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1522314

Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0545082

UMLS CUI [1,2]

C0332307