9639
Table: ATL_BIRD_EVENT_H
ATL_BIRD_EVENT_H
Entity
Published / External
7284
AFSC/FMA/North Pacific Groundfish and Halibut Observer Program, Post 2008 Fishery Statistics.
Data Set
Completed
This entity records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.
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 records bird interactions characterized by type, that may occur at either the haul, offload or at the trip level. Each interaction is recorded separately and may be for multiple animals.
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
EVENT_NUMBER
NUMBER
22
No
No
4
0
Active
User defined event reference number which is unique within a cruise.
NUMBER
5
CHANGED_BY
VARCHAR2
30
No
No
Active
Oracle user who made a change to the transaction table record.
VARCHAR2
6
DATE_CHANGED
DATE
7
No
No
Active
Timestamp of change to transaction record.
DATE
7
BIRD_EVENT_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier of a bird interaction event.
NUMBER
8
TRIP_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier of a trip
NUMBER
9
OFFLOAD_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for an offload record
NUMBER
10
HAUL_SEQ
NUMBER
22
No
No
9
0
Active
Sequence generated unique identifier for a haul record
NUMBER
11
DETERRENT_USED_CODE
VARCHAR2
10
No
No
Active
Unique code dientifying the reason for the use or absence of a bird deterrence strategy.
VARCHAR2
12
BEAUFORT_CODE
VARCHAR2
10
No
No
Active
International Beaufort Sea State Code
VARCHAR2
13
COUNT_TYPE_CODE
VARCHAR2
10
No
No
Active
Unique code describing how the number of animals field is determined. Except for a type of specific the grouping is an estimate and number is not required.
VARCHAR2
14
LOCATION_CODE
VARCHAR2
10
No
No
Active
Unique code identifying the location of the bird at the first observation
VARCHAR2
15
WEATHER_CODE
VARCHAR2
10
Yes
No
Active
Unique weather code
VARCHAR2
16
FISHERY_CODE
VARCHAR2
5
No
No
Active
Unique Abbreviated code for a fishery as defined by the observer.
VARCHAR2
17
NUMBER_OF_ANIMALS
NUMBER
22
No
No
4
0
Active
Number of animals involved with this interaction
NUMBER
18
LATITUDE_DEGREE
NUMBER
22
No
No
2
0
Active
Latitude at which the interaction with a bird occured.
NUMBER
19
LATITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Latitude at which the interaction with a bird occured.
NUMBER
20
LATITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Latitude at which the interaction with a bird occured.
NUMBER
21
LONGITUDE_DEGREE
NUMBER
22
No
No
3
0
Active
Longitude at which the interaction with a bird occured.
NUMBER
22
LONGITUDE_MINUTES
NUMBER
22
No
No
2
0
Active
Longitude at which the interaction with a bird occured.
NUMBER
23
LONGITUDE_SECONDS
NUMBER
22
No
No
2
0
Active
Longitude at which the interaction with a bird occured.
NUMBER
24
LONGITUDE_EW
VARCHAR2
1
No
No
Active
Identifies the logitude as E(ast) or W(est)
VARCHAR2
25
INTERACTION_DATE_TIME
DATE
7
No
No
Active
Date the 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
26
COMMENTS
VARCHAR2
500
No
No
Active
Observer entered comments regarding this interaction.
VARCHAR2
gov.noaa.nmfs.inport:9639
Doug Turnbull
2009-06-30T16:11:15
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