Detected will be added as a single checkbox field to the Visit grid in the Source Feature record, with a default value of Yes. 

Previous feedback (Forum topics, mockup webinar, Data Backlog working group) suggests that some programs currently record negative data in Biotics. This is to notify you to review your data for any records which should have a value of 'No' in the Detected field. 


Assuming you do indeed have SFs with >1 Visits, make a list of the VISIT_IDs which will need their value changed. Create a spreadsheet with a single VISIT_ID per row, or a comma-delimited list of VISIT_IDs, to facilitate updating the values when appropriate via a single SQL statement.


Attached is guidance, developed by Karen Cieminski (MN) and Jodi Shippee (VT), for identifying data in the Visit grid which should be populated with a Detected value = 'N' and instructions on how to do so via SQL scripts.


From Florida:

Most of the time it will be that last visit (max visit date) that is the failed to find so that’s one way programs could make the change. 

 

In FL we have an extensible field that ranks each SF as either extant, failed to find, or extirpated.  I imagine I’ll make the change by selecting the visit with the max date for each of the failed to find/extirpated and then skimming the visit notes to make sure that they do indeed have a not found visit recorded.