5407 PDC_INT_ACCESS_PURCHASES 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 50 No No Active TIF Number VARCHAR2 3 SCHEDULE VARCHAR2 12 No 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 Permit Number Assigned to Dealer by the SOuth East Regional Office VARCHAR2 5 NE_DEALER VARCHAR2 4 No No Active Permit Number Assigned By North East Regional Office VARCHAR2 6 END_DATE VARCHAR2 10 No No Active Ending Date of The Time/Reporting Period In question VARCHAR2 7 NMF_SPECIES VARCHAR2 4 No No Active NMFS Species Code VARCHAR2 8 SIZE_CODE VARCHAR2 2 No No Active Size Code VARCHAR2 9 DRESSED_WEIGHT NUMBER 22 No No 10 0 Active Dressed Weight NUMBER 10 PRICE_PER_POUND NUMBER 22 No No 10 2 Active Price Per Pound NUMBER 11 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 some come logbooks in the older format are returned VARCHAR2 12 OP_NAME VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 13 OP_VALUE VARCHAR2 50 No No Active A Vendor Supplied field VARCHAR2 14 OP_DATE DATE 7 No No Active A Vendor Supplied field DATE gov.noaa.nmfs.inport:5407 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