Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_BIRD_EVENT

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18967 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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.

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.

Entity Type
Data Table

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

Data Attribute / Type

Description

BIRD_EVENT_SEQ
NUMBER

Sequence generated unique identifier of a bird interaction event.

CRUISE
NUMBER

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

PERMIT
VARCHAR2

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

EVENT_NUMBER
NUMBER

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

TRIP_SEQ
NUMBER

Sequence generated unique identifier of a trip

OFFLOAD_SEQ
NUMBER

Sequence generated unique identifier for an offload record

HAUL_SEQ
NUMBER

Sequence generated unique identifier for a haul record

DETERRENT_USED_CODE
VARCHAR2

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

BEAUFORT_CODE
VARCHAR2

International Beaufort Sea State Code

LOCATION_CODE
VARCHAR2

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

WEATHER_CODE
VARCHAR2

Unique weather code

FISHERY_CODE
VARCHAR2

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

NUMBER_OF_ANIMALS
NUMBER

Number of animals involved with this interaction

LATITUDE_DEGREE
NUMBER

Latitude at which the interaction with a bird occured.

LATITUDE_MINUTES
NUMBER

Latitude at which the interaction with a bird occured.

LATITUDE_SECONDS
NUMBER

Latitude at which the interaction with a bird occured.

LONGITUDE_DEGREE
NUMBER

Longitude at which the interaction with a bird occured.

LONGITUDE_MINUTES
NUMBER

Longitude at which the interaction with a bird occured.

LONGITUDE_SECONDS
NUMBER

Longitude at which the interaction with a bird occured.

LONGITUDE_EW
VARCHAR2

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

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.

COMMENTS
VARCHAR2

Observer entered comments regarding this interaction.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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 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.

Attribute Summary

	Name	Type	Description
100	BIRD_EVENT_SEQ	NUMBER	Sequence generated unique identifier of a bird interaction event.
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	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.

Name

Type

Description

100

BIRD_EVENT_SEQ

NUMBER

Sequence generated unique identifier of a bird interaction event.

100

CRUISE

NUMBER

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

100

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

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 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

Table: ATL_BIRD_EVENT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

BIRD_EVENT_SEQ

CRUISE

PERMIT

EVENT_NUMBER

TRIP_SEQ

OFFLOAD_SEQ

HAUL_SEQ

DETERRENT_USED_CODE

BEAUFORT_CODE

LOCATION_CODE

WEATHER_CODE

FISHERY_CODE

NUMBER_OF_ANIMALS

LATITUDE_DEGREE

LATITUDE_MINUTES

LATITUDE_SECONDS

LONGITUDE_DEGREE

LONGITUDE_MINUTES

LONGITUDE_SECONDS

LONGITUDE_EW

INTERACTION_DATE_TIME

COMMENTS

Catalog Details