29950
Table: ALS_PUERTO_RICO_FISHERS_LOOKUP
ALS_PUERTO_RICO_FISHERS_LOOKUP
Entity
Published / External
1919
Puerto Rico Commercial Landings Statistics 1983 and more recent in Accumulated Landings System (ALS) Compatible Format
Data Set
Completed
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.
Loaded by batch 7906, 12-22-2015 14:11
Data Table
Yes
ALS
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.
1
YEAR_LANDED
VARCHAR2
4
No
No
Active
The year the catch was landed.
VARCHAR2
2
MONTH_LANDED
VARCHAR2
2
No
No
Active
The month the catch was landed.
VARCHAR2
3
DAY_LANDED
VARCHAR2
2
No
No
Active
The calendar day the catch was landed.
VARCHAR2
4
FISHING_CENTER
VARCHAR2
3
No
No
Active
The code for the fishing center wherein the catch was landed.
VARCHAR2
5
PR_ID_CODE
VARCHAR2
6
No
No
Active
The permit code for the primary fisher landing the catch.
VARCHAR2
6
TRIP_TICKET_NUMBER
VARCHAR2
11
No
No
Active
The trip ticket number assigned to the trip.
VARCHAR2
7
MUNICIPALITY_NAME
VARCHAR2
50
No
No
Active
The name of the municipality containing the fishing center in which the landings occurred.
VARCHAR2
8
FISHER_FIRST_NAME
VARCHAR2
50
No
No
Active
The fishers first name.
VARCHAR2
9
FISHER_LAST_NAME
VARCHAR2
50
No
No
Active
The fisher last name.
VARCHAR2
gov.noaa.nmfs.inport:29950
Joshua Bennett
2015-12-22T14:11:37
SysAdmin InPortAdmin
2022-08-09T17:11:13
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06