Query Guidelines

Cheatsheets and how-to notes for building MongoDB queries over CDISC/SDTM-style subject data.

Back to Query Builder
This page provides guidelines to help you understand how to set up your queries. IMS supports two ways to build requests:
Simple (guided UI): use Query Builder 2.0 to select common filters step-by-step.
Power-user (MongoDB query language): use Query Builder to write the MongoDB query object directly.
CDISC Domains Cheatsheet

Helpful mapping between human concepts and the CDISC / SDTM-style keys you use in queries. This dataset is typically self-contained: domains like VS and SC are arrays of rows, and each row includes both a *TESTCD (stable code) and *TEST (human label) plus the value field (e.g. VSORRES, SCORRES).

USUBJID
Unique subject identifier (child ID).
DM
Demographics (age, sex, country, etc.).
SC
Subject characteristics (e.g. smoker, phenotype tags).
VS
Vital signs (height, weight, BMI, blood pressure, ...).
MH
Medical history (e.g. asthma, diabetes, hypertension).
LB
Laboratory tests (glucose, cholesterol, HbA1c, ...).
CM
Concomitant medications.
QS
Questionnaires / scales (e.g. quality-of-life, diet).
HO
Healthcare encounters (hospital / clinic visits).
RP
Reproductive findings.
RS
Disease response (mainly oncology).
APDM / APMH / APVS
Associated persons (e.g. parents) demographics, medical history, vital signs.

Row structure (common pattern)
  • VS (Vital Signs): match the measurement by VSTESTCD (preferred) or VSTEST, compare the value in VSORRES, unit in VSORRESU, optional timepoint in VSTPT.
  • SC (Subject Characteristics): match the characteristic by SCTESTCD (preferred) or SCTEST, value in SCORRES, unit in SCORRESU.
