Total Crystalloid Administered

Search:

Description

This phenotype sums of all Crystalloids used during the intraoperative timeframe of a specific case in mls.

Limitation

All Crystalloids documented between anesthesia start and end are totalled into a single output.

Does not include volumes that have medication administered (ie vasopressor infusions in 250ml D5 etc).
Only includes infusions/fluids between anesthesia start and stop.
Component fluids limited to 40L per case.
Only includes volumes that are postive.
Excludes negative values or values charted as 0 mL.
If the unit conversion is not listed, then it is not used for that fluid

Data quality is limited to individual site documentation accuracy, completeness, and variable mapping, which is performed by each site, independently. MPOG, as the coordinating center, reviews data quality at each data upload and monthly via Data Diagnostics and Case Validation tools. This review, while thorough, may not contain all data elements relevant to this phenotype and thus should be carefully reviewed by the user.

Value Type

Enumeration

Value	Value Code	Definition

Return Columns

Name	Data Type

Granularity

Logic

Input MPOG Concepts:

MPOG Concept ID	MPOG Concept Name	Classification
10259	ELECTROLYTE-A SOLUTION	Balanced Crystalloid
10456	LACTATED RINGERS	Balanced Crystalloid
10457	NORMOSOL	Balanced Crystalloid
10461	DEXTROSE / LACTATED RINGERS 5%	Balanced Crystalloid
10539	DEXTROSE 10% W/LR	Balanced Crystalloid
10548	PLASMALYTE 148 W/DEXTROSE 5%	Balanced Crystalloid
10610	PLASMALYTE A (PH BALANCED)	Balanced Crystalloid
10406	SALINE 3%	Non-Qualifying – Hypertonic
10551	SALINE W/NAHCO3 0.45% + 150 MEQ/L	Non-Qualifying – Hypertonic
10607	SALINE 2%	Non-Qualifying – Hypertonic
10455	SALINE 0.45%	Non-Qualifying – Hypotonic
10460	DEXTROSE / WATER 5%	Non-Qualifying – Hypotonic
10462	DEXTROSE / WATER 10%	Non-Qualifying – Hypotonic
10463	SALINE W/KCL 0.45% + 20 MEQ/L	Non-Qualifying – Hypotonic
10465	DEXTROSE / SALINE 5% / 0.225%	Non-Qualifying – Hypotonic
10466	DEXTROSE / SALINE 5% / 0.45%	Non-Qualifying – Hypotonic
10468	DEXTROSE / SALINE W/KCL 5% / 0.45% + 20 MEQ/L	Non-Qualifying – Hypotonic
10470	DEXTROSE / SALINE 10% / 0.45%	Non-Qualifying – Hypotonic
10549	PLASMALYTE 56	Non-Qualifying – Hypotonic
10559	DEXTROSE / SALINE W/KCL 5% / 0.45% + 40 MEQ/L	Non-Qualifying – Hypotonic
10588	DEXTROSE / SALINE W/KCL 10% / 0.225% + 20 MEQ/L	Non-Qualifying – Hypotonic
10594	DEXTROSE / SALINE W/KCL 5% / 0.45% + 10 MEQ/L	Non-Qualifying – Hypotonic
10602	DEXTROSE / SALINE 10% / 0.225%	Non-Qualifying – Hypotonic
10464	SALINE W/KCL 0.9% + 20 MEQ/L	Non-Qualifying – Other/unspecified
10469	DEXTROSE / SALINE W/KCL 5% / 0.9% + 20 MEQ/L	Non-Qualifying – Other/unspecified
10606	SALINE W/KCL 0.9% + 40 MEQ/L	Non-Qualifying – Other/unspecified
10454	SALINE 0.9%	Normal Saline
10467	DEXTROSE / SALINE 5% / 0.9%	Normal Saline

Step 1. Determine if the case has any of the Crystalloid concepts listed above with an administration start time between anestheisa start and anesthesia end.

Step 2. Ensure all administration amounts are converted to mls using the conversions below.

For All Fluids in Time Based Units:
- Fluid start time is the later of Fluid Start Time or Anesthesia Start
- Fluid stop time is the earlier of Fluid Stop Time or Anesthesia Stop
Unit Conversions: (If the unit conversion is not listed, then it is not used for that fluid)
- SODIUM CHLORIDE 0.9%
  - SODIUM CHLORIDE 0.9% in mL = mL
  - SODIUM CHLORIDE 0.9% in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- SALINE 3%
  - SALINE 3% in mL = mL
  - SALINE 3% in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- SALINE 0.9%
  - SALINE 0.9% in mL = mL
  - SALINE 0.9% in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - SALINE 0.9% in mL/min converted to mL based on charted Start/Stop Time (subject to logic above)
- SALINE 0.45%
  - SALINE 0.45% in mL = mL
  - SALINE 0.45% in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - SALINE 0.45% in mL/min converted to mL based on charted Start/Stop Time (subject to logic above)
- LACTATED RINGERS
  - LACTATED RINGERS mL = mL
  - LACTATED RINGERS mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- NORMOSOL
  - NORMOSOL mL = mL
  - NORMOSOL mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / WATER 5%
  - DEXTROSE / WATER 5% mL = mL
  - DEXTROSE / WATER 5% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - DEXTROSE / WATER 5% g. Converted to mL: g Amount / 0.05
  - DEXTROSE / WATER 5% mg. Converted to mL: ( mg Amount / 0.05 ) / 1000
