Hi
I can see the new CEH checklist, but I have an issue with the newly added BSBI England Red List statuses:
SELECT Index_Taxon_Designation.Taxon_List_Item_Key, Index_Taxon_Designation.Taxon_Designation_Type_Key, TAXON_DESIGNATION_TYPE.Status_Abbreviation
FROM Index_Taxon_Designation INNER JOIN
TAXON_DESIGNATION_TYPE ON Index_Taxon_Designation.Taxon_Designation_Type_Key = TAXON_DESIGNATION_TYPE.TAXON_DESIGNATION_TYPE_KEY
WHERE (Index_Taxon_Designation.Taxon_List_Item_Key = 'NHMSYS0020519614')
returns the following for Lady's Slipper Orchid:
Taxon_List_Item_Key Taxon_Designation_Type_Key Status_Abbreviation
NHMSYS0020519614 NBNSYS0000000017 WCA8
NHMSYS0020519614 NBNSYS0000000059 Bern1
NHMSYS0020519614 NBNSYS0000000063 HSD2p
NHMSYS0020519614 NBNSYS0000000064 HSD4
NHMSYS0020519614 NBNSYS0000000089 CITESB
NHMSYS0020519614 NBNSYS0100000012 NR-excludes
NHMSYS0020519614 NBNSYS0100000013 Sect.41
NHMSYS0020519614 NBNSYS0100000021 HabRegs5
NHMSYS0020519614 NHMSYS0020443050 UKBAP
NHMSYS0020519614 NHMSYS0020443053 RLGB.CR
NHMSYS0020519614 NHMSYS0021177873 RLENG.CR - here is the England Red List status
So the status info is there, the only thing that is missing is an entry for the Taxon_Designation_Type_Key NHMSYS0021177873 in the Taxon_Designation_Set_Item table as the following returns nothing:
SELECT Taxon_Designation_Set_Item_Key, Taxon_Designation_Set_Key, Taxon_Designation_Type_Key, Entered_By, Entry_Date, Changed_By, Changed_Date,
System_Supplied_Data, Custodian
FROM NBNData.dbo.Taxon_Designation_Set_Item
WHERE (Taxon_Designation_Type_Key = 'NHMSYS0021177873')
I'm on R6.26.2.286 which is supposed to be compatible with the latest dictionary update but it looks as though it didn't populate the Taxon_Designation_Set_Item table with the new BSBI statuses, making them impossible (without editing a table in SQL Server) to use from the R6 report wizard and dbo.ufn_GetDesignations SQL function.
Thanks
Ian