Table: ATL_BIRD_EVENT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18967 | Updated: August 9, 2022 | Published / External
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
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. |
Attribute Details
BIRD_EVENT_SEQ
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |