5424
View: PDC_SCANNED_VESSELS_ERRORS_V
PDC_SCANNED_VESSELS_ERRORS_V
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
Completed
View Of Errors Detected While validating pelagic dealer Vessel data
Loaded by batch 1703, 10-15-2007 10:13
Data View
Yes
FLS
View Of Errors Detected While validating pelagic dealer Vessel data
1
BATCH_NUMBER
VARCHAR2
20
No
No
Active
Vendor assigned number for all records processed during a data scan
VARCHAR2
2
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
3
VESSELID
VARCHAR2
10
No
No
Active
The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VARCHAR2
4
VESSEL_NAME
VARCHAR2
30
No
No
Active
Reported Vessel Name On The Form
VARCHAR2
5
DATE_LANDED
VARCHAR2
10
No
No
Active
Dta vessel landed
VARCHAR2
6
STATE_LANDED
VARCHAR2
10
No
No
Active
State Landed
VARCHAR2
7
PORT_LANDED
VARCHAR2
30
No
No
Active
Port Landed On Data Entry Form
VARCHAR2
8
VESSEL_ID_VALUE
VARCHAR2
50
No
No
Active
Suggested Vessel Id Value
VARCHAR2
9
VESSEL_NAME_VALUE
VARCHAR2
50
No
No
Active
Suggested New Vessel Name Value
VARCHAR2
10
PORT_LANDED_VALUE
VARCHAR2
50
No
No
Active
Suggested New Port Landed Value
VARCHAR2
11
COLUMN_NAME
VARCHAR2
50
No
No
Active
Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id.
VARCHAR2
12
USERID
VARCHAR2
20
No
No
Active
Oracle ID of the runner of the validation program
VARCHAR2
gov.noaa.nmfs.inport:5424
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