Opened 12 years ago

Last modified 12 years ago

#438 closed enhancement

Overview report — at Version 4

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#) and 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 (4)

comment:1 by olle, 12 years ago

Status: new → assigned

Ticket accepted.

comment:2 by olle, 12 years ago

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 by olle, 12 years ago

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 12 years ago by olle (previous) (diff)

comment:4 by olle, 12 years ago

Description: modified (diff)

Ticket description updated to include two tables in the report.

Note: See TracTickets for help on using tickets.