Slide Menu
Jump to Section...
Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > Puerto Rico Commercial Landings Statistics 1983... >

Table: ALS_PUERTO_RICO_FISHERS_LOOKUP

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29950  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

The lookup table for FISHER NAMES for data from ALS.ALS_LANDINGS_PUERTO_RICO. Lookup is based on primary key of first six columns of tables. Table is updated bi-weekly for fisher data.
Notes:

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

Entity Information

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

The lookup table for FISHER NAMES for data from ALS.ALS_LANDINGS_PUERTO_RICO. Lookup is based on primary key of first six columns of tables. Table is updated bi-weekly for fisher data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 YEAR_LANDED VARCHAR2 The year the catch was landed.
100
 MONTH_LANDED VARCHAR2 The month the catch was landed.
100
 DAY_LANDED VARCHAR2 The calendar day the catch was landed.
100
 FISHING_CENTER VARCHAR2 The code for the fishing center wherein the catch was landed.
100
 PR_ID_CODE VARCHAR2 The permit code for the primary fisher landing the catch.
100
 TRIP_TICKET_NUMBER VARCHAR2 The trip ticket number assigned to the trip.
100
 MUNICIPALITY_NAME VARCHAR2 The name of the municipality containing the fishing center in which the landings occurred.
100
 FISHER_FIRST_NAME VARCHAR2 The fishers first name.
100
 FISHER_LAST_NAME VARCHAR2 The fisher last name.

Attribute Details

YEAR_LANDED

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

The year the catch was landed.
General Data Type: VARCHAR2

MONTH_LANDED

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

The month the catch was landed.
General Data Type: VARCHAR2

DAY_LANDED

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

The calendar day the catch was landed.
General Data Type: VARCHAR2

FISHING_CENTER

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

The code for the fishing center wherein the catch was landed.
General Data Type: VARCHAR2

PR_ID_CODE

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

The permit code for the primary fisher landing the catch.
General Data Type: VARCHAR2

TRIP_TICKET_NUMBER

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

The trip ticket number assigned to the trip.
General Data Type: VARCHAR2

MUNICIPALITY_NAME

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

The name of the municipality containing the fishing center in which the landings occurred.
General Data Type: VARCHAR2

FISHER_FIRST_NAME

CC ID: 267252
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The fishers first name.
General Data Type: VARCHAR2

FISHER_LAST_NAME

CC ID: 267253
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

The fisher last name.
General Data Type: VARCHAR2

Catalog Details

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