- DEXTROSE / LACTATED RINGERS 5%
  - DEXTROSE / LACTATED RINGERS 5% mL = mL
  - DEXTROSE / LACTATED RINGERS 5% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / WATER 10%
  - DEXTROSE / WATER 10% mL = mL
  - DEXTROSE / WATER 10% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - DEXTROSE / WATER 10% in g. mL = g Amount * 10
- SALINE W/KCL 0.45% + 20 MEQ/L
  - SALINE W/KCL 0.45% + 20 MEQ/L mL = mL
  - SALINE W/KCL 0.45% + 20 MEQ/L mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- SALINE W/KCL 0.9% + 20 MEQ/L
  - SALINE W/KCL 0.9% + 20 MEQ/L mL = mL
  - SALINE W/KCL 0.9% + 20 MEQ/L mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE 5% / 0.225%
  - DEXTROSE / SALINE 5% / 0.225% mL = mL
  - DEXTROSE / SALINE 5% / 0.225% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - For DEXTROSE / SALINE 5% / 0.225% all other charting units considered non-valid
- DEXTROSE / SALINE 5% / 0.45%
  - DEXTROSE / SALINE 5% / 0.45% mL = mL
  - DEXTROSE / SALINE 5% / 0.45% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - For DEXTROSE / SALINE 5% / 0.45% all other charting units considered non-valid.
- DEXTROSE / SALINE 5% / 0.9%
  - DEXTROSE / SALINE 5% / 0.9% mL = mL
  - DEXTROSE / SALINE 5% / 0.9% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE W/KCL 5% / 0.45% + 20 MEQ/L
  - DEXTROSE / SALINE W/KCL 5% / 0.45% + 20 MEQ/L mL = mL
  - DEXTROSE / SALINE W/KCL 5% / 0.45% + 20 MEQ/L mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE W/KCL 5% / 0.9% + 20 MEQ/L
  - DEXTROSE / SALINE W/KCL 5% / 0.9% + 20 MEQ/L mL = mL
  - DEXTROSE / SALINE W/KCL 5% / 0.9% + 20 MEQ/L converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE 10% / 0.45%
  - DEXTROSE / SALINE 10% / 0.45% mL = mL
  - DEXTROSE / SALINE 10% / 0.45% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE 10% W/LR
  - DEXTROSE 10% W/LR mL = mL
- PLASMALYTE 148 W/DEXTROSE 5%
  - Used only a single institution and not currently listed in AIMS_IntraopInputOutput
- PLASMALYTE 56
  - PLASMALYTE 56 mL = mL
  - PLASMALYTE 56 mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- SALINE W/NAHCO3 0.45% + 150 MEQ/L
  - SALINE W/NAHCO3 0.45% + 150 MEQ/L in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - SALINE W/NAHCO3 0.45% + 150 MEQ/L in mL = mL.
- DEXTROSE / SALINE W/KCL 5% / 0.225% + 20 MEQ/L
  - DEXTROSE / SALINE W/KCL 5% / 0.225% + 20 MEQ/L in mL = mL
  - DEXTROSE / SALINE W/KCL 5% / 0.225% + 20 MEQ/L in mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
  - DEXTROSE / SALINE W/KCL 5% / 0.45% + 40 MEQ/L - not used widely in MPOG database - Excluded
- DEXTROSE / SALINE W/KCL 10% / 0.225% + 20 MEQ/L
  - DEXTROSE / SALINE W/KCL 10% / 0.225% + 20 MEQ/L mL = mL
  - DEXTROSE / SALINE W/KCL 10% / 0.225% + 20 MEQ/L mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE W/KCL 5% / 0.45% + 10 MEQ/L
  - DEXTROSE / SALINE W/KCL 5% / 0.45% + 10 MEQ/L mL = mL
  - DEXTROSE / SALINE W/KCL 5% / 0.45% + 10 MEQ/L mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- DEXTROSE / SALINE 10% / 0.225%
  - DEXTROSE / SALINE 10% / 0.225% mL = mL
  - DEXTROSE / SALINE 10% / 0.225% mL/Hr converted to mL based on infusion start/stop time
  - DEXTROSE / SALINE 10% / 0.225% all other values considered non-valid
- SALINE W/KCL 0.9% + 40 MEQ/L
  - SALINE W/KCL 0.9% + 40 MEQ/L mL = mL
- SALINE 2%
  - SALINE 2% mL = mL
  - SALINE 2% mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- PLASMALYTE A (PH BALANCED)
  - PLASMALYTE A (PH BALANCED) mL = mL
  - PLASMALYTE A (PH BALANCED) mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)
- ELECTROLYTE-A SOLUTION
  - PLASMALYTE A (PH BALANCED) mL = mL
  - PLASMALYTE A (PH BALANCED) mL/hr converted to mL based on charted Start/Stop Time (subject to logic above)

Step 3: Generate case totals.

Add all of the Crystalloid administrations together and output as mls in a "Total Recieved" column.
Add all of the Balanced Crystalloids together and output as mls in a "Balanced Crystalloids (chloride restrictive)" column.
Add all of the Non-Qualifying – Hypertonic together and output as mls in a "Non-Qualifying – Hypertonic" column.
Add all of the Non-Qualifying – Hypotonic together and output as mls in a "Non-Qualifying – Hypotonic" column.
Add all of the Non-Qualifying – Other/unspecified together and output as mls in a "Non-Qualifying – Other/unspecified" column.
Add all of the Normal Saline together and output as mls in a "Normal Saline (chloride liberal)" column.

Note: Each case will return a total ml amount with a max of 40L.