Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table is a lookup for fishing center codes used in the ALS_landings_puerto_rico table. Provides fishing center name, as well as coast and municipality in which center is located.

Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

Table is a lookup for fishing center codes used in the ALS_landings_puerto_rico table. Provides fishing center name, as well as coast and municipality in which center is located.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
FISHING_CENTER VARCHAR2 The code for the fishing center.
100
FISHING_CENTER_NAME VARCHAR2 The name of the Puerto Rico fishing center represented by the code.
100
LANDING_LOCATION_COUNTY VARCHAR2 The municipality in which the fishing center is located.
100
COAST VARCHAR2 The coast in which the fishing center is located.

Attribute Details

FISHING_CENTER

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

The code for the fishing center.

General Data Type: VARCHAR2

FISHING_CENTER_NAME

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

The name of the Puerto Rico fishing center represented by the code.

General Data Type: VARCHAR2

LANDING_LOCATION_COUNTY

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

The municipality in which the fishing center is located.

General Data Type: VARCHAR2

COAST

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

The coast in which the fishing center is located.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29948
GUID: gov.noaa.nmfs.inport:29948
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06