1 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Verification flags

In the TAXON_OCCURRENCE and DETERMINATION_TYPE tables there is a VERIFIED field that has a value of 0, 1 or 2, which I gather loosely stands for Unverified, Invalid and Verified respectively.

Is this correct?

Is there a reason the VERIFIED field in DETERMINATION_TYPE is a tinyint and the one in TAXON_OCCURRENCE is a smallint?

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Verification flags

Hi Charles,
I doubt there is a good reason, most likely a difference that got copied through from MS Access when the software migrated from Access to SQL Server. They should both really be tinyint though it would only save 1 byte per occurrence.
Best Wishes

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Verification flags

The values of the Verified flag mean:
0 - Not verified
1 - Failed/pending verification
2 - Passed verification
This text is displayed in blue at the bottom of the General tab of taxon and biotope occurrences. For details of how the flag is set see Verification of identifications under the heading Significant changes in Recorder 6 version 6.13 on the opening page of the Recorder 6 help. Observations flagged as Failed/pending verification are excluded from reports unless users override the default in the report wizard.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

4 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Verification flags

Thanks Sally.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website