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

Summary

Abstract

Valid Vessels.

Description

Valid Vessels.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
POP_VESSEL_CODE
VARCHAR2
Vessel Code For Pop System
COAST_GUARD_VESSEL_ID
VARCHAR2
Coast Guard Vessel Id
NEFS_VESSEL_ID
VARCHAR2
North East Fisheries Center Vessel Id
STATE_VESSEL_ID
VARCHAR2
State Regisration Number
VESSEL_NAME
VARCHAR2
Vessel Name
NOTES
VARCHAR2
Note On Vessel
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Modified by whom
MODIFIED_DATE
DATE
Modified when

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Valid Vessels.

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Valid Vessels.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key POP_VESSEL_CODE VARCHAR2 Vessel Code For Pop System
100
COAST_GUARD_VESSEL_ID VARCHAR2 Coast Guard Vessel Id
100
NEFS_VESSEL_ID VARCHAR2 North East Fisheries Center Vessel Id
100
STATE_VESSEL_ID VARCHAR2 State Regisration Number
100
VESSEL_NAME VARCHAR2 Vessel Name
100
NOTES VARCHAR2 Note On Vessel
100
CREATED_BY_USER_ID VARCHAR2 Created by whom
100
CREATED_DATE DATE Created when
100
MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
MODIFIED_DATE DATE Modified when

Attribute Details

POP_VESSEL_CODE

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

Vessel Code For Pop System

General Data Type: VARCHAR2

COAST_GUARD_VESSEL_ID

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

Coast Guard Vessel Id

General Data Type: VARCHAR2

NEFS_VESSEL_ID

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

North East Fisheries Center Vessel Id

General Data Type: VARCHAR2

STATE_VESSEL_ID

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

State Regisration Number

General Data Type: VARCHAR2

VESSEL_NAME

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

Vessel Name

General Data Type: VARCHAR2

NOTES

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

Note On Vessel

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

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

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

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

Modified when

General Data Type: DATE

Catalog Details

Catalog Item ID: 5375
GUID: gov.noaa.nmfs.inport:5375
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+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