5413 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