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

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

[olle]

Ticket accepted.

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

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

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

[olle]

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

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

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

[olle]

Ticket closed since the requested changes have been added.

[olle]

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