Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > FRAM (Fishery Resource Analysis and Monitoring)... > First Receiver and Shorebased Processor Data -... >

edc_frpurchprod_view_conf

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:36431  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Replicate of EDC FR purchase product view

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
measure
varchar 		Unit of measure
type
varchar 		Type of fish purchase information: paid, transfer, received
species
varchar 		Species (corresponds to EDC form)
fullcode
varchar 		Unique identifier of survey field
d_number
numeric 		Reported value
fishery
varchar 		Species group (corresponds to cost disaggregation groups: Pacific Whiting, Non-whiting groundfish, Other)
species_cd
varchar 		Indicates bycatch if processor only produces bycatch of a certain species group
ghid
int4 		Unique processor identifier
survey_year
int4 		Fiscal year
tablename
varchar 		Long description of viewtable
source
varchar 		Source of fish
product
varchar 		Product type produced

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: edc_frpurchprod_view_conf

Entity Information

Entity Type: Data Table
Description:

Replicate of EDC FR purchase product view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 measure varchar Unit of measure
100
 type varchar Type of fish purchase information: paid, transfer, received
100
 species varchar Species (corresponds to EDC form)
100
 fullcode varchar Unique identifier of survey field
100
 d_number numeric Reported value
100
 fishery varchar Species group (corresponds to cost disaggregation groups: Pacific Whiting, Non-whiting groundfish, Other)
100
 species_cd varchar Indicates bycatch if processor only produces bycatch of a certain species group
100
 ghid int4 Unique processor identifier
100
 survey_year int4 Fiscal year
100
 tablename varchar Long description of viewtable
100
 source varchar Source of fish
100
 product varchar Product type produced

Attribute Details

measure

CC ID: 376479
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Unit of measure
Unit of Measure: unspecified
Allowed Values: Any

type

CC ID: 376480
Data Storage Type: varchar
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Type of fish purchase information: paid, transfer, received
Unit of Measure: unspecified
Allowed Values: Any

species

CC ID: 376481
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Species (corresponds to EDC form)
Unit of Measure: unspecified
Allowed Values: Any

fullcode

CC ID: 376482
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of survey field
Unit of Measure: unspecified
Allowed Values: Any

d_number

CC ID: 376483
Data Storage Type: numeric
Max Length: 12
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Reported value
Unit of Measure: unspecified
Allowed Values: Any

fishery

CC ID: 376484
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Species group (corresponds to cost disaggregation groups: Pacific Whiting, Non-whiting groundfish, Other)
Unit of Measure: unspecified
Allowed Values: Any

species_cd

CC ID: 376485
Data Storage Type: varchar
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Indicates bycatch if processor only produces bycatch of a certain species group
Unit of Measure: unspecified
Allowed Values: Any

ghid

CC ID: 376486
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Unique processor identifier
Unit of Measure: unspecified
Allowed Values: Any

survey_year

CC ID: 376487
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Fiscal year
Unit of Measure: unspecified
Allowed Values: Any

tablename

CC ID: 376488
Data Storage Type: varchar
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Long description of viewtable
Unit of Measure: unspecified
Allowed Values: Any

source

CC ID: 376489
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Source of fish
Unit of Measure: unspecified
Allowed Values: Any

product

CC ID: 376490
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Product type produced
Unit of Measure: unspecified
Allowed Values: Any

Catalog Details

Catalog Item ID: 36431
GUID: gov.noaa.nmfs.inport:36431
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 12:55+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-13