Slide Menu
System Maintenance Notice, Sunday, May 22, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

Holds the DLS Location 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 Location codes information.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FISHING_AREA_CODE VARCHAR2 Fishing Area Code.
100
Primary Key LOCATION_CODE VARCHAR2 Location Code.
100
LOCATION_LABEL VARCHAR2 Location Name.
100
LOCATION_DESCRIPTION VARCHAR2 Location Description.
100
ICCAT_FISHING_AREA_CODE VARCHAR2 ICCAT Fishing Area Code.

Attribute Details

FISHING_AREA_CODE

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

Fishing Area Code.

General Data Type: VARCHAR2
Foreign Key Relations:

DLS.DLS_FISHING_AREA_CODES

LOCATION_CODE

CC ID: 197665
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

Location Code.

General Data Type: VARCHAR2

LOCATION_LABEL

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

Location Name.

General Data Type: VARCHAR2

LOCATION_DESCRIPTION

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

Location Description.

General Data Type: VARCHAR2

ICCAT_FISHING_AREA_CODE

CC ID: 197668
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

FAQs

FAQ 1

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

What is the difference between fishing area codes 01 and 02?

Answer:

Fishing area codes 01 and 02 both refer to the Northeast Distant fishing area located within the bounds of -20 to -60 W and 35 - 55 N. Both codes were used interchangeably until 2011. Since 2011, code 02 is the preferred area code used.

Catalog Details

Catalog Item ID: 24495
GUID: gov.noaa.nmfs.inport:24495
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 Review Frequency: 1 Year