5411 PDC_INT_SCANNED_HEADERS Entity Published / External 5402 Pelagic Dealer Commercial Landings Monitoring (HMS Dealers) Data Set Completed Pre-validation table that holds header data Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Pre-validation table that holds header data 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 This contains the scanned images provided by the vendor. It currently does not have a place in our master tables VARCHAR2 3 SCHEDULE VARCHAR2 12 Yes Yes Active his 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 NE_PNUMBER VARCHAR2 4 No No Active This is the permit number issued by the Northeast Regional Office for Tuna dealers. It was once a 5 digit number, zero filled. Now it ranges from 3-4 digits, and not zero filled. VARCHAR2 5 SE_PNUMBER VARCHAR2 5 No No Active This is the permit number issued by the Southeast Regional Office for Swordfish and Shark dealers. It is comprised of 4 letters, up to 4 numbers, followed by 2 digits for the year, e.g., DLR-LA-1234-01. Only the center numbers of the permit (e.g., 1234) are entered in the permit files provided by the SE office, as well as into the Swordfish Compliance Program. Updated dealer permit numbers are downloaded and saved in n:\sdc\dbf\dlr_new.dbf.If a Swordfish or Shark dealer (indicated by a SE permit number) also has a Tuna dealer permit (indicated by a NE permit number), it would be helpful if the NE number was automatically entered with the SE permit number. These dealers with both NE and SE issued permits are currently linked in the above mentioned file, dlr_new.dbf. VARCHAR2 6 BEGIN_DATE VARCHAR2 10 No No Active This is the date that the reporting period begins. This date is often the first or the 16th of each month. VARCHAR2 7 END_DATE VARCHAR2 10 No No Active This is the date that the reporting period ends. This date is often the 15th or the last day of each month. VARCHAR2 8 COUNTY_NAME VARCHAR2 20 No No Active County Name VARCHAR2 9 DEALER_PHONE VARCHAR2 20 No No Active Phone Number Of Dealer VARCHAR2 10 STATE_ABBREVIATION VARCHAR2 2 No No Active State Abbreviation VARCHAR2 11 NMFS_STATE_CODE VARCHAR2 2 No No Active NMFS State code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 12 NMFS_COUNTY_CODE VARCHAR2 3 No No Active NMFS County code corresponing to the Dealerlocation.Thiscolumn is filled in on data entry. VARCHAR2 13 FORM_ID VARCHAR2 20 No No Active Logbook form version date is shown in this column VARCHAR2 14 PURCHASE_FISH VARCHAR2 1 No No Active This is a yes/no field. If the dealer did not purchase any highly migratory species during the 2 week period, the no is checked. VARCHAR2 15 FISH_IMPORTED VARCHAR2 1 No No Active This is a yes/no field. If the dealer did not import any fish during the 2 week period, the no is checked. VARCHAR2 16 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 iss VARCHAR2 17 WEIGH_OUT VARCHAR2 1 No No Active This is a yes/no field. If the weigh out was not submitted by the dealer during the 2 week period, the no is checked. VARCHAR2 18 OP_NAME VARCHAR2 50 No No Active Vendor SUpplied Column VARCHAR2 19 OP_VALUE VARCHAR2 50 No No Active Vendor Supplied Column VARCHAR2 20 OP_DATE VARCHAR2 10 No No Active Vendor Supplied Column VARCHAR2 21 SOURCE_FILE VARCHAR2 50 No No Active Name Of source file loaded that populates this table VARCHAR2 22 RECEIVED_DATE VARCHAR2 10 No No Active Date Logbook form was recieved VARCHAR2 23 POSTMARK_DATE VARCHAR2 10 No No Active Date Logbook form was post marked VARCHAR2 gov.noaa.nmfs.inport:5411 Lee Weinberger 2007-10-15T10:13:55 SysAdmin InPortAdmin 2022-08-09T17:11:00 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