Opened 7 years ago

Closed 7 years ago

#438 closed enhancement (fixed)

Overview report

Reported by: olle Owned by: olle
Priority: major Milestone: Reggie v2.10
Component: net.sf.basedb.reggie Keywords:
Cc:

Description (last modified by olle)

The reggie report generator should be updated to include an overview report. The report should include the current numbers for each site:

  1. Number of patients
  2. Number of blood samples
  3. Number of specimens
  4. Number of no specimens
  5. Number of approved consent
  6. Number of missing consent

Number of approved consents should include consents without patient id (PAT#) or date.

In addition, an extra table should report different kinds of patient records:

  1. Number of patients with blood samples only
  2. Number of patients with specimens only
  3. Number of patients with no specimens only
  4. Number of patients with both blood samples and specimens
  5. Number of patients with both blood samples and no specimens
  6. Number of patients with both specimens and no specimens
  7. Number of patients with both blood samples, specimens, and no specimens

Change History (7)

comment:1 Changed 7 years ago by olle

Status: newassigned

Ticket accepted.

comment:2 Changed 7 years ago by olle

Traceability note:

  • The report generator was introduced in Ticket #339 (Report generator). It included a sample count report.
  • The sample count report was updated in Ticket #419 (Allow user to select resolution in sample count report), Ticket #420 (Sample count report should have two columns for summed data), and Ticket #421 (Sample count report does not always handle all views correctly).
  • The report generator was updated to include a consent count report in Ticket #426 (Consent count report generator). It was updated in Ticket #430 (Consent count report should allow time period selection).
  • The general layout of the reports was updated in Ticket #428 (Reports should have sites in alphabetic order and a column with latest item dates).
  • The report generator was updated to include a patient count report in Ticket #433 (Patient count report generator).

comment:3 Changed 7 years ago by olle

Design discussion.

Previous reports all used sample queries with various restrictions:

  • Patient count: Subtypes SPECIMEN, NO_SPECIMEN, or BLOOD
  • Blood sample count: Subtype BLOOD
  • Specimen count: Subtype SPECIMEN
  • Consent count: Subtypes BLOOD or CASE

It should therefore be possible to acquire all data needed for the overview report by using a sample query for subtypes SPECIMEN, NO_SPECIMEN, BLOOD, or CASE.

Last edited 7 years ago by olle (previous) (diff)

comment:4 Changed 7 years ago by olle

Description: modified (diff)

Ticket description updated to include two tables in the report.

comment:5 Changed 7 years ago by olle

Description: modified (diff)

Ticket description updated by clarifying text.

comment:6 Changed 7 years ago by olle

Design description.

  • JSP script samplereportgenerator in reggie/resources/ will have the design for the layout of the overview report based on that of the consent count report, since both contain two main tables, where the columns do not represent time intervals. However, unlike the consent count report, the main table of the overview report has columns representing different kinds of items, making percentage values uninteresting.
  • Servlet SampleReportServlet in reggie/src/net/sf/basedb/reggie/servlet/ will perform a database sample query for subtypes SPECIMEN, NO_SPECIMEN, BLOOD, or CASE, and then process the result to obtain values for the report.
  • The date for latest update for each site and for all sites combined will be based on the latest update of any item in the table, irrespective of type, e.g. patient, blood sample, specimen, no specimen, or consent.
  • The first version of the report will not keep special track of the latest update of patient records, so the second table showing patient records of different kinds, will not contain a column for latest date the data was updated, and neither will the date for latest update of any patient record.

comment:7 Changed 7 years ago by olle

Resolution: fixed
Status: assignedclosed

(In [1765]) Fixes #438. First version of overview report added.

Note: See TracTickets for help on using tickets.