Hi Tony

It could be because there are two 'Galium pumilum' species in the BRC Coded Checklist.

One is the species entry, which points to the preferred list 'VASCULAR PLANTS AND STONEWORTS BSBI List of British & Irish Vascular Plants and Stoneworts' as the recommended entry and does have the s41 status (and others).

The other is the sens. lat. entry, which points to the preferred list 'List of additional names' as the recommended entry and does NOT have the s41 status (or any other designations).

So, perhaps your records are using the latter agg. list item?

I would guess then that these records have been recorded using a checklist whose recommended name is not in the preferred checklist and hence they do not have any statuses.

From a quick check it looks like there are 6 species in the s41 list that have entries in a non-preferred checklist and hence do not have
the designation statuses that they should have.

I think that this needs to be addressed as there are potentially hundreds of species that do not have designation statuses they should have because they do not point to the correct recommended name.

If you have access to SQL Server Management Studio I can write a query for you to list any 'Galium pumilium' records in your database that do NOT point to the recommended name in the preferred checklist.

Tony

Try this ...

USE NBNData
GO

SELECT DISTINCT SUR.ITEM_NAME AS SURVEY_NAME, LN.ITEM_NAME AS LOCATION_NAME, ITN.ACTUAL_NAME, TOCC.TAXON_OCCURRENCE_KEY, ITN.TAXON_LIST_ITEM_KEY, ITN.RECOMMENDED_TAXON_LIST_ITEM_KEY, TL.ITEM_NAME AS TAXON_LIST
FROM INDEX_TAXON_NAME ITN
INNER JOIN TAXON_LIST_VERSION TLV ON TLV.TAXON_LIST_VERSION_KEY = ITN.TAXON_LIST_VERSION_KEY
INNER JOIN TAXON_LIST TL ON TL.TAXON_LIST_KEY = TLV.TAXON_LIST_KEY
INNER JOIN TAXON_DETERMINATION TD ON TD.TAXON_LIST_ITEM_KEY = ITN.TAXON_LIST_ITEM_KEY
INNER JOIN TAXON_OCCURRENCE TOCC ON TOCC.TAXON_OCCURRENCE_KEY = TD.TAXON_OCCURRENCE_KEY
INNER JOIN SAMPLE S ON S.SAMPLE_KEY = TOCC.SAMPLE_KEY
INNER JOIN SURVEY_EVENT SE ON SE.SURVEY_EVENT_KEY = S.SURVEY_EVENT_KEY
INNER JOIN SURVEY SUR ON SUR.SURVEY_KEY = SE.SURVEY_KEY
INNER JOIN LOCATION LOC ON LOC.LOCATION_KEY = SE.LOCATION_KEY
INNER JOIN LOCATION_NAME LN ON LN.LOCATION_KEY = LOC.LOCATION_KEY
LEFT JOIN Index_Taxon_Designation ITD ON ITD.Taxon_List_Item_Key = ITN.TAXON_LIST_ITEM_KEY
WHERE ITN.ACTUAL_NAME = 'Galium pumilum'
AND ITD.Taxon_Designation_Type_Key IS NULL
AND LN.PREFERRED = 1
ORDER BY SUR.ITEM_NAME

Let me know how you get on.