7539 MAMMAL_INTERACTION Entity Published / External 7283 AFSC/FMA/ATLAS Remote Client Data Set Completed This entity records marine mammal interactions that coud occur at the haul level or the trip level. Loaded by batch 2204, 03-28-2008 14:09 Data Table Yes TURNBULLD This entity records marine mammal interactions that coud occur at the haul level or the trip level. 1 INTERACTION_SEQ NUMBER 22 Yes Yes 9 0 Active Sequence within Mammal Parent record NUMBER 2 MAMMAL_SEQ NUMBER 22 Yes No 9 0 Active Sequence generated unique identifier for a mammal record NUMBER TURNBULLD.MAMMAL 3 SPECIES_CODE NUMBER 22 No No 4 0 Active Unique identifier for a species imported from Norpac NUMBER TURNBULLD.LOV_SPECIES_CODE 4 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 TURNBULLD.LOV_DETERRENCE 5 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 TURNBULLD.LOV_DETERRENCE 6 DETERRENCE_SUCCESS_FLAG VARCHAR2 1 No No Active Identifies whether or not the deterence measures applied were successful VARCHAR2 7 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 TURNBULLD.LOV_MAMMAL_INTERACTI 8 CONDITION_CODE NUMBER 22 Yes No 2 0 Active FK from the LOV_Condition_Table. Numeric code identifying the injury NUMBER TURNBULLD.LOV_CONDITION 9 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 TURNBULLD.LOV_CONDITION 10 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 11 OBSERVATION_FLAG VARCHAR2 1 No No Active Did the observer physically witness the interaction. VARCHAR2 12 NUMBER_OF_ANIMALS NUMBER 22 Yes No 3 0 Active Number of animals involved with this interaction NUMBER 13 LATITUDE_DEGREES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 14 LATITUDE_MINUTES NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 15 LATITUDE_SECONDS NUMBER 22 No No 2 0 Active Latitude at which the interaction with a mammal occured. NUMBER 16 LONGITUDE_DEGREES NUMBER 22 No No 3 0 Active Longitude at which the interaction with a mammal occured. NUMBER 17 LONGITUDE_MINUTES NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 18 LONGITUDE_SECONDS NUMBER 22 No No 2 0 Active Longitude at which the interaction with a mammal occured. NUMBER 19 LONGITUDE_EW VARCHAR2 1 No No Active Identifies the logitude as E(ast) or W(est) VARCHAR2 20 COMMENTS VARCHAR2 1000 Yes No Active Observer entered comments regarding this interaction. VARCHAR2 gov.noaa.nmfs.inport:7539 Doug Turnbull 2008-03-28T14:10:00 SysAdmin InPortAdmin 2022-08-09T17:11:01 2016-05-04 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 2016-05-04 1 Year 2017-05-04