56041 CRF_CATCH_20190321 Entity Published / External 20969 Bottomfish Fishery-Independent Survey in Hawaii (BFISH) - Cooperative Research Fishing Surveys Data Set On Going . Data Table . 1 BFISH VARCHAR2 12 Yes Yes Active Id for survey Mission: BFISH_Year_Season (e.g. BFISH_2017_F). CHARACTER 2 SAMPLE_ID VARCHAR2 16 No No Active Id for primary sampling unit in which the sample was collected. CHARACTER 3 DRIFT_NR NUMBER 1 No No Active Sequential number for each unique drift within a "PSU". NUMBER 4 BAIT_CD VARCHAR2 5 No No Active Code for bait being fished. CHARACTER 5 SPECIES_CD VARCHAR2 4 No No Active 4 letter code for species name. CHARACTER 6 SCIENTIFIC_NAME VARCHAR2 50 No No Active Linean (Latin) species name. CHARACTER 7 COMMON_NAME VARCHAR2 50 No No Active Local Hawaiian species name. CHARACTER 8 LENGTH_CM NUMBER 6 No No 2 Active Fork length of fish to nearest centimeter. Units for values are centimeters. Measures are reported with a precision of 6. NUMBER centimeters 9 WEIGHT_LB NUMBER 2 No No Active Weight in pounds of the fish. Units for values are pounds. NUMBER pounds 10 N NUMBER 1 No No Active Numer of species of this length caught. NUMBER 11 RETAINED VARCHAR2 1 No No Active "y" or "N code for if the fish was retained (Y) or released (N). CHARACTER 12 TAG_NR NUMBER 3 No No Active Id number for PIFSC LHP tag per fish. NUMBER 13 SEQUENCE_NR VARCHAR2 8 8 Yes Yes Active Consecutive number added to each record. Starts with 00000001 for each BFISH (Survey Mission). CHARACTER 14 CREATE_DTM DATE No No Active Date and time this record was added to the database (populated by trigger); field added in August 2019. CHARACTER 15 CREATED_BY VARCHAR2 30 No No Active Application Express or Oracle username of the person creating this record (populated by trigger); field added in August 2019. CHARACTER 16 LAST_MOD_DTM DATE No No Active Date and time this record was last modified (populated by trigger); field added in August 2019. DATE 17 LAST_MOD_BY VARCHAR2 30 No No Active Application Express or Oracle username of the person who last modified this record (populated by trigger); field added in August 2019. CHARACTER gov.noaa.nmfs.inport:56041 Brent Miyamoto 2019-04-12T22:22:33 SysAdmin InPortAdmin 2022-08-09T17:11:43 2019-08-21 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2019-08-21 1 Year 2020-08-21