Search Help Show/Hide Menu
Metadata Rubric
100%
5.97 / 6
View Report
NWFSC Metadata Library > FRAM (Fishery Resource Analysis and Monitoring)... > Catcher Processor Cost Earnings Data - Economic... >

edc_cp_view_conf

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

Summary

Description

Replicate of EDC Catcher-Processor view

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
measure
varchar 		Unit of measure
wtall
numeric 		Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska
activity
varchar 		Activity, more specific definition relies on the type of survey
edcwcdas
numeric 		Total days reported on EDC form
edcsurvey_dbid
int4 		EDC survey database identifier
species
varchar 		First receiver species group
obsdas
numeric 		Total days calculated based on observer data
expense
varchar 		Name of the expense category
rvval
numeric 		Total production revenue from catch share purchases
rvwt
numeric 		otal production weight (metric tons) from catch share purchases
location
varchar 		Fishing location
limited_entry_permit_id
bpchar
d_number_response
int4 		Numeric result for full code
viewtable
varchar 		Variable used to group questions into useful categories
fullcode
varchar 		Full code used to identify a value in a table
ak_perc
numeric 		Percent allocation to Alaska
type
varchar 		Type of fish purchase information: paid, transfer, received
tablename
varchar 		Long description of viewtable
wt_retained_makah
numeric 		Total catch or purchase weight (metric tones) in Makah fishery
wt_retained_cp
numeric 		Total catch or purchase weight (metric tons) in catch share program
vessel_id
int4 		Similar to Legacy PacFINs DRVID, but not exactly. It can be a USCG VID (ex: 1234567 or AK1234nn) or MISSING or UNKNOWN if vessel ID not provided or invalid. It is also Null if no vessel was used. For the at-sea sector, populated with catcher vessel_id or catcher processor vessel_id
tribal_disag
numeric 		Total portion allocated to Makah measured in metric tons
ak_disag
numeric 		Total portion allocated to Alaska measured in metric tons
product
varchar 		Product type produced
edcwtcpwc
numeric 		Total catch or purchase weight (metric tons) in catch share program and Makah fishery
cp_disag
numeric 		Total portion allocated to catch shares measured in metric tons
year
int4 		The year the catch was delivered. The database table is partitioned by PacFIN year. All queries that include year should use PACFIN_YEAR instead of LANDING_YEAR
data_type
varchar 		Data type of fullcode result
text_response
varchar 		Text result of full code
description
varchar 		Long description of full code
tribal_perc
numeric 		Percent allocated to Makah

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_cp_view_conf

Entity Information

Entity Type: Data Table
Description:

Replicate of EDC Catcher-Processor view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 measure varchar Unit of measure
100
 wtall numeric Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska
100
 activity varchar Activity, more specific definition relies on the type of survey
100
 edcwcdas numeric Total days reported on EDC form
100
 edcsurvey_dbid int4 EDC survey database identifier
100
 species varchar First receiver species group
100
 obsdas numeric Total days calculated based on observer data
100
 expense varchar Name of the expense category
100
 rvval numeric Total production revenue from catch share purchases
100
 rvwt numeric otal production weight (metric tons) from catch share purchases
100
 location varchar Fishing location
67
 limited_entry_permit_id bpchar
100
 d_number_response int4 Numeric result for full code
100
 viewtable varchar Variable used to group questions into useful categories
100
 fullcode varchar Full code used to identify a value in a table
100
 ak_perc numeric Percent allocation to Alaska
100
 type varchar Type of fish purchase information: paid, transfer, received
100
 tablename varchar Long description of viewtable
100
 wt_retained_makah numeric Total catch or purchase weight (metric tones) in Makah fishery
100
 wt_retained_cp numeric Total catch or purchase weight (metric tons) in catch share program
100
 vessel_id int4 Similar to Legacy PacFINs DRVID, but not exactly. It can be a USCG VID (ex: 1234567 or AK1234nn) or MISSING or UNKNOWN if vessel ID not provided or invalid. It is also Null if no vessel was used. For the at-sea sector, populated with catcher vessel_id or catcher processor vessel_id
100
 tribal_disag numeric Total portion allocated to Makah measured in metric tons
100
 ak_disag numeric Total portion allocated to Alaska measured in metric tons
100
 product varchar Product type produced
100
 edcwtcpwc numeric Total catch or purchase weight (metric tons) in catch share program and Makah fishery
100
 cp_disag numeric Total portion allocated to catch shares measured in metric tons
