9729 ATL_MAMMAL_INTERACTION Entity Published / External 7284 AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics. Data Set Completed This entity records marine mammal interactions that coud occur at the offload, haul, or the trip level. 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 records marine mammal interactions that coud occur at the haul level or the trip level. 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 2 INTERACTION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within Mammal Parent record NUMBER 3 MAMMAL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a mammal record NUMBER NORPAC.ATL_MAMMAL 4 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER NORPAC.ATL_LOV_SPECIES_CODE 5 DETERRENCE_ANIMAL_TYPE VARCHAR2 1 No No Active Optional FK from LOV_Deterrence. Class of animal mammal (M), bird (B) for which the deterrence (if it exists) was utilized VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 6 DETERRENCE_CODE VARCHAR2 2 No No Active Optional FK from LOV_Deterrence combined with deterrence_animal type. Deterrence codes are from NORPAC bird or mammal deterance tables. VARCHAR2 NORPAC.ATL_LOV_DETERRENCE 7 DETERRENCE_SUCCESS_FLAG VARCHAR2 1 No No Active Identifies whether or not the deterence measures applied were successful VARCHAR2 8 MAMMAL_INTERACT_CODE NUMBER 22 Yes No 38 Active Numeric code uniquely identifying a mammal interaction. The value is suppllied at data load from Norpac NUMBER NORPAC.ATL_LOV_MAMMAL_INTERACT 9 CONDITION_CODE NUMBER 22 Yes No 2 0 Active FK from the LOV_Condition_Table. Numeric code identifying the injury NUMBER NORPAC.ATL_LOV_CONDITION 10 CONDITION_ANIMAL_TYPE VARCHAR2 1 Yes No Active FK from the LOV_Condition_Table. Refers the the class of animal for example M - mammal H-halibut. Enforced by the Domain Animal Type. VARCHAR2 NORPAC.ATL_LOV_CONDITION 11 INTERACTION_DATE DATE 7 No No Active Date the mammal interaction was observed. If an interaction record is related to an offload or a haul this date is inferred as the haul date or offload end date. If the interaction is related to a trip the interaction date is mandatory. DATE 12 OBSERVATION_FLAG VARCHAR2 1 No No Active Did the observer physically witness the interaction. VARCHAR2 13 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of animals involved with this interaction NUMBER 14 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occurred. NUMBER 15 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occurred. NUMBER 16 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occurred. NUMBER 17 LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Longitude at which the interaction with a mammal occurred. NUMBER 18 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occurred. NUMBER 19 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occurred. NUMBER 20 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 21 COMMENTS VARCHAR2 4000 Yes No Active Observer entered comments regarding this interaction. VARCHAR2 22 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 gov.noaa.nmfs.inport:9729 Doug Turnbull 2009-06-30T16:11:40 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