9731 ATL_MAMMAL_SPECIMEN Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity maps to the Norpac Domestic_Mammal_Specimen Table, and records sampling information for marine mammal tissue and measurements recorded for hauls, offloads, or trips. Loaded by batch 2390, 06-30-2009 16:11 Theme AFSC Theme ATL Theme ATLAS Theme BYCATCH Theme FMA Theme GROUNDFISH Theme MARINE MAMMAL Theme NORPAC Theme OBSERVER Theme SAMPLING Spatial AI Spatial ALEUTIAN ISLANDS Spatial BERING SEA Spatial BS Spatial BSAI Spatial GOA Spatial GULF OF ALASKA Data Table Yes NORPAC This entity maps to the Norpac Domestic_Mammal_Specimen Table 1 CRUISE NUMBER 22 Yes Yes 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER NORPAC.ATL_MAMMAL_INTERACTION 2 MAMMAL_SPECIMEN_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within Mammal Parent. NUMBER 3 ANIMAL_NUMBER NUMBER 22 Yes No 3 0 Active User Entered identifier or a particular animal within a mammal interaction. This number is unique in combination with a specimen type. NUMBER 4 SPECIMEN_TYPE_SEQ NUMBER 22 Yes No 9 0 Active Unique identifier of a specimen type NUMBER NORPAC.ATL_LOV_MAMMAL_SPECIMEN 5 INTERACTION_SEQ NUMBER 22 Yes No 9 0 Active Sequence within Mammal Parent record NUMBER NORPAC.ATL_MAMMAL_INTERACTION 6 SPECIMEN_NUMBER NUMBER 22 Yes No 9 0 Active A specimen number is unique with a mammal record. It is auser defined identifier. NUMBER 7 SEX VARCHAR2 1 Yes No Active Sex of a mammal speciem (M)ale, (F)emale, (U)nknown or undertermined. VARCHAR2 8 VALUE VARCHAR2 10 No No Active If the Specimen Type requires a value to be entered this attribute is the data store. VARCHAR2 9 COMMENTS VARCHAR2 1000 No No Active Observer entered comments VARCHAR2 10 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 NORPAC.ATL_MAMMAL_INTERACTION gov.noaa.nmfs.inport:9731 Doug Turnbull 2009-06-30T16:11:41 SysAdmin InPortAdmin 2022-08-09T17:11:03 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