Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: ATL_LOV_BIRD_FISHERY
Short Name: ATL_LOV_BIRD_FISHERY
Status: Completed
Abstract:

This entity identifies the current fishery a vessel in engaged in during a bird interaction. These values are not matched to AKR target fishery as computed by the catch accounting system.

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 identifies the current fishery a vessel in engaged in during a bird interaction. These values are not matched to AKR target fishery as computed by the catch accounting system.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISHERY_CODE VARCHAR2 Unique Abbreviated code for a fishery as defined by the observer.
100
FISHERY_NUMBER_CODE NUMBER Numeric value for use as a data entry aid. The alpha code is necessary to port the data to fish and wildlife without transformation. There is a unique key on this column.
100
DESCRIPTION VARCHAR2 Descriptive Text of the Fishery

Attribute Details

FISHERY_CODE

CC ID: 112027
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique Abbreviated code for a fishery as defined by the observer.

General Data Type: VARCHAR2

FISHERY_NUMBER_CODE

CC ID: 112028
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Numeric value for use as a data entry aid. The alpha code is necessary to port the data to fish and wildlife without transformation. There is a unique key on this column.

General Data Type: NUMBER

DESCRIPTION

CC ID: 112029
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
Description:

Descriptive Text of the Fishery

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 18999
GUID: gov.noaa.nmfs.inport:18999
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