NAs in PacFIN comprehensive tables for select California data columns

[chantelwetzel-noaa]

Examining recently pulled bds data for Dover sole from PacFIN comprehensive tables that currently prevent the data from being worked up for use in the assessment:

NUMBER_OF_FEMALES NUMBER_OF_MALES SPECIES_WEIGHT_LBS

A bds pull from last year using the older tables shows that this is likely a newer issue related to the new comprehensive table. Need to determine if these pieces of information are available in an alternative table for an immediate fix, although the correct fix would be to get these columns correctly populated on PacFIN.

[kellijohnson-NOAA]

Tried a work around where I looked at SPECIES_WGT in the pacfin.bds_cluster data table (where the bds comprehensive documentation says that the information is stored) and nothing newer than 2017 has a species weight for dover.

Next steps to try and solve this are (@chantelwetzel-noaa feel free to edit this post and modify the following list):

• [x] contact Brad again
• [x] tell Hastie
• [x] email EJ to see if he has ideas / contact person at CalCOM

[chantelwetzel-noaa]

I have alerted Hastie to the issue as well, he suggested a couple other people to contact. I also emailed Brenda Erwin yesterday to notify her of the problem.

• [x] email Brenda Erwin
• [ ] email Rob Ames and Bob Rizner

[chantelwetzel-noaa]

I heard back from Brad and he aims to work on this next week.

[kellijohnson-NOAA]

@chantelwetzel-noaa can you update this issue if you ever heard back from Brad about this?

[chantelwetzel-noaa]

This was fixed during the last assessment season.