9719 ATL_LOV_SPECIES_CODE Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity maps to the Norpac domestic_species table Loaded by batch 2390, 06-30-2009 16:11 Theme AFSC Theme ATL Theme ATLAS Theme BYCATCH Theme FMA Theme GROUNDFISH Theme NORPAC Theme OBSERVER Spatial AI Spatial ALEUTIAN ISLANDS Spatial BERING SEA Spatial BS Spatial BSAI Spatial GOA Spatial GULF OF ALASKA Data Table Yes NORPAC This entity maps to the Norpac domestic_species table 1 SPECIES_CODE NUMBER 22 Yes Yes 4 0 Active Unique identifier for a species imported from Norpac NUMBER 2 PROHIB_SPECIES_GROUP_CODE VARCHAR2 1 No No Active Alpha code identifying the group that a species may belong to. VARCHAR2 NORPAC.ATL_LOV_PROHIB_SPECIES_ 3 EGGS_REQUIRED_FLAG VARCHAR2 1 Yes No Active For prohibited crab species where sex = F. The flag identifies whether the observer must record the presence or absence of eggs. VARCHAR2 4 SPECIES_COMP_SEX_REQUIRED_FLAG VARCHAR2 1 Yes No Active For species with this flag set to yes, the user interface will require that the sex of the species composition record be recorded. VARCHAR2 5 WEIGHT_AND_NUMBER_REQD VARCHAR2 1 Yes No Active Indicates whether the weight and number of animals are required for a subsequent species composition record. VARCHAR2 6 COMMON_NAME VARCHAR2 60 Yes No Active Common or Management name for a species. VARCHAR2 7 SCIENTIFIC_NAME VARCHAR2 60 Yes No Active Scientific Name (genus-species) VARCHAR2 8 LENGTH_ACCEPTED_FLAG VARCHAR2 1 Yes No Active Length data is not collected for all species. This flag identifies those for whom legth and specimen data may be collected. VARCHAR2 9 AVIAN_SPECIES_CODE VARCHAR2 4 Yes No Active Bird identification - species code from fish and wildlife Used to limit species presented in the bird interaction table. VARCHAR2 gov.noaa.nmfs.inport:9719 Doug Turnbull 2009-06-30T16:11:37 SysAdmin InPortAdmin 2022-08-09T17:11:03 2018-09-26 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2018-09-26 1 Year 2019-09-26