Skip to main content

Master Client Inquiry - PM

Generate a comprehensive client demographic and treatment history report.


  1. Go to: Avatar PM > Client Management > Census Management Reports > Master Client Inquiry
  2. In the Select Client screen, enter the client name or ID and select.
  3. In the Select Patient field, enter the client name or ID and select.
  4. If the client has multiple episodes, in the Select Episode Number field, select the client episode.
  5. Click Process. The Master Client Inquiry report contains a main report and several sub-reports.
► SQL Tables
  • SYSTEM.admission_data
  • SYSTEM.admission_practitioner
  • SYSTEM.admission_referral_data
  • SYSTEM.billing_tx_history
  • SYSTEM.discharge_data
  • SYSTEM.episode_history
  • SYSTEM.history_attending_practitioner
  • SYSTEM.history_diagnosis
  • SYSTEM.history_legal_status
  • SYSTEM.patient_current_demographics
  • SYSTEM.patient_demographic_history
  • SYSTEM.view_episode_summary_admit