Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_VESSEL_LIST
Short Name: FLS_VESSEL_LIST
Status: Completed
Abstract:

This table contains unique vessel IDs that have applied for permits. It is a combination of the tables known as EEZ and OEEZ. The list of vessel permits generated by the Southeast Regional Office (SERO) contains many records for each vessel. Whenever a change is made to any field in their records, they generate a new record, change the Status and Date of Status (i.e., DOS) fields and make a copy of the record to make all necessary changes. To be able to use the SERO vessel permit file, we must create a list of unique vessels that holds the most current information for each vessel. A daily snapshot updates records in this table and the VPS_VESSEL_PERMIT table. A primary key, vessel_id, enables us to use this table to validate the vessel id number throughout the system. Since the data are collected and maintened by SERO we have to accept the information provided by them.

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None vessels

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None EEZ
None OEEZ

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

This table contains unique vessel IDs that have applied for permits. It is a combination of the tables known as EEZ and OEEZ. The list of vessel permits generated by the Southeast Regional Office (SERO) contains many records for each vessel. Whenever a change is made to any field in their records, they generate a new record, change the Status and Date of Status (i.e., DOS) fields and make a copy of the record to make all necessary changes. To be able to use the SERO vessel permit file, we must create a list of unique vessels that holds the most current information for each vessel. A daily snapshot updates records in this table and the VPS_VESSEL_PERMIT table. A primary key, vessel_id, enables us to use this table to validate the vessel id number throughout the system. Since the data are collected and maintened by SERO we have to accept the information provided by them.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VESSEL_ID VARCHAR2 Unique identifier that distiguishes each vessel. This identification number is generally assigned either by the Coast Guard or the state. This is the number that is used by the Sotheast Regional Office (SERO) to issue permits.
100
VESSEL_NAME VARCHAR2 Name of the vessel given by the vessel or fleet owner.
100
OWNER_NAME VARCHAR2 Name of the person who owns the vessel. The date of birth of the owner is used to determine the expiration date of the permit.
100
OWNER_PHONE VARCHAR2 Telephone number of the vessel owner.
100
OWNER_CITY VARCHAR2 City where the owner lives.
100
OWNER_STATE VARCHAR2 State where the owner lives.
100
OWNER_STREET VARCHAR2 Street address where the owner lives.
100
OWNER_ZIP_CODE VARCHAR2 Zip code of the owner's address.
100
HOME_PORT_CITY VARCHAR2 City of the home port of the vessel.
100
HOME_PORT_STATE VARCHAR2 State of the home port of the vessel.
100
DATE_OF_STATUS DATE In the permit system generated by the SERO, each time a modification is made to any of the vessel's information, a copy of the most current record is made and a new record is created. If this date is null, the record is assumed to be the current record. All other dates indicate when the information was modified.
100
TYPE_OF_PERMIT VARCHAR2 Indicates the types of permits that were issued to the vessel. Each different permit type is separated by a comma, which is how SERO identifies their data.
100
LEASE_HOLDER_NAME VARCHAR2 Name of the person who leases the vessel.
100
LEASE_HOLDER_PHONE VARCHAR2 Telephone number of the person who leases the vessel.
100
LEASE_HOLDER_STREET VARCHAR2 Street address where the lease holder lives.
100
LEASE_HOLDER_CITY VARCHAR2 City where the lease holder lives.
100
LEASE_HOLDER_STATE VARCHAR2 State where the lease holder resides
100
LEASE_HOLDER_ZIP_CODE VARCHAR2 Zip code of the lease holder's address.
100
LEASE_HOLDER_SSN VARCHAR2 Social security number of the lease holder.
100
LEASE_HOLDER_BIRTH_DATE DATE Birth date of the lease holder.
100
LEASE_EXPIRATION_DATE DATE Expiration date for the lease holder's lease.

Attribute Details

VESSEL_ID

CC ID: 27400
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique identifier that distiguishes each vessel. This identification number is generally assigned either by the Coast Guard or the state. This is the number that is used by the Sotheast Regional Office (SERO) to issue permits.

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 27401
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of the vessel given by the vessel or fleet owner.

General Data Type: VARCHAR2

OWNER_NAME

CC ID: 27402
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Name of the person who owns the vessel. The date of birth of the owner is used to determine the expiration date of the permit.

General Data Type: VARCHAR2

OWNER_PHONE

CC ID: 27403
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Telephone number of the vessel owner.

General Data Type: VARCHAR2

OWNER_CITY

CC ID: 27404
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

City where the owner lives.

General Data Type: VARCHAR2

OWNER_STATE

CC ID: 27405
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State where the owner lives.

General Data Type: VARCHAR2

OWNER_STREET

CC ID: 27406
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Street address where the owner lives.

General Data Type: VARCHAR2

OWNER_ZIP_CODE

CC ID: 27407
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Zip code of the owner's address.

General Data Type: VARCHAR2

HOME_PORT_CITY

CC ID: 27408
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

City of the home port of the vessel.

General Data Type: VARCHAR2

HOME_PORT_STATE

CC ID: 27409
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State of the home port of the vessel.

General Data Type: VARCHAR2

DATE_OF_STATUS

CC ID: 27410
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

In the permit system generated by the SERO, each time a modification is made to any of the vessel's information, a copy of the most current record is made and a new record is created. If this date is null, the record is assumed to be the current record. All other dates indicate when the information was modified.

General Data Type: DATE

TYPE_OF_PERMIT

CC ID: 27411
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Indicates the types of permits that were issued to the vessel. Each different permit type is separated by a comma, which is how SERO identifies their data.

General Data Type: VARCHAR2

LEASE_HOLDER_NAME

CC ID: 27412
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

Name of the person who leases the vessel.

General Data Type: VARCHAR2

LEASE_HOLDER_PHONE

CC ID: 27413
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Telephone number of the person who leases the vessel.

General Data Type: VARCHAR2

LEASE_HOLDER_STREET

CC ID: 27414
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Street address where the lease holder lives.

General Data Type: VARCHAR2

LEASE_HOLDER_CITY

CC ID: 27415
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

City where the lease holder lives.

General Data Type: VARCHAR2

LEASE_HOLDER_STATE

CC ID: 27416
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

State where the lease holder resides

General Data Type: VARCHAR2

LEASE_HOLDER_ZIP_CODE

CC ID: 27417
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Zip code of the lease holder's address.

General Data Type: VARCHAR2

LEASE_HOLDER_SSN

CC ID: 27418
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Social security number of the lease holder.

General Data Type: VARCHAR2

LEASE_HOLDER_BIRTH_DATE

CC ID: 27419
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Birth date of the lease holder.

General Data Type: DATE

LEASE_EXPIRATION_DATE

CC ID: 27420
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Expiration date for the lease holder's lease.

General Data Type: DATE

Catalog Details

Catalog Item ID: 7175
GUID: gov.noaa.nmfs.inport:7175
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07