Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table recording purchases by dealers

Description

Table recording purchases by dealers

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PDC_HEADER_KEY
NUMBER
To Link with PDC_HEADER table. The column here is programatically filled.
PDC_PURCHASE_KEY
NUMBER
Sequence Generated key of this table
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.
SPECIES_CODE_NMFS
VARCHAR2
Four digit NMFS code that identifies each species.
PRICE_PER_POUND
NUMBER
This is the average price that the dealer paid for the respective species during the reporting period.
VALUE
NUMBER
Value. Is calculated aS PRICE_PER_POUNDS * TOTAL_POUNDS
SIZE_CODE
VARCHAR2
A code to indicate the size/market category of the fish sold.
TOTAL_POUNDS
NUMBER
The total pounds that were purchased during the reporting period in dressed weight.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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: 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