Background
BMMRO need to be able to add specimen records to a biopsy record within the biopsy form. When a biopsy is taken, the material could make up skin or skin and blubber. The individual specimens are sectioned off and stored separately. BMMRO must ensure their specimen samples are stored appropriately and corresponding records are kept.
Acceptance Criteria
AC1: section header & button
given I am logged in to the BMMRO app
when I am viewing a biopsy record in the biopsy form
then I need to see a Specimen section with a button - "add specimen record"
AC2: add specimen row on button press
given I am logged in to the BMMRO app
when I am viewing a biopsy record in the biopsy form
and I click the add new specimen button (AC1)
then a specimen record row is added to the specimen section above any previously added records (the most recent should be at the top). Each row should have a Specimen #, Tissue type, and tissue storage field
Specimen # = free text (max length 20)
Tissue type = dropdown. Options = skin, skin/blubber
Tissue store = dropdown. Options = DMSO/NaCI, -80, -20
the tissue type drop down should have the options
and it should default to -- in the same way as other dropdowns on other forms
the tissue store drop down should have the options
and it should default to -- in the same way as other dropdowns on other forms
AC3: save button & commit to firebase
given I am logged in to the BMMRO app
when I am viewing a biopsy record in the biopsy form
and I can click a save button on the biopsy form
then firebase is updated
and I taken back to the Habitat Use screen
AC4: create specimens csv
given I am logged in to the BMMRO app
when I am exporting data from the app for import to MS Access
then I can see details of the specimens taken in a csv with the below fields populated:
This AC is dependent on later tickets (ie where the field is not yet in the biopsy form). The expectation is this story should create the specimen csv with all available fields, namely:
Sample #,
Specimen #,
Tissue Type,
Storage,
then from the biopsy form:
Species,
Sequence,
Date,
Time,
Area,
Attempt,
Lat,
Long
The field called Collection Type should be populated with the text "Biopsy"
Mapping below
AC5: add Sample # field to Biopsy Details section
given I am logged into the BMMRO app
when I am in the biopsy form
then I can see a field called "Sample #" within the Biopsy Details section
and I can no longer see a field called "Total Specimens" in the Biopsy Details section.
Specimen # should take the place of the "Total Specimens" field
Out of scope
Assumptions
To be clarified with Charlotte:
is there a relationship in the MS Access DB between samples and biopsy records?
YES. There is a relationship but this is not enforced in the database. The relationship does exist in the data between the 2 tables. The link between a biopsy and the related Specimens is the "Sample #"
do specimens in the biopsy form need to be written to the "Samples" table in MS Access?
**Yes. Write to Samples table. The 4 fields from the specimen section (Sample #, Specimen #, Tissue Type and Storage) should populate the samples table. Everything else for the samples table comes from the Biopsy record itself (this is duplicated data unfortunately)
do we need to capture a "Sample #" on the biopsy form in order to maintain a 1-M relationship between biopsy record and the associated specimens?
njktw
commented
2 years ago
Background BMMRO need to be able to add specimen records to a biopsy record within the biopsy form. When a biopsy is taken, the material could make up skin or skin and blubber. The individual specimens are sectioned off and stored separately. BMMRO must ensure their specimen samples are stored appropriately and corresponding records are kept.
Acceptance Criteria AC1: section header & button given I am logged in to the BMMRO app when I am viewing a biopsy record in the biopsy form then I need to see a Specimen section with a button - "add specimen record"
AC2: add specimen row on button press given I am logged in to the BMMRO app when I am viewing a biopsy record in the biopsy form and I click the add new specimen button (AC1) then a specimen record row is added to the specimen section above any previously added records (the most recent should be at the top). Each row should have a Specimen #, Tissue type, and tissue storage field
the tissue type drop down should have the options
and it should default to -- in the same way as other dropdowns on other forms
the tissue store drop down should have the options
and it should default to -- in the same way as other dropdowns on other forms
AC3: save button & commit to firebase given I am logged in to the BMMRO app when I am viewing a biopsy record in the biopsy form and I can click a save button on the biopsy form then firebase is updated and I taken back to the Habitat Use screen
AC4: create specimens csv given I am logged in to the BMMRO app when I am exporting data from the app for import to MS Access then I can see details of the specimens taken in a csv with the below fields populated:
This AC is dependent on later tickets (ie where the field is not yet in the biopsy form). The expectation is this story should create the specimen csv with all available fields, namely:
then from the biopsy form:
Mapping below
AC5: add Sample # field to Biopsy Details section given I am logged into the BMMRO app when I am in the biopsy form then I can see a field called "Sample #" within the Biopsy Details section and I can no longer see a field called "Total Specimens" in the Biopsy Details section.
Specimen # should take the place of the "Total Specimens" field
Out of scope
Assumptions To be clarified with Charlotte:
CFRs