Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: vessel_directory
Status: In Work
Abstract:

This data contains vessel information and representative contact information

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

This data contains vessel information and representative contact information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key Vsl_Num numeric vessel number (primary key)
100
Vsl_Name character vessel name
100
Area1 numeric primary landing area
100
Area2 numeric Secondary landing area
100
Region Character Region Code
100
Port_Num numeric port number
100
Port_Add1 Character first line of port street address
100
Port_Add2 Character Second line of port street address
100
State Character Two letter State Postal abbreviation of port
100
City Character port City
100
zip character Five number port zipcode
100
Website Character website Contact Comments
100
In_Survey Numeric vessel is currently in survey
100
Active numeric vessel is currently active
100
Cooperative numeric vessel is currently cooperative
100
Permit_Hold numeric vessel is currently on permit hold
100
Comments Character captain or owner is contact
100
Capt_First Character First Name Of Vessel Captain C_Fon3 C_Fon4 C_Email Same
100
Capt_Last character Last Name Of Vessel Captain
100
C_Suffix character Suffix (if present) in the name of the vessel captain
100
Capt_Add1 character first line of the address of the vessel captain
100
Capt_Add2 character second line (if present) of the address of the vessel captain
100
Capt_Add3 character third line (if present) of the address of the vessel captain
100
Capt_City character City of the address of the vessel captain
100
Capt_State character State Postal abbreviation of the address of the vessel captain
100
Capt_Zip numeric Zip Code (only 5 numbers) of the address of the vessel captain
100
C_Fon1 Numeric First phone Number of the vessel Captain
100
C_Fon21 numeric second phone Number of the vessel Captain
100
C_Fon3 numeric third phone Number of the vessel Captain
100
C_Fon4 numeric fourth phone Number of the vessel Captain
100
c_email character email address of the vessel of the vessel Captain
100
c_same character Are the vessel captain and the owner the same
100
owner_first name character First Name of Vessel owner owner city owner state owner zip owner phone owner phone owner phone owner phone owner email address US Coast Guard Number
100
owner suffix character Suffix (if present) of Owner's Name
100
owner last name character Last Name of Vessel owner
100
Owner_Add1 character first line of owner address
100
Owner_Add2 character second line (if present) of owner address
100
Owner_Add3 character third line if present of owner address
100
Owner_City character city of the owner address
100
Owner_State character Two letter state abbreviation of the owner address
100
Owner_Zip character five digit zip code of owner address
100
O_Fon1 numeric first contact phone number of owner
100
O_Fon2 numeric second contact phone number of owner
100
O_Fon3 numeric third contact phone number of owner
100
O_Fon4 numeric fourth contact phone number of owner
100
o_email character owner email address
100
vsl_id numeric us Coast Guard Id of the Vessel

Attribute Details

Vsl_Num

CC ID: 568533
Seq. Order: 10
Data Storage Type: numeric
Required: Yes
Primary Key: Yes
Status: Active
Description:

vessel number (primary key)

Vsl_Name

CC ID: 568534
Seq. Order: 20
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

vessel name

Area1

CC ID: 568535
Seq. Order: 40
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

primary landing area

Area2

CC ID: 568536
Seq. Order: 50
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 2
Status: Active
Description:

Secondary landing area

Region

CC ID: 568537
Seq. Order: 70
Data Storage Type: Character
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Region Code

Allowed Values: AT (Atlantic) GU (Gulf)

Port_Num

CC ID: 568538
Seq. Order: 80
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 4
Status: Active
Description:

port number

Port_Add1

CC ID: 568539
Seq. Order: 90
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

first line of port street address

Port_Add2

CC ID: 568540
Seq. Order: 100
Data Storage Type: Character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Second line of port street address

State

CC ID: 568542
Seq. Order: 110
Data Storage Type: Character
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two letter State Postal abbreviation of port

City

CC ID: 568541
Seq. Order: 120
Data Storage Type: Character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

port City

zip

CC ID: 568543
Seq. Order: 130
Data Storage Type: character
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Five number port zipcode

Website

CC ID: 568544
Seq. Order: 140
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

website

Contact

Comments

In_Survey

