9669 ATL_FISH_INV_SPECIMEN_H Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. 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. Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity represents the finfish or invertebrate specimen which has been chosen for additional biota sampling from the length sample of animals. BARCODE NUMBER No No Active Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. 1 SEQ_NUMBER NUMBER 22 Yes Yes 10 0 Active Oracle user who made a change to the transaction table record. NUMBER 2 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 3 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 4 CRUISE NUMBER 22 No No 22 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 5 MATURITY_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a maturity record. NUMBER 6 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 7 LENGTH_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier for a length record NUMBER 8 SPECIMEN_SEQ NUMBER 22 No No 22 0 Active Sequence generated unique identifier of a specimen record NUMBER 9 SPECIMEN_TYPE NUMBER 22 No No 22 0 Active Unique numeric value for a specimen type record. NUMBER 10 SPECIMEN_NUMBER VARCHAR2 10 No No Active A specimen number is unique for a cruise/permit combination (effective 01/01/2014). Duplicate specimen numbers indicate multiple specimen types collected for the same fish. In the case of an otolith (type 1 specimen) the barcode may or may not be the specimen number. The specimen number identifies the fish and the barcode is now an added attribute. Current protocol only requires specimen number to be unique for a cruise/permit, so some users are still using barcode as specimen number; however the 'best practice' is to start at '1' for a cruise and ascend from there for all specimen types and species. VARCHAR2 11 WEIGHT NUMBER 22 No No 22 0 Active Weight in kg of the specimen. Effective 01/01/2014, otoliths, scales, and stomachs no longer have a weight associated with the specimen record; instead a separate specimen (type 3) is entered for the same specimen number. NUMBER 12 AGE NUMBER 22 No No 3 0 Active Age of the animal (Specimen) in years. NUMBER 13 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. VARCHAR2 14 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 gov.noaa.nmfs.inport:9669 Doug Turnbull 2009-06-30T16:11:23 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