Gaps #86887
Updated by Vasuki Muniratnam 5 months ago
*Report Tittle:* Specimen Receipt Statistics Report | *Filter* | *Control* | | Unit | Dropdown | | Department | Multi-select Dropdown (Searchable) | | Source Type | Multi-select Dropdown (Searchable) | | Specimen Type | Multi-select Dropdown (Searchable) | | From Month Date - To Month Date | Date Picker | | Group By | Fixed (Month) Dropdown (Day / Week / Month) | *The reporting period shall be determined based on the *From Date - To Date: Choose from Central Receiving Date (the date the (when laboratory successfully received the specimen). Monthly counts displayed in the report are grouped according to this Central Receiving Date. *Validation:* 1. Maximum date range allowed: 12 months. 2. Date selection is based on Central Receiving Date. 3. User must select a valid period not exceeding 12 months. specimen) *Output Grid:* | No | Sub Department | Source Type | Specimen Type | Jan-25 No. of Specimens Received | Feb-25 | Mar-25 | Apr-25 | ... | Dec-25 | Total | *Sorting* Default sorting: Highest No. of Specimens Received (Descending) (Highest specimen count shall appear first. appears first.) *Definition of Number of Specimens Received* Number of Specimens Received refers to the total number of specimens that have been successfully received and recorded in the Central Receiving module within the selected date range and report criteria. If a single request contains multiple specimens, each specimen shall be counted individually. *Exclusion Criteria* Cancelled or rejected specimen receipt records shall be excluded from the report. Only successfully received specimens recorded in the Central Receiving module shall be counted. *Note:* > Recollected Specimens Recollected specimens that are assigned a new Specimen Number and successfully received in Central Receiving shall be counted as new specimens. *Expected Sample Report* *Sample Output Format* !clipboard-202606100857-3cb3x.png! (Follow the same report layout/design as the current MIS reports, similar to the Dominant Organism report sample.) *BUSINESS RULES* 1. One row represents a unique combination of: 2. Department + | No |Department | Source Type + | Specimen Type. 3. When Specimen Type filter = "All": | No. of Specimens Received | 4. All specimen types shall be displayed as separate rows. | 1 | Hematology | Inpatient | Blood | 2,350 | 5. Monthly columns shall be dynamically generated based on the selected month range. | 2 | Biochemistry | Outpatient | Serum | 1,920 | 6. A Total column shall be displayed as the cumulative count across all displayed months. | 3 | Microbiology | Inpatient | Urine | 1,450 | 7. A Grand Total row shall be displayed at the bottom of the report. | 4 | Histopathology | Referral | Tissue | 780 | 8. Maximum reporting period allowed is 12 months. | 5 | Cytology | Outpatient | Cytology Smear | 520 | !clipboard-202606091632-gupeo.png!