Table: LOV_DETERRENCE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7518 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThis 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 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
DETERRENCE_CODE | VARCHAR2 | Deterrence code from NORPAC bird or mammal deterance tables | |
100
|
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
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
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
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 |