36433 Entity Published / External 30866 Mothership Cost Earnings Data - Economic Data Collection for Monitoring the Economic Effects of the West Coast Groundfish Trawl Rationalization Program Data Set Data Table Replicate of EDC Mothership view activity varchar 75 No No Active Activity, more specific definition relies on the type of survey unspecified Any year int4 32 No No 0 Active 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 unspecified Any ak_perc numeric 12 No No 9 Active Percent allocation to Alaska unspecified Any d_number_response int4 32 No No 0 Active Numeric result for full code unspecified Any data_type varchar 10 No No Active Data type of fullcodee result unspecified Any description varchar 500 No No Active Long description of full code unspecified Any edcsurvey_dbid int4 32 No No 0 Active EDC survey database identifier unspecified Any edcwcdas numeric 16 No No 9 Active Total days reported on EDC form unspecified Any edcwtmswc numeric 16 No No 9 Active Total catch or purchase weight (metric tons) in catch share program and Makah fishery unspecified Any expense varchar 75 No No Active Name of the expense category unspecified Any expwht numeric 16 No No 9 Active Total cost of purchases unspecified Any fullcode varchar 25 No No Active Unique identifier of survey field unspecified Any limited_entry_permit_id bpchar 6 No No Active unspecified Any location varchar 30 No No Active Fishing location unspecified Any measure varchar 30 No No Active Unit of measure unspecified Any ms_disag numeric 20 No No 9 Active Total portion allocated to catch shares measured in metric tons unspecified Any obsdas numeric 16 No No 9 Active Total days calculated based on observer data unspecified Any product varchar 30 No No Active Product type produced unspecified Any rvval numeric 20 No No 9 Active Total production revenue from catch share purchases unspecified Any rvwt numeric 16 No No 9 Active Total production weight (metric tons) from catch share purchases unspecified Any species varchar 60 No No Active First receiver species group unspecified Any tablename varchar 100 No No Active Long description of viewtable unspecified Any text_response varchar 50 No No Active Text result of full code unspecified Any tribal_disag numeric 20 No No 9 Active Total portion allocated to Makah measured in metric tons unspecified Any tribal_perc numeric 12 No No 9 Active Percent allocated to Makah unspecified Any type varchar 50 No No Active Type of fish purchase information: paid, transfer, received unspecified Any vessel_id int4 32 No No 0 Active 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 unspecified Any viewtable varchar 60 No No Active Variable used to group questions into useful categories unspecified Any wt_retained_makah numeric 16 No No 9 Active Total catch or purchase weight (metric tones) in Makah fishery unspecified Any wt_retained_mothership numeric 16 No No 9 Active Total catch or purchase weight (metric tons) in catch share program unspecified Any wtall numeric 16 No No 9 Active Total catch or purchase weight (metric tons) in Makah, catch share, and Alaska unspecified Any ak_disag numeric 20 No No 9 Active Total portion allocated to Alaska measured in metric tons unspecified Any gov.noaa.nmfs.inport:36433 Jeffrey Cowen 2017-01-25T12:55:25 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-02-13 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2017-02-13 1 Year 2018-02-13