CODEBOOK Summary of laboratory markers (renal panel, complete blood count, iPTH/CRP, lipid panel, and iron tests) 7-25-2022 Start ____Field____ Section/ Column Len Format Variable Question Description Code ------ --- --------- -------------------------------- ------------ ------------------------------ ------------------------------ 1 6 KID CKiD ID number 101001 . . 299999 7 3 VISIT CKiD Visit number 10 . . 90 10 4 4.0 Sodium Result: Sodium (mmol/L) 120= 120 . . 160= 160 -1= NA (Skipped) -9= Missing -90= Extreme Value 14 5 5.1 Potassium Result: Potassium (mmol/L) 3.0= 3.0 . . 6.1= 6.1 -1= NA (Skipped) -9= Missing -90= Extreme Value 19 4 4.0 Chloride Result: Chloride (mmol/L) 93= 93 . . 117= 117 -1= NA (Skipped) -9= Missing -90= Extreme Value 23 4 4.0 CO2 Result: Carbon dioxide (mmol/ 15= 15 L) (from local lab if . available) . 40= 40 -1= NA (Skipped) -9= Missing -90= Extreme Value 27 4 4.0 CO2type local (from L03) or central 1= Local (from L05) 2= Central -1= NA -9= Missing 31 3 3.0 Acidosis CO2 < 20 mmol/L 0= No (CO2 >= 20 mmol/L) 1= Yes (CO2 < 20 mmol/L) -1= NA (Skipped) -9= Missing 34 4 4.0 Glucose Result: Glucose (mg/dL) 50= 50 . . 600= 600 -1= NA (Skipped) -9= Missing -90= Extreme Value 38 5 5.1 Albumin Result: Albumin (g/dL) 3.0= 3.0 . . 6.0= 6.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 43 3 3.0 Hypoalb Hypoalbuminemia (Albumin < 4 0= No (Albumin >= 4 g/dL) g/dL) 1= Yes (Albumin < 4 g/dL) -1= NA (Skipped) -9= Missing 46 7 7.2 Microalb Result: Microalbumin (mg/dL) 0.01= 0.01 . . 99.99= 99.99 -1= NA (Skipped) -7= Refusal -8= Don't know -9= Missing -90= Extreme Value 53 5 5.1 Calcium Result: Calcium (mg/dL) 6.0= 6.0 . . 13.0= 13.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 58 3 3.0 Cal_LNH Calcium low, normal, or high 1= Abnormal Low based on age-specific 2= Normal thresholds 3= Abnormal High -1= NA (Skipped) -9= Missing 61 5 5.1 Phosphate Result: Phosphate (mg/dL) 1.0= 1.0 . . 20.0= 20.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 66 3 3.0 Phos_LNH Phosphate low, normal, or 1= Abnormal Low high based on age-specific 2= Normal thresholds 3= Abnormal High -1= NA (Skipped) -9= Missing 69 6 6.2 CalXPhos Calcium-Phosphate Product 6.0= 6.0 . . 100.0= 100.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 75 3 3.0 CaXP_high Elevated Calcium-Phosphate 0= No (normal) Product based on age-specific 1= Yes (elevated) threshold -1= NA (Skipped) -9= Missing 78 4 4.0 UrCrea Result: Urine creatinine (mg/ 1= 1 dL) . . 999= 999 -1= NA (Skipped) -9= Missing -90= Extreme Value 82 5 5.0 UrProt Result: Urine protein (mg/dL) 1= 1 . . 9999= 9999 -1= NA (Skipped) -9= Missing -90= Extreme Value 87 6 6.2 uPCratio urine Protein/Creatinine ratio 0= 0 . . 1000= 1000 -1= NA (Skipped) -9= Missing -90= Extreme Value 93 3 3.0 NephProt Nephrotic proteinuria 0= No (uPCratio<=2) (uPCratio>2) 1= Yes (uPCratio>2) -1= NA (Skipped) -9= Missing 96 6 6.0 WBC Result: Leukocyte Count (cu 1000= 1000 mm) . . 30000= 30000 -1= NA (Skipped) -9= Missing -90= Extreme Value 102 6 6.2 RBC Result: Erythrocyte Count (M/ 4.20= 4.20 cu mm) or (x10-6 uL) . . 9.99= 9.99 -1= NA (Skipped) -9= Missing -90= Extreme Value 108 4 4.0 Platelets Result: Platelet Count (K/cu 100= 100 mm) or (x10-3 uL) . . 500= 500 -1= NA (Skipped) -9= Missing -90= Extreme Value 112 5 5.1 Hemoglobin Result: Hemoglobin (g/dL) 10.0= 10.0 . . 16.0= 16.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 117 6 6.2 HGBZasr Hemoglobin Z-score based on -9.99 age, sex, and race (per CDC . guidelines) . 9.99 123 6 6.2 HGBPCTasr Hemoglobin percentile base on 00.00% age, sex, and race (per CDC . guidelines, assuming . normality of HGBZasr) 99.99% 129 3 3.0 Anemia_cdc Anemia (Hemoglobin < 5th 0= No (HGB >= 5th %ile) percentile for age, sex, and 1= Yes (HGB < 5th %ile) race, based on empirical -1= NA (Skipped) thresholds) -9= Missing 132 5 5.1 Hematocrit Result: PCV - Hematocrit (%) 30.0= 30.0 . . 50.0= 50.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 137 5 5.1 MCH Result: Mean Corpuscular 23= 23 Hemoglobin (pg/cell) . . 35= 35 -1= NA (Skipped) -9= Missing -90= Extreme Value 142 6 6.1 MCHconc Result: MCH Concentration (g/ 30.0= 30.0 dL) . . 40.0= 40.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 148 6 6.1 MCV Result: MC Volume (fL) 74.0= 74.0 . . 110.0= 110.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 154 6 6.1 RCD Result: Red Cell Distribution 9.0= 9.0 Width (%) . . 20.0= 20.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 160 6 6.1 iPTH Result: iPTH (pg/mL) 14.0= 14.0 . . 72.0= 72.0 -1= NA (Skipped) -9= Missing -90= Extreme Value 166 6 6.2 CRP Result: hsCRP (if available) 0.00= 0.00 or wrCRP (mg/L) . . 10.00= 10.00 -1= NA (Skipped) -9= Missing -90= Extreme Value 172 3 3.0 CRPtype CRP method, high sensitivity 1= HS or wide range 2= WR -1= NA -9= Missing 175 3 3.0 CRP_high Elevated CRP, >3 mg/L 0= No (CRP <= 3 mg/L) 1= Yes (CRP > 3 mg/L) -1= NA (Skipped) -9= Missing 178 5 5.0 TotalChol Result: cholesterol (mg/dL) 120= 120 . . 300= 300 -1= NA (Skipped) -9= Missing -90= Extreme Value 183 5 5.0 Trig Result: total triglycerides 60= 60 (mg/dL) . . 999= 999 -1= NA (Skipped) -9= Missing -90= Extreme Value 188 5 5.0 HDL Result: high density 20= 20 lipoproteins (mg/dL) . . 90= 90 -1= NA (Skipped) -9= Missing -90= Extreme Value 193 5 5.0 LDL Result: low density 80= 80 lipoproteins (mg/dL) . . 200= 200 -1= NA (Skipped) -9= Missing -90= Extreme Value 198 6 6.1 CholHDLratio Result: cholesterol/HDL ratio 0.1= 0.1 . . 9.9= 9.9 -1= NA (Skipped) -7= Refusal -8= Don't know -9= Missing -90= Extreme Value 204 5 5.0 NonHDL Total cholesterol minus HDL 30= 30 . . 300= 300 -1= NA (Skipped) -9= Missing -90= Extreme Value 209 4 4.0 SerumIron Serum Iron (ug/dL) 38= 38 . . 159= 159 -1= NA (Skipped) -9= Missing -90= Extreme Value 213 4 4.0 TIBC Total Iron-Binding Capacity 250= 250 (ug/dL) . . 450= 450 -1= NA (Skipped) -9= Missing -90= Extreme Value 217 4 4.0 TSAT Transferrin Saturation (TSAT) 15= 15 (%) . . 55= 55 -1= NA (Skipped) -9= Missing -90= Extreme Value 221 5 5.0 Ferritin Ferritin 10= 10 . . 322= 322 -1= NA (Skipped) -9= Missing -90= Extreme Value 226 4 4.0 Transferrin Transferrin 202= 202 . . 336= 336 -1= NA (Skipped) -9= Missing -90= Extreme Value 230 2 2.0 PIP_RenalDateCaution flag for PIP renal panel data 1= Caution/out-of-range >6mo out of range 0= No caution 232 2 2.0 PIP_CBCDateCaution flag for PIP CBC panel data 1= Caution/out-of-range >6mo out of range 0= No caution 234 2 2.0 PIP_IronDateCaution flag for PIP iron test data 1= Caution/out-of-range >6mo out of range 0= No caution 236 6 $ VERSION Version number of data V01.01= Version 01, in Visit 01. . . V99.03= Version 03, in Visit 99.