Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#581 closed enhancement (fixed)

Monthly operation list export should only include patients in region "RCC syd"

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

Description (last modified by olle)

Monthly operation list export should only include patients in region "RCC syd" (Regionalt Cancercentrum syd), since the operation lists are sent to the latter. For practical reasons and confidentiality concerns, RCC syd should only receive information on patients within its jurisdiction.

Change History (9)

comment:1 Changed 7 years ago by olle

Status: newassigned

Ticket accepted.

comment:2 Changed 7 years ago by olle

Background information:

"RCC syd" is an abbreviation of "Regionalt Cancercentrum syd" ("Regional Cancer Center - south"), which manages information on cancer patients in southern Sweden.

comment:3 Changed 7 years ago by olle

Traceability note:

  • The monthly operation list export was introduced in Ticket #385 (Export information needed by the tumor registry).
  • The list was updated in Ticket #386 (Qiacube/nanodrop wizard).
  • The list was updated in Ticket #397 (Add option to export item subtype in the monthly operation list).
  • The list was updated in Ticket #398 (Add option to export the monthly operation list for a full year).
  • The list was updated in Ticket #416 (Check consent before exporting "monthly operation list").
  • The list was updated in Ticket #431 (Add option for exporting PAT-id in the montly operation list).
  • The list was updated in Ticket #432 (The monthly operation list should include column headers).
  • The list was updated in Ticket #486 (Monthly operation list export should not have optional columns).

comment:4 Changed 7 years ago by olle

Design background:

A case number starts with a two-letter prefix string, that identifies the site, the patient belonged to, when samples/information were sent to the project/study. Historically, the prefix has always been a two-figure code for known sites (An "Unknown" site is also defined for report purposes), but there is no guarantee that this will be true in future updates. The sites are defined in Java class/file Site.java in reggie/src/net/sf/basedb/reggie/, which contains information on site prefix, name, and start date for inclusion in the project/study, but not whether the site belongs to "RCC syd" or not. Currently, the sites included in the project/study are as follows:

Prefix Site name Start date Belongs to "RCC syd"
11 Lund 2010-11-10 Yes
22 Helsingborg 2010-11-01 Yes
33 Halmstad 2010-10-01 Yes
44 Kristianstad 2010-09-15 Yes
55 Karlskrona 2010-10-04 Yes
66 Växjö 2010-10-01 Yes
77 Malmö 2010-08-30 Yes
88 Uppsala 2013-10-01 No

The monthly operation list export is managed by JSP script export_monthly_oplist.jsp in reggie/resources/personal/ and java servlet ExportServlet.java in reggie/src/net/sf/basedb/reggie/servlet/.

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

comment:5 Changed 7 years ago by olle

Description: modified (diff)
Summary: Monthly operation list export should only include patients in region "RSS syd"Monthly operation list export should only include patients in region "RCC syd"

Typo ("RSS syd" instead of "RCC syd") in ticket description corrected.

comment:6 Changed 7 years ago by olle

Design discussion:

Currently there are no plans for sending monthly operation lists to other regions than "RCC syd". The desired list can therefore be obtained by only including sites belonging to the latter region. Java servlet ExportServlet.java in reggie/src/net/sf/basedb/reggie/servlet/ constructs the monthly operation list and should be updated to only include sites belonging to "RCC syd".

Possible solutions:

  1. Java servlet ExportServlet.java in reggie/src/net/sf/basedb/reggie/servlet/ could be updated with a local list of what sites belong to region "RCC syd". This would restrict the operative changes to a single class, but has the problem that the servlet would need to be updated, if a new site belonging to region "RCC syd" should be included in the project/study.
  2. Class/file Site.java in reggie/src/net/sf/basedb/reggie/ could be updated to include a boolean flag, indicating whether the site is part of "RCC syd", or not. The flag would then be set when a new site is included, and there would be no need to update more than this class/file. This is the solution that was chosen.

In addition, JSP script export_monthly_oplist.jsp in reggie/resources/personal/ should be updated to display a note, that only patients belonging to "RCC syd" will be included in the generated list.

comment:7 Changed 7 years ago by olle

(In [2250]) Refs #581. Monthly operation list export updated to only include patients for sites belonging to "RCC syd" (Regionalt Cancercentrum syd) in the list:

  1. JSP script export_monthly_oplist.jsp in reggie/resources/personal/ updated to display a note, that only patients for sites belonging to "RCC syd" will be included in the generated list.
  2. Class/file Site.java in reggie/src/net/sf/basedb/reggie/ updated with a new boolean flag attribute partOfRCC_syd, indicating whether the site is part of "RCC syd", or not.
  3. Java servlet ExportServlet.java in reggie/src/net/sf/basedb/reggie/servlet/ updated to only include sites, for which the new flag attribute partOfRCC_syd has value true.

comment:8 Changed 7 years ago by olle

Resolution: fixed
Status: assignedclosed

Ticket closed since the requested changes have been added.

comment:9 Changed 7 years ago by olle

Milestone: Reggie v2.16Reggie v2.15

Ticket description updated by changing milestone from Reggie v2.16 to Reggie v2.15.

Note: See TracTickets for help on using tickets.