Slide Menu
Search Help Show/Hide Menu

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