Slide Menu
System Maintenance Notice, Sunday, January 16, 2022 @ 8am-10pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

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