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

Summary

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.

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.

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
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: 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 2183, 03-27-2008 11:52

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: 29287
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: 29285
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: 29286
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: 7449
GUID: gov.noaa.nmfs.inport:7449
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 11:52+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