7383 ATL_LENGTH Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity is mapped to the Norpac length tables. It contains header information about sampled animals. Loaded by batch 2164, 03-27-2008 10:42 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 is mapped to the Norpac length tables. It contains header information about sampled animals. 1 CRUISE NUMBER 22 Yes Yes 8 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER Refers to more than one entity 2 LENGTH_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a length record NUMBER 3 SPECIES_COMPOSITION_SEQ NUMBER 22 No No 9 0 Active Sequence Generated unique identifier of a species composition record NUMBER NORPAC.ATL_SPECIES_COMPOSITION 4 HAUL_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for a haul record NUMBER NORPAC.ATL_HAUL 5 OFFLOAD_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an offload record NUMBER NORPAC.ATL_OFFLOAD 6 CONDITION_CODE NUMBER 22 No No 38 Active Numeric code identifying the injury NUMBER NORPAC.ATL_LOV_CONDITION 7 SAMPLE_SYSTEM_CODE NUMBER 22 Yes No 38 Active Unique numeric identifier of a sample coding system. NUMBER NORPAC.ATL_LOV_SAMPLE_SYSTEM_C 8 ANIMAL_TYPE_CODE VARCHAR2 2 No No Active Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 NORPAC.ATL_LOV_CONDITION 9 SPECIES_CODE NUMBER 22 No No 4 0 Active In the case of a length record which is not a child of species composition. This is the species identifier attribute. NUMBER NORPAC.ATL_LOV_SPECIES_CODE 10 SEX_CODE VARCHAR2 1 No No Active The sex of this animal VARCHAR2 11 LENGTH_SIZE NUMBER 22 No No 8 0 Active The length of this animal NUMBER 12 FREQUENCY NUMBER 22 No No 38 Active The total number of animals within this size group NUMBER 13 EGGS_IND VARCHAR2 1 No No Active Identifies the presence or absence of egg for crabs. VARCHAR2 14 VIABILITY VARCHAR2 1 No No Active Identifies the viability status for halibut valid values are Excellent, Poor, Dead, Unknown. VARCHAR2 gov.noaa.nmfs.inport:7383 Doug Turnbull 2008-03-27T10:42:14 SysAdmin InPortAdmin 2022-08-09T17:11:02 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