Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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