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 - To Month | Date Picker | | Group By | Fixed (Month) | *The reporting period shall be determined based on the Central Receiving Date (the date the 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. *Output Grid:* | No | Department | Source Type | Specimen Type | Jan-25 | Feb-25 | Mar-25 | Apr-25 | ... | Dec-25 | Total | *Sorting* Default sorting: Highest specimen count shall appear first. *Definition of Number of Specimens Received* Number of Specimens Received refers to the total number of specimens 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* !clipboard-202606100946-1ssyy.png! !clipboard-202606100857-3cb3x.png! *BUSINESS RULES* 1. One row represents a unique combination of: 2. Department + Source Type + Specimen Type. 3. When Specimen Type filter = "All": 4. All specimen types shall be displayed as separate rows. 5. Monthly columns shall be dynamically generated based on the selected month range. 6. A Total column shall be displayed as the cumulative count across all displayed months. 7. A Grand Total row shall be displayed at the bottom of the report. 8. Maximum reporting period allowed is 12 months.