Suspect Data

I'd like to monitor what's going on with my collection. How can I do that?

Loan and Permit reminders are emailed to the listed contacts at 1 year, 6 months, 1 month, and upon the permit expiring or the loan becoming due. Any agent with an email address may act as a contact.

The following are available under the Management/Misc tab:

  • Publication Staging is a way to quickly capture very basic information about possible Citations in Arctos. Curators should periodically review and update the information in this form.
  • Management/Misc/Sync parent/child taxonomy finds specimens in a Parent Of/Child Of relationship which do not share current Identification, and provides a means to synchronize them.
  • Merge Dup Agents provides a means to reconcile agents in relationship "bad duplicate of".
  • Pending Relationships provides access to those cataloged item relationships created during Data Entry which have not been successfully formalized. Curatorial action is required for anything in this list.
The following are available under the Reports tab:
  • GenBank MIA is a script that periodically crawls GenBank looking for sequences that may be related to Arctos specimens and which do not already have an Arctos LinkOut (newly-linked may continue to appear in the table for a few days).
    • Query type specimen_voucher:collection are GenBank sequences with which the collector has submitted a properly-formatted link to GenBank, and are almost certainly accurate.
    • Other query types are various guesses, and may or may not accurately resolve to specimens.
  • Annotations are user-submitted annotations. The data quality contact (which may be set under Manage Collections) should also receive notification when annotations are filed.
  • Loan/Citation Stats summarizes loans by the borrower, loan status, number of citations against specimens which were loaned, and cited versus current Identification. Citations must be individually examined to determine from which loan they originated. Citation Counts may reflect repeated usage of individual specimens.
  • Audit SQL contains all UPDATE, DELETE, or INSERT statements, including those which were subsequently rolled back (e.g., due to constraint violations).
  • Oracle Roles is a summary of users by assigned roles. Curators should monitor this, particularly the collection roles (e.g., UAM_MAMM) to ensure that only authorized persons have access to their collections.
  • Funky Data/Suspect Data has several sub-options:
    • Publications without Authors should always find nothing.
    • Publications without Citations may find publications which do not properly cite specimens. This usage may still be reflected in a Project.
    • Projects with Loans and without Publications may require followup with the borrower. Note that Publications may now include things like class reports, dissertations, and brochures.
    • Loans without Specimens are probably legacy or incomplete loans and may not be effectively used to demonstrate collection usage.
  • Funky Data/Partless Specimens finds specimens which have zero specimen parts. Only observations should be in this list; all other cataloged items should have at least one part, even if that part has a disposition of "missing" or "used up."
  • Funky Data/Messy Taxonomy allows searching taxonomy by many criteria to identify various problems.
  • Funky Data/Catalog Number Gaps finds unused catalog numbers. There are no technical problems with nonsequential catalog numbers; this is purely an informational form.