Overview report

[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

[olle]

Ticket accepted.

[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).

[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.

[olle]

Ticket description updated to include two tables in the report.

[olle]

Ticket description updated by clarifying text.

[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.

[olle]

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