Slide Menu
Jump to Section...
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
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Atlas Remote Client > AFSC/FMA/ATLAS Remote Client >

Table: LOV_DETERRENCE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7518  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

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.
Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
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
100
 DESCRIPTION VARCHAR2 Descriptive text of deterrence method used.

Attribute Details

DETERRENCE_CODE

CC ID: 29661
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: 29659
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
General Data Type: VARCHAR2
Foreign Key Relations:

TURNBULLD.LOV_ANIMAL_TYPE

DESCRIPTION

CC ID: 29660
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: 7518
GUID: gov.noaa.nmfs.inport:7518
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:09+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04