Table: ATL_BIRD_EVENT_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9639 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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 Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SEQ_NUMBER
NUMBER |
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. |
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. |
CHANGED_BY
VARCHAR2 |
Oracle user who made a change to the transaction table record. |
DATE_CHANGED
DATE |
Timestamp of change to transaction record. |
BIRD_EVENT_SEQ
NUMBER |
Sequence generated unique identifier of a bird interaction event. |
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 |
COUNT_TYPE_CODE
VARCHAR2 |
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. |
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. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | Table: ATL_BIRD_EVENT_H |
---|---|
Short Name: | ATL_BIRD_EVENT_H |
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. |
Purpose: |
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. |
Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
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
|
SEQ_NUMBER | NUMBER | 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. | |
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
|
CHANGED_BY | VARCHAR2 | Oracle user who made a change to the transaction table record. | |
100
|
DATE_CHANGED | DATE | Timestamp of change to transaction record. | |
100
|
BIRD_EVENT_SEQ | NUMBER | Sequence generated unique identifier of a bird interaction event. | |
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
|
COUNT_TYPE_CODE | VARCHAR2 | 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. | |
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
SEQ_NUMBER
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 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. |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
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 |
PERMIT
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
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 |
EVENT_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
User defined event reference number which is unique within a cruise. |
General Data Type: | NUMBER |
CHANGED_BY
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Oracle user who made a change to the transaction table record. |
General Data Type: | VARCHAR2 |
DATE_CHANGED
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Timestamp of change to transaction record. |
General Data Type: | DATE |
BIRD_EVENT_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 of a bird interaction event. |
General Data Type: | NUMBER |
TRIP_SEQ
Seq. Order: | 8 |
---|---|
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 |
OFFLOAD_SEQ
Seq. Order: | 9 |
---|---|
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 |
HAUL_SEQ
Seq. Order: | 10 |
---|---|
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 |
DETERRENT_USED_CODE
Seq. Order: | 11 |
---|---|
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 |
BEAUFORT_CODE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
International Beaufort Sea State Code |
General Data Type: | VARCHAR2 |
COUNT_TYPE_CODE
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
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. |
General Data Type: | VARCHAR2 |
LOCATION_CODE
Seq. Order: | 14 |
---|---|
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 |
WEATHER_CODE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique weather code |
General Data Type: | VARCHAR2 |
FISHERY_CODE
Seq. Order: | 16 |
---|---|
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 |
NUMBER_OF_ANIMALS
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Number of animals involved with this interaction |
General Data Type: | NUMBER |
LATITUDE_DEGREE
Seq. Order: | 18 |
---|---|
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: | 19 |
---|---|
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: | 20 |
---|---|
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: | 21 |
---|---|
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: | 22 |
---|---|
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: | 23 |
---|---|
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: | 24 |
---|---|
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: | 25 |
---|---|
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: | 26 |
---|---|
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: | 9639 |
---|---|
GUID: | gov.noaa.nmfs.inport:9639 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2009-06-30 16:11+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-26 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-26 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-26 |