Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

Table: PDC_VESSELS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5431  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.

Description

This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PDC_HEADER_KEY
NUMBER 		Key to Header Table
PDC_VESSEL_KEY
NUMBER 		Primary key of the table..
PC_ARTIFICIAL_KEY
NUMBER 		historical key use when this was a PC based system
VESSELID
VARCHAR2 		The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VESSELNAME
VARCHAR2 		The vessel name
DATE_LANDED
DATE 		Dta vessel landed
LANDING_PORT
VARCHAR2 		Landing port of the vessel
ALPHA_STATE_LANDED
VARCHAR2 		2 character alphabetic code of state landed.
REP_VESSELID
VARCHAR2 		The vessel information reported on the form
TIF_NUMBER
VARCHAR2 		The scan images provided by the vendor

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: PDC_VESSELS
Short Name: PDC_VESSELS
Status: Completed
Abstract:

This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.
Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

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

This table is used for the dealer to report what vessels from which fish was bouight.This is a detail table . The Header table assocaiated with it is PDC_HEADER.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 PDC_HEADER_KEY NUMBER Key to Header Table
100
 Primary Key PDC_VESSEL_KEY NUMBER Primary key of the table..
100
 PC_ARTIFICIAL_KEY NUMBER historical key use when this was a PC based system
100
 VESSELID VARCHAR2 The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
100
 VESSELNAME VARCHAR2 The vessel name
100
 DATE_LANDED DATE Dta vessel landed
100
 LANDING_PORT VARCHAR2 Landing port of the vessel
100
 ALPHA_STATE_LANDED VARCHAR2 2 character alphabetic code of state landed.
100
 REP_VESSELID VARCHAR2 The vessel information reported on the form
100
 TIF_NUMBER VARCHAR2 The scan images provided by the vendor

Attribute Details

PDC_HEADER_KEY

CC ID: 17074
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Key to Header Table
General Data Type: NUMBER

PDC_VESSEL_KEY

CC ID: 17073
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Primary key of the table..
General Data Type: NUMBER

PC_ARTIFICIAL_KEY

CC ID: 17072
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

historical key use when this was a PC based system
General Data Type: NUMBER

VESSELID

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

The corrected vessl information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
General Data Type: VARCHAR2

VESSELNAME

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

The vessel name
General Data Type: VARCHAR2

DATE_LANDED

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

Dta vessel landed
General Data Type: DATE

LANDING_PORT

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

Landing port of the vessel
General Data Type: VARCHAR2

ALPHA_STATE_LANDED

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

2 character alphabetic code of state landed.
General Data Type: VARCHAR2

REP_VESSELID

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

The vessel information reported on the form
General Data Type: VARCHAR2

TIF_NUMBER

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

The scan images provided by the vendor
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5431
GUID: gov.noaa.nmfs.inport:5431
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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