Description

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.

Data type

text

Alias

UMLS CUI [1]

C2348585

Description

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.

Data type

text

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1300638

Description

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

Data type

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0600091

Description

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

Data type

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

Description

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.

Data type

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0805701

UMLS CUI [1,3]

C0332307

Description

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

Data type

text

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0205313

UMLS CUI [1,3]

C1514468

Description

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+

Data type

text

Alias

UMLS CUI [1]

C0005810

Description

Administration start date.

Data type

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0808070

Description

Administration start time

Data type

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1301880

Description

Administration end date

Data type

date

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C0806020

Description

Administration end time

Data type

time

Alias

UMLS CUI [1,1]

C0005841

UMLS CUI [1,2]

C1522314

Description

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.

Data type

text

Alias

UMLS CUI [1,1]

C0545082

UMLS CUI [1,2]

C0332307