Table: ATL_BIRD_INTERAC_DETERRENT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18968 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory.
DescriptionThis entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
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 |
BIRD_EVENT_SEQ
NUMBER |
Sequence generated nique identifier of a bird interaction |
ANIMAL_TYPE_CODE
VARCHAR2 |
Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized |
DETERRENCE_CODE
VARCHAR2 |
Deterrence code from NORPAC bird or mammal deterance tables |
COMMENTS
VARCHAR2 |
Problems with deployment of deterrent device or details of type of deterrent. |
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_INTERAC_DETERRENT |
---|---|
Short Name: | ATL_BIRD_INTERAC_DETERRENT |
Status: | Completed |
Abstract: |
This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. |
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 resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
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
|
BIRD_EVENT_SEQ | NUMBER | Sequence generated nique identifier of a bird interaction | |
100
|
ANIMAL_TYPE_CODE | VARCHAR2 | Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized | |
100
|
DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables | |
100
|
COMMENTS | VARCHAR2 | Problems with deployment of deterrent device or details of type of deterrent. |
Attribute Details
CRUISE
Seq. Order: | 1 |
---|---|
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_BIRD_EVENT |
PERMIT
Seq. Order: | 2 |
---|---|
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_BIRD_EVENT |
BIRD_EVENT_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated nique identifier of a bird interaction |
General Data Type: | NUMBER |
Foreign Key Relations: |
NPRB_1017.ATL_BIRD_EVENT |
ANIMAL_TYPE_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Class of animal mammal (M), bird (B) for which the deterrence was utilized. References ATL_LOV_Animal_TYPEClass of animal mammal (M), bird (B) for which the deterrence was utilized |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NPRB_1017.ATL_LOV_DETERRENCE |
DETERRENCE_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Deterrence code from NORPAC bird or mammal deterance tables |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NPRB_1017.ATL_LOV_DETERRENCE |
COMMENTS
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Problems with deployment of deterrent device or details of type of deterrent. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 18968 |
---|---|
GUID: | gov.noaa.nmfs.inport:18968 |
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 |