Metadata Rubric

98%

5.89 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Caribbean Commercial Landings (CCL) Tables... >

Table: FISHER_PERMIT

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28542 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

A unique list of regional permits with owner name (bus or individual) and associated permits.

Description

A unique list of regional permits with owner name (bus or individual) and associated permits.

Entity Type
Data Table

Data Attribute / Type	Description
FISHER_PERMIT_ID NUMBER	Primary key for this table. An instance of the permit holder
REGION_PERMIT_NUM VARCHAR2	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.
FISHER_TYPE_CD VARCHAR2	FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.
FISHER_FIRST_NM VARCHAR2	First name of the fisher.
FISHER_LAST_NM VARCHAR2	Last name of the fisher.
BUSINESS_NM VARCHAR2	Business name of the fisher when the permit is owned by a Business.
HMS_PERMIT_NUM VARCHAR2	Field to store the Fishers HMS fishing permit/license number
CONCH_PERMIT_NUM VARCHAR2	Field to store the Fishers Conch fishing permit/license number.
LOBSTER_PERMIT_NUM VARCHAR2	Field to store the Fishers Lobster fishing permit/license number.
PHONE_NUM VARCHAR2	Phone number associated to a Fisher or Business.
LU_DT DATE	Last update date.
LU_USER_ID NUMBER	Last update user.
FISHER_PERMIT_EXP_DT DATE	Date that the data expired and was replaced by newer data
ISLAND_CD VARCHAR2	This island home of the fisher
ENTITY_ID NUMBER	Internal unique identifier for the entity (across instances and historical data)
IS_INACTIVE NUMBER	1=inactive user
CREATED_DT DATE
CREATED_BY_USER_ID NUMBER

Data Attribute / Type

Description

FISHER_PERMIT_ID
NUMBER

Primary key for this table. An instance of the permit holder

REGION_PERMIT_NUM
VARCHAR2

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.

FISHER_TYPE_CD
VARCHAR2

FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.

FISHER_FIRST_NM
VARCHAR2

First name of the fisher.

FISHER_LAST_NM
VARCHAR2

Last name of the fisher.

BUSINESS_NM
VARCHAR2

Business name of the fisher when the permit is owned by a Business.

HMS_PERMIT_NUM
VARCHAR2

Field to store the Fishers HMS fishing permit/license number

CONCH_PERMIT_NUM
VARCHAR2

Field to store the Fishers Conch fishing permit/license number.

LOBSTER_PERMIT_NUM
VARCHAR2

Field to store the Fishers Lobster fishing permit/license number.

PHONE_NUM
VARCHAR2

Phone number associated to a Fisher or Business.

LU_DT
DATE

Last update date.

LU_USER_ID
NUMBER

Last update user.

FISHER_PERMIT_EXP_DT
DATE

Date that the data expired and was replaced by newer data

ISLAND_CD
VARCHAR2

This island home of the fisher

ENTITY_ID
NUMBER

Internal unique identifier for the entity (across instances and historical data)

IS_INACTIVE
NUMBER

1=inactive user

CREATED_DT
DATE

CREATED_BY_USER_ID
NUMBER

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: FISHER_PERMIT
Short Name:	FISHER_PERMIT
Status:	Completed
Abstract:	A unique list of regional permits with owner name (bus or individual) and associated permits.
Notes:	Loaded by batch 7533, 11-05-2015 16:10

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CCL
Description:	A unique list of regional permits with owner name (bus or individual) and associated permits.

Attribute Summary

	Name	Type	Description
100	FISHER_PERMIT_ID	NUMBER	Primary key for this table. An instance of the permit holder
100	REGION_PERMIT_NUM	VARCHAR2	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.
100	FISHER_TYPE_CD	VARCHAR2	FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.
100	FISHER_FIRST_NM	VARCHAR2	First name of the fisher.
100	FISHER_LAST_NM	VARCHAR2	Last name of the fisher.
100	BUSINESS_NM	VARCHAR2	Business name of the fisher when the permit is owned by a Business.
100	HMS_PERMIT_NUM	VARCHAR2	Field to store the Fishers HMS fishing permit/license number
100	CONCH_PERMIT_NUM	VARCHAR2	Field to store the Fishers Conch fishing permit/license number.
100	LOBSTER_PERMIT_NUM	VARCHAR2	Field to store the Fishers Lobster fishing permit/license number.
100	PHONE_NUM	VARCHAR2	Phone number associated to a Fisher or Business.
100	LU_DT	DATE	Last update date.
100	LU_USER_ID	NUMBER	Last update user.
100	FISHER_PERMIT_EXP_DT	DATE	Date that the data expired and was replaced by newer data
100	ISLAND_CD	VARCHAR2	This island home of the fisher
100	ENTITY_ID	NUMBER	Internal unique identifier for the entity (across instances and historical data)
100	IS_INACTIVE	NUMBER	1=inactive user
67	CREATED_DT	DATE
67	CREATED_BY_USER_ID	NUMBER

