Gaps #86887
Updated by Vasuki Muniratnam 5 months ago
*Description* This report provides the total number of specimens successfully received and recorded in the Central Receiving module within the selected reporting period. The report summarizes specimen receipt volume by Unit, Department, and Source Type, grouped by month based on the Central Receiving Date. *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 | Month/Year 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. The system shall validate: from Month is earlier than or equal to To Month. 4. Selected User must select a valid period does not exceed exceeding 12 months. *Validation Message* Selected reporting period cannot exceed 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! *Business Rules* *BUSINESS RULES* 1. One row represents a unique combination of: Unit 2. Department + Source Type + Specimen Type. 2. 3. When Specimen Type filter = "All": 4. All specimens received under the same Unit, Department and Source Type specimen types shall be aggregated into a single row. displayed as separate rows. 3. 5. Monthly columns shall be dynamically generated based on the selected reporting period. month range. 4. 6. A Total column shall be displayed as the cumulative count across all displayed months. 5. 7. A Grand Total row shall be displayed at the bottom of the report. 6. 8. Maximum reporting period allowed is 12 months. 7. Only specimens successfully received in Central Receiving shall be counted. 8. Cancelled specimen receipts shall not be counted. 9. Rejected specimen receipts shall not be counted. 10. Recollected specimens assigned with a new Specimen Number shall be counted as new specimens. 11. Default sorting shall be by Total Count in descending order. 12. The report grouping shall always be Month (fixed). 13. Monthly totals in the Grand Total row shall equal the sum of all displayed rows for the corresponding month. 14. The Total column shall equal the sum of all displayed monthly columns for that row.