CRDW Sweep & Specify

OUHSC BBMC — CDW Dictionary Metadata Generator
🔍
Tip: Be specific about what codes you need. The AI will generate comprehensive search keywords.
  • Add a keyword: Type a word and press Enter or , — it becomes a filter chip.
  • Multiple keywords: Add as many chips as you need. Rows matching any keyword are shown (OR logic).
  • Wildcard: Use * for partial matching — e.g. ovar* matches "ovary", "ovarian", etc.
  • Paste a list: Paste comma-separated terms (e.g. breast, ovar*, C50) and each becomes its own chip.
  • Remove a chip: Click the × on any chip, or press Backspace when the input is empty.
  • AI Expand: Click the ★ AI Expand button and describe what you need in plain language (e.g. “all diagnoses related to hypertension”). The AI will generate a comprehensive list of search keywords — including related terms you might not think of — and add them as chips automatically. Requires an API key (see Settings).
  • Desired column: All matching rows default to checked. Uncheck any you don't want. The downloaded CSV includes all matching rows with a desired column (TRUE/FALSE).
  • Category column: Click any row's Category cell to type a free-text label (e.g. "obesity-related", "age-related"). Categories are saved in the CSV so you can group rows by purpose.
Total in dictionary: 0 Matching filter: 0 Checked (desired): 0
Desired Concept ID Vocabulary ICD Code Description Category Keyword Matched
🔍
Tip: Include drug classes, brand names, or therapeutic categories.
  • Add a keyword: Type a word and press Enter or , — it becomes a filter chip.
  • Multiple keywords: Add as many chips as you need. Rows matching any keyword are shown (OR logic).
  • Wildcard: Use * for partial matching — e.g. insulin* matches "insulin lispro", "insulin glargine", etc.
  • Paste a list: Paste comma-separated terms and each becomes its own chip.
  • Remove a chip: Click the × on any chip, or press Backspace when the input is empty.
  • AI Expand: Click the ★ AI Expand button and describe what you need in plain language (e.g. “all GLP-1 receptor agonists including brand names”). The AI will generate a comprehensive keyword list — every generic name, brand name, and variant — and add them as chips automatically. Requires an API key (see Settings).
  • Desired column: All matching rows default to checked. Uncheck any you don't want. The downloaded CSV includes all matching rows with a desired column (TRUE/FALSE).
  • Category column: Click any row's Category cell to type a free-text label (e.g. "obesity-related", "age-related"). Categories are saved in the CSV so you can group rows by purpose.
Total in dictionary: 0 Matching filter: 0 Checked (desired): 0
Desired Source Key/Mnemonic Name Generic Name Pharm Class Pharm Subclass Category Keyword Matched
🔍
Tip: Use panel names (CBC, CMP) and the AI will expand to all analytes.
  • Add a keyword: Type a word and press Enter or , — it becomes a filter chip.
  • Multiple keywords: Add as many chips as you need. Rows matching any keyword are shown (OR logic).
  • Wildcard: Use * for partial matching — e.g. glucose* matches "glucose", "glucose fasting", etc.
  • Paste a list: Paste comma-separated terms and each becomes its own chip.
  • Remove a chip: Click the × on any chip, or press Backspace when the input is empty.
  • AI Expand: Click the ★ AI Expand button and describe what you need in plain language (e.g. “complete metabolic panel” or “all renal function labs”). The AI will expand panel names into every individual analyte (e.g. CBC → hemoglobin, hematocrit, WBC, RBC, platelets, etc.) and add them as chips automatically. Requires an API key (see Settings).
  • Desired column: All matching rows default to checked. Uncheck any you don't want. The downloaded CSV includes all matching rows with a desired column (TRUE/FALSE).
  • Category column: Click any row's Category cell to type a free-text label (e.g. "obesity-related", "age-related"). Categories are saved in the CSV so you can group rows by purpose.
Total in dictionary: 0 Matching filter: 0 Checked (desired): 0
Desired Source Key/Print# Name Common Name LOINC Units Category Keyword Matched
🔍
Tip: Describe the specialty, department type, or location names you need.
  • Add a keyword: Type a word and press Enter or , — it becomes a filter chip.
  • Multiple keywords: Add as many chips as you need. Rows matching any keyword are shown (OR logic).
  • Wildcard: Use * for partial matching — e.g. cardio* matches "cardiology", "cardiovascular", etc.
  • Paste a list: Paste comma-separated terms and each becomes its own chip.
  • Remove a chip: Click the × on any chip, or press Backspace when the input is empty.
  • AI Expand: Click the ★ AI Expand button and describe what you need in plain language (e.g. “all cardiology clinics and cardiac surgery units”). The AI will generate a comprehensive list of department and specialty keywords and add them as chips automatically. Requires an API key (see Settings).
  • Desired column: All matching rows default to checked. Uncheck any you don't want. The downloaded CSV includes all matching rows with a desired column (TRUE/FALSE).
  • Category column: Click any row's Category cell to type a free-text label (e.g. "obesity-related", "age-related"). Categories are saved in the CSV so you can group rows by purpose.
Total in dictionary: 0 Matching filter: 0 Checked (desired): 0
Desired Source Key/Mnemonic Name Specialty/Type Location/Facility Category Keyword Matched
🔍
Tip: Include procedure types, CPT descriptions, or surgical specialties.
  • Add a keyword: Type a word and press Enter or , — it becomes a filter chip.
  • Multiple keywords: Add as many chips as you need. Rows matching any keyword are shown (OR logic).
  • Wildcard: Use * for partial matching — e.g. vitrect* matches "vitrectomy", "vitrectomies", etc.
  • Paste a list: Paste comma-separated terms and each becomes its own chip.
  • Remove a chip: Click the × on any chip, or press Backspace when the input is empty.
  • Source: Date range determines which system is shown. Before 2023-06-03 → GECB (CPT billing); on or after → Epic.
  • AI Expand: Click the ★ AI Expand button and describe what you need in plain language (e.g. “all cataract and retinal surgery procedures”). Requires an API key (see Settings).
Total in dictionary: 0 Matching filter: 0 Checked (desired): 0
Desired Source Procedure Name Short Name CPT Code Category Vocabulary Keyword Matched