Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: ATL_LOV_DETERRENCE
Short Name: ATL_LOV_DETERRENCE
Status: Completed
Abstract:

This entity maps to both the Norpac Domestic Bird_Deterrence and the Domestic Mammal_Deterrence tables. It is a list of ezuipment and actions used to deter gear interactions with birds or mammals. In Atlas the animal_type column was added to allow this.

Notes:

Loaded by batch 2164, 03-27-2008 10:42

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None AFSC
None ATL
None ATLAS
None BYCATCH
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This entity maps to both the Norpac Bird_Deterrence and the Mammal_Deterrence tables. In Atlas the animal_type column was added to allow this.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key DETERRENCE_CODE VARCHAR2 Deterrence code from NORPAC bird or mammal deterance tables
100
Primary Key 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
DESCRIPTION VARCHAR2 Descriptive text of deterrence method used.

Attribute Details

DETERRENCE_CODE

CC ID: 28830
Seq. Order: 1
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

ANIMAL_TYPE_CODE

CC ID: 28828
Seq. Order: 2
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:

NORPAC.ATL_LOV_ANIMAL_TYPE

DESCRIPTION

CC ID: 28829
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

Descriptive text of deterrence method used.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7390
GUID: gov.noaa.nmfs.inport:7390
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 10:42+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