view_catch

Identifies fishing report that catch record belongs to.

Code that is abbreviation of data source. Example: Dealer Report System, code = DRS; Online Dealer Reports, code = ODR.

Code assigned to report type. Example: MHI Deep 7 Bottomfish Fishing Trip Report, code = BF; Tuna Handline Trip Report, code = TUNA.

The following rules are applied by OFR:

• By Default, code = FR (Fishing Report).

• When one or more of Deep 7 Bottomfish are caught, code = BF. Deep 7 are found in species table with species_id = (15, 17, 19, 21, 22, 58, 97) and have species.species_category_code = 21 (Bottomfish – Deep 7).

• When the fishing method is a Tuna fishing method and the area is a Tuna area, code = TUNA. Tuna fishing methods are found in method table where method_code = (8, 9, 10, 61, 62, 63, 92, 93, 97) or where method.is_tuna = 1. Tuna areas are found in area table where area_code = (15818, 181, 16223F, 15717, 16019, 15217) or where area.is_tuna = 1.

• When one or more fishing methods is a NTD fishing method, code = NTD. NTD fishing methods are found in method table where method_code = (13, 14, 21, 22, 23, 24, 25, 26, 27, 32, 33, 40, 51, 52, 53, 54) and where method.is_ntd = 1.

• When multiple criteria are met, only a single code is applied using the following priority: BF, TUNA, NTD, FR.

Identifies fisher who submitted fishing report.

Commercial Marine License number assigned by HDAR.

Unique key in licensee table. The following rules apply to calculating the number:

• For 'Permanent' licenses, value = licensee.license_number.

• For 'Yearly Food' licenses, value = licensee.license_number_year + licensee.license_number + licensee.duplicate_license_number_suffix.

• For 'Yearly Aquarium' licenses, value = licensee.license_number_year + licensee.license_number + 'A'.

Example: 1001, 1978-215A, 1976-1-A, etc.

Full name of individual holding license.

Date HDAR staff received paper form or date fisher submitted report online. Date is set to the current date when a fisher modifies report online.

Year fishing report was submitted. Only applies to reports submitted once per month.

Month fishing report was submitted. Only applies to reports submitted once per month.

Date fishing trip started. Only applies to reports submitted once per fishing trip. For NTD in FRS, trip_start_date = trip_end_date because form submitted daily.

Date fishing trip ended. Only applies to reports submitted once per fishing trip. For NTD in FRS, trip_start_date = trip_end_date because form submitted daily.

Last day that fishing could have occured for a fishing report. Not the date fisher submitted fishing report. If view_catch.trip_end_date exists, report_date = trip_end_date. If trip_end_date does not exist, equal to last day in view_catch.report_month and view_catch.report_year. This is the column to use when grouping data by year or month. Different from view_catch.day_fished, which is the day fishing occurred.

Code that represents type of fishing vessel. Example: Boat/Ship, code = BS; Kayak, code = KA, etc.

Name of fishing vessel type. Example: Boat/Ship, Kayak, etc.

Hawaii State (HA) or U.S. Coast Guard (UCSG) vessel registration/documentation number. In FRS, this is optional. Required in OFR when vessel type is Boat/Ship vessel or fishing method requires vessel.

Note: HA vessel registration number suffix indicates vessel use. Recreational use is denoted by letters 'A' through 'F.' Commercial fishing is denoted by 'CF.' Commercial passenger is denoted by 'CP.'

Name of fishing vessel as registered with the State Division of Boating & Ocean Recreation. Field will not be reported if vessel was not used when fishing. Always null in OFR. OFR can display vessel name because it maintains a list of vessel names to the vessel_id.

Numeric code associated with port or launch ramp where fisher departed to go fishing. Example: Kewalo Basin, code = 511. Required field in OFR when fisher enters own report, but optional if staff enters fishing report.

Numeric code associated with port or launch ramp where fisher landed catch or returned fishing vessel. Example: Kewalo Basin, code = 511. Required field in OFR.

Value = 1 (true) for chartered trips.

Comments regarding the fishing report.

Type of sales transaction. Values include: NOS, DLR, CRS, or DLR,CRS where:

• NOS = No Sales (Did not sell any fish)

• DLR = Sold to dealer (dealers column will have value)

