Table: PDC_PURCHASES
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5423 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: PDC_PURCHASES |
|---|---|
| Short Name: | PDC_PURCHASES |
| Status: | Completed |
| Abstract: |
Table recording purchases by dealers |
| Notes: |
Loaded by batch 1703, 10-15-2007 10:13 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | FLS |
| Description: |
Table recording purchases by dealers |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
PDC_HEADER_KEY | NUMBER | To Link with PDC_HEADER table. The column here is programatically filled. | |
|
100
|
|
PDC_PURCHASE_KEY | NUMBER | Sequence Generated key of this table |
|
100
|
PC_ARTIFICIAL_KEY | NUMBER | 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. | |
|
100
|
SPECIES_CODE_NMFS | VARCHAR2 | Four digit NMFS code that identifies each species. | |
|
100
|
PRICE_PER_POUND | NUMBER | This is the average price that the dealer paid for the respective species during the reporting period. | |
|
100
|
VALUE | NUMBER | Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS | |
|
100
|
SIZE_CODE | VARCHAR2 | A code to indicate the size/market category of the fish sold. | |
|
100
|
TOTAL_POUNDS | NUMBER | The total pounds that were purchased during the reporting period in dressed weight. |
Attribute Details
PDC_HEADER_KEY
CC ID: 17027
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
To Link with PDC_HEADER table. The column here is programatically filled. |
| General Data Type: | NUMBER |
PDC_PURCHASE_KEY
CC ID: 17026
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Sequence Generated key of this table |
| General Data Type: | NUMBER |
PC_ARTIFICIAL_KEY
CC ID: 17025
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
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. |
| General Data Type: | NUMBER |
SPECIES_CODE_NMFS
CC ID: 17024
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Four digit NMFS code that identifies each species. |
| General Data Type: | VARCHAR2 |
PRICE_PER_POUND
CC ID: 17023
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 2 |
| Status: | Active |
| Description: |
This is the average price that the dealer paid for the respective species during the reporting period. |
| General Data Type: | NUMBER |
VALUE
CC ID: 17022
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 9 |
| Scale: | 2 |
| Status: | Active |
| Description: |
Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS |
| General Data Type: | NUMBER |
SIZE_CODE
CC ID: 17021
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
A code to indicate the size/market category of the fish sold. |
| General Data Type: | VARCHAR2 |
TOTAL_POUNDS
CC ID: 17020
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 8 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The total pounds that were purchased during the reporting period in dressed weight. |
| General Data Type: | NUMBER |
Catalog Details
| Catalog Item ID: | 5423 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:5423 |
| Metadata Record Created By: | Lee M Weinberger |
| Metadata Record Created: | 2007-10-15 10:13+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2021-05-06 |
| Owner Org: | SEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2021-05-06 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2022-05-06 |