10662
Table: DEBRIEFED_SPCOMP
DEBRIEFED_SPCOMP
Entity
Published / External
10657
AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT)
Data Set
Completed
This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model.
Loaded by batch 2535, 11-09-2010 10:55
Data Table
Yes
OBSINT
This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model.
1
T_TABLE
VARCHAR2
8
Yes
No
Active
Identifier of Source Table
VARCHAR2
2
CRUISE
NUMBER
22
Yes
No
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
3
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
4
HAUL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier of an atl_haul record.
NUMBER
5
HAUL_JOIN
NUMBER
22
Yes
No
38
Active
Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
NUMBER
OBSINT.DEBRIEFED_HAUL
6
VESSEL
VARCHAR2
6
Yes
No
Active
Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
VARCHAR2
7
HAUL_DATE
DATE
7
No
No
Active
Date of haul retrieval.
DATE
8
HAUL
NUMBER
22
No
No
6
0
Active
Number which is entered by the observer identifying a unique haul within a trip.
NUMBER
9
SEX
VARCHAR2
1
No
No
Active
Sex if so identified.
VARCHAR2
10
SPECIES
NUMBER
22
Yes
No
4
0
Active
Unique identifier for a species imported from Norpac
NUMBER
11
SPECIES_NAME
VARCHAR2
60
No
No
Active
Common Name for a species imported from Norpac
VARCHAR2
12
SAMPLE_TYPE
VARCHAR2
1
No
No
Active
Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.
VARCHAR2
13
SAMPLE_NUMBER
NUMBER
22
No
No
6
0
Active
Sum of the count of a species for a haul
NUMBER
14
SAMPLE_SIZE
NUMBER
22
No
No
9
0
Active
Sum of all parent samples recorded for a haul
NUMBER
15
SAMPLE_WEIGHT
NUMBER
22
No
No
10
2
Active
Sum of the weights of a species for a haul
NUMBER
16
EXTRAPOLATED_WEIGHT
NUMBER
22
No
No
38
Active
Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.
NUMBER
17
EXTRAPOLATED_NUMBER
NUMBER
22
No
No
38
Active
Number of a species extrapolated to the haul. This algorithm differs by gear type.
NUMBER
18
PERCENT_RETAINED
NUMBER
22
No
No
3
0
Active
Percent of this species that was retained from the total catch.
NUMBER
19
YEAR
NUMBER
22
No
No
4
0
Active
Year extracted from haul retrieval date
NUMBER
20
DATE_OF_ENTRY
DATE
7
No
No
Active
Computed value for date of entry from haul - has little meaning.
DATE
gov.noaa.nmfs.inport:10662
Doug Turnbull
2010-11-09T10:55:45
SysAdmin InPortAdmin
2022-08-09T17:11:03
2016-10-13
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
2016-10-13
1 Year
2017-10-13