Table: ATL_BIRD_INTERAC_DETERRENT_H
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9645 | 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 |
---|---|
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. |
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 |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
DETERRENCE_CODE
VARCHAR2 |
Deterrence code from NORPAC bird or mammal deterance tables |
PERMIT
VARCHAR2 |
Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau |
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 nique identifier of a bird interaction |
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_H |
---|---|
Short Name: | ATL_BIRD_INTERAC_DETERRENT_H |
Status: | Completed |
Abstract: |
This entity resolves the intersection of a bird deterrent code and a bird interaction. Multiple deterrents are allowed none are mandatory. |
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 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
|
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
|
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
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables | |
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
|
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 nique identifier of a bird interaction | |
100
|
COMMENTS | VARCHAR2 | Problems with deployment of deterrent device or details of type of deterrent. |
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 |
ANIMAL_TYPE_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
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 |
CRUISE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
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 |
DETERRENCE_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Deterrence code from NORPAC bird or mammal deterance tables |
General Data Type: | VARCHAR2 |
PERMIT
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
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 |
CHANGED_BY
Seq. Order: | 6 |
---|---|
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: | 7 |
---|---|
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: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated nique identifier of a bird interaction |
General Data Type: | NUMBER |
COMMENTS
Seq. Order: | 9 |
---|---|
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: | 9645 |
---|---|
GUID: | gov.noaa.nmfs.inport:9645 |
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 |