Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? Name Type Description
100
PDC_HEADER_KEY NUMBER To Link with PDC_HEADER table. The column here is programatically filled.
100
Primary Key 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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07