Name

Type

Description

100

FISHER_PERMIT_ID

NUMBER

Primary key for this table. An instance of the permit holder

100

REGION_PERMIT_NUM

VARCHAR2

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.

100

FISHER_TYPE_CD

VARCHAR2

FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.

100

FISHER_FIRST_NM

VARCHAR2

First name of the fisher.

100

FISHER_LAST_NM

VARCHAR2

Last name of the fisher.

100

BUSINESS_NM

VARCHAR2

Business name of the fisher when the permit is owned by a Business.

100

HMS_PERMIT_NUM

VARCHAR2

Field to store the Fishers HMS fishing permit/license number

100

CONCH_PERMIT_NUM

VARCHAR2

Field to store the Fishers Conch fishing permit/license number.

100

LOBSTER_PERMIT_NUM

VARCHAR2

Field to store the Fishers Lobster fishing permit/license number.

100

PHONE_NUM

VARCHAR2

Phone number associated to a Fisher or Business.

100

LU_DT

DATE

Last update date.

100

LU_USER_ID

NUMBER

Last update user.

100

FISHER_PERMIT_EXP_DT

DATE

Date that the data expired and was replaced by newer data

100

ISLAND_CD

VARCHAR2

This island home of the fisher

100

ENTITY_ID

NUMBER

Internal unique identifier for the entity (across instances and historical data)

100

IS_INACTIVE

NUMBER

1=inactive user

CREATED_DT

DATE

CREATED_BY_USER_ID

NUMBER

Attribute Details

FISHER_PERMIT_ID

CC ID: 246949

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	38
Status:	Active
Description:	Primary key for this table. An instance of the permit holder
General Data Type:	NUMBER

REGION_PERMIT_NUM

CC ID: 246958

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	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.
General Data Type:	VARCHAR2

FISHER_TYPE_CD

CC ID: 246947

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	FK to FISHER_TYPE_LIST. Identifies if the Fisher is a Business or an Individual.
General Data Type:	VARCHAR2
Foreign Key Relations:	CCL.FISHER_TYPE_LIST

FISHER_FIRST_NM

CC ID: 246959

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	First name of the fisher.
General Data Type:	VARCHAR2

FISHER_LAST_NM

CC ID: 246960

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Last name of the fisher.
General Data Type:	VARCHAR2

BUSINESS_NM

CC ID: 246961

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Business name of the fisher when the permit is owned by a Business.
General Data Type:	VARCHAR2

HMS_PERMIT_NUM

CC ID: 246962

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Field to store the Fishers HMS fishing permit/license number
General Data Type:	VARCHAR2

CONCH_PERMIT_NUM

CC ID: 246963

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Field to store the Fishers Conch fishing permit/license number.
General Data Type:	VARCHAR2

LOBSTER_PERMIT_NUM

CC ID: 246964

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Field to store the Fishers Lobster fishing permit/license number.
General Data Type:	VARCHAR2

PHONE_NUM

CC ID: 246950

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone number associated to a Fisher or Business.
General Data Type:	VARCHAR2

LU_DT

CC ID: 246951

Seq. Order:	11
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Last update date.
General Data Type:	DATE

LU_USER_ID

CC ID: 246952

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Last update user.
General Data Type:	NUMBER

FISHER_PERMIT_EXP_DT

CC ID: 246953

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date that the data expired and was replaced by newer data
General Data Type:	DATE

ISLAND_CD

CC ID: 246948

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This island home of the fisher
General Data Type:	VARCHAR2
Foreign Key Relations:	CCL.ISLAND_LIST

ENTITY_ID

CC ID: 246954

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Internal unique identifier for the entity (across instances and historical data)
General Data Type:	NUMBER

IS_INACTIVE

CC ID: 246955

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	1=inactive user
General Data Type:	NUMBER

CREATED_DT

CC ID: 246956

Seq. Order:	17
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	DATE

CREATED_BY_USER_ID

CC ID: 246957

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	NUMBER

Catalog Item ID:	28542
GUID:	gov.noaa.nmfs.inport:28542
Metadata Record Created By:	Joshua Bennett
Metadata Record Created:	2015-11-05 16:10+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

Table: FISHER_PERMIT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

FISHER_PERMIT_ID

REGION_PERMIT_NUM

FISHER_TYPE_CD

FISHER_FIRST_NM

FISHER_LAST_NM

BUSINESS_NM

HMS_PERMIT_NUM

CONCH_PERMIT_NUM

LOBSTER_PERMIT_NUM

PHONE_NUM

LU_DT

LU_USER_ID

FISHER_PERMIT_EXP_DT

ISLAND_CD

ENTITY_ID

IS_INACTIVE

CREATED_DT

CREATED_BY_USER_ID

Catalog Details