Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: ATL_BIRD_EVENT
Short Name: ATL_BIRD_EVENT
Status: Completed
Abstract:

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.

Notes:

Loaded by batch 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
Description:

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key BIRD_EVENT_SEQ NUMBER Sequence generated unique identifier of a bird interaction event.
100
Primary Key CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
Primary Key PERMIT VARCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
EVENT_NUMBER NUMBER User defined event reference number which is unique within a cruise.
100
TRIP_SEQ NUMBER Sequence generated unique identifier of a trip
100
OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record
100
HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
DETERRENT_USED_CODE VARCHAR2 Unique code dientifying the reason for the use or absence of a bird deterrence strategy.
100
BEAUFORT_CODE VARCHAR2 International Beaufort Sea State Code
100
LOCATION_CODE VARCHAR2 Unique code identifying the location of the bird at the first observation
100
WEATHER_CODE VARCHAR2 Unique weather code
100
FISHERY_CODE VARCHAR2 Unique Abbreviated code for a fishery as defined by the observer.
100
NUMBER_OF_ANIMALS NUMBER Number of animals involved with this interaction
100
LATITUDE_DEGREE NUMBER Latitude at which the interaction with a bird occured.
100
LATITUDE_MINUTES NUMBER Latitude at which the interaction with a bird occured.
100
LATITUDE_SECONDS NUMBER Latitude at which the interaction with a bird occured.
100
LONGITUDE_DEGREE NUMBER Longitude at which the interaction with a bird occured.
100
LONGITUDE_MINUTES NUMBER Longitude at which the interaction with a bird occured.
100
LONGITUDE_SECONDS NUMBER Longitude at which the interaction with a bird occured.
100
LONGITUDE_EW VARCHAR2 Identifies the logitude as E(ast) or W(est)
100
INTERACTION_DATE_TIME DATE 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.
100
COMMENTS VARCHAR2 Observer entered comments regarding this interaction.

Attribute Details

BIRD_EVENT_SEQ

CC ID: 111737
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a bird interaction event.

General Data Type: NUMBER

CRUISE

CC ID: 111727
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

PERMIT

CC ID: 111728
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

EVENT_NUMBER

CC ID: 111748
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

User defined event reference number which is unique within a cruise.

General Data Type: NUMBER

TRIP_SEQ

CC ID: 111729
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a trip

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_FMA_TRIP

OFFLOAD_SEQ

CC ID: 111736
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for an offload record

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_OFFLOAD

HAUL_SEQ

CC ID: 111730
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a haul record

General Data Type: NUMBER
Foreign Key Relations:

NPRB_1017.ATL_HAUL

DETERRENT_USED_CODE

CC ID: 111732
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Unique code dientifying the reason for the use or absence of a bird deterrence strategy.

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_BIRD_DETERER

BEAUFORT_CODE

CC ID: 111731
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

International Beaufort Sea State Code

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_BEAUFORT_SCA

LOCATION_CODE

CC ID: 111733
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Unique code identifying the location of the bird at the first observation

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_BIRD_EVENT_L

WEATHER_CODE

CC ID: 111735
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Unique weather code

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_WEATHER_CODE

FISHERY_CODE

CC ID: 111734
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Unique Abbreviated code for a fishery as defined by the observer.

General Data Type: VARCHAR2
Foreign Key Relations:

NPRB_1017.ATL_LOV_BIRD_FISHERY

NUMBER_OF_ANIMALS

CC ID: 111738
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number of animals involved with this interaction

General Data Type: NUMBER

LATITUDE_DEGREE

CC ID: 111739
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.

General Data Type: NUMBER

LATITUDE_MINUTES

CC ID: 111740
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.

General Data Type: NUMBER

LATITUDE_SECONDS

CC ID: 111741
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Latitude at which the interaction with a bird occured.

General Data Type: NUMBER

LONGITUDE_DEGREE

CC ID: 111742
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.

General Data Type: NUMBER

LONGITUDE_MINUTES

CC ID: 111743
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.

General Data Type: NUMBER

LONGITUDE_SECONDS

CC ID: 111744
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Longitude at which the interaction with a bird occured.

General Data Type: NUMBER

LONGITUDE_EW

CC ID: 111745
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifies the logitude as E(ast) or W(est)

General Data Type: VARCHAR2

INTERACTION_DATE_TIME

CC ID: 111746
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: DATE

COMMENTS

CC ID: 111747
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Observer entered comments regarding this interaction.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 18967
GUID: gov.noaa.nmfs.inport:18967
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18