Define roa information mapping

[ruegenbfr]

Clarify roa report information mapping.

Label composition of the different roa entities:

Label for Confidential station:

: Label for Public station Label for a confidential lot: Label for a public lot: Label for a non station sample: Label for a station sample Label for case: ? Label for lot in case: ? ### Where are the above mentioned properties coming from: **station.activities** : use column 'typeOfBusiness' from stations table. **station.ctno** ? Proposal: Symbol assignment from the web app. The Symbols are sequentially assigned according to there reading order (top-down, left right) like in the excel column naming ("A", "B",...,"Z","AA","AB",...,"BZ","BB",...). **station.FBO** ? Proposal: from column 'Name' of station table **product.commonProductName** ? Proposal: from column 'Name' of delivery table **product.brandName** : use column 'brandName' of deliveries table. **lot.identifier** ? Proposal: from column 'Lot ID' of delivery table **lot.quantity** ? Proposal: from column 'lotQuantity' of delivery table **lot.durability** ? Proposal: from column 'lotDurability' of delivery table **dateOfConsumption** ? **sample.type** ? Proposal: from column 'type' of sample table **sample.amount** ? Proposal: from column 'amount' of sample table **sample.material** ? Proposal: from column 'material' of sample table **sample.result** ? Proposal: from column 'result' of sample table **sample.time** ? Proposal: from column 'time' of sample table ###Other properties: **sample.resultType** ? Proposal: from column 'resultType' of sample table (Element of {Confirmed, Negative, Probable}) **sample.station** ? Proposal: from column 'sampleStation' of table samples (!It has to be defined how the mapping to a station needs to be done, Proposal: station.name == sample.station) **sample.lot** ? Proposal: from column 'sampledLot' of table samples (It has to be defined how the mapping to a lot needs to be done) ### Other things: The labels for case boxes are still undefined. The case relations to stations are still undefined.

[draaw]

station.activities is missing - please use focusStationChain product.brandName is missing - please use brandName lotQuantity - does not work

[ruegenbfr]

Change: focusStationName to typeOfBusiness