Search Help Show/Hide Menu
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