Preop Creatinine (Most Recent within 60 days)

Search:

Description

Most recent preoperative creatinine within 60 days

References:

1.Frank H. Wians, Jr., PhD; Merck Manuel, professional version; Blood Tests: Normal Values; accessed 10-17-2016; http://www.merckmanuals.com/professional/appendixes/normal-laboratory-values/blood-tests-normal-values#v8508814

2. FDA, investigations operations manual 2015, appendix C, Blood Serum Chesitry – Normal Values ; published 2015, accessed 10-17-2016; http://www.fda.gov/downloads/ICECI/Inspections/IOM/UCM135835.pdf

3. Farmacotherapeutisch kompass, 2016, the Netherlands; published 10-01-2016; accessed 10-17-2016; https://www.farmacotherapeutischkompas.nl/bladeren-volgens-boek/inleidingen/inl-referentiewaarden-klinische-chemie

4. Persaud, Christine & Sandesara, Uttsav & Hoang, Victor & Tate, Joshua & Latack, Wayne & Dado, David. (2021). Highest Recorded Serum Creatinine. Case Reports in Nephrology. 2021. 1-3. 10.1155/2021/6048919.

Limitation

This collation does not set “normal” ranges for the values. Valid ranges account only for data collection extremes. There is a conversion for this collation for sites that use alternate units. There is no returned “invalid” value as this collation only uses values in the valid range.

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

Values collected under MPOG ID 5002 (Formal lab – Creatinine, Serum/Plasma) & 3496 (Formal lab - Creatinine, Serum/Plasma mcmol/L)

Convert values under the MPOG Concept ID: 3496 from mcmol/L to mg/dl.

(mcmol/L / 88.4 = mg/dl)

Obtain most recent (latest) valid creatinine (MPOG concept ID 5002) prior to anesthesia start and within 60 days of anesthesia start with number of days prior to surgery

Valid >=0.2 mg/dl and <74 mg/dl
If data invalid ? collation only returns values in the valid range (if there are only invalid values, a -999 would be returned)
If data valid ? Output = (numeric value in mg/dl)
If there are no values a -999 will be returned
If the value has the text <,>,=. <=. >= Use the process in the Table 1 below to determine the value

General reference ranges _1,2

0.5-1.2 mg/dl (Conventional Unit)
45-110 mcmol/l (SI Unit) ₃
Extreme value: 73.8 mg/dl ₄

Conversion to mg/dl before classifying as valid or invalid

amount mcmol/l ÷ 88.4 =amount in mg/dl3

Table 1
Text prior to numaric value	Logic to Determine Value	Example
<	Subtract 0.01 from numeric value	<0.2 would return 0.19
>	Add 0.01 to numeric value	>0.2 would return 0.21
=	Return the numeric value	=0.2 would return 0.2
<=	Return the numeric value	<=0.2 would return 0.2
>=	Return the numeric value	>=0.2 would return 0.2