7383
Table: ATL_LENGTH
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26