9625 ATLW_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 haul, offload or the trip level. Working Tables accept the raw data from field transmissions or data entry. They are unconstrained, Relational integrity data validation is performed when data are loaded into NORPAC transaction tables. Error checking is performed by batch processes on production data. Loaded by batch 2390, 06-30-2009 16:11 Data Table Yes NORPAC This entity records marine mammal interactions that coud occur at the haul level or the trip level. 1 RECORD_SET_STATUS_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier of a record set header NUMBER 2 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 3 INTERACTION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within Mammal Parent record NUMBER 4 MAMMAL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a mammal record NUMBER 5 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER 6 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 7 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 8 DETERRENCE_SUCCESS_FLAG VARCHAR2 1 No No Active Identifies whether or not the deterence measures applied were successful VARCHAR2 9 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 10 CONDITION_CODE NUMBER 22 Yes No 2 0 Active FK from the LOV_Condition_Table. Numeric code identifying the injury NUMBER 11 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 12 INTERACTION_DATE DATE 7 No No Active Date the mammal interaction was observed. DATE 13 OBSERVATION_FLAG VARCHAR2 1 No No Active Did the observer physically witness the interaction. VARCHAR2 14 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of animals involved with this interaction NUMBER 15 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 16 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 17 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 18 LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Longitude at which the interaction with a mammal occured. NUMBER 19 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 20 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 21 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 22 COMMENTS VARCHAR2 2500 Yes No Active Observer entered comments regarding this interaction. VARCHAR2 23 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 gov.noaa.nmfs.inport:9625 Doug Turnbull 2009-06-30T16:11:10 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