Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_LOV_DETERRENCE

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

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 4574, 05-03-2013 17:18

Entity Information

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

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.

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: 112051
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: 112050
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:

NPRB_1017.ATL_LOV_ANIMAL_TYPE

DESCRIPTION

CC ID: 112052
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: 19009
GUID: gov.noaa.nmfs.inport:19009
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