Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Observer Vessel Support Table

Notes:

Loaded by batch 8950, 07-06-2016 08:24

Entity Information

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

Observer Vessel Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
HULLNUM VARCHAR2 Number of vessel as it appears on the hull of the vessel. Collected for ASM where applicable.
100
PERMIT NUMBER Permit number issued to vessel. Collected for ASM where applicable.
100
VESSELNAME VARCHAR2 Current name of vessel identified by hullnum; may change over time.
100
MIN_DATE_ISSUED DATE Date permit is issued to a vessel.
100
MAX_DATE_CANCELED DATE Date permit record is canceled.

Attribute Details

HULLNUM

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

Number of vessel as it appears on the hull of the vessel. Collected for ASM where applicable.

General Data Type: VARCHAR2

PERMIT

CC ID: 331245
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Permit number issued to vessel. Collected for ASM where applicable.

General Data Type: NUMBER

VESSELNAME

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

Current name of vessel identified by hullnum; may change over time.

General Data Type: VARCHAR2

MIN_DATE_ISSUED

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

Date permit is issued to a vessel.

General Data Type: DATE

MAX_DATE_CANCELED

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

Date permit record is canceled.

General Data Type: DATE

Catalog Details

Catalog Item ID: 33356
GUID: gov.noaa.nmfs.inport:33356
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:24+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28