• CRS = Cash or Retail Sales

• DLR,CRS = Sold to dealer and cash or retails sale (dealers column will have value)

List of license numbers or names of commercial dealers that the catch was sold to. Required in OFR when view_catch.sales_type_code = 'DLR', 'DLR,CRS', or 'CRS' (Dealer Sale, Dealer Sale and Cash and Retail Sale, Cash or Retail Sale).

Validation status when adding report to OFR. Values include: Approved, Pending, Approved - No Response. HDAR staff reach out to fishers whose fishing reports are flagged on Error Reports. If fisher was contacted, status set to Pending. If fisher makes a correction or confirms the original report was correct, status set to Approved. If fisher does not respond after multiple attempts to contact, status set to Approved - No Response. A null value means the report was never flagged or no error was detected.

Only applicable to Aquarium Catch. If value = 1 (true), sales information (e.g. sold and value) was reported at a later time. Upon receiving the sales information at a later date, fisher could use another form to report sales, or the original submission.

Only applicable to Aquarium Catch. If value = 1 (true), catch was directly exported or sold outside Hawaii (e.g. shipping, auction websites, etc.) or to persons within Hawaii (e.g. friends, family, cash basis, etc.); if not, value = 0 (false).

Only applicable to Aquarium Catch if peddled. Location fish exported to. Example: California.

Sequential page number of report from NWHI Bottomfish Trip Daily Log sheets from 2002-2009. Different from view_purchases.trip_number, which is the number generated by dealers who buy from longline fishers on purchase reports.

Identifies the day fishing ocurred. Records with the same day_fished_id were caught on the same day of a fishing trip.

Date fishing took place. Different from view_catch.report_date, which is last day that fishing could have occurred for a fishing report.

Approximate wind speed (knots) on day of fishing. Reported using OFR. Values include: 0-10,11-15, 16-20, 21+. Different from view_catch.area_wind_speed, which is wind speed reported for NWHI reports using FRS.

Identifies records that were fished in the same area on the same day of a trip.

Code assigned to a buoy. Reported when fishing on or around a buoy. In OFR, fishing area is automatically assigned to fishing report when buoy is selected. Buoy types can be FADs, State FADs, Artificial Reefs, or Weather Buoys.

Can either be area code or concatenation of area and subarea. Example: 103, 140, 101A, etc. Code = 99 for all Historical Bait Reports.

Code for the fishing location that corresponds to the area fished on the HDAR Commercial Fisheries Statistical Chart used after 1993. Example: areas around Hawaii Island are coded 100-199. Areas can be subdivided into subareas. Example: some areas around Hawaii Island are coded with letters starting with 'A' or a number.

Some areas are broken up into smaller subsections, which are named by a letter or number. In Northwestern Hawaiian Islands, areas are broken up into subareas approximately 20 square nautical miles, labeled 'A' through 'I'. These subareas are from the HDAR Commercial Fisheries Statistical Chart used after 1993. Example: A, B, etc.

Name of bank, shoal, reef, pinnacle, atoll, island, or seamount. Example: Kingman Reef, Middle Bank, etc.

Optional field only reported on NWHI Bottomfish Trip Daily Logs in FRS. Directional quadrant fishing bank is located within. Values include: Northwest (NW), Northeast (NE), Southeast (SE), Southwest (SW).

Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Minimum approximate depth (fathoms) where fishing activity began.

Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Maximum approximate depth (fathoms) where fishing activity ended.

Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Estimated wind speed (knots) at beginning of fishing activity. Different from view_catch.wind_speed, which is wind speed reported from the data source OFR.

Optional field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Direction wind was blowing at beginning of fishing activity. Values include: Northwest (NW), North (N), Northeast (NE), East (E), Southeast (SE), South (S), Southwest (SW), West (W).

Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Estimated height of waves (feet) at beginning of fishing activity.

Optional field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Approximate subsurface current speed at beginning of fishing activity. Values include: Slow, Medium, Fast.

Optional field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Approximate subsurface current direction at beginning of fishing activity. Values include: Northwest (NW), North (N), Northeast (NE), East (E), Southeast (SE), South (S), Southwest (SW), West (W).

Identifies a fishing method used in a given area for a trip. Records with the same area_method_id were fished in the same area for a given trip.

