open_access_survey_fact_conf
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:36443 | Updated: August 9, 2022 | Published / External
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
communications_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for communications, including VMS, satellite phone, skymate measured to the nearest 100 dollars | |
|
100
|
trucking_fish_to_buyer_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for trucking of fish to buyer measured to the nearest 100 dollars | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_as_captain_vessel_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the vessel on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain | |
|
100
|
other_wc_fisheries_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in other West Coast fisheries | |
|
100
|
wc_shoreside_landings_earnings_2014 | int4 | Income earned during 2014 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars | |
|
100
|
salmon_disaster_relief_2014 | int4 | Income earned during 2014 for salmon disaster relief payments measured to the nearest 100 dollars | |
|
100
|
survey_date_dim$month_of_year | int2 | numeric representation of month of year | |
|
100
|
participant_person_dim$last_name | varchar | last name of person | |
|
100
|
survey_date_dim$month_name | varchar | text representation of month | |
|
100
|
alaska_fisheries_not_tendering_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in Alaska fisheries (not including tendering) measured in knots | |
|
100
|
tendering_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in tendering measured in gallons per day | |
|
100
|
home_port_dim$port_code | bpchar | port code for observer program | |
|
100
|
permit_quota_sales_2015 | int4 | Income earned during 2015 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
wc_shrimp_trawl_gear_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast shrimp trawl gear | |
|
100
|
previous_survey_replacement_value | int4 | The replacement value of the vessel from the last completed survey rounded to the nearest 100 dollars | |
|
100
|
wc_shrimp_trawl_gear_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast shrimp trawl gear | |
|
100
|
off_load_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for off-load expenses (cross dock fees, port tariffs, hoist fees, etc.) measured to the nearest 100 dollars | |
|
100
|
steaming_between_wc_alaska_crew_size | int4 | Vessel's crew size (not including captain) when engaged in steaming between the West Coast and Alaska | |
|
100
|
home_port_dim$record_type | varchar | port record or reason record is unavailable | |
|
100
|
fishing_assoc_commission_costs_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fishing association and commission costs measured to the nearest 100 dollars | |
|
100
|
bait_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for bait measured to the nearest 100 dollars | |
|
100
|
alaska_chartering_research_tendering_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in Alaska chartering, research, or tendering | |
|
100
|
previous_survey_include_fishing_gear | varchar | Indicates if previous completed survey market value or replacement value includes the value of all the fishing gear on the vessel at that time | |
|
100
|
permit_quota_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for purchase and leasing of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
insurance_premium_payments_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for insurance premium payments (hull and machinery, protection and indemnity, and pollution insurance) measured to the nearest 100 dollars | |
|
100
|
alaska_fisheries_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in Alaska fisheries (not including chartering, research, or tendering) | |
|
100
|
participant_person_dim$record_type | varchar | person record or reason record is unavailable | |
|
100
|
home_port_dim$port_name_std | varchar | port name in standard format | |
|
100
|
wc_chartering_research_tendering_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast chartering, research, or tendering | |
|
100
|
off_load_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for off-load expenses (cross dock fees, port tariffs, hoist fees, etc.) measured to the nearest 100 dollars | |
|
100
|
permit_quota_sales_2014 | int4 | Income earned during 2014 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
fuel_lubrication_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fuel and lubrication measured to the nearest 100 dollars | |
|
100
|
vessel_leasing_2015 | int4 | Income earned during 2015 for leasing of vessel measured to the nearest 100 dollars | |
|
100
|
state_licensing_fed_permit_fees_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for state licensing and federal permit fees measured to the nearest 100 dollars | |
|
100
|
other_earnings_2015 | int4 | Income earned during 2015 for other earnings measured to the nearest 100 dollars | |
|
100
|
wc_crab_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast crab | |
|
100
|
wc_halibut_pacific_or_california_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast halibut (Pacific or California) measured in gallons per day | |
|
100
|
alaska_shoreside_landings_earnings_2015 | int4 | Income earned during 2015 for Alaska shoreside landings and at-sea deliveries of fish harvested with this vessel measured to the nearest 100 dollars | |
|
100
|
other_earnings_type | varchar | Other earnings description by participant | |
|
100
|
2015_crew_share_system | int4 | Indicates if crew shared system was used for any trips that derived the most revenue from West Coast landings during fiscal year 2015 to pay the crew | |
|
100
|
processing_equipment_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for processing equipment purchases, upgrade repair, and maintenance including any equipment used to process or head and gut fish on-board the vessel measured to the nearest 100 dollars | |
|
100
|
ice_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for ice measured to the nearest 100 dollars | |
|
100
|
survey_date_dim$month_abbrev | bpchar | three character representation of month in capital letters | |
|
100
|
crew_share_total_revenue_other_deduction | int4 | Other deductions taken from total revenue to determine crew share for the fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 described by participant | |
|
100
|
2015_fiscal_year_date_month_abbreviation | char | Three character representation of month in capital letters | |
|
100
|
wc_salmon_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in West Coast salmon measured in knots | |
|
100
|
captain_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for captain (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) | |
|
100
|
lease_bareboat_charter_of_vessel_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for lease or bareboat charter of this vessel measured to the nearest 100 dollars | |
|
100
|
previous_survey_completed_year | int2 | The year this survey was last completed | |
|
100
|
participant_person_dim$first_name | varchar | first name of person | |
|
100
|
wc_shrimp_trawl_gear_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast shrimp trawl gear measured in gallons per day | |
|
100
|
participant_person_whid | int4 | Participant of the survey | |
|
100
|
food_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for food measured to the nearest 100 dollars | |
|
100
|
vessel_id_uscg_state | varchar | Vessel ID US Coast Guard number or state number | |
|
100
|
survey_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable | |
|
100
|
home_port_dim$port_group_code | bpchar | port group code for observer program | |
|
100
|
vessel_engines_hp | numeric | Total engines horsepower of vessel | |
|
100
|
steaming_between_wc_alaska_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in steaming between the West Coast and Alaska measured in gallons per day | |
|
100
|
survey_date_dim$day_of_month | int2 | numeric representation of the day in month | |
|
100
|
permit_quota_leases_2015 | int4 | Income earned during 2015 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
vessel_fuel_capacity_gal | numeric | Fuel capacity of vessel | |
|
100
|
freight_to_vessel_on_supplies_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for freight to the vessel on supplies measured to the nearest 100 dollars | |
|
100
|
steaming_between_wc_alaska_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in steaming between West Coast and Alaska | |
|
100
|
survey_date_dim$yyyymmdd | bpchar | text representation of year month day | |
|
100
|
observer_fees_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for observer fees measured to the nearest 100 dollars | |
|
100
|
previous_survey_value_includes_permits | varchar | Indicates if previous completed survey market value or replacement value includes the value of permits associated with the vessel at that time | |
|
100
|
2015_fiscal_year_date_whid | int8 | Warehouse identifier for the 2015 fiscal year start date | |
|
100
|
vessel_on_board_equipment_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for vessel and on-board equipment purchases, upgrades, repair, and maintenance including all electronics, safety equipment, and machinery not used to harvest fish and excluding fishing gear and processing equipment measured to the nearest 100 dollars | |
|
100
|
participant_zip | char | Zip code of participant | |
|
100
|
participant_person_dim$full_name | varchar | full name in format of First and Last (Suffix) | |
|
100
|
freight_to_vessel_on_supplies_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for freight to the vessel on supplies measured to the nearest 100 dollars | |
|
100
|
participant_street_address | varchar | Street address of participant | |
|
100
|
survey_date_whid | int8 | Warehouse identifier for the survey date | |
|
100
|
wc_halibut_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast halibut (Pacific or California) | |
|
100
|
wcgf_fixed_gear_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast groundfish fixed gear measured in gallons per day | |
|
100
|
alaska_fisheries_not_tendering_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in Alaska fisheries (not including tendering) measured in gallons per day | |
|
100
|
crew_expenses_included_in_captain_expenses | varchar | Indicates if crew expenses are included in captain expenses | |
|
100
|
wc_chartering_research_tendering_2014 | int4 | Income earned during 2014 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars | |
|
100
|
steaming_between_wc_alaska_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in steaming between the West Coast and Alaska measured in knots | |
|
100
|
wc_shrimp_trawl_gear_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in West Coast shrimp trawl gear measured in knots | |
|
100
|
marine_survey_performed | varchar | Indicates if a marine survey has been completed for the vessel | |
|
100
|
home_port_dim$port_name_caps | varchar | port name in all capitals format | |
|
100
|
wc_halibut_pacific_or_california_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast halibut (Pacific or California) | |
|
100
|
trucking_fish_to_buyer_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for trucking of fish to buyer measured to the nearest 100 dollars | |
|
100
|
vessel_name | varchar | Vessel name | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_as_captain_captain_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the captain on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain | |
|
100
|
2015_fiscal_year_date_month_name | varchar | Text representation of month | |
|
100
|
crew_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for crew (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) measured to the nearest 100 dollars | |
|
100
|
previous_survey_market_value | int4 | The market value of the vessel from the last completed survey rounded to the nearest 100 dollars | |
|
100
|
wcgf_fixed_gear_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast groundfish fixed gear (longline or pots) | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_as_captain_crew_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the crew on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain | |
|
100
|
fuel_lubrication_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fuel and lubrication measured to the nearest 100 dollars | |
|
100
|
2015_wc_landings_most_revenue_source | int4 | Fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 | |
|
100
|
home_port_dim$state_abbrev | bpchar | two letter state abbreviation | |
|
100
|
moorage_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for moorage measured to the nearest 100 dollars | |
|
100
|
alaska_chartering_research_tendering_2014 | int4 | Income earned during 2014 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars | |
|
100
|
ice_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for ice measured to the nearest 100 dollars | |
|
100
|
captain_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for captain (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) | |
|
100
|
wc_tuna_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast tuna | |
|
100
|
other_supply_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for other supplies (cleaning, clothing, safety, etc.) measured to the nearest 100 dollars | |
|
100
|
participant_person_dim$middle_initial | bpchar | middle initial of person | |
|
100
|
observer_fees_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for observer fees measured to the nearest 100 dollars | |
|
100
|
wc crab_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast crab | |
|
100
|
wc_tuna_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast tuna measured in gallons per day | |
|
100
|
2015_fiscal_year_date_year | int4 | Numeric representation of year | |
|
100
|
2015_fiscal_year_date_record_type | varchar | Type of record | |
|
100
|
insurance_premium_payments_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for insurance premium payments (hull and machinery, protection and indemnity, and pollution insurance) measured to the nearest 100 dollars | |
|
100
|
other_supply_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for other supplies (cleaning, clothing, safety, etc.) measured to the nearest 100 dollars | |
|
100
|
crew_captain_travel_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for crew or captain travel not deducted from wages measured to the nearest 100 dollars | |
|
100
|
participant_state_abbrev | char | State abbreviation of participant | |
|
100
|
wc_tuna_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast tuna | |
|
100
|
fishing_gear_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fishing gear purchases, upgrades, repair, and maintenance including nets, doors, traps, pots, cables, and fishing machinery measured to the nearest 100 dollars | |
|
100
|
home_port_dim$port_group_name | varchar | port group name for observer program | |
|
100
|
crew_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for crew (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) measured to the nearest 100 dollars | |
|
100
|
crew_captain_travel_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for crew or captain travel not deducted from wages measured to the nearest 100 dollars | |
|
100
|
permit_quota_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for purchase and leasing of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
home_port_whid | int4 | Warehouse identifier for home port | |
|
100
|
participant_person_dim$nick_name | varchar | nickname of person | |
|
100
|
tendering_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in tendering measured in knots | |
|
100
|
survey_date_dim$year | int4 | numeric representation of year | |
|
100
|
wc_tuna_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in West Coast tuna measured in knots | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_not_captain_crew_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the crew on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain | |
|
100
|
moorage_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for moorage measured to the nearest 100 dollars | |
|
100
|
total_depreciation_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for total deprecation (vessel, on-board equipment, processing equipment, and quota) taken during the year measured to the nearest 100 dollars | |
|
100
|
participant_vessel_relationship | varchar | Relationship the participant has to the vessel | |
|
100
|
alaska_shoreside_landings_earnings_2014 | int4 | Income earned during 2014 for Alaska shoreside landings and at-sea deliveries of fish harvested with this vessel measured to the nearest 100 dollars | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_not_captain_captain_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the captain on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain | |
|
100
|
vessel_length_m | numeric | Length of vessel measured in meters | |
|
100
|
alaska_chartering_research_tendering_2015 | int4 | Income earned during 2015 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars | |
|
100
|
wc_salmon_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast salmon | |
|
100
|
wc_salmon_days_at_sea_2015 | int2 | Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast salmon | |
|
100
|
lease_bareboat_charter_of_vessel_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for lease or bareboat charter of this vessel measured to the nearest 100 dollars | |
|
100
|
wc_salmon_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast salmon measured in gallons per day | |
|
100
|
2015_fiscal_year_date_yyyymmdd | char | String representation of year month day | |
|
100
|
wcgf_fixed_gear_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast groundfish fixed gear | |
|
100
|
2015_fiscal_year_full_date | date | Full date value | |
|
100
|
survey_date_dim$full_date | timestamp | full date value | |
|
100
|
2015_fiscal_year_date_month_of_year | int2 | Numeric representative of month of year | |
|
100
|
wc_chartering_research_tendering_2015 | int4 | Income earned during 2015 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars | |
|
100
|
2015_fiscal_year_date_day_of_month | int2 | Numeric representation of the day in month | |
|
100
|
total_deprecatoin_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for total deprecation (vessel, on-board equipment, processing equipment, and quota) taken during the year measured to the nearest 100 dollars | |
|
100
|
crew_share_total_revenue_deductions | int4 | Concatenation of possible deductions taken from total revenue to determine crew share for the fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 | |
|
100
|
communications_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for communications, including VMS, satellite phone, skymate measured to the nearest 100 dollars | |
|
100
|
permit_quota_leases_2014 | int4 | Income earned during 2014 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars | |
|
100
|
tendering_crew_size | int4 | Vessel's crew size (not including captain) when engaged in tendering | |
|
100
|
survey_comments | varchar | Participant comments | |
|
100
|
vessel_on_board_equipment_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for vessel and on-board equipment purchases, upgrades, repair, and maintenance including all electronics, safety equipment, and machinery not used to harvest fish and excluding fishing gear and processing equipment to the nearest 100 dollars | |
|
100
|
bait_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for bait measured to the nearest 100 dollars | |
|
100
|
fishing_assoc_commission_costs_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fishing association and commission costs measured to the nearest 100 dollars | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_as_captain_fishing_trips_pct | int4 | Percentage of fishing trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 wherein the vessel owner served as captain | |
|
100
|
wc_shoreside_landings_earnings_2015 | int4 | Income earned during 2015 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars | |
|
100
|
participant_person_dim$role | varchar | role taken during an operation | |
|
100
|
salmon_disaster_relief_2015 | int4 | Income earned during 2015 for salmon disaster relief payments measured to the nearest 100 dollars | |
|
100
|
wc_crab_ave_fuel_gal_per_day | numeric | Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast crab measured in gallons per day | |
|
100
|
vessel_length_ft | numeric | Length of vessel measured in feet | |
|
100
|
participant_phone | varchar | Phone number of participant | |
|
100
|
state_licensing_fed_permit_fees_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for state licensing and federal permit fees measured to the nearest 100 dollars | |
|
100
|
alaska_fisheries_not_tendering_crew_size | int4 | Vessel's crew size (not including captain) when engaged in Alaska fisheries (not including tendering) | |
|
100
|
fishing_gear_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fishing gear purchases, upgrades, repair, and maintenance including nets, doors, traps, pots, cables, and fishing machinery measured to the nearest 100 dollars | |
|
100
|
participant_city | varchar | City of participant | |
|
100
|
other_earnings_2014 | int4 | Income earned during 2014 for other earnings measured to the nearest 100 dollars | |
|
100
|
vessel_leasing_2014 | int4 | Income earned during 2014 for leasing of vessel measured to the nearest 100 dollars | |
|
100
|
participant_email | varchar | Email of the participant | |
|
100
|
most_revenue_from_wc_landings_vessel_owner_not_captain_vessel_net_revenue_share | int4 | Share of net revenue (revenue minus the deductions) going to the vessel on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain | |
|
100
|
food_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for food measured to the nearest 100 dollars | |
|
100
|
home_port_dim$state_name | varchar | state name | |
|
100
|
processing_equipment_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for processing equipment purchases, upgrades, repair, and maintenance including any equipment used to process or head and gut fish on-board the vessel measured to the nearest 100 dollars |
Attribute Details
communications_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for communications, including VMS, satellite phone, skymate measured to the nearest 100 dollars |
trucking_fish_to_buyer_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for trucking of fish to buyer measured to the nearest 100 dollars |
most_revenue_from_wc_landings_vessel_owner_as_captain_vessel_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the vessel on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain |
other_wc_fisheries_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in other West Coast fisheries |
wc_shoreside_landings_earnings_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars |
salmon_disaster_relief_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for salmon disaster relief payments measured to the nearest 100 dollars |
survey_date_dim$month_of_year
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of month of year |
| Allowed Values: | 1-12 |
participant_person_dim$last_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
last name of person |
survey_date_dim$month_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
alaska_fisheries_not_tendering_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in Alaska fisheries (not including tendering) measured in knots |
tendering_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in tendering measured in gallons per day |
home_port_dim$port_code
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port code for observer program |
permit_quota_sales_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars |
wc_shrimp_trawl_gear_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast shrimp trawl gear |
previous_survey_replacement_value
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The replacement value of the vessel from the last completed survey rounded to the nearest 100 dollars |
wc_shrimp_trawl_gear_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast shrimp trawl gear |
off_load_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for off-load expenses (cross dock fees, port tariffs, hoist fees, etc.) measured to the nearest 100 dollars |
steaming_between_wc_alaska_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in steaming between the West Coast and Alaska |
home_port_dim$record_type
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port record or reason record is unavailable |
| Allowed Values: | Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
fishing_assoc_commission_costs_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fishing association and commission costs measured to the nearest 100 dollars |
bait_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for bait measured to the nearest 100 dollars |
alaska_chartering_research_tendering_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in Alaska chartering, research, or tendering |
previous_survey_include_fishing_gear
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if previous completed survey market value or replacement value includes the value of all the fishing gear on the vessel at that time |
| Allowed Values: | Includes Fishing Gear, Does Not Include Fishing Gear |
permit_quota_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for purchase and leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
insurance_premium_payments_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for insurance premium payments (hull and machinery, protection and indemnity, and pollution insurance) measured to the nearest 100 dollars |
alaska_fisheries_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in Alaska fisheries (not including chartering, research, or tendering) |
participant_person_dim$record_type
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
person record or reason record is unavailable |
| Allowed Values: | Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
home_port_dim$port_name_std
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port name in standard format |
wc_chartering_research_tendering_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast chartering, research, or tendering |
off_load_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for off-load expenses (cross dock fees, port tariffs, hoist fees, etc.) measured to the nearest 100 dollars |
permit_quota_sales_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars |
fuel_lubrication_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fuel and lubrication measured to the nearest 100 dollars |
vessel_leasing_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for leasing of vessel measured to the nearest 100 dollars |
state_licensing_fed_permit_fees_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for state licensing and federal permit fees measured to the nearest 100 dollars |
other_earnings_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for other earnings measured to the nearest 100 dollars |
wc_crab_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast crab |
wc_halibut_pacific_or_california_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast halibut (Pacific or California) measured in gallons per day |
alaska_shoreside_landings_earnings_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for Alaska shoreside landings and at-sea deliveries of fish harvested with this vessel measured to the nearest 100 dollars |
other_earnings_type
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other earnings description by participant |
2015_crew_share_system
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Indicates if crew shared system was used for any trips that derived the most revenue from West Coast landings during fiscal year 2015 to pay the crew |
| Allowed Values: | Crew Share System Used, Crew Share System Not Used |
processing_equipment_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for processing equipment purchases, upgrade repair, and maintenance including any equipment used to process or head and gut fish on-board the vessel measured to the nearest 100 dollars |
ice_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for ice measured to the nearest 100 dollars |
survey_date_dim$month_abbrev
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
crew_share_total_revenue_other_deduction
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Other deductions taken from total revenue to determine crew share for the fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 described by participant |
2015_fiscal_year_date_month_abbreviation
| Data Storage Type: | char |
|---|---|
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Three character representation of month in capital letters |
| Allowed Values: | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
wc_salmon_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in West Coast salmon measured in knots |
captain_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for captain (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) |
lease_bareboat_charter_of_vessel_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for lease or bareboat charter of this vessel measured to the nearest 100 dollars |
previous_survey_completed_year
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The year this survey was last completed |
participant_person_dim$first_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
first name of person |
wc_shrimp_trawl_gear_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast shrimp trawl gear measured in gallons per day |
participant_person_whid
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Participant of the survey |
food_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for food measured to the nearest 100 dollars |
vessel_id_uscg_state
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel ID US Coast Guard number or state number |
survey_date_dim$record_type
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
date, month, or year record or reason record is unavailable |
| Allowed Values: | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
home_port_dim$port_group_code
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port group code for observer program |
| Allowed Values: | AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF |
vessel_engines_hp
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Status: | Active |
| Description: |
Total engines horsepower of vessel |
steaming_between_wc_alaska_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in steaming between the West Coast and Alaska measured in gallons per day |
survey_date_dim$day_of_month
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of the day in month |
| Allowed Values: | 1-31 |
permit_quota_leases_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
vessel_fuel_capacity_gal
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Status: | Active |
| Description: |
Fuel capacity of vessel |
freight_to_vessel_on_supplies_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for freight to the vessel on supplies measured to the nearest 100 dollars |
steaming_between_wc_alaska_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in steaming between West Coast and Alaska |
survey_date_dim$yyyymmdd
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
text representation of year month day |
observer_fees_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for observer fees measured to the nearest 100 dollars |
previous_survey_value_includes_permits
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if previous completed survey market value or replacement value includes the value of permits associated with the vessel at that time |
| Allowed Values: | Includes Permits, Does Not Include Permits, NA |
2015_fiscal_year_date_whid
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the 2015 fiscal year start date |
vessel_on_board_equipment_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for vessel and on-board equipment purchases, upgrades, repair, and maintenance including all electronics, safety equipment, and machinery not used to harvest fish and excluding fishing gear and processing equipment measured to the nearest 100 dollars |
participant_zip
| Data Storage Type: | char |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Zip code of participant |
participant_person_dim$full_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full name in format of First and Last (Suffix) |
freight_to_vessel_on_supplies_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for freight to the vessel on supplies measured to the nearest 100 dollars |
participant_street_address
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Street address of participant |
survey_date_whid
| Data Storage Type: | int8 |
|---|---|
| Max Length: | 64 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for the survey date |
wc_halibut_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast halibut (Pacific or California) |
wcgf_fixed_gear_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast groundfish fixed gear measured in gallons per day |
alaska_fisheries_not_tendering_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in Alaska fisheries (not including tendering) measured in gallons per day |
crew_expenses_included_in_captain_expenses
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if crew expenses are included in captain expenses |
| Allowed Values: | Crew Expenses Included in Captain Expenses, Crew Expenses Not Included in Captain Expenses, NA |
wc_chartering_research_tendering_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
steaming_between_wc_alaska_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in steaming between the West Coast and Alaska measured in knots |
wc_shrimp_trawl_gear_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in West Coast shrimp trawl gear measured in knots |
marine_survey_performed
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates if a marine survey has been completed for the vessel |
| Allowed Values: | Marine Survey Performed, Marine Survey Not Performed, NA |
home_port_dim$port_name_caps
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port name in all capitals format |
wc_halibut_pacific_or_california_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast halibut (Pacific or California) |
trucking_fish_to_buyer_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for trucking of fish to buyer measured to the nearest 100 dollars |
vessel_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel name |
most_revenue_from_wc_landings_vessel_owner_as_captain_captain_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the captain on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain |
2015_fiscal_year_date_month_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Text representation of month |
| Allowed Values: | January, February, March, April, May, June, July, August, September, October, November, December |
crew_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for crew (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) measured to the nearest 100 dollars |
previous_survey_market_value
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
The market value of the vessel from the last completed survey rounded to the nearest 100 dollars |
wcgf_fixed_gear_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast groundfish fixed gear (longline or pots) |
most_revenue_from_wc_landings_vessel_owner_as_captain_crew_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the crew on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner serves as captain |
fuel_lubrication_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fuel and lubrication measured to the nearest 100 dollars |
2015_wc_landings_most_revenue_source
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 |
| Allowed Values: | Groundfish, Salmon, Crab, Shrimp, Other West Coast Fishery |
home_port_dim$state_abbrev
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
two letter state abbreviation |
| Allowed Values: | AK, CA, OR, WA |
moorage_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for moorage measured to the nearest 100 dollars |
alaska_chartering_research_tendering_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
ice_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for ice measured to the nearest 100 dollars |
captain_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for captain (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) |
wc_tuna_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast tuna |
other_supply_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for other supplies (cleaning, clothing, safety, etc.) measured to the nearest 100 dollars |
participant_person_dim$middle_initial
| Data Storage Type: | bpchar |
|---|---|
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
middle initial of person |
observer_fees_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for observer fees measured to the nearest 100 dollars |
wc crab_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast crab |
wc_tuna_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast tuna measured in gallons per day |
2015_fiscal_year_date_year
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Numeric representation of year |
| Allowed Values: | 1978+ |
2015_fiscal_year_date_record_type
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Type of record |
| Allowed Values: | Date, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
insurance_premium_payments_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for insurance premium payments (hull and machinery, protection and indemnity, and pollution insurance) measured to the nearest 100 dollars |
other_supply_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for other supplies (cleaning, clothing, safety, etc.) measured to the nearest 100 dollars |
crew_captain_travel_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for crew or captain travel not deducted from wages measured to the nearest 100 dollars |
participant_state_abbrev
| Data Storage Type: | char |
|---|---|
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
State abbreviation of participant |
wc_tuna_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast tuna |
fishing_gear_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fishing gear purchases, upgrades, repair, and maintenance including nets, doors, traps, pots, cables, and fishing machinery measured to the nearest 100 dollars |
home_port_dim$port_group_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
port group name for observer program |
crew_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for crew (including wages, bonuses, benefits, payroll taxes, and unemployment insurance) measured to the nearest 100 dollars |
crew_captain_travel_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for crew or captain travel not deducted from wages measured to the nearest 100 dollars |
permit_quota_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for purchase and leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
home_port_whid
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Warehouse identifier for home port |
participant_person_dim$nick_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
nickname of person |
tendering_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in tendering measured in knots |
survey_date_dim$year
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
numeric representation of year |
| Allowed Values: | 1978+ |
wc_tuna_speed_while_fishing_kn
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average speed when engaged in West Coast tuna measured in knots |
most_revenue_from_wc_landings_vessel_owner_not_captain_crew_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the crew on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain |
moorage_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for moorage measured to the nearest 100 dollars |
total_depreciation_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for total deprecation (vessel, on-board equipment, processing equipment, and quota) taken during the year measured to the nearest 100 dollars |
participant_vessel_relationship
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Relationship the participant has to the vessel |
| Allowed Values: | Vessel Captain, Accountaint/Bookkeeper for Owner, Other |
alaska_shoreside_landings_earnings_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for Alaska shoreside landings and at-sea deliveries of fish harvested with this vessel measured to the nearest 100 dollars |
most_revenue_from_wc_landings_vessel_owner_not_captain_captain_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the captain on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain |
vessel_length_m
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Status: | Active |
| Description: |
Length of vessel measured in meters |
alaska_chartering_research_tendering_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
wc_salmon_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast salmon |
wc_salmon_days_at_sea_2015
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Number of days (partial days count as full and includes days tendering as well as days fishing) this vessel was at sea during 2015 when engaged in West Coast salmon |
lease_bareboat_charter_of_vessel_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for lease or bareboat charter of this vessel measured to the nearest 100 dollars |
wc_salmon_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast salmon measured in gallons per day |
2015_fiscal_year_date_yyyymmdd
| Data Storage Type: | char |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
String representation of year month day |
wcgf_fixed_gear_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in West Coast groundfish fixed gear |
2015_fiscal_year_full_date
| Data Storage Type: | date |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Full date value |
survey_date_dim$full_date
| Data Storage Type: | timestamp |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
full date value |
2015_fiscal_year_date_month_of_year
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Numeric representative of month of year |
| Allowed Values: | 1,2,3,4,5,6,7,8,9,10,11,12 |
wc_chartering_research_tendering_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
2015_fiscal_year_date_day_of_month
| Data Storage Type: | int2 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Numeric representation of the day in month |
| Allowed Values: | 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31 |
total_deprecatoin_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for total deprecation (vessel, on-board equipment, processing equipment, and quota) taken during the year measured to the nearest 100 dollars |
crew_share_total_revenue_deductions
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Concatenation of possible deductions taken from total revenue to determine crew share for the fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 |
| Allowed Values: | Crew or Captain Travel not Deducted from Wages, Observer Fees, Fishing Association and Commision Costs, State Licensing and Federal Permit Fees, Buyback Fees, Fuel and Lubrication, Food, Ice, Bait, Off-load Expenses, Freight to Vessel on Supplies, Other Supplies, Communications, Trucking of Fish to Buyer, Insurance Premium Payments, Lease or Charter of Vessel, Expenses for Purchase and Leasing of Permits and Quoata Assocciated with this Vessel |
communications_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for communications, including VMS, satellite phone, skymate measured to the nearest 100 dollars |
permit_quota_leases_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
tendering_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in tendering |
survey_comments
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 1000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Participant comments |
vessel_on_board_equipment_expenses_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for vessel and on-board equipment purchases, upgrades, repair, and maintenance including all electronics, safety equipment, and machinery not used to harvest fish and excluding fishing gear and processing equipment to the nearest 100 dollars |
bait_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for bait measured to the nearest 100 dollars |
fishing_assoc_commission_costs_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fishing association and commission costs measured to the nearest 100 dollars |
most_revenue_from_wc_landings_vessel_owner_as_captain_fishing_trips_pct
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Percentage of fishing trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 wherein the vessel owner served as captain |
wc_shoreside_landings_earnings_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars |
participant_person_dim$role
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
role taken during an operation |
| Allowed Values: | Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand |
salmon_disaster_relief_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2015 for salmon disaster relief payments measured to the nearest 100 dollars |
wc_crab_ave_fuel_gal_per_day
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Vessel's average fuel use per day and includes steaming to the fishing grounds, harvesting fish, and steaming back to port and should include all fuels used for propulsion or other uses when engaged in West Coast crab measured in gallons per day |
vessel_length_ft
| Data Storage Type: | numeric |
|---|---|
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Precision: | 2 |
| Status: | Active |
| Description: |
Length of vessel measured in feet |
participant_phone
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Phone number of participant |
state_licensing_fed_permit_fees_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for state licensing and federal permit fees measured to the nearest 100 dollars |
alaska_fisheries_not_tendering_crew_size
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Vessel's crew size (not including captain) when engaged in Alaska fisheries (not including tendering) |
fishing_gear_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fishing gear purchases, upgrades, repair, and maintenance including nets, doors, traps, pots, cables, and fishing machinery measured to the nearest 100 dollars |
participant_city
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
City of participant |
other_earnings_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for other earnings measured to the nearest 100 dollars |
vessel_leasing_2014
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Income earned during 2014 for leasing of vessel measured to the nearest 100 dollars |
participant_email
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 100 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Email of the participant |
most_revenue_from_wc_landings_vessel_owner_not_captain_vessel_net_revenue_share
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Share of net revenue (revenue minus the deductions) going to the vessel on trips in the fishery that derived the most revenue from West Coast landings during fiscal year 2015 when the vessel owner did not serve as captain |
food_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for food measured to the nearest 100 dollars |
home_port_dim$state_name
| Data Storage Type: | varchar |
|---|---|
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
state name |
| Allowed Values: | Alaska, California, Oregon, Washington |
processing_equipment_expenses_2015
| Data Storage Type: | int4 |
|---|---|
| Max Length: | 32 |
| Required: | No |
| Primary Key: | No |
| Precision: | 0 |
| Status: | Active |
| Description: |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for processing equipment purchases, upgrades, repair, and maintenance including any equipment used to process or head and gut fish on-board the vessel measured to the nearest 100 dollars |