100
 year int4 The year the catch was delivered. The database table is partitioned by PacFIN year. All queries that include year should use PACFIN_YEAR instead of LANDING_YEAR
100
 data_type varchar Data type of fullcode result
100
 text_response varchar Text result of full code
100
 description varchar Long description of full code
100
 tribal_perc numeric Percent allocated to Makah

Attribute Details

measure

CC ID: 376429
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

wtall

CC ID: 376430
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska
Unit of Measure: unspecified
Allowed Values: Any

activity

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

Activity, more specific definition relies on the type of survey
Unit of Measure: unspecified
Allowed Values: Any

edcwcdas

CC ID: 376432
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total days reported on EDC form
Unit of Measure: unspecified
Allowed Values: Any

edcsurvey_dbid

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

EDC survey database identifier
Unit of Measure: unspecified
Allowed Values: Any

species

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

First receiver species group
Unit of Measure: unspecified
Allowed Values: Any

obsdas

CC ID: 376435
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total days calculated based on observer data
Unit of Measure: unspecified
Allowed Values: Any

expense

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

Name of the expense category
Unit of Measure: unspecified
Allowed Values: Any

rvval

CC ID: 376437
Data Storage Type: numeric
Max Length: 20
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total production revenue from catch share purchases
Unit of Measure: unspecified
Allowed Values: Any

rvwt

CC ID: 376438
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

otal production weight (metric tons) from catch share purchases
Unit of Measure: unspecified
Allowed Values: Any

location

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

Fishing location
Unit of Measure: unspecified
Allowed Values: Any

limited_entry_permit_id

CC ID: 376440
Data Storage Type: bpchar
Max Length: 6
Required: No
Primary Key: No
Status: Active
Unit of Measure: unspecified
Allowed Values: Any

d_number_response

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

Numeric result for full code
Unit of Measure: unspecified
Allowed Values: Any

viewtable

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

Variable used to group questions into useful categories
Unit of Measure: unspecified
Allowed Values: Any

fullcode

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

Full code used to identify a value in a table
Unit of Measure: unspecified
Allowed Values: Any

ak_perc

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

Percent allocation to Alaska
Unit of Measure: unspecified
Allowed Values: Any

type

CC ID: 376445
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

tablename

CC ID: 376446
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

wt_retained_makah

CC ID: 376447
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total catch or purchase weight (metric tones) in Makah fishery
Unit of Measure: unspecified
Allowed Values: Any

wt_retained_cp

CC ID: 376448
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total catch or purchase weight (metric tons) in catch share program
Unit of Measure: unspecified
Allowed Values: Any

vessel_id

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

Similar to Legacy PacFINs DRVID, but not exactly. It can be a USCG VID (ex: 1234567 or AK1234nn) or MISSING or UNKNOWN if vessel ID not provided or invalid. It is also Null if no vessel was used. For the at-sea sector, populated with catcher vessel_id or catcher processor vessel_id
Unit of Measure: unspecified
Allowed Values: Any

tribal_disag

CC ID: 376450
Data Storage Type: numeric
Max Length: 20
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total portion allocated to Makah measured in metric tons
Unit of Measure: unspecified
Allowed Values: Any

ak_disag

CC ID: 376451
Data Storage Type: numeric
Max Length: 20
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total portion allocated to Alaska measured in metric tons
Unit of Measure: unspecified
Allowed Values: Any

product

CC ID: 376452
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

edcwtcpwc

CC ID: 376453
Data Storage Type: numeric
Max Length: 16
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total catch or purchase weight (metric tons) in catch share program and Makah fishery
Unit of Measure: unspecified
Allowed Values: Any

cp_disag

CC ID: 376454
Data Storage Type: numeric
Max Length: 20
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total portion allocated to catch shares measured in metric tons
Unit of Measure: unspecified
Allowed Values: Any

year

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

The year the catch was delivered. The database table is partitioned by PacFIN year. All queries that include year should use PACFIN_YEAR instead of LANDING_YEAR
Unit of Measure: unspecified
Allowed Values: Any

data_type

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

Data type of fullcode result
Unit of Measure: unspecified
Allowed Values: NUMBER, TEXT

text_response

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

Text result of full code
Unit of Measure: unspecified
Allowed Values: Any

description

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

Long description of full code
Unit of Measure: unspecified
Allowed Values: Any

tribal_perc

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

Percent allocated to Makah
Unit of Measure: unspecified
Allowed Values: Any

Catalog Details

Catalog Item ID: 36427
GUID: gov.noaa.nmfs.inport:36427
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