28537
Table: DID_NOT_FISH
DID_NOT_FISH
Entity
Published / External
27501
U.S. Caribbean Commercial Landings (CCL) Tables in new format since July 2011 for U.S. Virgin Islands and January 2012 for Puerto Rico
Data Set
Completed
Table of Did Not Fish reports from permit holders. A permit holder is required to submit a report indicating that they did not fish for a whole month.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
Table of Did Not Fish reports from permit holders. A permit holder is required to submit a report indicating that they did not fish for a whole month.
1
DID_NOT_FISH_ID
NUMBER
22
Yes
Yes
Active
Primary key for this table.
NUMBER
2
FISHER_PERMIT_ID
NUMBER
22
Yes
No
38
Active
FK to the FISHER_PERMIT who provided the Did Not Fish report.
NUMBER
CCL.FISHER_PERMIT
3
DID_NOT_FISH_MON
CHAR
2
Yes
No
Active
The Month value for Did Not Fish reports.
CHAR
4
DID_NOT_FISH_YR
CHAR
4
Yes
No
Active
The Year value for Did Not Fish reports.
CHAR
5
TRIP_TICKET_NUM
VARCHAR2
30
Yes
No
Active
Each logbook has a unique Trip Ticket number. This feild stored that number for Did Not Fish reports.
VARCHAR2
6
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
7
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
8
DNF_REASON_CD
VARCHAR2
30
No
No
Active
Reason why the did not fish report
VARCHAR2
CCL.DNF_REASON_LIST
gov.noaa.nmfs.inport:28537
Joshua Bennett
2015-11-05T16:10:53
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