Weight (kg)

Search:

Weight (kg)

Description

Cleaned AIMS Weight and converted to kilograms (if needed)

Limitation

Relies on accurate documentation and variable mapping.

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

Numeric

Enumeration

Value	Value Code	Definition

Return Columns

Column Name	Data Type

Granularity

Logic

Valid weight range is considered 0.5-250kg

If case only reported weight in kilograms, use AIMS_Weight_kg and only include values [0.5-250]. If outside that range returns NULL value
If case only reported weight in pounds, use AIM_Weight_lb and multiply by 2.205 to convert to MPOG_Weight_kg. Valid ranges will be considered [0.5-250]. If outside that range returns NULL value

[ ] = inclusive (meaning including 0.5 and 250 kg values)

Age is determined in weeks (boundaryies are interpolated linerally from CDC growth charts) up to one month. After one month, the age is converted to months and the average of the surrounding months are averaged and used. For patients 20+ years of age, the 20-year-old bounds are used.

We omit all entries that are outside the CDC bounds based on age. Then, we take the latest weight in the period of one hour before and one hour after anesthesia start. If there are no valid entries in this time, we look 12 hours prior and 12 hours after anesthesia start and we take the closest valid entry to anesthesia start. Finally, if there were no entries in either of these windows, we look 30 days prior to anesthesia start and take the closest valid entry. If still no entries, we return NULL.