unepwcmc/SAPI — pull request #187 by agnessa (2014-01-29 14:45:25+00:00)
Title: Appendix N validation

The objective here is that if a species is listed in any EU annex (initially I thought that was just about annex D, but it seems from Patricia's comment that it could be any), it may be reported under appendix N without raising a secondary validation error. The validation rule has been extended to allow such values.

To verify this you need to build the valid_species_name_annex_year_mview. That can be done in isolation like so (provided your eu_listing_changes_mview and valid_species_name_appendix_year_mview are already there):

SELECT * FROM rebuild_valid_species_name_annex_year_mview()