Slide Menu
Search Help Show/Hide Menu

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: 2019-06-04 13:14+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-02-14