view_catch
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 65075
| Published / External
Created: 2021-07-27
|
Last Modified: 2023-09-23
Data Set (DS) | ID: 5609
ID: 65075
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | view_catch |
---|---|
Short Name | |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Main view for fishing report data. Joins five main fishing report tables and useful look-up tables. Replaces annual tables generated by FRS. |
* 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 View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | hawaii_dar_frds |
» Description |
Main view for fishing report data. Joins five main fishing report tables and useful look-up tables. Replaces annual tables generated by FRS. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | fishing_report_id | bigint | Identifies fishing report that catch record belongs to. |
100 | Yes | No | data_source_code | varchar | Code that is abbreviation of data source. Example: Dealer Report System, code = DRS; Online Dealer Reports, code = ODR. |
100 | Yes | No | report_type_code | varchar | 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. |
100 | Yes | No | licensee_id | bigint | Identifies fisher who submitted fishing report. |
100 | No | No | license_number | int | Commercial Marine License number assigned by HDAR. |
100 | No | No | license_number_full | varchar | 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. |
100 | No | No | fisher_name | varchar | Full name of individual holding license. |
100 | No | No | received_date | date | 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. |
100 | No | No | report_year | smallint | Year fishing report was submitted. Only applies to reports submitted once per month. |
100 | No | No | report_month | tinyint | Month fishing report was submitted. Only applies to reports submitted once per month. |
100 | No | No | trip_start_date | date | 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. |
100 | No | No | trip_end_date | date | 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. |
100 | No | No | report_date | date | 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. |
100 | No | No | vessel_type_code | varchar | Code that represents type of fishing vessel. Example: Boat/Ship, code = BS; Kayak, code = KA, etc. |
100 | No | No | vessel_type | varchar | Name of fishing vessel type. Example: Boat/Ship, Kayak, etc. |
100 | No | No | vessel_id | varchar | 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.' |
100 | No | No | vessel_name | varchar | 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. |
100 | No | No | departure_port_code | int | 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. |
100 | No | No | landing_port_code | int | 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. |
100 | Yes | No | charter_trip | tinyint | Value = 1 (true) for chartered trips. |
100 | No | No | comments | varchar | Comments regarding the fishing report. |
100 | No | No | sales_type_code | varchar | 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) |
100 | No | No | dealers | varchar | 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). |
100 | No | No | validation_status | enum | 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. |
100 | Yes | No | delayed_sale | tinyint | 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. |
100 | Yes | No | peddled | tinyint | 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). |
100 | No | No | peddled_location | varchar | Only applicable to Aquarium Catch if peddled. Location fish exported to. Example: California. |
100 | No | No | logbook_number | varchar | 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. |
100 | No | No | day_fished_id | bigint | Identifies the day fishing ocurred. Records with the same day_fished_id were caught on the same day of a fishing trip. |
100 | No | No | day_fished | date | Date fishing took place. Different from view_catch.report_date, which is last day that fishing could have occurred for a fishing report. |
100 | No | No | wind_speed | enum | 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. |
100 | No | No | day_area_id | bigint | Identifies records that were fished in the same area on the same day of a trip. |
100 | No | No | buoy_code | varchar | 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. |
100 | No | No | area_code | varchar | Can either be area code or concatenation of area and subarea. Example: 103, 140, 101A, etc. Code = 99 for all Historical Bait Reports. |
100 | No | No | area | int | 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. |
100 | No | No | subarea | char | 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. |
100 | No | No | bank | varchar | Name of bank, shoal, reef, pinnacle, atoll, island, or seamount. Example: Kingman Reef, Middle Bank, etc. |
100 | No | No | bank_quadrant | enum | 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). |
100 | No | No | depth_begin | int | Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Minimum approximate depth (fathoms) where fishing activity began. |
100 | No | No | depth_end | int | Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Maximum approximate depth (fathoms) where fishing activity ended. |
100 | No | No | area_wind_speed | int | 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. |
100 | No | No | wind_direction | enum | 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). |
100 | No | No | wave_height | int | Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Estimated height of waves (feet) at beginning of fishing activity. |
100 | No | No | current_speed | enum | 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. |
100 | No | No | current_direction | enum | 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). |
100 | No | No | area_method_id | bigint | 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. |
100 | No | No | method_code | int | 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)). |
100 | No | No | method_name | varchar | Name of fishing method. Example: Throw Net, Crab Net, Scoop Net, etc. |
100 | No | No | method_abbreviation | varchar | Abbreviation for fishing method. Example: Throw Net = TN, Crab Net = CN, Scoop Net = SC, etc. Not all fishing methods have an abbreviation. |
100 | No | No | method_type_code | int | 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. |
100 | No | No | method_type | varchar | Name of fishing method type. Example: Dive, Line, Net, etc. |
100 | No | No | hours_fished | decimal | 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. |
100 | No | No | number_of_gear_sets | int | 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'. |
100 | No | No | number_of_gear_units | int | 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. |
100 | No | No | net_height | int | 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). |
100 | No | No | number_of_hooks_per_line | int | 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). |
100 | No | No | percent_time_barrier_net | int | 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%. |
100 | No | No | percent_time_hand_net | int | 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%. |
100 | No | No | percent_time_hand | int | 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%. |
100 | No | No | percent_time_other_method | int | 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%. |
100 | No | No | other_method_code | int | 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. |
100 | No | No | catch_id | bigint | Identifies a unique catch record. |
100 | No | No | species_id | int | Identifies the species that was caught. Different from view_catch.food_species_code and view_catch.aquarium_species_code. |
100 | No | No | food_species_code | int | 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. |
100 | No | No | aquarium_species_code | int | 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. |
100 | No | No | species_group | varchar | 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. |
100 | No | No | food_name | text | Comma delimited list of names associated with a given species_id sold for food. Example: species_id = 2, food_name = Skipjack. |
100 | No | No | aquarium_name | text | Comma delimited list of names associated with a given species_id that are sold for aquariums. Example: species_id = 83, aquarium_name = Achilles Tang. |
100 | No | No | local_name | text | Comma delimited list of local names associated with a given species_id. Example: species_id = 2, local_name = Aku, Otado, Otaru. |
100 | No | No | display_name | mediumtext | 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. |
100 | No | No | rank | varchar | Name of taxonomic ranking. Example: Kingdom, Subkingdom, Phylum, Subphylum, Class, etc. |
100 | No | No | scientific_name | varchar | 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. |
100 | No | No | species_category | varchar | Name of the category marine species falls under. Example: Shells, Seaweed, Freshwater fish, Bait Only, etc. |
100 | No | No | number_caught | int | 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. |
100 | No | No | pounds_caught | decimal | 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. |
100 | No | No | number_sold | int | 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. |
100 | No | No | pounds_sold | decimal | 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. |
100 | No | No | total_value | decimal | 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. |
100 | No | No | number_released | int | 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. |
100 | No | No | number_released_berried | int | 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. |
100 | No | No | number_released_min_size | int | 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. |
100 | No | No | number_lost_to_predator | int | Number of animals lost to a predator such as a shark or dolphin. |
100 | No | No | predator_code | int | 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. |
100 | No | No | predator | varchar | Name of predator. Example: Barracuda. |
100 | No | No | bait_caught | int | 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. |
100 | No | No | bait_unit | enum | Unit measurement used to report number of bait fish taken. Example: Buckets, Pieces, Lbs, etc. Required if bait fish caught. |
Attribute Details
Attribute Name | fishing_report_id |
---|---|
Seq. Order | 1 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
Identifies fishing report that catch record belongs to. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | data_source_code |
---|---|
Seq. Order | 2 |
Data Storage Type | varchar |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code that is abbreviation of data source. Example: Dealer Report System, code = DRS; Online Dealer Reports, code = ODR. |
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 | report_type_code |
---|---|
Seq. Order | 3 |
Data Storage Type | varchar |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | licensee_id |
---|---|
Seq. Order | 4 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
Identifies fisher who submitted fishing report. |
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 | license_number |
---|---|
Seq. Order | 5 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Commercial Marine License number assigned by HDAR. |
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 | license_number_full |
---|---|
Seq. Order | 6 |
Data Storage Type | varchar |
Max Length | 13 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | fisher_name |
---|---|
Seq. Order | 7 |
Data Storage Type | varchar |
Max Length | 192 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Full name of individual holding license. |
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 | received_date |
---|---|
Seq. Order | 8 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | report_year |
---|---|
Seq. Order | 9 |
Data Storage Type | smallint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Year fishing report was submitted. Only applies to reports submitted once per month. |
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 | report_month |
---|---|
Seq. Order | 10 |
Data Storage Type | tinyint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Month fishing report was submitted. Only applies to reports submitted once per month. |
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 | trip_start_date |
---|---|
Seq. Order | 11 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | trip_end_date |
---|---|
Seq. Order | 12 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | report_date |
---|---|
Seq. Order | 13 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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_type_code |
---|---|
Seq. Order | 14 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code that represents type of fishing vessel. Example: Boat/Ship, code = BS; Kayak, code = KA, etc. |
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_type |
---|---|
Seq. Order | 15 |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fishing vessel type. Example: Boat/Ship, Kayak, etc. |
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 |
---|---|
Seq. Order | 16 |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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.' |
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 | 17 |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | departure_port_code |
---|---|
Seq. Order | 18 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | landing_port_code |
---|---|
Seq. Order | 19 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | charter_trip |
---|---|
Seq. Order | 20 |
Data Storage Type | tinyint |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
Value = 1 (true) for chartered trips. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | comments |
---|---|
Seq. Order | 21 |
Data Storage Type | varchar |
Max Length | 1024 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments regarding the fishing report. |
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 | sales_type_code |
---|---|
Seq. Order | 22 |
Data Storage Type | varchar |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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) |
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 | dealers |
---|---|
Seq. Order | 23 |
Data Storage Type | varchar |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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). |
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 | validation_status |
---|---|
Seq. Order | 24 |
Data Storage Type | enum |
Max Length | 21 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | delayed_sale |
---|---|
Seq. Order | 25 |
Data Storage Type | tinyint |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | peddled |
---|---|
Seq. Order | 26 |
Data Storage Type | tinyint |
Max Length | |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | peddled_location |
---|---|
Seq. Order | 27 |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Only applicable to Aquarium Catch if peddled. Location fish exported to. Example: 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 | logbook_number |
---|---|
Seq. Order | 28 |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | day_fished_id |
---|---|
Seq. Order | 29 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
Identifies the day fishing ocurred. Records with the same day_fished_id were caught on the same day of a fishing trip. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | day_fished |
---|---|
Seq. Order | 30 |
Data Storage Type | date |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date fishing took place. Different from view_catch.report_date, which is last day that fishing could have occurred for a fishing report. |
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 | wind_speed |
---|---|
Seq. Order | 31 |
Data Storage Type | enum |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | day_area_id |
---|---|
Seq. Order | 32 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
Identifies records that were fished in the same area on the same day of a trip. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | buoy_code |
---|---|
Seq. Order | 33 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | area_code |
---|---|
Seq. Order | 34 |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Can either be area code or concatenation of area and subarea. Example: 103, 140, 101A, etc. Code = 99 for all Historical Bait Reports. |
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 | area |
---|---|
Seq. Order | 35 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | subarea |
---|---|
Seq. Order | 36 |
Data Storage Type | char |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | bank |
---|---|
Seq. Order | 37 |
Data Storage Type | varchar |
Max Length | 35 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of bank, shoal, reef, pinnacle, atoll, island, or seamount. Example: Kingman Reef, Middle Bank, etc. |
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 | bank_quadrant |
---|---|
Seq. Order | 38 |
Data Storage Type | enum |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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). |
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 | depth_begin |
---|---|
Seq. Order | 39 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Minimum approximate depth (fathoms) where fishing activity began. |
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 | depth_end |
---|---|
Seq. Order | 40 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Maximum approximate depth (fathoms) where fishing activity ended. |
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 | area_wind_speed |
---|---|
Seq. Order | 41 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | wind_direction |
---|---|
Seq. Order | 42 |
Data Storage Type | enum |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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). |
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 | wave_height |
---|---|
Seq. Order | 43 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Required field reported only on NWHI Bottomfish Trip Daily Logs in FRS. Estimated height of waves (feet) at beginning of fishing activity. |
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 | current_speed |
---|---|
Seq. Order | 44 |
Data Storage Type | enum |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | current_direction |
---|---|
Seq. Order | 45 |
Data Storage Type | enum |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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). |
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 | area_method_id |
---|---|
Seq. Order | 46 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | method_code |
---|---|
Seq. Order | 47 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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)). |
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 | method_name |
---|---|
Seq. Order | 48 |
Data Storage Type | varchar |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fishing method. Example: Throw Net, Crab Net, Scoop Net, etc. |
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 | method_abbreviation |
---|---|
Seq. Order | 49 |
Data Storage Type | varchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Abbreviation for fishing method. Example: Throw Net = TN, Crab Net = CN, Scoop Net = SC, etc. Not all fishing methods have an abbreviation. |
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 | method_type_code |
---|---|
Seq. Order | 50 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | method_type |
---|---|
Seq. Order | 51 |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of fishing method type. Example: Dive, Line, Net, etc. |
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 | hours_fished |
---|---|
Seq. Order | 52 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 2 |
Status | Active |
Description |
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. |
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 | number_of_gear_sets |
---|---|
Seq. Order | 53 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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'. |
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 | number_of_gear_units |
---|---|
Seq. Order | 54 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | net_height |
---|---|
Seq. Order | 55 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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). |
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 | number_of_hooks_per_line |
---|---|
Seq. Order | 56 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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). |
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 | percent_time_barrier_net |
---|---|
Seq. Order | 57 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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%. |
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 | percent_time_hand_net |
---|---|
Seq. Order | 58 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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%. |
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 | percent_time_hand |
---|---|
Seq. Order | 59 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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%. |
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 | percent_time_other_method |
---|---|
Seq. Order | 60 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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%. |
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_method_code |
---|---|
Seq. Order | 61 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | catch_id |
---|---|
Seq. Order | 62 |
Data Storage Type | bigint |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 19 |
Scale | 0 |
Status | Active |
Description |
Identifies a unique catch record. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | species_id |
---|---|
Seq. Order | 63 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Identifies the species that was caught. Different from view_catch.food_species_code and view_catch.aquarium_species_code. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | 0 |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | food_species_code |
---|---|
Seq. Order | 64 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | aquarium_species_code |
---|---|
Seq. Order | 65 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | species_group |
---|---|
Seq. Order | 66 |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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_name |
---|---|
Seq. Order | 67 |
Data Storage Type | text |
Max Length | 65535 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comma delimited list of names associated with a given species_id sold for food. Example: species_id = 2, food_name = Skipjack. |
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 | aquarium_name |
---|---|
Seq. Order | 68 |
Data Storage Type | text |
Max Length | 65535 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comma delimited list of names associated with a given species_id that are sold for aquariums. Example: species_id = 83, aquarium_name = Achilles Tang. |
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 | local_name |
---|---|
Seq. Order | 69 |
Data Storage Type | text |
Max Length | 65535 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comma delimited list of local names associated with a given species_id. Example: species_id = 2, local_name = Aku, Otado, Otaru. |
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 | display_name |
---|---|
Seq. Order | 70 |
Data Storage Type | mediumtext |
Max Length | 16777215 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | rank |
---|---|
Seq. Order | 71 |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of taxonomic ranking. Example: Kingdom, Subkingdom, Phylum, Subphylum, Class, etc. |
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 | scientific_name |
---|---|
Seq. Order | 72 |
Data Storage Type | varchar |
Max Length | 125 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
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 | species_category |
---|---|
Seq. Order | 73 |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of the category marine species falls under. Example: Shells, Seaweed, Freshwater fish, Bait Only, etc. |
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 | number_caught |
---|---|
Seq. Order | 74 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | pounds_caught |
---|---|
Seq. Order | 75 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 17 |
Scale | 2 |
Status | Active |
Description |
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. |
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 | number_sold |
---|---|
Seq. Order | 76 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | pounds_sold |
---|---|
Seq. Order | 77 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 17 |
Scale | 2 |
Status | Active |
Description |
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. |
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_value |
---|---|
Seq. Order | 78 |
Data Storage Type | decimal |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 17 |
Scale | 2 |
Status | Active |
Description |
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. |
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 | number_released |
---|---|
Seq. Order | 79 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | number_released_berried |
---|---|
Seq. Order | 80 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | number_released_min_size |
---|---|
Seq. Order | 81 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | number_lost_to_predator |
---|---|
Seq. Order | 82 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Number of animals lost to a predator such as a shark or dolphin. |
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 | predator_code |
---|---|
Seq. Order | 83 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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 | predator |
---|---|
Seq. Order | 84 |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of predator. Example: Barracuda. |
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_caught |
---|---|
Seq. Order | 85 |
Data Storage Type | int |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
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. |
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_unit |
---|---|
Seq. Order | 86 |
Data Storage Type | enum |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit measurement used to report number of bait fish taken. Example: Buckets, Pieces, Lbs, etc. Required if bait fish caught. |
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 | 65075 |
---|---|
Metadata Record Created By | Bradley M Gough |
Metadata Record Created | 2021-07-27 02:20+0000 |
Metadata Record Last Modified By | Bradley M Gough |
» Metadata Record Last Modified | 2023-09-23 00:42+0000 |
Metadata Record Published | 2023-09-23 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date |
Tags |
---|