5431
Table: PDC_VESSELS
PDC_VESSELS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
Completed
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.
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
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.
1
PDC_HEADER_KEY
NUMBER
22
Yes
No
10
0
Active
Key to Header Table
NUMBER
2
PDC_VESSEL_KEY
NUMBER
22
Yes
Yes
10
0
Active
Primary key of the table..
NUMBER
3
PC_ARTIFICIAL_KEY
NUMBER
22
No
No
10
0
Active
historical key use when this was a PC based system
NUMBER
4
VESSELID
VARCHAR2
10
No
No
Active
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.
VARCHAR2
5
VESSELNAME
VARCHAR2
30
No
No
Active
The vessel name
VARCHAR2
6
DATE_LANDED
DATE
7
No
No
Active
Dta vessel landed
DATE
7
LANDING_PORT
VARCHAR2
30
No
No
Active
Landing port of the vessel
VARCHAR2
8
ALPHA_STATE_LANDED
VARCHAR2
2
No
No
Active
2 character alphabetic code of state landed.
VARCHAR2
9
REP_VESSELID
VARCHAR2
10
No
No
Active
The vessel information reported on the form
VARCHAR2
10
TIF_NUMBER
VARCHAR2
12
No
No
Active
The scan images provided by the vendor
VARCHAR2
gov.noaa.nmfs.inport:5431
Lee Weinberger
2007-10-15T10:13:56
SysAdmin InPortAdmin
2022-08-09T17:10:59
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06