Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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 Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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

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 Details

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