Table: ATL_LOV_DETERRENCE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:19009 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
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
|
|
|
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. 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
| 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. 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
| 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 |
