Gaps #93952
Updated by Vasuki Muniratnam 5 months ago
*Description:* To generate the percentage of resistant isolates for selected organisms and antibiotics within a specified period.
*Step to reproduce:*
1. Login to Medcare
2. Navigate to MIS Report> Lab Report> List of Reports
3. Create new report tittle: Resistance Pattern Report
4. The system shall provide search filters for Date Range, Unit, Ward, Specimen Type, Source Type, and Organism. Users may select a single organism, multiple organisms, or all organisms before generating the Resistance Pattern Report.
| *Field* | *Control Type* | *Mandatory* |
| From Date | Date Picker | Yes |
| To Date | Date Picker | Yes |
| Unit | Dropdown | Optional |
| Ward | Dropdown | Optional |
| Specimen Type | Multi Select (Searchable) | Optional |
| Source Type | Multi Select (Searchable) | Optional |
| Organism | Single/ Multi Select/ All (Searchable) | Optional |
*Note: User may select single / multiple or all organisms.
5. Based on the formula given below, generate the report
Formula:
*Resistance % = (Number of Resistant Isolates / Total Isolates Tested) × 100*
Where:
1. Total Isolates Tested = Total number of susceptibility results recorded for the same Organism and Antibiotic combination within the selected filters.
2. Number of Resistant Isolates = Total number of results with Interpretation = 'R' (Resistant).
*Conditions:*
1. Retrieve all antibiotics used within selected date range.
2. The report shall display the following information:
>Organism
>Antibiotic
>Total Tested
>Resistant Count
>Resistance Percentage (%)
3. The system shall automatically determine the antibiotics tested for the selected organism(s). No antibiotic selection is required on the search screen.
*Sample Expected Report layout is shown below:*
!clipboard-202606081147-p7gwt.png!