5413
Table: PDC_INT_SCANNED_VESSELS
PDC_INT_SCANNED_VESSELS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
Completed
pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
pre-validation table for the vessel data in PDC System. This table is loaded with data from PDC_INT_ACCESS_VESSELS and data from this table goes into the table PDS_VESSELS
1
ID_NUMBER
VARCHAR2
10
No
No
Active
Sequential Number Assigned By Vendor Software During Data Entry
VARCHAR2
2
TIF_NUMBER
VARCHAR2
12
No
No
Active
The scan images provided by the vendor
VARCHAR2
3
SCHEDULE
VARCHAR2
12
Yes
No
Active
This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique.
VARCHAR2
4
DATE_LANDED
VARCHAR2
10
No
No
Active
Dta vessel landed
VARCHAR2
5
VESSEL_NAME
VARCHAR2
30
No
No
Active
Vessel Name
VARCHAR2
6
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
7
PORT_LANDED
VARCHAR2
30
No
No
Active
Port Landed
VARCHAR2
8
STATE_LANDED
VARCHAR2
10
No
No
Active
State Landed
VARCHAR2
9
BATCH_NUMBER
VARCHAR2
20
No
No
Active
When logbooks are picked up at the post office, they are processed together in batches. Each piece of paper is stamped with a unique schedule number. These pieces of paper may be in different formats because although new logbooks are issued every year to each permit holder, we may get information written on logbooks printed as early as 1992.When this batch of records are sent to the contractor that enters them, since there records are entered using an electronic scanner, the logbooks must be culled by year so that the scanner can correctly interpret the image it is reading. Hence, for each year, we have a separate file.All of the files that form part of a batch are loaded together so that the schedule numbers can be checked. If any are missing or out of bounds, an error is reported during validation. Validation:None.
VARCHAR2
10
OP_NAME
VARCHAR2
50
No
No
Active
A Vendor Supplied field
VARCHAR2
11
OP_DATE
VARCHAR2
8
No
No
Active
A Vendor Supplied field
VARCHAR2
12
OP_VALUE
VARCHAR2
50
No
No
Active
A Vendor Supplied field
VARCHAR2
13
SOURCE_FILE
VARCHAR2
50
No
No
Active
Source file used to load this data
VARCHAR2
14
REP_VESSELID
VARCHAR2
10
No
No
Active
The vessel information reported on the form
VARCHAR2
gov.noaa.nmfs.inport:5413
Lee Weinberger
2007-10-15T10:13:55
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