1 / 30

Basic Q-Man

CMI. Basic Q-Man. Q. Developed by: Cimarron Medical Informatics, LLC Tucson, AZ. PCC Data Entry. Inpatient. Patient Registration. Dental. PCC Patient Database. Behavioral Health. Laboratory. Emergency Room. Pharmacy. Field Nursing. Surgery. Women’s Health. Radiology.

lauren
Download Presentation

Basic Q-Man

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CMI Basic Q-Man Q Developed by: Cimarron Medical Informatics, LLC Tucson, AZ

  2. PCC Data Entry Inpatient Patient Registration Dental PCC Patient Database Behavioral Health Laboratory Emergency Room Pharmacy Field Nursing Surgery Women’s Health Radiology Appointment System CHR The RPMS Integrates Multiple Clinical Systems EHR

  3. Resource & Patient Management System PCC Patient Care Component RPMS and the PCC

  4. An ad hoc PCC query tool that allows formulation of reports with user defined selection of clinical and/or demographic data limited by specified conditions of values or time frames. Special outputs such as saved templates of patients or visits as well as age-related, workload, or monthly distribution reports may be created. Qman

  5. Menu Options & Security Keys QMAN Menu: AMQQMENU Keys: AMQQZMENU, AMQQZCLIN, AMQQZRPT, AMQQZEMAN PCC Management Reports Menu: APCLMENU Keys: APCLZMENU, APCLZ IPV REPORTS, APCLZ TAXONOMY SETUP

  6. PCC Terms • Community • Facility/ Location • Clinic • Visit Type • Service Category • Provider Discipline/Class • Admitting/Discharge Service/Treating Specialty

  7. Visit Types I IHS C Contract T Tribal O Other 6 638 V VA S State U Urban P Compact

  8. Service Categories A Ambulatory H Hospitalization I In-Hospital C Chart Review T Telecommunications N Not Found (PHN) S Day Surgery O Observation E Event (Historical) R Nursing Home

  9. Query The query is the primary “building block” of the search. The query consists of four elements: • Subject • Attribute • Condition • Value Q

  10. Query Elements Subject: What you are looking for - Patients, Visits, Register Attribute: A distinguishing characteristic of the subject, demographic or clinical Condition: A logical operator like <, >, = Value: A quantity or state of the attribute

  11. Variations of “Patients” as Subjects Living Patients Case Mgmt. Register Patients Deceased Pts. Subject An Individual Patient Name Males Females Random Sample of Patients Women of Childbearing Age Infants

  12. Demographic Attributes One to One Relationship • Age • Sex • Tribe • Community • Classification • Service Unit of Residence • Blood Quantum • Date of Death • Death Age • Cause of Death • Eligibility • Third Party Enrollment

  13. Conditions Words or symbols used to establish a basis of comparison Condition Synonym Operator • Equals (Is) = • Greater Than (Over) > • Less Than (Under) < • After (Since) • Before • Between (During) • On

  14. Values A quantity or state used with the condition to indicate the status of a particular attribute. • Hypertension • Penicillin • 192 • 4+ • 1:10 • 1/5/88 • Navajo • 1/4 • Tucson • 130/88

  15. Q-Man Query Examples Subject Attribute Condition Value patients diagnosis is hypertension women age over 40 Martin,Lisa hematocrit less than 20 patients tribe is Navajo visit date since 1/1/92 visit provider is Mary Brown females pap null register (DM) HgB A1C over 9.0

  16. Search A search is a series of queries sharing the same subject which are “and’ed” or “or’ed” together. An “Or’ed” Search Mescalero Attribute CommunityRuidoso Alamogordo A hit will be a patient with one of these attribute values * * *Values are always OR’ed together in a search * * *

  17. Search A search is a series of queries sharing the same subject which are “and’ed” or “or’ed” together. An “And’ed” Search Attribute ___Sex___Female and Attribute __Tribe___Apache and Attribute Community_Mescalero A hit will be a patient with all of these attribute values * * * Attributes are always ANDed together in a search * * *

  18. Search A search is a series of queries sharing the same subject which are “and’ed” or “or’ed” together. A combined “And’ed” & “Or’ed” Search Attribute ___Sex___Female and Attribute __Tribe___Apache and Attribute Community_Mescalero or Community_Ruidoso or Community Alamogordo A hit will be a patient with all of these attribute values

  19. Taxonomy A group of related items. Q-Man - A defined set of values. Subject Attribute Condition Value Patient RX Is Penicillin VK 250 mg Tab Penicillin VK 500 mg Tab A “hit” will be registered if the patient has at least one of these values. Q

  20. Taxonomy A group of related items. Q-Man - A defined set of values. Subject Attribute Condition Value Patient Diagnosis Is 250.00-250.93

  21. Taxonomy A group of related items. Q-Man - A defined set of attribute values. Subject Attribute Condition Value Patient Community Is Sault Ste. Marie St. Ignace Dafter Kincheloe A “hit” will be registered if the patient has at least one of these values.

  22. Taxonomy Taxonomies are “owned” by their creator. Taxonomies may be used by anyone. Only the creator can modify / delete a taxonomy Tip: For easy recall, use your initials as the first part of the taxonomy name. eg. GRL DM dx codes Retrieve taxonomy, after selecting the attribute, with special character ( [ ) followed by taxonomy name … eg. [GRL MY SERVICE AREA

  23. Attributes Used Primarily for Display Purposes • Birth Certificate Number • Death Certificate Number • Social Security Number • Tribal Enrollment Number • Mailing Address • Mother’s Name • Secondary Chart Numbers • Home Phone Number • Office Phone Number

  24. Clinical Attributes May be a “one to many” relationship • • Measurements • • Immunizations • • Skin Tests • • Lab Tests • • Exams • • Visits • • Health Factors* • Radiology Exams* • Diagnosis / POV* • Operation / Procedure* • Problems* • Medications* • Patient Education* • Treatments* • CPT codes* • Dental Procedures* * Attribute=category

  25. Clinical Attributes May be a “one to many” relationship Introduced with Qman patch #20 • Refusals • Screening exams Depression Screening Alcohol Screening Intimate Partner Violence

  26. Q-Man Outputs Display Print Count Cohort (Template) SAVE search logic for future use R-MAN special report generator Delimited via screen capture • R-Man special reports • Health Summaries • Age Distribution Report • Mailing Labels • Workload Report • Month Distribution Report • • Export ASCII File to PC

  27. Special Conditions • Sum • At Least n • At Most n • Span (High-Low) • Change (Last-First) • Count • Greatest • Smallest • First n • Last n • New • Average

  28. Very Special Conditions • All (Exists) • Null (Does Not Exist) • Any • Relative Age • Relative Date Q

  29. Visit Attributes • Amount Billed • Diagnosis • Operation • Provider • Date of Visit • Date Entered in PCC • Location (Facility) • Service Category • Clinic

  30. Search Template A cohort of patients who meet all the criteria of the search. This cohort is stored on disk and is available through Q-Man, FileMan, PGEN and VGEN. Search templates have a limited “shelf-life” Tip: For easy recall, begin the name of Search Templates with your initials. eg.: WBM-PTS W/ HIGH AIC VALUES Search templates are useable by anyone, but only their creator can modify/delete. Recall with special ( [ ) character, followed by template name, at attribute prompt. eg. [WBM-PTS W/ HIGH A1C VAULES

More Related