29950 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