5424 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