5423
Table: PDC_PURCHASES
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