9645
Table: ATL_BIRD_INTERAC_DETERRENT_H
ATL_BIRD_INTERAC_DETERRENT_H
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory.
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 resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory.
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
ANIMAL_TYPE_CODE
VARCHAR2
2
No
No
Active
Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized
VARCHAR2
3
CRUISE
NUMBER
22
No
No
9
0
Active
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
NUMBER
4
DETERRENCE_CODE
VARCHAR2
2
No
No
Active
Deterrence code from NORPAC bird or mammal deterance tables
VARCHAR2
5
PERMIT
VARCHAR2
6
No
No
Active
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
VARCHAR2
6
CHANGED_BY
VARCHAR2
30
No
No
Active
Oracle user who made a change to the transaction table record.
VARCHAR2
7
DATE_CHANGED
DATE
7
No
No
Active
Timestamp of change to transaction record.
DATE
8
BIRD_EVENT_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated nique identifier of a bird interaction
NUMBER
9
COMMENTS
VARCHAR2
500
No
No
Active
Problems with deployment of deterrent device or details of type of deterrent.
VARCHAR2
gov.noaa.nmfs.inport:9645
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
http://www.afsc.noaa.gov
0700-1700 Pacific Time
1001
Public
No
2018-09-26
1 Year
2019-09-26