Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISHING_CENTER
VARCHAR2
The code for the fishing center.
FISHING_CENTER_NAME
VARCHAR2
The name of the Puerto Rico fishing center represented by the code.
LANDING_LOCATION_COUNTY
VARCHAR2
The municipality in which the fishing center is located.
COAST
VARCHAR2
The coast in which the fishing center is located.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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