AAFC-BICoE / dina-planning

AAFC-DINA planning repository
3 stars 2 forks source link

Types of reports needed for the management of living collections #348

Open banchinic opened 2 years ago

banchinic commented 2 years ago

At our last meeting on November 3rd 2022 I was asked to come up with a list of the kinds of reports that we want the system to generate.
Here are my first thoughts for CCAMF but I will probably add more once we start a discussion about reports. Also note that these are not a wish list but questions we get asked all the time from management / collaborators and have to report on each year.

Please @rintoult @RanahanE @ron-reade add what is missing for your collections.

Reports needed for CCAMF • How many Material Samples were created between X date and X date for each collection (in vitro/ in vivo) • Names of Genus + Species and numbers of material samples of each currently cultivated (shown separately for what is in greenhouse and stored in vials) need to differentiate between stored soil samples and specimens in the greenhouse. Would work if filtered by containers (ie greenhouse and the fridge where the vials are sorted) • Origin (Country, Province, Region) of material samples currently cultivated (in greenhouse and stored in vials) • Origin of material samples AND the genus + species currently cultivated (in greenhouse and stored in vials) these 2 reports show how useful it would be to be able to place material samples on a map • How many requests for material samples we got between X date and X date • Names of genus + species of the requests for material samples we got between X date and X date • Strains (DAOM number or Collection ID) of the requests for material samples we got between X date and X date • How many total vials where sent for the requests for material samples we got between X date and X date • How many different clients requested vials between X date and X date • Report on origin of the requests we got for vials (where the customer was located (which Country)) • How many DNA extractions were made between X date and X date • How many sequences were generated between X date and X date • How many pictures were added to the CCAMF collection between X date and X date

rintoult commented 2 years ago

I agree with all of what Claudia states above. Also I wonder if reports, is also the function that would provide us with prettily laid out summaries of specimen information for us to share with clients ordering material from us. Example attached from our Access Requests and Deposits database. R2022-044_FORM LETTER SPECIMEN LIST Requests.pdf