28542
Table: FISHER_PERMIT
FISHER_PERMIT
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
A unique list of regional permits with owner name (bus or individual) and associated permits.
Loaded by batch 7533, 11-05-2015 16:10
Data Table
Yes
CCL
A unique list of regional permits with owner name (bus or individual) and associated permits.
1
FISHER_PERMIT_ID
NUMBER
22
Yes
Yes
38
Active
Primary key for this table. An instance of the permit holder
NUMBER
2
REGION_PERMIT_NUM
VARCHAR2
30
Yes
No
Active
FK to REGION_LIST. Associated a Fishing Permit or fishing License holder to a Region. Allos the system to support multiple Regions and keep the Fishers Permits by Region.
VARCHAR2
3
FISHER_TYPE_CD
VARCHAR2
30
Yes
No
Active
FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.
VARCHAR2
CCL.FISHER_TYPE_LIST
4
FISHER_FIRST_NM
VARCHAR2
60
No
No
Active
First name of the fisher.
VARCHAR2
5
FISHER_LAST_NM
VARCHAR2
60
No
No
Active
Last name of the fisher.
VARCHAR2
6
BUSINESS_NM
VARCHAR2
60
No
No
Active
Business name of the fisher when the permit is owned by a Business.
VARCHAR2
7
HMS_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers HMS fishing permit/license number
VARCHAR2
8
CONCH_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers Conch fishing permit/license number.
VARCHAR2
9
LOBSTER_PERMIT_NUM
VARCHAR2
30
No
No
Active
Field to store the Fishers Lobster fishing permit/license number.
VARCHAR2
10
PHONE_NUM
VARCHAR2
30
No
No
Active
Phone number associated to a Fisher or Business.
VARCHAR2
11
LU_DT
DATE
7
Yes
No
Active
Last update date.
DATE
12
LU_USER_ID
NUMBER
22
Yes
No
Active
Last update user.
NUMBER
13
FISHER_PERMIT_EXP_DT
DATE
7
No
No
Active
Date that the data expired and was replaced by newer data
DATE
14
ISLAND_CD
VARCHAR2
30
Yes
No
Active
This island home of the fisher
VARCHAR2
CCL.ISLAND_LIST
15
ENTITY_ID
NUMBER
22
No
No
Active
Internal unique identifier for the entity (across instances and historical data)
NUMBER
16
IS_INACTIVE
NUMBER
22
Yes
No
1
0
Active
1=inactive user
NUMBER
17
CREATED_DT
DATE
7
No
No
Active
DATE
18
CREATED_BY_USER_ID
NUMBER
22
No
No
Active
NUMBER
gov.noaa.nmfs.inport:28542
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