Gaps #87143
Updated by Vasuki Muniratnam 5 months ago
*MIS REPORT* *Report Name:* Dominant Organism Analysis Report *Search Criteria* | Filter | Control | Remarks | | Unit | Dropdown | Default value: Hospital Universiti Malaysia Sabah (HUMS). Data shall be retrieved based on the selected unit. | | Ward | Dropdown | Populate ward list based on patient ward/location master. Include "All" option.Searchable. | | From Collection Date | Date Picker | Culture specimen collection start date. | | To Collection Date | Date Picker | Culture specimen collection end date. | | Specimen Type | Multi-select Dropdown | Populate from Microbiology Specimen Type Master. Include "All" option. Searchable | | Source Type | Multi-select Dropdown | Populate based on patient encounter category (ER, Inpatient, Outpatient, Day Care). Include "All" option. | | Bacteria | Optional Search | Optional searchable field to filter by identified organism/bacteria name. | | Show Report | Button | Generate report based on selected criteria. | Screen Layout: !clipboard-202606031538-zpjj1.png! *Output Grid* | Bacteria | Specimen Type | Source Type | Unit | Ward |No. of Isolates | Sample output grid image: !clipboard-202606031609-qnelu.png! *Sorting* Default sorting: No. of Isolates: DECREASING ORDER (Highest Highest isolate count appears first.) first. ### Number of Isolates Report *Data Inclusion Criteria* *Calculation Logic:* Only 1. Step 1 : Retrieve all finalized positive microbiology culture results shall be included in within the report. selected: i) Collection Date range ii) Ward iii)Specimen Type iv) Source Type v) Bacteria The report shall include 2. Step 2 Exclude: Negative cultures No growth cultures Contaminated cultures Pending cultures *Include only culture results cultures with an identified organism. organisms.* *Data Exclusion Criteria* 3. Step 3 The following *Isolate Counting Rule*: a.) Only finalized positive culture results shall be excluded from included in the report: * Negative report. b.) Each positive culture result shall be counted as one isolate. c.) If the same patient has multiple positive cultures for the same organism and specimen type on d.) the SAME collection date, it shall be counted as one isolate only. * No Growth e.) If the same patient has positive cultures for the same organism and specimen type on f.) DIFFERENT collection dates, each occurrence shall be counted as a separate isolate. * Pending g.) Positive cultures from different specimen types shall be counted as separate isolates even when collected on the same collection date. *1.) Same patient + same organism + same specimen type + same collection date = Count once * No Organism Seen * No Fungal Elements Seen *2.) Same patient + same organism + same specimen type + different collection date = Count separately * Growth In Progress – Pending Identification * No Growth After 5 Days of Incubation * So Far No Growth After 5 Days of Incubation * So Far No Growth After Step 4 Days Calculation of Incubation * So Far No Growth After 3 Days Number of Incubation Isolates * So Far No Growth After 48 Hours of Incubation Only finalized positive culture results shall be included. * So Far No Growth After 24 Hours of Incubation * No Significant Growth, Normal Flora * No Pathogen Isolated * Non-Significant Pathogen Isolated * No Enterobacteriae Pathogen Isolated * No Salmonella, Shigella or Vibrio Isolated * No Vibrio Cholerae Isolated *Isolate Definition* A unique isolate shall be identified based on the combination of: * on: Patient * Organism Name * Specimen Type * Collection Date The following rules shall apply: * Multiple positive culture results for the same patient, organism, specimen type, and collection date shall be counted as one (1) isolate. * Positive culture results for the same patient, organism, and specimen type collected on different collection dates shall be counted as separate isolates. * Positive culture results from different specimen types The report shall be counted as separate isolates, regardless calculate the Number of collection date. *Calculation Formula Isolates by grouping identified isolates based on: Organism Name Specimen Type Source Type Ward * **Number Results shall be displayed in descending order of Isolates = Total Count Number of Isolates. First, Identify Unique Isolates** Isolates Where: **Unique Isolate = *Group by:* Patient + Organism Name Bacteria + Specimen Type + Collection Date** Date *Report Output* The After unique isolates are identified, generate the report shall display the Number of Isolates summarized by: * by grouping: Organism Name * + Specimen Type * + Source Type * + Ward Results shall be displayed Then, Count Isolates Sort by, No of isolates, in descending order based on the Number of Isolates. Sample output grid image: !clipboard-202606031609-qnelu.png! Decreasing Order.