Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07