CC ID: 568545
Seq. Order: 150
Data Storage Type: Numeric
Required: No
Primary Key: No
Status: Active
Description:

vessel is currently in survey

Active

CC ID: 568546
Seq. Order: 160
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

vessel is currently active

Cooperative

CC ID: 568547
Seq. Order: 170
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

vessel is currently cooperative

Permit_Hold

CC ID: 568548
Seq. Order: 180
Data Storage Type: numeric
Required: No
Primary Key: No
Status: Active
Description:

vessel is currently on permit hold

Comments

CC ID: 568549
Seq. Order: 190
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

captain or owner is contact

Capt_First

CC ID: 568550
Seq. Order: 210
Data Storage Type: Character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

First Name Of Vessel Captain

C_Fon3

C_Fon4

C_Email

Same

Capt_Last

CC ID: 568557
Seq. Order: 220
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Last Name Of Vessel Captain

C_Suffix

CC ID: 568558
Seq. Order: 230
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Suffix (if present) in the name of the vessel captain

Capt_Add1

CC ID: 568559
Seq. Order: 240
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

first line of the address of the vessel captain

Capt_Add2

CC ID: 568560
Seq. Order: 250
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

second line (if present) of the address of the vessel captain

Capt_Add3

CC ID: 568561
Seq. Order: 260
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

third line (if present) of the address of the vessel captain

Capt_City

CC ID: 568562
Seq. Order: 270
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

City of the address of the vessel captain

Capt_State

CC ID: 568563
Seq. Order: 280
Data Storage Type: character
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State Postal abbreviation of the address of the vessel captain

Capt_Zip

CC ID: 568564
Seq. Order: 290
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Zip Code (only 5 numbers) of the address of the vessel captain

C_Fon1

CC ID: 568565
Seq. Order: 300
Data Storage Type: Numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

First phone Number of the vessel Captain

C_Fon21

CC ID: 568566
Seq. Order: 310
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

second phone Number of the vessel Captain

C_Fon3

CC ID: 568567
Seq. Order: 320
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

third phone Number of the vessel Captain

C_Fon4

CC ID: 568568
Seq. Order: 330
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

fourth phone Number of the vessel Captain

c_email

CC ID: 568569
Seq. Order: 340
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

email address of the vessel of the vessel Captain

c_same

CC ID: 568570
Seq. Order: 350
Data Storage Type: character
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Are the vessel captain and the owner the same

owner_first name

CC ID: 568571
Seq. Order: 360
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

First Name of Vessel owner

owner city

owner state

owner zip

owner phone

owner phone

owner phone

owner phone

owner email address

US Coast Guard Number

owner suffix

CC ID: 568573
Seq. Order: 370
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Suffix (if present) of Owner's Name

owner last name

CC ID: 568572
Seq. Order: 380
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Last Name of Vessel owner

Owner_Add1

CC ID: 568574
Seq. Order: 390
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

first line of owner address

Owner_Add2

CC ID: 568575
Seq. Order: 400
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

second line (if present) of owner address

Owner_Add3

CC ID: 568576
Seq. Order: 410
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

third line if present of owner address

Owner_City

CC ID: 568577
Seq. Order: 420
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

city of the owner address

Owner_State

CC ID: 568578
Seq. Order: 430
Data Storage Type: character
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Two letter state abbreviation of the owner address

Owner_Zip

CC ID: 568579
Seq. Order: 440
Data Storage Type: character
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

five digit zip code of owner address

O_Fon1

CC ID: 568580
Seq. Order: 450
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

first contact phone number of owner

O_Fon2

CC ID: 568581
Seq. Order: 460
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

second contact phone number of owner

O_Fon3

CC ID: 568582
Seq. Order: 470
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

third contact phone number of owner

O_Fon4

CC ID: 568583
Seq. Order: 480
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

fourth contact phone number of owner

o_email

CC ID: 568584
Seq. Order: 490
Data Storage Type: character
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

owner email address

vsl_id

CC ID: 568585
Seq. Order: 500
Data Storage Type: numeric
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

us Coast Guard Id of the Vessel

Catalog Details

Catalog Item ID: 46084
GUID: gov.noaa.nmfs.inport:46084
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2017-05-18 06:56+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-07 10:52+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year