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

Summary

Abstract

Vessel Codes Look Up Table

Description

Vessel Codes Look Up Table

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
VESSELNAME
VARCHAR2
Name of the vessel usually visable on the vessel hull.
HULLNUM
VARCHAR2
Federal or State vessel registration number usually visable on the vessel hull.
PERMIT_NUM
NUMBER
Federal fishing permit number for this vessel.
INSTALL_DATE
DATE
Not currently used.
UNINSTALL_DATE
DATE
Not currently used.
VMP_APPROVAL
DATE
Not currently used.
FISHERY
VARCHAR2
Not currently used.
PROVIDERCD
VARCHAR2
Not currently used.
EM_PROGRAM
VARCHAR2
Not currently used.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: EMVESSELS
Short Name: EMVESSELS
Status: Completed
Abstract:

Vessel Codes Look Up Table

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Vessel Codes Look Up Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESSELNAME VARCHAR2 Name of the vessel usually visable on the vessel hull.
100
HULLNUM VARCHAR2 Federal or State vessel registration number usually visable on the vessel hull.
100
PERMIT_NUM NUMBER Federal fishing permit number for this vessel.
100
INSTALL_DATE DATE Not currently used.
100
UNINSTALL_DATE DATE Not currently used.
100
VMP_APPROVAL DATE Not currently used.
100
FISHERY VARCHAR2 Not currently used.
100
PROVIDERCD VARCHAR2 Not currently used.
100
EM_PROGRAM VARCHAR2 Not currently used.

Attribute Details

VESSELNAME

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

Name of the vessel usually visable on the vessel hull.

General Data Type: VARCHAR2

HULLNUM

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

Federal or State vessel registration number usually visable on the vessel hull.

General Data Type: VARCHAR2

PERMIT_NUM

CC ID: 799058
Seq. Order: 3
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Federal fishing permit number for this vessel.

General Data Type: NUMBER

INSTALL_DATE

CC ID: 799059
Seq. Order: 4
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Not currently used.

General Data Type: DATE

UNINSTALL_DATE

CC ID: 799060
Seq. Order: 5
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Not currently used.

General Data Type: DATE

VMP_APPROVAL

CC ID: 799061
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Not currently used.

General Data Type: DATE

FISHERY

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

Not currently used.

General Data Type: VARCHAR2

PROVIDERCD

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

Not currently used.

General Data Type: VARCHAR2

EM_PROGRAM

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

Not currently used.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 54826
GUID: gov.noaa.nmfs.inport:54826
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2018-11-13 17:32+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-14
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-14