Code that identifies the specific fishing method within a method_type group. Each method_type can have one or more method_codes. Example: method_type 6 is 'Net', and includes method_codes such as 26 = Crab Net, 27 = Throw Net, and 41 = Scoop Net.

The hierarchy for this grouping is method_type (broader category of fishing methods) then method_code (specific fishing methods) where each method_code belongs to a method_type.

For specific types of reports, the following method_codes apply:

• For Aku fishing reports the method_code is always 1 (Aku Boat).

• For bait reports (e.g. Aku Boat Bait Reports) the method_code is always 30 (Bait Net).

• Aquarium fishing reports the method_code is always 1000 (Aquarium (Multiple Methods)).

Name of fishing method. Example: Throw Net, Crab Net, Scoop Net, etc.

Abbreviation for fishing method. Example: Throw Net = TN, Crab Net = CN, Scoop Net = SC, etc. Not all fishing methods have an abbreviation.

Code that identifies the broadest grouping of fishing methods. Each method_type_code can have one or more method_codes, which are more specific types of fishing methods. Example: method_type 6 is 'Net', and includes method_codes such as 26 = Crab Net, 27 = Throw Net, and 41 = Scoop Net.

The hierarchy for this grouping is method_type (broader category of fishing methods) then method_code (specific fishing methods) where each method_code belongs to a method_type.

Name of fishing method type. Example: Dive, Line, Net, etc.

Number of hours fished (fishing gear soak time), excludes transit and search time. In fishing reports, field is either not allowed, optional or required based on fishing report type and fishing method business rules. Value is null if not required. Value of zero represents bad data.

Number of times the gear was set. In fishing reports, field is not allowed, optional or required based on fishing report type and fishing method business rules. For Aku Boat and Bait Fish reports, field is always required and fishing method is always 'Bait Net'.

Number of gear units, such as number of divers, number of fishers, number of lines, number of traps, etc. In fishing reports, field is not allowed, optional or required based on fishing report type and fishing method business rules.

Height of net used (feet). In fishing reports, field is not allowed, optional or required based on fishing report type and fishing method business rules. Only applies to Gill Net fishing (method_code = 22).

Number of hooks per line. In fishing reports, field is not allowed, optional or required based on fishing report type and fishing method business rules. Only applies to Deep-Sea Handline fishing (method_code = 3).

Only used by Aquarium fishing reports. Percentage of time barrier net is deployed (even if fisher collects with other methods at the same time). The sum of all percent_time columns in this table must add up to 100%.

Only used by Aquarium fishing reports. Percentage of time utilizing a hand net. The sum of all percent_time columns in this table must add up to 100%.

Only used by Aquarium fishing reports. Percentage of time collecting species by hand. The sum of all percent_time columns in this table must add up to 100%.

Only used by Aquarium fishing reports. Percentage of time utilizing any other fishing method not listed. The sum of all percent_time columns in this table must add up to 100%.

Only used by Aquarium fishing reports. Codes of other fishing methods. Example: Slurp Gun, code = 1001; Vinyl Bag, code = 1002, etc. Required when view_catch.percent_time_other_method > 0.

Identifies a unique catch record.

Identifies the species that was caught. Different from view_catch.food_species_code and view_catch.aquarium_species_code.

Codes associated with species collected for food from all HDAR forms except Aquarium forms. Different from view_catch.aquarium_species_code, which are codes associated with species collected for aquarium. Note: food_species_code and view_catch.aquarium_species_code have overlapping species but species codes are unique to each column, meaning the same fish can have a different code in each column. Example: Achilles Tang, food_species_code = 85 and view_catch.aquarium_species_code = 103.

Codes associated with species collected for aquariums. Codes are from HDAR Aquarium Fish Trip Report. Different from view_catch.food_species_code, which are codes associated with species collected for food. Note: view_catch.food_species_code and aquarium_species_code have overlapping species but species codes are unique to each column, meaning the same fish can have a different code in each column. Example: Achilles Tang, view_catch.food_species_code = 85 and aquarium_species_code = 103.

Only applies to Aquarium species. Regulations by HDAR Administrative Rules, Title 13, Subtitle 4 Fisheries. Can refer to physical characteristics of species such as sex, size, age, or color of animal. Example: Female, >4", Medium, Black, etc.

