9643 ATL_BIRD_INTERACTION_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 intersection of an interaction type, its outcome to either the general interaction or to the individual animal. 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 intersection of an interaction type, its outcome to either the general interaction or to the individual animal. 1 SEQ_NUMBER NUMBER 22 Yes Yes 9 0 Active Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle. NUMBER 2 CRUISE NUMBER 22 Yes No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. NUMBER 3 PERMIT VARCHAR2 6 Yes No Active Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau VARCHAR2 4 CHANGED_BY VARCHAR2 30 No No Active Oracle user who made a change to the transaction table record. VARCHAR2 5 DATE_CHANGED DATE 7 No No Active Timestamp of change to transaction record. DATE 6 EVENT_INTERACTION_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird event interaction. NUMBER 7 BIRD_EVENT_SEQ NUMBER 22 No No 9 0 Active Sequence generated nique identifier of a bird interaction event. NUMBER 8 INTERACTION_SPECIES_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier for an species interaction record NUMBER 9 SPECIMEN_SEQ NUMBER 22 No No 9 0 Active Sequence generated unique identifier of a bird specimen. NUMBER 10 BIRD_INTERACT_CODE VARCHAR2 6 No No Active Unique code identifying a list of the currently valid avian interactions identified with gear, vessels, and offloads. VARCHAR2 11 COMMENTS VARCHAR2 500 No No Active Discussion of the interaction type and it's outcome at the event or specimen level. VARCHAR2 gov.noaa.nmfs.inport:9643 Doug Turnbull 2009-06-30T16:11:16 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