Slide Menu
Search Help Show/Hide Menu

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: 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