Comma delimited list of names associated with a given species_id sold for food. Example: species_id = 2, food_name = Skipjack.

Comma delimited list of names associated with a given species_id that are sold for aquariums. Example: species_id = 83, aquarium_name = Achilles Tang.

Comma delimited list of local names associated with a given species_id. Example: species_id = 2, local_name = Aku, Otado, Otaru.

Primary name displayed by applications and reports. Name come from species_common_name.name where species_common_name_type_code = 5 (Display Name). If no records where species_common_name_type_code = 5, species.scientific_name is used.

Name of taxonomic ranking. Example: Kingdom, Subkingdom, Phylum, Subphylum, Class, etc.

Normally the binomial name, which consists of a generic name (the genus name) and the specific name (the species name). If species cannot be identified to the species level, it will be identified to the highest known taxonomic ranking, such as its phylum, class, infraclass, order, suborder, family, or subfamily. A genus name followed by 'spp.' refers to multiple species within that genus. A genus name followed by 'sp.' refers to one species. The scientific name for species identified at the rank of family or higher will be the name followed by the rank in parentheses. Example: Thunnus thynnus, Nerita spp., Scombridae (family), Anthozoa (class), etc. Different from common name.

Name of the category marine species falls under. Example: Shells, Seaweed, Freshwater fish, Bait Only, etc.

Estimated number of animals caught or landed. Commonly reported with view_catch.pounds_caught. Always required in FRS but value can be zero for certain species, if catch is released or released to a predator. Required in OFR unless species is exempt from reporting.

Number of pounds of marine life caught or landed, uses standard rounding. Commonly reported with view_catch.number_caught. Always required in FRS but value can be zero for certain species, if catch is released or released to a predator. Required in OFR unless species is exempt from reporting weight.

Reported in NWHI and Aquarium reports. Number of animals sold. Commonly reported with view_catch.pounds_sold. Can be zero when field is required, depending on fishing report type.

Reported in Historical Catch and NWHI reports. Number of pounds of marine life sold, uses standard rounding. Commonly reported with view_catch.number_sold. Can be zero when field is required, depending on fishing report type. If percent of whole weight for species condition does not exist for species, view_purchase.pounds_bought = pounds_sold.

Reported in Historical Catch, NWHI and Aquarium reports. Total value of marine life sold. Can be zero when field is required, depending on the fishing report type.

Number of animals released dead or alive. Includes those tagged and released. Required when entering data in FRS and OFR except when entering catch for Net Trap Dive species caught using a Net Trap Dive fishing method. Either number_released is reported, or view_catch.number_released_berried and view_catch.number_released_min_size are reported, depending on the species caught.

Number of animals that were released because they were egg-bearing. Regulation from Hawaii Administrative Rules, Title 13, Chapter 95. Required in FRS when entering catch for species listed on Net Trap Dive Activity Report Form (when view_catch.report_type_code = NTD). Required in OFR when entering catch for Net Trap Dive species using a Net Trap Dive fishing method. Either view_catch.number_released is reported, or number_released_berried and view_catch.number_released_min_size are reported together, depending on the species caught.

Number of animals that were released because they were under the minimum size requirement for taking. Regulation from Hawaii Administrative Rules, Title 13, Chapter 95. Required in FRS when entering catch for species listed on Net Trap Dive Activity Report Form (view_catch.report_type_code = NTD). Required in OFR when entering catch for Net Trap Dive species using a Net Trap Dive fishing method. Either view_catch.number_released is reported, or view_catch.number_released_berried and number_released_min_size are reported together, depending on the species caught.

Number of animals lost to a predator such as a shark or dolphin.

Numeric code for type of predator. Example: Barracuda, code = 3. Required when view_catch.number_lost_to_predator > 0. Code = 99 (Unknown) is used when the fisher is unsure what species took their catch. When importing data from the FRS, predator code was converted to code = 99 when more than one predator was listed due to differences in how the data was stored.

Name of predator. Example: Barracuda.

Number of bait fish taken, in units specified in view_catch.bait_unit. Always required in Bait Reports, and required if bait fish caught for Aku Reports.

Unit measurement used to report number of bait fish taken. Example: Buckets, Pieces, Lbs, etc. Required if bait fish caught.