Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Holds the DLS Fishing Area Codes information.

Notes:

Loaded by batch 5871, 04-20-2015 08:47

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: DLS
Description:

Holds the DLS Fishing Area Codes information.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISHING_AREA_CODE VARCHAR2 Fishing Area Code.
100
FISHING_AREA_LABEL VARCHAR2 Fishing Area Name.
100
FISHING_AREA_DESCRIPTION VARCHAR2 List of location codes included in the fishing area represents.
100
FISHING_AREA_ORDER NUMBER Number which defines the order of the records in the DLS summary reports and DLS frequency size reports.
100
ICCAT_FISHING_AREA_CODE VARCHAR2 ICCAT Fishing Area Code.
100
ICCAT_FISHING_AREA_LABEL VARCHAR2 ICCAT Fishing Area Name.
100
ICCAT_LOCATION_NUMBER VARCHAR2 ICCAT Location Number.

Attribute Details

FISHING_AREA_CODE

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

Fishing Area Code.

General Data Type: VARCHAR2

FISHING_AREA_LABEL

CC ID: 197641
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Fishing Area Name.

General Data Type: VARCHAR2

FISHING_AREA_DESCRIPTION

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

List of location codes included in the fishing area represents.

General Data Type: VARCHAR2

FISHING_AREA_ORDER

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

Number which defines the order of the records in the DLS summary reports and DLS frequency size reports.

General Data Type: NUMBER

ICCAT_FISHING_AREA_CODE

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

ICCAT Fishing Area Code.

General Data Type: VARCHAR2

ICCAT_FISHING_AREA_LABEL

CC ID: 197645
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

ICCAT Fishing Area Name.

General Data Type: VARCHAR2

ICCAT_LOCATION_NUMBER

CC ID: 197646
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

ICCAT Location Number.

General Data Type: VARCHAR2

FAQs

FAQ 1

CC ID: 197695
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

What is the difference between fishing location code 01 and 02?

Answer:

Fishing location codes 01 and 02 both refer to the Northeast Distant body of water, -20 to -60 W and 35 - 55 N. Since 2011, only code 02 has been used for this region.

Catalog Details

Catalog Item ID: 24492
GUID: gov.noaa.nmfs.inport:24492
Metadata Record Created By: Allison Shideler
Metadata Record Created: 2015-04-20 08:47+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07