CMI Basic QMan Q Developed by Cimarron Medical
CMI Basic Q-Man Q Developed by: Cimarron Medical Informatics, LLC Tucson, AZ
The RPMS Integrates Multiple Clinical Systems EHR PCC Data Entry Inpatient Patient Registration Laboratory Emergency Room Dental Behavioral Health PCC Patient Database Pharmacy Field Nursing Women’s Health Surgery Radiology Appointment System CHR
PCC Patient Care Component Resource & Patient Management System RPMS and the PCC
Qman 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 agerelated, workload, or monthly distribution reports may be created.
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
PCC Terms • Community • Facility/ Location • Clinic • Visit Type • Service Category • Provider Discipline/Class • Admitting/Discharge Service/Treating Specialty
Visit Types I C T O 6 V S U P IHS Contract Tribal Other 638 VA State Urban Compact
Service Categories A H I C T N S O E R Ambulatory Hospitalization In-Hospital Chart Review Telecommunications Not Found (PHN) Day Surgery Observation Event (Historical) Nursing Home
Query The query is the primary “building block” of the search. The query consists of four elements: • Subject • Attribute Q • Condition • Value
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
Variations of “Patients” as Subjects Living Patients Case Mgmt. Register Patients An Individual Patient Name Deceased Pts. Subject Random Sample of Patients Women of Childbearing Age Males Females Infants
Demographic Attributes One to One Relationship • Age • Blood Quantum • Sex • Date of Death • Tribe • Death Age • Community • Cause of Death • Classification • Eligibility • Service Unit • Third Party Enrollment of Residence
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 • On (During)
Values A quantity or state used with the condition to indicate the status of a particular attribute. • 1/5/88 • Hypertension • Navajo • Penicillin • 1/4 • 192 • Tucson • 4+ • 130/88 • 1: 10
Q-Man Query Examples Subject Attribute Condition Value patients women Martin, Lisa patients visit females register (DM) diagnosis age hematocrit tribe date provider pap Hg. B A 1 C is over less than is since is null over hypertension 40 20 Navajo 1/1/92 Mary Brown 9. 0
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 Community Ruidoso Alamogordo A hit will be a patient with one of these attribute values * * *Values are always OR’ed together in a search * * *
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 * * *
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
Taxonomy A group of related items. Q-Man - A defined set of values. Subject Attribute Patient RX A “hit” will be registered if the patient has at least one of these values. Condition Is Value Penicillin VK 250 mg Tab Penicillin VK 500 mg Tab Q
Taxonomy A group of related items. Q-Man - A defined set of values. Subject Attribute Condition Value Patient Diagnosis Is 250. 00 -250. 93
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.
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
Attributes Used Primarily for Display Purposes • Mailing Address • Birth Certificate Number • Mother’s Name • Death Certificate Number • Secondary Chart Numbers • Social Security Number • Home Phone Number • Tribal Enrollment Number • Office Phone Number
Clinical Attributes May be a “one to many” relationship • Measurements • Diagnosis / POV* • Immunizations • Operation / Procedure* • Skin Tests • Problems* • Lab Tests • Medications* • Exams • Patient Education* • Visits • Treatments* • Health Factors* • CPT codes* • Radiology Exams* • Dental Procedures* * Attribute=category
Clinical Attributes May be a “one to many” relationship Introduced with Qman patch #20 • Refusals • Screening exams Depression Screening Alcohol Screening Intimate Partner Violence
Q-Man Outputs Display R-Man special reports Print • Health Summaries Count • Age Distribution Report Cohort (Template) • Mailing Labels SAVE search logic for future use • Workload Report R-MAN special report generator • Export ASCII File to PC Delimited via screen capture • Month Distribution Report
Special Conditions • Greatest • Sum • Smallest • At Least n • First n • At Most n • Last n • Span (High-Low) • New • Change (Last-First) • Average • Count
Very Special Conditions • All (Exists) • Null (Does Not Exist) • Any • Relative Age • Relative Date Q
Visit Attributes • Date of Visit • Amount Billed • Date Entered in PCC • Diagnosis • Location (Facility) • Operation • Service Category • Provider • Clinic
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, File. Man, 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 A 1 C VAULES
- Slides: 30