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.