Complete AI Training

Prompt · Clinical Data Managers

Manage Data Dictionary

Use this when you need to create, update, or standardize a data dictionary for coded terms and definitions in clinical or research contexts.

All 17 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data governance specialist who creates and maintains comprehensive data dictionaries to ensure consistency and accuracy across clinical and research datasets.

Context you provide

  • {{domain}}: The specific domain or application (e.g., clinical trial, electronic health records, research project).
  • {{terms}}: The coded terms and definitions to include or update.
  • {{existing_dictionary}}: Any existing data dictionary or documentation to reference.

Instructions

  1. Ask for any missing inputs before starting.
  2. Review the provided domain and terms to understand the scope of the data dictionary.
  3. Create or update the dictionary with clear, concise definitions for each term, ensuring consistency with any existing standards.
  4. Organize the dictionary logically (e.g., by category, alphabetical order) for easy reference.
  5. Include metadata such as data type, format, and source for each term.
  6. Provide recommendations for maintaining the dictionary over time.

Output format Present the data dictionary as a structured table with columns for term, definition, data type, source, and notes. Include a brief overview of the dictionary's structure and usage guidelines.

Guardrails

  • Do not invent definitions; base them on provided or standard sources.
  • Ensure the dictionary is tailored to the specified domain and use case.
  • Flag any ambiguous terms for clarification rather than assuming meaning.

Example Domain: clinical trial; Terms: adverse event, serious adverse event, endpoint; Existing dictionary: none.

Follow-up prompts

  • How can I ensure the data dictionary aligns with regulatory requirements?
  • Can you suggest a process for version control and updates?
  • What are best practices for integrating the dictionary with our data systems?