Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DETERRENCE_CODE
VARCHAR2
Deterrence code from NORPAC bird or mammal deterance tables
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
DESCRIPTION
VARCHAR2
Descriptive text of deterrence method used.

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_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