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

Summary

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.

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.

Entity Information

Entity Type
Data Table

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

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