7. Using the CRATE web interface

• 7.1. Overview for clinicians and researchers using the CRATE web interface
  • 7.1.1. For clinicians
  • 7.1.2. For researchers
  • 7.1.3. For researchers wishing to re-identify and contact patients
  • 7.1.4. Your settings
  • 7.1.5. About CRATE
• 7.2. Database structure
  • 7.2.1. Online in paginated tabular format
  • 7.2.2. Online in single-page tabular format
  • 7.2.3. Online in collapsible tree form
  • 7.2.4. Download in tab-separated values (TSV) format
  • 7.2.5. Download in Excel (.XLSX) format
  • 7.2.6. Help on local database structure
• 7.3. Research queries
  • 7.3.1. Query builder
  • 7.3.2. SQL
  • 7.3.3. Highlighting text in results
  • 7.3.4. Results: table view
  • 7.3.5. Results: record view
  • 7.3.6. Results: tab-separated values (TSV) file
  • 7.3.7. Results: Excel (.XLSX) file
• 7.4. Standard site queries
• 7.5. SQL helpers
  • 7.5.1. Find text anywhere
  • 7.5.2. Find drugs of a given type anywhere
• 7.6. Patient Explorer queries
  • 7.6.1. Build a Patient Explorer
  • 7.6.2. Choose Patient Explorer
  • 7.6.3. Data Finder: results
  • 7.6.4. Data Finder: Excel
  • 7.6.5. Table Browser
  • 7.6.6. Monster Data
  • 7.6.7. More detail on the Patient Explorer concept
• 7.7. Privileged functions for clinicians
  • 7.7.1. Find text anywhere
  • 7.7.2. Look up research ID from patient ID
  • 7.7.3. Submit patient contact request
• 7.8. Archive view
  • 7.8.1. Background
  • 7.8.2. How to customize the archive view
  • 7.8.3. Examples
  • 7.8.4. Design notes
• 7.9. Contacting patients about research studies
  • 7.9.1. View/manage your studies
  • 7.9.2. Submit a contact request
• 7.10. Research Database Manager functions
  • 7.10.1. RDBM admin site
  • 7.10.2. Edit sitewide query library
  • 7.10.3. Look up patient ID (PID) from research ID (RID)
  • 7.10.4. Charity payment report
  • 7.10.5. Report patients to be excluded entirely from anonymised database
  • 7.10.6. Test message queue by sending an e-mail to the RDBM
• 7.11. Developer functions
  • 7.11.1. Developer admin site
  • 7.11.2. Generate random NHS numbers for testing
  • 7.11.3. Test patient lookup without saving data
  • 7.11.4. Test consent mode lookup without saving data
  • 7.11.5. Test templates