open_access_survey_fact_conf
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36443
| Published / External
Created: 2017-01-25
|
Last Modified: 2025-03-26
Data Set (DS) | ID: 30863
ID: 36443
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | open_access_survey_fact_conf |
---|---|
Short Name | |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Economic cost earnings data on commercial fishing vessels operating in the groundfish, salmon, crab, and shrimp industries. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | salmon_disaster_relief_2014 | int4 | Income earned during 2014 for salmon disaster relief payments measured to the nearest 100 dollars |
100 | No | No | survey_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | participant_person_dim$last_name | varchar | last name of person |
100 | No | No | survey_date_dim$month_name | varchar | text representation of month |
100 | No | No | 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 | No | No | 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 | No | No | home_port_dim$port_code | bpchar | port code for observer program |
100 | No | No | 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 | No | No | wc_shrimp_trawl_gear_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast shrimp trawl gear |
100 | No | No | previous_survey_replacement_value | int4 | The replacement value of the vessel from the last completed survey rounded to the nearest 100 dollars |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | home_port_dim$record_type | varchar | port record or reason record is unavailable |
100 | No | No | 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 | No | No | bait_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for bait measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | participant_person_dim$record_type | varchar | person record or reason record is unavailable |
100 | No | No | home_port_dim$port_name_std | varchar | port name in standard format |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | vessel_leasing_2015 | int4 | Income earned during 2015 for leasing of vessel measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | other_earnings_2015 | int4 | Income earned during 2015 for other earnings measured to the nearest 100 dollars |
100 | No | No | wc_crab_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast crab |
100 | No | No | 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 | No | No | 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 | No | No | other_earnings_type | varchar | Other earnings description by participant |
100 | No | No | 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 | No | No | 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 | No | No | ice_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for ice measured to the nearest 100 dollars |
100 | No | No | survey_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | 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 | No | No | 2015_fiscal_year_date_month_abbreviation | char | Three character representation of month in capital letters |
100 | No | No | wc_salmon_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in West Coast salmon measured in knots |
100 | No | No | 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 | No | No | 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 | No | No | previous_survey_completed_year | int2 | The year this survey was last completed |
100 | No | No | participant_person_dim$first_name | varchar | first name of person |
100 | No | No | 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 | No | No | participant_person_whid | int4 | Participant of the survey |
100 | No | No | food_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for food measured to the nearest 100 dollars |
100 | No | No | vessel_id_uscg_state | varchar | Vessel ID US Coast Guard number or state number |
100 | No | No | survey_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | home_port_dim$port_group_code | bpchar | port group code for observer program |
100 | No | No | vessel_engines_hp | numeric | Total engines horsepower of vessel |
100 | No | No | 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 | No | No | survey_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | 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 | No | No | vessel_fuel_capacity_gal | numeric | Fuel capacity of vessel |
100 | No | No | 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 | No | No | 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 | No | No | survey_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | 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 | No | No | 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 | No | No | 2015_fiscal_year_date_whid | int8 | Warehouse identifier for the 2015 fiscal year start date |
100 | No | No | 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 | No | No | participant_zip | char | Zip code of participant |
100 | No | No | participant_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
100 | No | No | 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 | No | No | participant_street_address | varchar | Street address of participant |
100 | No | No | survey_date_whid | int8 | Warehouse identifier for the survey date |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | crew_expenses_included_in_captain_expenses | varchar | Indicates if crew expenses are included in captain expenses |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | marine_survey_performed | varchar | Indicates if a marine survey has been completed for the vessel |
100 | No | No | home_port_dim$port_name_caps | varchar | port name in all capitals format |
100 | No | No | 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 | No | No | 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 | No | No | vessel_name | varchar | Vessel name |
100 | No | No | 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 | No | No | 2015_fiscal_year_date_month_name | varchar | Text representation of month |
100 | No | No | 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 | No | No | previous_survey_market_value | int4 | The market value of the vessel from the last completed survey rounded to the nearest 100 dollars |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 2015_wc_landings_most_revenue_source | int4 | Fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 |
100 | No | No | home_port_dim$state_abbrev | bpchar | two letter state abbreviation |
100 | No | No | moorage_expenses_2014 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for moorage measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | ice_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for ice measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | wc_tuna_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast tuna |
100 | No | No | 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 | No | No | participant_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 2015_fiscal_year_date_year | int4 | Numeric representation of year |
100 | No | No | 2015_fiscal_year_date_record_type | varchar | Type of record |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | participant_state_abbrev | char | State abbreviation of participant |
100 | No | No | 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 | No | No | 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 | No | No | home_port_dim$port_group_name | varchar | port group name for observer program |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | home_port_whid | int4 | Warehouse identifier for home port |
100 | No | No | participant_person_dim$nick_name | varchar | nickname of person |
100 | No | No | tendering_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in tendering measured in knots |
100 | No | No | survey_date_dim$year | int4 | numeric representation of year |
100 | No | No | wc_tuna_speed_while_fishing_kn | numeric | Vessel's average speed when engaged in West Coast tuna measured in knots |
100 | No | No | 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 | No | No | moorage_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for moorage measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | participant_vessel_relationship | varchar | Relationship the participant has to the vessel |
100 | No | No | 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 | No | No | 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 | No | No | vessel_length_m | numeric | Length of vessel measured in meters |
100 | No | No | 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 | No | No | wc_salmon_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast salmon |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 2015_fiscal_year_date_yyyymmdd | char | String representation of year month day |
100 | No | No | wcgf_fixed_gear_crew_size | int4 | Vessel's crew size (not including captain) when engaged in West Coast groundfish fixed gear |
100 | No | No | 2015_fiscal_year_full_date | date | Full date value |
100 | No | No | survey_date_dim$full_date | timestamp | full date value |
100 | No | No | 2015_fiscal_year_date_month_of_year | int2 | Numeric representative of month of year |
100 | No | No | 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 | No | No | 2015_fiscal_year_date_day_of_month | int2 | Numeric representation of the day in month |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | tendering_crew_size | int4 | Vessel's crew size (not including captain) when engaged in tendering |
100 | No | No | survey_comments | varchar | Participant comments |
100 | No | No | 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 | No | No | bait_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for bait measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | participant_person_dim$role | varchar | role taken during an operation |
100 | No | No | salmon_disaster_relief_2015 | int4 | Income earned during 2015 for salmon disaster relief payments measured to the nearest 100 dollars |
100 | No | No | 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 | No | No | vessel_length_ft | numeric | Length of vessel measured in feet |
100 | No | No | participant_phone | varchar | Phone number of participant |
100 | No | No | 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 | No | No | alaska_fisheries_not_tendering_crew_size | int4 | Vessel's crew size (not including captain) when engaged in Alaska fisheries (not including tendering) |
100 | No | No | 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 | No | No | participant_city | varchar | City of participant |
100 | No | No | other_earnings_2014 | int4 | Income earned during 2014 for other earnings measured to the nearest 100 dollars |
100 | No | No | vessel_leasing_2014 | int4 | Income earned during 2014 for leasing of vessel measured to the nearest 100 dollars |
100 | No | No | participant_email | varchar | Email of the participant |
100 | No | No | 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 | No | No | food_expenses_2015 | int4 | Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for food measured to the nearest 100 dollars |
100 | No | No | home_port_dim$state_name | varchar | state name |
100 | No | No | 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
Attribute Name | communications_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | trucking_fish_to_buyer_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_as_captain_vessel_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_wc_fisheries_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shoreside_landings_earnings_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | salmon_disaster_relief_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for salmon disaster relief payments measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$last_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
last name of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_fisheries_not_tendering_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in Alaska fisheries (not including tendering) measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tendering_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$port_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port code for observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_sales_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shrimp_trawl_gear_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast shrimp trawl gear |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | previous_survey_replacement_value |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The replacement value of the vessel from the last completed survey rounded to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shrimp_trawl_gear_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | off_load_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | steaming_between_wc_alaska_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in steaming between the West Coast and Alaska |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Port, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fishing_assoc_commission_costs_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | bait_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for bait measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_chartering_research_tendering_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | previous_survey_include_fishing_gear |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Includes Fishing Gear, Does Not Include Fishing Gear |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | insurance_premium_payments_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_fisheries_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
person record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$port_name_std |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in standard format |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_chartering_research_tendering_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | off_load_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_sales_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for sale of permits and quota associated with this vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fuel_lubrication_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for fuel and lubrication measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_leasing_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for leasing of vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | state_licensing_fed_permit_fees_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_earnings_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for other earnings measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_crab_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast crab |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_halibut_pacific_or_california_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_shoreside_landings_earnings_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_earnings_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Other earnings description by participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_crew_share_system |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Crew Share System Used, Crew Share System Not Used |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | processing_equipment_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ice_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for ice measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_share_total_revenue_other_deduction |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_month_abbreviation |
---|---|
Seq. Order | |
Data Storage Type | char |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_salmon_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in West Coast salmon measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | captain_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lease_bareboat_charter_of_vessel_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | previous_survey_completed_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The year this survey was last completed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$first_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
first name of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shrimp_trawl_gear_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Participant of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | food_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for food measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_id_uscg_state |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel ID US Coast Guard number or state number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$port_group_code |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group code for observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, AT, BB, CA, CB, CC, EA, FB, LA, MB, MT, NB, NP, SB, SF |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_engines_hp |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | |
Status | Active |
Description |
Total engines horsepower of vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | steaming_between_wc_alaska_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_leases_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_fuel_capacity_gal |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | |
Status | Active |
Description |
Fuel capacity of vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | freight_to_vessel_on_supplies_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | steaming_between_wc_alaska_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | observer_fees_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for observer fees measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | previous_survey_value_includes_permits |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Includes Permits, Does Not Include Permits, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the 2015 fiscal year start date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_on_board_equipment_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_zip |
---|---|
Seq. Order | |
Data Storage Type | char |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Zip code of participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$full_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full name in format of First and Last (Suffix) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | freight_to_vessel_on_supplies_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_street_address |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Street address of participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the survey date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_halibut_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wcgf_fixed_gear_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_fisheries_not_tendering_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_expenses_included_in_captain_expenses |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if crew expenses are included in captain expenses |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Crew Expenses Included in Captain Expenses, Crew Expenses Not Included in Captain Expenses, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_chartering_research_tendering_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | steaming_between_wc_alaska_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in steaming between the West Coast and Alaska measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shrimp_trawl_gear_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in West Coast shrimp trawl gear measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | marine_survey_performed |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if a marine survey has been completed for the vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Marine Survey Performed, Marine Survey Not Performed, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$port_name_caps |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port name in all capitals format |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_halibut_pacific_or_california_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast halibut (Pacific or California) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | trucking_fish_to_buyer_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_as_captain_captain_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | previous_survey_market_value |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The market value of the vessel from the last completed survey rounded to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wcgf_fixed_gear_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_as_captain_crew_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fuel_lubrication_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for fuel and lubrication measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_wc_landings_most_revenue_source |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Fishery this vessel derived the most revenue from West Coast landings during fiscal year 2015 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Groundfish, Salmon, Crab, Shrimp, Other West Coast Fishery |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$state_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
two letter state abbreviation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AK, CA, OR, WA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | moorage_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2014 for moorage measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_chartering_research_tendering_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ice_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for ice measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | captain_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_tuna_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast tuna |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_supply_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$middle_initial |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
middle initial of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | observer_fees_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for observer fees measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc crab_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_tuna_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of record |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | insurance_premium_payments_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_supply_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_captain_travel_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_state_abbrev |
---|---|
Seq. Order | |
Data Storage Type | char |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State abbreviation of participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_tuna_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fishing_gear_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$port_group_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
port group name for observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_captain_travel_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for home port |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$nick_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
nickname of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tendering_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in tendering measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_tuna_speed_while_fishing_kn |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Vessel's average speed when engaged in West Coast tuna measured in knots |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_not_captain_crew_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | moorage_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for moorage measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | total_depreciation_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_vessel_relationship |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Relationship the participant has to the vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Vessel Captain, Accountaint/Bookkeeper for Owner, Other |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_shoreside_landings_earnings_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_not_captain_captain_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_length_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | |
Status | Active |
Description |
Length of vessel measured in meters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_chartering_research_tendering_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for Alaska chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_salmon_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast salmon |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_salmon_days_at_sea_2015 |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lease_bareboat_charter_of_vessel_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_salmon_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | char |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
String representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wcgf_fixed_gear_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in West Coast groundfish fixed gear |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_full_date |
---|---|
Seq. Order | |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Numeric representative of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4,5,6,7,8,9,10,11,12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_chartering_research_tendering_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for West Coast chartering, research, or tendering including direct reimbursements measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | 2015_fiscal_year_date_day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | total_deprecatoin_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | crew_share_total_revenue_deductions |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | communications_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | permit_quota_leases_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for leasing of permits and quota associated with this vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tendering_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in tendering |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | survey_comments |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 1000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Participant comments |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_on_board_equipment_expenses_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | bait_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for bait measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fishing_assoc_commission_costs_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_as_captain_fishing_trips_pct |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_shoreside_landings_earnings_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for West Coast shoreside landings (obtained from fish ticket data) measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_person_dim$role |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
role taken during an operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | salmon_disaster_relief_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2015 for salmon disaster relief payments measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | wc_crab_ave_fuel_gal_per_day |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_length_ft |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | |
Status | Active |
Description |
Length of vessel measured in feet |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_phone |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Phone number of participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | state_licensing_fed_permit_fees_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | alaska_fisheries_not_tendering_crew_size |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Vessel's crew size (not including captain) when engaged in Alaska fisheries (not including tendering) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fishing_gear_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_city |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
City of participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | other_earnings_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for other earnings measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel_leasing_2014 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Income earned during 2014 for leasing of vessel measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | participant_email |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Email of the participant |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_revenue_from_wc_landings_vessel_owner_not_captain_vessel_net_revenue_share |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | food_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Total costs (both expenses and capitalized expenditures) during fiscal year 2015 for food measured to the nearest 100 dollars |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | home_port_dim$state_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Alaska, California, Oregon, Washington |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | processing_equipment_expenses_2015 |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
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 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36443 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:22+0000 |
Metadata Record Last Modified By | Allen Chen |
» Metadata Record Last Modified | 2025-03-26 18:42+0000 |
Metadata Record Published | 2017-02-13 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-13 |
Tags |
---|