5406 PDC_INT_ACCESS_HEADERS Entity Published / External 5402 Pelagic Dealer Commercial Landings Monitoring (HMS Dealers) Data Set Completed Processing Table to take the scanned data received from the vendor into oracle via access macro Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Processing Table to take the scanned data received from the vendor into oracle via access macro 1 ID_NO VARCHAR2 10 Yes Yes Active ID NUmber On The form VARCHAR2 2 TIF_NO VARCHAR2 12 No No Active TIF Number 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 systemThe actual unique key is SCHEDULE + BATCH_YEAR. VARCHAR2 4 SE_DEALER VARCHAR2 4 No No Active SE Permit Number VARCHAR2 5 NE_DEALER VARCHAR2 4 No No Active NE Dealer Code 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 STATE VARCHAR2 2 No No Active State Name VARCHAR2 10 FISH_PURCHASE VARCHAR2 1 No No Active Were fish purchases VARCHAR2 11 FISH_IMPORTED VARCHAR2 1 No No Active Indicates whether or not the data reported included imports in addition to domestic purchases. VARCHAR2 12 DEALER_PHONE VARCHAR2 20 No No Active Phone nUmber of Dealer VARCHAR2 13 FORM_ID VARCHAR2 20 No No Active Which Version Of The Form was scanned VARCHAR2 14 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 15 WEIGH_OUT VARCHAR2 1 No No Active his indicates whether or not tally sheets (weigh out data) were provided with the HMS form. This aids in locating weigh out sheets upon request. VARCHAR2 16 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 17 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 18 OP_DATE VARCHAR2 8 No No Active A Vendor Supplied field VARCHAR2 19 RECEIVED_DATE VARCHAR2 10 No No Active Date Logbook Form was received. VARCHAR2 20 POSTMARK_DATE VARCHAR2 10 No No Active Date in which envelope containing the logbook form was post marked. VARCHAR2 gov.noaa.nmfs.inport:5406 Lee Weinberger 2007-10-15T10:13:54 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