Table: FISHER_PERMIT
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28542 | Updated: August 9, 2022 | Published / External
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
|
|
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 |
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 |