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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionThe 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
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
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
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
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
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
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
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
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
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
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 |