In your subject JSON, only USUBJID is a scalar. Most other keys are arrays of row objects. Each row includes both the concept label/code and the value (e.g. VSORRES / SCORRES).
Example queries (combined, no duplicates)
BMI ≥ 30 (VS)
Stable code (VSTESTCD): {"VS": {"$elemMatch": {"VSTESTCD": "BMI", "VSORRES": {"$gte": 30}}}}
Human label (VSTEST): {"VS":{"$elemMatch":{"VSTEST":"Body Mass Index","VSORRES":{"$gte":30}}}}
Systolic BP ≥ 130 (VS)
Stable code (VSTESTCD): {"VS": {"$elemMatch": {"VSTESTCD": "SYSBP", "VSORRES": {"$gte": 130}}}}
Human label (VSTEST): {"VS":{"$elemMatch":{"VSTEST":"Systolic Blood Pressure","VSORRES":{"$gte":130}}}}
Country = Slovenia (SC / CTRYPAD)
Exact match (case-sensitive): {"SC": {"$elemMatch": {"SCTESTCD": "CTRYPAD", "SCORRES": "Slovenia"}}}
Case-insensitive regex: {"SC":{"$elemMatch":{"SCTESTCD":"CTRYPAD","SCORRES":{"$regex":"Slovenia","$options":"i"}}}}
Body Length at birth (VS, timepoint)
{"VS": {"$elemMatch": {"VSTESTCD": "BODLNGTH", "VSTPT": "BIRTH"}}}
Mother has Diabetes Type 2 (APMH)
{"APMH":{"$elemMatch":{"SREL":"MOTHER","MHTERM":{"$regex":"Diabetes Type 2","$options":"i"}}}}
Father has Cholesterol (APMH)
{"APMH":{"$elemMatch":{"SREL":"FATHER","MHTERM":{"$regex":"Cholesterol","$options":"i"}}}}
Bariatric Surgery (APPR)
{"APPR":{"$elemMatch":{"SREL":"MOTHER","PRTRT":"Bariatric Surgery"}}}
Note: some “values” can be special objects (e.g. {"$numberDouble":"NaN"}) or null. If a numeric filter returns no data, try leaving that filter empty or use a different variable.
Example Subject JSON
{
  "APDM": [
    {
      "AGE": {
        "$numberDouble": "NaN"
      },
      "AGEU": "YEARS",
      "SREL": "MOTHER"
    },
    {
      "AGE": {
        "$numberDouble": "NaN"
      },
      "AGEU": "YEARS",
      "SREL": "FATHER"
    }
  ],
  "APMH": [
    {
      "MHOCCUR": null,
      "MHTERM": "Cholesterol",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Diabetes Type 2",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Gestational Diabetes",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Diabetes Type 1",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Cholesterol",
      "SREL": "FATHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Diabetes Type 2",
      "SREL": "FATHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Hypertension",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Hypertension",
      "SREL": "FATHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Cardiovascular disease",
      "SREL": "FATHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Cardiovascular disease",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Hypertension during gestation",
      "SREL": "MOTHER"
    },
    {
      "MHOCCUR": null,
      "MHTERM": "Diabetes Type 1",
      "SREL": "FATHER"
    }
  ],
  "APPR": [
    {
      "PROCCUR": null,
      "PRTRT": "Bariatric Surgery",
      "SREL": "MOTHER"
    },
    {
      "PROCCUR": null,
      "PRTRT": "Bariatric Surgery",
      "SREL": "FATHER"
    }
  ],
  "APRP": [
    {
      "RPORRES": {
        "$numberDouble": "NaN"
      },
      "RPORRESU": "YEARS",
      "RPTESTCD": "MENERAGE",
      "SREL": "MOTHER"
    },
    {
      "RPORRES": {
        "$numberDouble": "NaN"
      },
      "RPORRESU": "YEARS",
      "RPTESTCD": "PUBAGE",
      "SREL": "FATHER"
    }
  ],
  "APSC": [
    {
      "SCORRES": {
        "$numberDouble": "NaN"
      },
      "SCTEST": "Number of Children in Household",
      "SCTESTCD": "CHLDHSHN"
    }
  ],
  "APSCFB": [
    {
      "SCORRES": null,
      "SCTEST": "Marital Status",
      "SCTESTCD": "MARISTAT",
      "SREL": "MOTHER"
    },
    {
      "SCORRES": null,
      "SCTEST": "Marital Status",
      "SCTESTCD": "MARISTAT",
      "SREL": "FATHER"
    }
  ],
  "APVS": [
    {
      "SREL": "MOTHER",
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg",
      "VSTESTCD": "WEIGHT",
      "VSTPT": "GESTATION"
    },
    {
      "SREL": "FATHER",
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg/m²",
      "VSTESTCD": "BMI",
      "VSTPT": null
    },
    {
      "SREL": "MOTHER",
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg/m²",
      "VSTESTCD": "BMI",
      "VSTPT": "PRIOR CONCEPTION"
    },
    {
      "SREL": "MOTHER",
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg/m²",
      "VSTESTCD": "BMI",
      "VSTPT": null
    },
    {
      "SREL": "FATHER",
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg/m²",
      "VSTESTCD": "BMI",
      "VSTPT": "PRIOR CONCEPTION"
    }
  ],
  "CM": [
    {
      "CMDECOD": {
        "$numberDouble": "NaN"
      },
      "CMOCCUR": null
    }
  ],
  "DM": [
    {
      "AGE": 17,
      "AGEU": "YEARS",
      "RACEC": " ",
      "SEX": "F"
    }
  ],
  "HO": [
    {
      "HOINDC": "[]",
      "HOOCCUR": "N",
      "HOREAS": "NON-OBESITY",
      "HOTERM": null
    }
  ],
  "LB": [
    {
      "LBORRES": null,
      "LBORRESU": "umol/L",
      "LBSCAT": null,
      "LBTEST": "Creatinine",
      "LBTESTCD": "creatinine"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/mol",
      "LBSCAT": null,
      "LBTEST": "Hemoglobin A1C",
      "LBTESTCD": "glycated_hemoglobin"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "Cholesterol",
      "LBTESTCD": "total_cholesterol"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mU/L",
      "LBSCAT": null,
      "LBTEST": "Insulin",
      "LBTESTCD": "insulin"
    },
    {
      "LBORRES": null,
      "LBORRESU": "g/L    ",
      "LBSCAT": null,
      "LBTEST": "Lipoprotein-a",
      "LBTESTCD": "lipoprotein"
    },
    {
      "LBORRES": null,
      "LBORRESU": "ukat/L ",
      "LBSCAT": null,
      "LBTEST": "Alanine Aminotransferase",
      "LBTESTCD": "alanine_aminotransferase"
    },
    {
      "LBORRES": null,
      "LBORRESU": "g/L    ",
      "LBSCAT": null,
      "LBTEST": "Apolipoprotein B",
      "LBTESTCD": "apolipoprotein_b"
    },
    {
      "LBORRES": 0.41,
      "LBORRESU": "-",
      "LBSCAT": null,
      "LBTEST": "Hematocrit",
      "LBTESTCD": "hematocrit"
    },
    {
      "LBORRES": null,
      "LBORRESU": "nmol/L",
      "LBSCAT": null,
      "LBTEST": "Sex Hormone Binding Globulin",
      "LBTESTCD": "sex_hormone_binding_globulin"
    },
    {
      "LBORRES": 345,
      "LBORRESU": "g/L    ",
      "LBSCAT": null,
      "LBTEST": "Ery. Mean Corpuscular HGB Concentration",
      "LBTESTCD": "mean_corpuscular_hemoglobin_concentration"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "Glucose",
      "LBTESTCD": "glucose"
    },
    {
      "LBORRES": null,
      "LBORRESU": "pmol/l",
      "LBSCAT": null,
      "LBTEST": "Thyroxine",
      "LBTESTCD": "thyroxine"
    },
    {
      "LBORRES": null,
      "LBORRESU": "ukat/L ",
      "LBSCAT": null,
      "LBTEST": "Aspartate Aminotransferase",
      "LBTESTCD": "aspartate_aminotransferase"
    },
    {
      "LBORRES": 10.18,
      "LBORRESU": "10E9/L ",
      "LBSCAT": null,
      "LBTEST": "Leukocytes",
      "LBTESTCD": "leukocytes"
    },
    {
      "LBORRES": null,
      "LBORRESU": null,
      "LBSCAT": "LIVER FAT",
      "LBTEST": null,
      "LBTESTCD": null
    },
    {
      "LBORRES": null,
      "LBORRESU": "nmol/L ",
      "LBSCAT": null,
      "LBTEST": "Estradiol",
      "LBTESTCD": "estradiol"
    },
    {
      "LBORRES": null,
      "LBORRESU": "nmol/l",
      "LBSCAT": null,
      "LBTEST": "Cortisol",
      "LBTESTCD": "cortisol"
    },
    {
      "LBORRES": null,
      "LBORRESU": null,
      "LBSCAT": null,
      "LBTEST": "Androstenedione",
      "LBTESTCD": "d4_androstenedione"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mIU/mL",
      "LBSCAT": null,
      "LBTEST": "Luteinizing Hormone",
      "LBTESTCD": "luteinizing_hormone"
    },
    {
      "LBORRES": null,
      "LBORRESU": "umol/L ",
      "LBSCAT": null,
      "LBTEST": "Urate",
      "LBTESTCD": "uric_acid"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mIU/mL",
      "LBSCAT": null,
      "LBTEST": "Follicle Stimulating Hormone",
      "LBTESTCD": "follicle_stimulating_hormone"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "LDL Cholesterol",
      "LBTESTCD": "low_density_lipoprotein"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "HDL Cholesterol",
      "LBTESTCD": "high_density_lipoprotein"
    },
    {
      "LBORRES": null,
      "LBORRESU": "umol/L",
      "LBSCAT": null,
      "LBTEST": "Dehydroepiandrosterone Sulfate",
      "LBTESTCD": "dehydroepiandrosterone_sulfate"
    },
    {
      "LBORRES": null,
      "LBORRESU": "pmol/l",
      "LBSCAT": null,
      "LBTEST": "Triiodothyronine",
      "LBTESTCD": "triiodothyronine"
    },
    {
      "LBORRES": null,
      "LBORRESU": "nmol/L ",
      "LBSCAT": null,
      "LBTEST": "total_serum_25_hydroxyvitamin_dd)",
      "LBTESTCD": "total_serum_25_hydroxyvitamin_dd)"
    },
    {
      "LBORRES": null,
      "LBORRESU": "nmol/L ",
      "LBSCAT": null,
      "LBTEST": "Testosterone, Free/Total Protein",
      "LBTESTCD": "testosterone_total"
    },
    {
      "LBORRES": null,
      "LBORRESU": "pmol/l",
      "LBSCAT": null,
      "LBTEST": "Thyroxine, Free",
      "LBTESTCD": "free_thyroxine"
    },
    {
      "LBORRES": 143,
      "LBORRESU": "g/L    ",
      "LBSCAT": null,
      "LBTEST": "Hemoglobin",
      "LBTESTCD": "hemoglobin"
    },
    {
      "LBORRES": 89.8,
      "LBORRESU": "fL",
      "LBSCAT": null,
      "LBTEST": "Ery. Mean Corpuscular Volume",
      "LBTESTCD": "mean_corpuscular_volume"
    },
    {
      "LBORRES": null,
      "LBORRESU": "g/L    ",
      "LBSCAT": null,
      "LBTEST": "Apolipoprotein A1",
      "LBTESTCD": "apolipoprotein_a1"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mU/L",
      "LBSCAT": null,
      "LBTEST": "Thyrotropin",
      "LBTESTCD": "thyroid_stimulating_hormone"
    },
    {
      "LBORRES": null,
      "LBORRESU": "ug/l   ",
      "LBSCAT": null,
      "LBTEST": "Prolactin",
      "LBTESTCD": "prolactin"
    },
    {
      "LBORRES": null,
      "LBORRESU": null,
      "LBSCAT": null,
      "LBTEST": "Insulin-like Growth Factor-1",
      "LBTESTCD": "insulin_like_growth_factor_1"
    },
    {
      "LBORRES": 31,
      "LBORRESU": "pg     ",
      "LBSCAT": null,
      "LBTEST": "Ery. Mean Corpuscular Hemoglobin",
      "LBTESTCD": "mean_corpuscular_hemoglobin"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "Urea",
      "LBTESTCD": "urea"
    },
    {
      "LBORRES": 296,
      "LBORRESU": "10E9/L ",
      "LBSCAT": null,
      "LBTEST": "Platelets",
      "LBTESTCD": "platelets"
    },
    {
      "LBORRES": null,
      "LBORRESU": "mmol/L ",
      "LBSCAT": null,
      "LBTEST": "Triglycerides",
      "LBTESTCD": "triglycerides"
    }
  ],
  "MH": [
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Cardiovascular Disease"
    },
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Asthma"
    },
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Hypertension"
    },
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Diabetes Type 2"
    },
    {
      "MHDECOD": null,
      "MHOCCUR": null,
      "MHTERM": "Depression or other psychological problems"
    },
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Metabolic Syndrome"
    },
    {
      "MHDECOD": null,
      "MHOCCUR": null,
      "MHTERM": "Gastrointestinal Complications"
    },
    {
      "MHDECOD": " ",
      "MHOCCUR": null,
      "MHTERM": "Sleep Apnoea"
    },
    {
      "MHDECOD": null,
      "MHOCCUR": null,
      "MHTERM": "Musculoskeletal complications"
    },
    {
      "MHDECOD": null,
      "MHOCCUR": null,
      "MHTERM": "Menstrual Problems in Girls"
    }
  ],
  "QS": [
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "FOODS THE CHILD REJECTS"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MUCH TIME DOES IT TAKE FOR EACH MEAL?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY EGGS DOES A CHILD EAT PER WEEK?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": "EUR",
      "QSTEST": "OBESITY RELATED HEALTHCARE COST"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY MEALS DOES THE CHILD HAVE PER DAY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "AMOUNT OF SALT INTAKE"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "IF YES, WITH WHICH"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT FOOD WHILE LEARNING?"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "HOW MANY TIMES A WEEK?"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "HOW MANY HOURS DOES THE CHILD SLEEP A DAY"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD GO TO BED WITH A FULL STOMACH?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY TIMES A WEEK IS MEAT ON THE MENU?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD WALKING TO SCHOOL?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD SALT THE FOOD AT THE TABLE?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY HOURS DOES THE CHILD SLEEP A DAY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "WHAT KIND OF MEAT DOES THE CHILD EAT?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MUCH FLUID DOES THE CHILD DRINK PER DAY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "TYPE OF SALT INTAKE"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "WHAT KIND OF LIQUID DOES THE CHILD CONSUME?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "WHO MAINLY PREPARES THE CHILD'S FOOD?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "WHEN DOES THE FAMILY HAVE A MEAL TOGETHER"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DISTANCE OF SCHOOL FROM HOME"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT FOOD WHILE READING THE BOOK?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY GLASSES OF MILK DOES THE CHILD DRINK A DAY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT FOOD WHILE WORK ON THE COMPUTER?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT BREAKFAST REGULARLY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "WHERE DOES THE CHILD EAT?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "FOOD INTAKE VOLUME"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY TIMES A WEEK IS THERE FRUIT?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT FOOD WHILE WATCHING TV?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD BUY EXTRA FOOD HIMSELF?"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "HOW MANY HOURS A DAY DOES THE CHILD SIT AT HOME"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EXERCISE REGULARLY AT SCHOOL?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD DO EXTRA SPORTS?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD EAT FOOD WHILE LISTENING TO MUSIC?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW DO YOU RATE THE MEALS?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "FAVORITE FOOD"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW OFTEN DOES THE CHILD EAT SWEETS?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "IS THE CHILD SUCCESSFUL IN SPORTS ACTIVITIES AT SCHOOL?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES YOUR CHILD LIKE SCHOOL GYM?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "SELF ASSESSMENT OF ATTITUDES TOWARDS OBESITY: IS THE CHILD UNHAPPY BECAUSE OF BEING OVERWEIGHT?"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "SELF RATED PEER ATTITUDES TOWARD HIS OVERWEIGHT?"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "TIME SPENT ON OUTDOOR ACTIVITIES"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY TEASPOONS OF SUGAR DOES THE CHILD DRINK IN A CUP OF TEA?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MUCH BREAD DOES THE CHILD EAT A DAY?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "DOES THE CHILD DRIVE TO SCHOOL"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "LEVEL OF DIFFICULTIES WITH THE PHYSICAL ACTIVITIES"
    },
    {
      "QSORRES": null,
      "QSORRESU": null,
      "QSTEST": "WHICH FAT DO YOU USE AT HOME IN YOUR HOUSEHOLD?"
    },
    {
      "QSORRES": " ",
      "QSORRESU": null,
      "QSTEST": "HOW MANY TIMES A WEEK DO YOU EAT VEGETABLES?"
    }
  ],
  "RP": [
    {
      "RPORRES": {
        "$numberDouble": "NaN"
      },
      "RPORRESU": null,
      "RPTEST": "Breastfeeding"
    },
    {
      "RPORRES": {
        "$numberDouble": "NaN"
      },
      "RPORRESU": "MONTHS",
      "RPTEST": "Breastfeeding Duration"
    }
  ],
  "RS": [
    {
      "RSCAT": "TANNER SCALE GIRL",
      "RSORRES": null
    }
  ],
  "SC": [
    {
      "SCORRES": null,
      "SCORRESU": null,
      "SCTEST": "Small for Gestational Age Indicator",
      "SCTESTCD": "SMGAIND"
    },
    {
      "SCORRES": "Urban",
      "SCORRESU": null,
      "SCTEST": "District of Permanent Address",
      "SCTESTCD": "DISTPAD"
    },
    {
      "SCORRES": "Slovenian",
      "SCORRESU": null,
      "SCTEST": "Country of Permanent Address",
      "SCTESTCD": "CTRYPAD"
    },
    {
      "SCORRES": null,
      "SCORRESU": "WEEKS",
      "SCTEST": "Estimated Gestational Age",
      "SCTESTCD": "EGESTAGE"
    },
    {
      "SCORRES": "high school",
      "SCORRESU": null,
      "SCTEST": "Level of Education Attained",
      "SCTESTCD": "EDULEVEL"
    },
    {
      "SCORRES": null,
      "SCORRESU": null,
      "SCTEST": "Low Birth Weight",
      "SCTESTCD": null
    },
    {
      "SCORRES": null,
      "SCORRESU": "YEARS",
      "SCTEST": "Age when BMI increased",
      "SCTESTCD": null
    }
  ],
  "USUBJID": "NORMAL001",
  "VS": [
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "mmHg",
      "VSTEST": "Systolic Blood Pressure",
      "VSTESTCD": "SYSBP",
      "VSTPT": null
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "cm",
      "VSTEST": "Head Circumference",
      "VSTESTCD": "HDCIRC",
      "VSTPT": null
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "cm",
      "VSTEST": "Body Length",
      "VSTESTCD": "BODLNGTH",
      "VSTPT": "BIRTH"
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "gr",
      "VSTEST": "Birth Weight",
      "VSTESTCD": "BRTHWT",
      "VSTPT": null
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "kg/m²",
      "VSTEST": "Body Mass Index",
      "VSTESTCD": "BMI",
      "VSTPT": null
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "mmHg",
      "VSTEST": "Diastolic Blood Pressure",
      "VSTESTCD": "DIABP",
      "VSTPT": null
    },
    {
      "VSORRES": {
        "$numberDouble": "NaN"
      },
      "VSORRESU": "m²",
      "VSTEST": "Body Surface Area",
      "VSTESTCD": "BSA",
      "VSTPT": null
    }
  ]
}
Reference shape for root keys and associated-person domains (APDM/APMH/APPR/APSC/APSCFB/APVS).