18982
Table: ATL_FISH_INV_SPECIMEN
ATL_FISH_INV_SPECIMEN
Entity
Published / External
18964
AFSC/FMA/NPRB Alternative Catch Monitoring Table and Column Definitions
Data Set
Completed
This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals.
Loaded by batch 4574, 05-03-2013 17:18
Data Table
Yes
NPRB_1017
This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of 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
NPRB_1017.ATL_LENGTH
2
SPECIMEN_SEQ
NUMBER
22
Yes
Yes
9
0
Active
Sequence generated unique identifier of a specimen record.
NUMBER
3
SPECIES_CODE
NUMBER
22
No
No
4
0
Active
Unique identifier for a species imported from Norpac, and the FK value from species_maturity.
NUMBER
NPRB_1017.ATL_LOV_SPECIES_MATU
4
MATURITY_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier of a maturity record.
NUMBER
NPRB_1017.ATL_LOV_SPECIES_MATU
5
LENGTH_SEQ
NUMBER
22
Yes
No
9
0
Active
Sequence generated unique identifier for a length record
NUMBER
NPRB_1017.ATL_LENGTH
6
SPECIMEN_TYPE
NUMBER
22
Yes
No
Active
Unique numeric value for a specimen type record.
NUMBER
NPRB_1017.ATL_LOV_SPECIMEN_TYP
7
SPECIMEN_NUMBER
VARCHAR2
10
Yes
No
Active
A specimen number is unique within a length, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial.
VARCHAR2
8
WEIGHT
NUMBER
22
No
No
10
3
Active
Weight in kg of the specimen.
NUMBER
9
AGE
NUMBER
22
No
No
3
0
Active
Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
NUMBER
10
SPECIAL_PROJECT_CODE
VARCHAR2
3
No
No
Active
Identifier of a special project record. Project to be a three character acronym unique to the project for a cruise. Populated by Debriefing Staff without System Validation.
VARCHAR2
11
PERMIT
VARCHAR2
6
Yes
Yes
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
NPRB_1017.ATL_LENGTH
gov.noaa.nmfs.inport:18982
Doug Turnbull
2013-05-03T17:18:46
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2016-05-18
1 Year
2017-05-18