5423 PDC_PURCHASES Entity Published / External 5402 Pelagic Dealer Commercial Landings Monitoring (HMS Dealers) Data Set Completed Table recording purchases by dealers Loaded by batch 1703, 10-15-2007 10:13 Data Table Yes FLS Table recording purchases by dealers 1 PDC_HEADER_KEY NUMBER 22 Yes No 10 0 Active To Link with PDC_HEADER table. The column here is programatically filled. NUMBER 2 PDC_PURCHASE_KEY NUMBER 22 Yes Yes 10 0 Active Sequence Generated key of this table NUMBER 3 PC_ARTIFICIAL_KEY NUMBER 22 No No 10 0 Active The old PC Key carried from the SDC System on the PC. It was loaded with the historical data, so that the new keys could be assigned. This column is not populated for new data. NUMBER 4 SPECIES_CODE_NMFS VARCHAR2 4 Yes No Active Four digit NMFS code that identifies each species. VARCHAR2 5 PRICE_PER_POUND NUMBER 22 No No 8 2 Active This is the average price that the dealer paid for the respective species during the reporting period. NUMBER 6 VALUE NUMBER 22 No No 9 2 Active Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS NUMBER 7 SIZE_CODE VARCHAR2 2 No No Active A code to indicate the size/market category of the fish sold. VARCHAR2 8 TOTAL_POUNDS NUMBER 22 No No 8 0 Active The total pounds that were purchased during the reporting period in dressed weight. NUMBER gov.noaa.nmfs.inport:5423 Lee Weinberger 2007-10-15T10:13:56 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