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

edc_ms_view_conf

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

Summary

Description

Replicate of EDC Mothership view

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
edcwcdas
numeric 		Total days reported on EDC form
type
varchar 		Type of fish purchase information: paid, transfer, received
location
varchar 		Fishing location
species
varchar 		First receiver species group
expense
varchar 		Name of the expense category
data_type
varchar 		Data type of fullcodee result
obsdas
numeric 		Total days calculated based on observer data
tribal_perc
numeric 		Percent allocated to Makah
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
ak_disag
numeric 		Total portion allocated to Alaska measured in metric tons
limited_entry_permit_id
bpchar
ak_perc
numeric 		Percent allocation to Alaska
expwht
numeric 		Total cost of purchases
edcwtmswc
numeric 		Total catch or purchase weight (metric tons) in catch share program and Makah fishery
d_number_response
int4 		Numeric result for full code
ms_disag
numeric 		Total portion allocated to catch shares measured in metric tons
measure
varchar 		Unit of measure
rvval
numeric 		Total production revenue from catch share purchases
wt_retained_mothership
numeric 		Total catch or purchase weight (metric tons) in catch share program
wt_retained_makah
numeric 		Total catch or purchase weight (metric tones) in Makah fishery
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
fullcode
varchar 		Unique identifier of survey field
wtall
numeric 		Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska
rvwt
numeric 		Total production weight (metric tons) from catch share purchases
text_response
varchar 		Text result of full code
activity
varchar 		Activity, more specific definition relies on the type of survey
edcsurvey_dbid
int4 		EDC survey database identifier
viewtable
varchar 		Variable used to group questions into useful categories
product
varchar 		Product type produced
tablename
varchar 		Long description of viewtable
description
varchar 		Long description of full code
tribal_disag
numeric 		Total portion allocated to Makah measured in metric tons

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_ms_view_conf

Entity Information

Entity Type: Data Table
Description:

Replicate of EDC Mothership view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 edcwcdas numeric Total days reported on EDC form
100
 type varchar Type of fish purchase information: paid, transfer, received
100
 location varchar Fishing location
100
 species varchar First receiver species group
100
 expense varchar Name of the expense category
100
 data_type varchar Data type of fullcodee result
100
 obsdas numeric Total days calculated based on observer data
100
 tribal_perc numeric Percent allocated to Makah
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
 ak_disag numeric Total portion allocated to Alaska measured in metric tons
67
 limited_entry_permit_id bpchar
100
 ak_perc numeric Percent allocation to Alaska
100
 expwht numeric Total cost of purchases
100
 edcwtmswc numeric Total catch or purchase weight (metric tons) in catch share program and Makah fishery
100
 d_number_response int4 Numeric result for full code
100
 ms_disag numeric Total portion allocated to catch shares measured in metric tons
100
 measure varchar Unit of measure
100
 rvval numeric Total production revenue from catch share purchases
100
 wt_retained_mothership numeric Total catch or purchase weight (metric tons) in catch share program
100
 wt_retained_makah numeric Total catch or purchase weight (metric tones) in Makah fishery
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
 fullcode varchar Unique identifier of survey field
100
 wtall numeric Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska
100
 rvwt numeric Total production weight (metric tons) from catch share purchases
100
 text_response varchar Text result of full code
100
 activity varchar Activity, more specific definition relies on the type of survey
100
 edcsurvey_dbid int4 EDC survey database identifier
100
 viewtable varchar Variable used to group questions into useful categories
100
 product varchar Product type produced
100
 tablename varchar Long description of viewtable
100
 description varchar Long description of full code
100
 tribal_disag numeric Total portion allocated to Makah measured in metric tons

Attribute Details

edcwcdas

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

type

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

location

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

Fishing location
Unit of Measure: unspecified
Allowed Values: Any

species

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

expense

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

data_type

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

Data type of fullcodee result
Unit of Measure: unspecified
Allowed Values: Any

obsdas

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

tribal_perc

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

vessel_id

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

ak_disag

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

limited_entry_permit_id

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

ak_perc

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

expwht

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

Total cost of purchases
Unit of Measure: unspecified
Allowed Values: Any

edcwtmswc

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

d_number_response

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

ms_disag

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

measure

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

rvval

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

wt_retained_mothership

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

wt_retained_makah

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

year

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

fullcode

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

wtall

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

rvwt

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

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

text_response

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

activity

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

edcsurvey_dbid

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

viewtable

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

product

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

tablename

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

description

CC ID: 376527
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_disag

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

Catalog Details

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