19026 ATL_LOV_SPECIES_CODE Entity Published / External 18964 AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions Data Set Completed This entity maps to the Norpac domestic_species table Loaded by batch 4574, 05-03-2013 17:18 Data Table Yes NPRB_1017 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 NPRB_1017.ATL_LOV_PROHIB_SPECI 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 No 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:19026 Doug Turnbull 2013-05-03T17:18:47 SysAdmin InPortAdmin 2022-08-09T17:11:09 2016-05-18 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 2016-05-18 1 Year 2017-05-18