Search Help Show/Hide Menu
Metadata Rubric
83%
4.96 / 6
View Report
PSMFC Metadata Library > Recreational Fisheries Information Network > RecFIN Database > RecFIN_MARTS Schema >

Table: COMPREHENSIVE_BIO_DETAIL

Entity (ENT)  |  Pacific States Marine Fisheries Commission (PSMFC)
GUID: gov.noaa.nmfs.inport:55989  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

The RecFIN Comprehensive Bio-Detail table provides bio-detail samples of recreational retained fish from dockside interviews and other landing locations as well as recreational released fish from at-sea commercial passenger fishing vessels (i.e., charter trips). Records in this table are from samples collected from California Department of Fish and Wildlife CRFSS, Oregon Department of Fish and Wildlife ORBS, Washington Department of Fish and Wildlife BDS, and Sportfishing Association of California sampling efforts.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BIO_DETAIL_ID
NUMBER 		Numeric unique identifier for the bio detail sample record
ANGLER_ID
NUMBER 		Numeric identifier for the parent angler trip record
CATCH_ID
NUMBER 		Numeric identifier for the parent catch record
CPFV_TRIP_ID
NUMBER 		Numeric identifier for the parent CPFV trip record
RECFIN_YEAR
NUMBER 		Year of sample
RECFIN_MONTH
NUMBER 		Month of sample
RECFIN_DAY
NUMBER 		Day of sample
RECFIN_DATE
DATE 		Date of sample
AGENCY_CODE
NUMBER 		RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
AGENCY
CHAR 		PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW)
STATE_NAME
VARCHAR2 		State name
LOCATION_NUMBER
NUMBER
INTERVIEW_SITE
NUMBER 		Numeric interview site code (CDFW only)
COUNTY_NUMBER
NUMBER 		State agency county code where interview occurred (CDFW only)
NUMBER_OF_ANGLERS
NUMBER 		Number of anglers fishing
NUMBER_HOURS_FISHED
NUMBER 		Number of hours fished during the trip (ODFW only)
SPORT_GEAR_TYPE
VARCHAR2 		Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear)
SPORT_GEAR_MODE
VARCHAR2 		State agency Biological Data System (BDS) fishing mode code (WDFW only)
AGENCY_PORT_CODE
NUMBER 		State agency port code
RECFIN_PORT_CODE
NUMBER 		RecFIN standard port or district code
RECFIN_PORT_NAME
VARCHAR2 		RecFIN port name
RECFIN_DISTRICT_NAME
VARCHAR2 		RecFIN standard district name
AGENCY_TRIP_TYPE_CODE
VARCHAR2 		State agency trip type (targeted species) code
RECFIN_TRIP_TYPE_CODE
NUMBER 		RecFIN standard trip type (targeted species) code
RECFIN_TRIP_TYPE_NAME
VARCHAR2 		RecFIN trip type (targeted species) name
RECFIN_TRIP_TYPE_DETAIL_NAME
VARCHAR2 		Specific state-defined trip type (targeted species)
DURATION_TYPE_CODE
NUMBER 		CPFV trip duration type code
DURATION_TYPE_DESCRIPTION
VARCHAR2 		CPFV trip duration type description
AGENCY_WATER_AREA_CODE
VARCHAR2 		State agency water area code
AGENCY_WATER_AREA_NAME
VARCHAR2 		State agency water area name
AGENCY_FISHED_AREA_CODE
VARCHAR2 		State agency specific fishing location code used
AGENCY_FISHED_AREA_NAME
VARCHAR2 		State agency specific fishing location name
RECFIN_WATER_AREA_CODE
NUMBER 		RecFIN standard water area code
RECFIN_WATER_AREA_NAME
VARCHAR2 		RecFIN water area name
AGENCY_CATCH_AREA_CODE
VARCHAR2 		State agency catch area code (ODFW only)
AGENCY_CATCH_AREA_NAME
VARCHAR2 		State agency catch area name (ODFW only)
WATER_FISHED_COUNTRY_NAME
VARCHAR2 		Country where the fishing trip occurred
AGENCY_MODE_CODE
VARCHAR2 		State agency fishing mode code
RECFIN_MODE_CODE
NUMBER 		RecFIN standard fishing mode code
RECFIN_MODE_NAME
VARCHAR2 		RecFIN fishing mode name
DESCENDING_DEVICE_USED
CHAR 		Descending device present (CDFW only)
FISHING_DEPTH
NUMBER 		Depth in feet.
AGENCY_SPECIES_CODE
VARCHAR2 		State agency species code
RECFIN_SPECIES_CODE
NUMBER 		RecFIN standard species code
SPECIES_NAME
VARCHAR2 		Species common name
SCIENTIFIC_NAME
VARCHAR2 		Species scientific name
FISHERY_MANAGEMENT_PLAN
VARCHAR2 		PFMC Fishery Management Plan
SPECIES_GROUP_NAME
VARCHAR2 		Species group name
STOCK_COMPLEX_NAME
VARCHAR2 		Species complex designation (e.g., nearshore deep demersal, etc.)
PACFIN_SPECIES_CODE
VARCHAR2 		PacFIN standard species code
FISH_SEX
VARCHAR2 		State agency fish sex code
AGENCY_LENGTH
NUMBER 		Measured length of sample
AGENCY_LENGTH_UNITS
CHAR 		Units of the agency measured length of sample (C = centimeters, M = millimeters)
AGENCY_LENGTH_TYPE
CHAR 		Type of length measurement of sample (T = Total, F = Fork)
IS_AGENCY_LENGTH_WITHIN_MAX
CHAR 		Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False)
AGENCY_WEIGHT
NUMBER 		Measured weight of sample
AGENCY_WEIGHT_UNITS
CHAR 		Units of the agency measured weight of sample (G = grams, K = kilograms)
RECFIN_LENGTH_MM
NUMBER 		Agency length converted to millimeters
RECFIN_LENGTH_TYPE
CHAR 		Type of length measurement of sample (T = Total, F = Fork)
RECFIN_IMPUTED_LENGTH
NUMBER
RECFIN_IMPUTED_WEIGHT_KG
NUMBER 		Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters
FISH_DISPOSITION
NUMBER 		Fish disposition (CDFW CRFS and CDFW and ODFW discard samples only; 3 = Eat, 4 = Bait, 5 = Give Away, 6 = ?, 7 = Other Purpose, 8 = Dont know, 9 = Refused)
FISH_INSPECTED
NUMBER 		Number of fish (avail.) (CDFW only)
NUMBER_OF_LOCATIONS
NUMBER 		Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only)
NUMBER_OF_SPECIES
NUMBER 		Number of species encountered on a trip (CDFW only)
SALMON_TAG
NUMBER 		5-digit salmon tag number (CDFW only)
WHITE_SEABASS_TAG
VARCHAR2 		3-character tag number (e.g., 01N, 02N, 03N; CDFW only)
SAMPLE_COMMENT
VARCHAR2 		Comments for Sample
SOURCE_CODE
VARCHAR2 		Sampling source code (BIO = ODFW ORBS and CDFW CRFS sampling, BDS = WDFW BDS sampling, CPFV = ODFW and CDFW at-sea CPFV sampling, ORA = ODFW age sampling, SAC = Sportfishing Association of California sampling)
IS_RETAINED
CHAR 		Identifies whether the sample was retained or released (T = retained, F = released)
RECFIN_VDATE
DATE

Child Items

No Child Items for this record.

Contact Information

Metadata Contact
Jason Edwards
jedwards@psmfc.org

Item Identification

Title: Table: COMPREHENSIVE_BIO_DETAIL
Short Name: COMPREHENSIVE_BIO_DETAIL Table
Status: On Going
Abstract:

The RecFIN Comprehensive Bio-Detail table provides bio-detail samples of recreational retained fish from dockside interviews and other landing locations as well as recreational released fish from at-sea commercial passenger fishing vessels (i.e., charter trips). Records in this table are from samples collected from California Department of Fish and Wildlife CRFSS, Oregon Department of Fish and Wildlife ORBS, Washington Department of Fish and Wildlife BDS, and Sportfishing Association of California sampling efforts.

Purpose:

The purpose of the RecFIN Comprehensive Bio-Detail table is to provide bio-detail samples (e.g. length, weight, sex) of retained and released fish from the ocean recreational fisheries of California, Oregon, and Washington.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None agency
None BDS
None bio-detail
None Biological Data System
None biological detail
None biological sample
None California Department of Fish and Wildlife
None California Recreational Fisheries Statistical Survey
None CDFW
None CPFV
None CRFSS
None length
None mode
None Ocean Recreational Boat Survey
None Ocean Sampling Project
None ODFW
None ORBS
None Oregon Department of Fish and Wildlife
None recreational fisheries
None release
None retained
None SAC
None sample
None sex
None species
None trip type
None Washington Department of Fish and Wildlife
None WDFW
None weight

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None month
None year

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None California
None county
None district
None interview site
None Oregon
None port
None state
None Washington
None water area

Physical Location

Organization: Pacific States Marine Fisheries Commission
City: Portland
State/Province: OR
Country: United States of America

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: RECFIN_MARTS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key BIO_DETAIL_ID NUMBER Numeric unique identifier for the bio detail sample record
100
 ANGLER_ID NUMBER Numeric identifier for the parent angler trip record
100
 CATCH_ID NUMBER Numeric identifier for the parent catch record
100
 CPFV_TRIP_ID NUMBER Numeric identifier for the parent CPFV trip record
100
 RECFIN_YEAR NUMBER Year of sample
100
 RECFIN_MONTH NUMBER Month of sample
100
 RECFIN_DAY NUMBER Day of sample
100
 RECFIN_DATE DATE Date of sample
100
 AGENCY_CODE NUMBER RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
100
 AGENCY CHAR PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW)
100
 STATE_NAME VARCHAR2 State name
67
 LOCATION_NUMBER NUMBER
100
 INTERVIEW_SITE NUMBER Numeric interview site code (CDFW only)
100
 COUNTY_NUMBER NUMBER State agency county code where interview occurred (CDFW only)
100
 NUMBER_OF_ANGLERS NUMBER Number of anglers fishing
100
 NUMBER_HOURS_FISHED NUMBER Number of hours fished during the trip (ODFW only)
100
 SPORT_GEAR_TYPE VARCHAR2 Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear)
100
 SPORT_GEAR_MODE VARCHAR2 State agency Biological Data System (BDS) fishing mode code (WDFW only)
100
 AGENCY_PORT_CODE NUMBER State agency port code
100
 RECFIN_PORT_CODE NUMBER RecFIN standard port or district code
100
 RECFIN_PORT_NAME VARCHAR2 RecFIN port name
100
 RECFIN_DISTRICT_NAME VARCHAR2 RecFIN standard district name
100
 AGENCY_TRIP_TYPE_CODE VARCHAR2 State agency trip type (targeted species) code
100
 RECFIN_TRIP_TYPE_CODE NUMBER RecFIN standard trip type (targeted species) code
100
 RECFIN_TRIP_TYPE_NAME VARCHAR2 RecFIN trip type (targeted species) name
100
 RECFIN_TRIP_TYPE_DETAIL_NAME VARCHAR2 Specific state-defined trip type (targeted species)
100
 DURATION_TYPE_CODE NUMBER CPFV trip duration type code
100
 DURATION_TYPE_DESCRIPTION VARCHAR2 CPFV trip duration type description
100
 AGENCY_WATER_AREA_CODE VARCHAR2 State agency water area code
100
 AGENCY_WATER_AREA_NAME VARCHAR2 State agency water area name
100
 AGENCY_FISHED_AREA_CODE VARCHAR2 State agency specific fishing location code used
100
 AGENCY_FISHED_AREA_NAME VARCHAR2 State agency specific fishing location name
100
 RECFIN_WATER_AREA_CODE NUMBER RecFIN standard water area code
100
 RECFIN_WATER_AREA_NAME VARCHAR2 RecFIN water area name
100
 AGENCY_CATCH_AREA_CODE VARCHAR2 State agency catch area code (ODFW only)
100
 AGENCY_CATCH_AREA_NAME VARCHAR2 State agency catch area name (ODFW only)
100
 WATER_FISHED_COUNTRY_NAME VARCHAR2 Country where the fishing trip occurred
100
 AGENCY_MODE_CODE VARCHAR2 State agency fishing mode code
100
 RECFIN_MODE_CODE NUMBER RecFIN standard fishing mode code
100
 RECFIN_MODE_NAME VARCHAR2 RecFIN fishing mode name
100
 DESCENDING_DEVICE_USED CHAR Descending device present (CDFW only)
100
 FISHING_DEPTH NUMBER Depth in feet.
100
 AGENCY_SPECIES_CODE VARCHAR2 State agency species code
100
 RECFIN_SPECIES_CODE NUMBER RecFIN standard species code
100
 SPECIES_NAME VARCHAR2 Species common name
100
 SCIENTIFIC_NAME VARCHAR2 Species scientific name
100
 FISHERY_MANAGEMENT_PLAN VARCHAR2 PFMC Fishery Management Plan
100
 SPECIES_GROUP_NAME VARCHAR2 Species group name
100
 STOCK_COMPLEX_NAME VARCHAR2 Species complex designation (e.g., nearshore deep demersal, etc.)
100
 PACFIN_SPECIES_CODE VARCHAR2 PacFIN standard species code
100
 FISH_SEX VARCHAR2 State agency fish sex code
100
 AGENCY_LENGTH NUMBER Measured length of sample
100
 AGENCY_LENGTH_UNITS CHAR Units of the agency measured length of sample (C = centimeters, M = millimeters)
100
 AGENCY_LENGTH_TYPE CHAR Type of length measurement of sample (T = Total, F = Fork)
100
 IS_AGENCY_LENGTH_WITHIN_MAX CHAR Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False)
100
 AGENCY_WEIGHT NUMBER Measured weight of sample
100
 AGENCY_WEIGHT_UNITS CHAR Units of the agency measured weight of sample (G = grams, K = kilograms)
100
 RECFIN_LENGTH_MM NUMBER Agency length converted to millimeters
100
 RECFIN_LENGTH_TYPE CHAR Type of length measurement of sample (T = Total, F = Fork)
67
 RECFIN_IMPUTED_LENGTH NUMBER
100
 RECFIN_IMPUTED_WEIGHT_KG NUMBER Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters
100
 FISH_DISPOSITION NUMBER Fish disposition (CDFW CRFS and CDFW and ODFW discard samples only; 3 = Eat, 4 = Bait, 5 = Give Away, 6 = ?, 7 = Other Purpose, 8 = Dont know, 9 = Refused)
100
 FISH_INSPECTED NUMBER Number of fish (avail.) (CDFW only)
100
 NUMBER_OF_LOCATIONS NUMBER Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only)
100
 NUMBER_OF_SPECIES NUMBER Number of species encountered on a trip (CDFW only)
100
 SALMON_TAG NUMBER 5-digit salmon tag number (CDFW only)
100
 WHITE_SEABASS_TAG VARCHAR2 3-character tag number (e.g., 01N, 02N, 03N; CDFW only)
100
 SAMPLE_COMMENT VARCHAR2 Comments for Sample
100
 SOURCE_CODE VARCHAR2 Sampling source code (BIO = ODFW ORBS and CDFW CRFS sampling, BDS = WDFW BDS sampling, CPFV = ODFW and CDFW at-sea CPFV sampling, ORA = ODFW age sampling, SAC = Sportfishing Association of California sampling)
100
 IS_RETAINED CHAR Identifies whether the sample was retained or released (T = retained, F = released)
67
 RECFIN_VDATE DATE

Attribute Details

BIO_DETAIL_ID

CC ID: 831636
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Numeric unique identifier for the bio detail sample record
General Data Type: NUMBER

ANGLER_ID

CC ID: 831637
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric identifier for the parent angler trip record
General Data Type: NUMBER

CATCH_ID

CC ID: 831638
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric identifier for the parent catch record
General Data Type: NUMBER

CPFV_TRIP_ID

CC ID: 831639
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric identifier for the parent CPFV trip record
General Data Type: NUMBER

RECFIN_YEAR

CC ID: 831640
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

Year of sample
General Data Type: NUMBER

RECFIN_MONTH

CC ID: 831641
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

Month of sample
General Data Type: NUMBER

RECFIN_DAY

CC ID: 831642
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

Day of sample
General Data Type: NUMBER

RECFIN_DATE

CC ID: 831643
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of sample
General Data Type: DATE

AGENCY_CODE

CC ID: 831644
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Scale: 0
Status: Active
Description:

RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
General Data Type: NUMBER

AGENCY

CC ID: 831645
Seq. Order: 10
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW)
General Data Type: CHAR

STATE_NAME

CC ID: 831646
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

State name
General Data Type: VARCHAR2

LOCATION_NUMBER

CC ID: 831647
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

INTERVIEW_SITE

CC ID: 831648
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric interview site code (CDFW only)
General Data Type: NUMBER

COUNTY_NUMBER

CC ID: 831649
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

State agency county code where interview occurred (CDFW only)
General Data Type: NUMBER

NUMBER_OF_ANGLERS

CC ID: 831650
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of anglers fishing
General Data Type: NUMBER

NUMBER_HOURS_FISHED

CC ID: 831651
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of hours fished during the trip (ODFW only)
General Data Type: NUMBER

SPORT_GEAR_TYPE

CC ID: 831652
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear)
General Data Type: VARCHAR2

SPORT_GEAR_MODE

CC ID: 831653
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency Biological Data System (BDS) fishing mode code (WDFW only)
General Data Type: VARCHAR2

AGENCY_PORT_CODE

CC ID: 831654
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

State agency port code
General Data Type: NUMBER

RECFIN_PORT_CODE

CC ID: 831655
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard port or district code
General Data Type: NUMBER

RECFIN_PORT_NAME

CC ID: 831656
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

RecFIN port name
General Data Type: VARCHAR2

RECFIN_DISTRICT_NAME

CC ID: 831657
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard district name
General Data Type: VARCHAR2

AGENCY_TRIP_TYPE_CODE

CC ID: 831658
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency trip type (targeted species) code
General Data Type: VARCHAR2

RECFIN_TRIP_TYPE_CODE

CC ID: 831659
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard trip type (targeted species) code
General Data Type: NUMBER

RECFIN_TRIP_TYPE_NAME

CC ID: 831660
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

RecFIN trip type (targeted species) name
General Data Type: VARCHAR2

RECFIN_TRIP_TYPE_DETAIL_NAME

CC ID: 831661
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Specific state-defined trip type (targeted species)
General Data Type: VARCHAR2

DURATION_TYPE_CODE

CC ID: 831662
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

CPFV trip duration type code
General Data Type: NUMBER

DURATION_TYPE_DESCRIPTION

CC ID: 831663
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

CPFV trip duration type description
General Data Type: VARCHAR2

AGENCY_WATER_AREA_CODE

CC ID: 831664
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency water area code
General Data Type: VARCHAR2

AGENCY_WATER_AREA_NAME

CC ID: 831665
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

State agency water area name
General Data Type: VARCHAR2

AGENCY_FISHED_AREA_CODE

CC ID: 831666
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency specific fishing location code used
General Data Type: VARCHAR2

AGENCY_FISHED_AREA_NAME

CC ID: 831667
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

State agency specific fishing location name
General Data Type: VARCHAR2

RECFIN_WATER_AREA_CODE

CC ID: 831668
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard water area code
General Data Type: NUMBER

RECFIN_WATER_AREA_NAME

CC ID: 831669
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

RecFIN water area name
General Data Type: VARCHAR2

AGENCY_CATCH_AREA_CODE

CC ID: 831670
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency catch area code (ODFW only)
General Data Type: VARCHAR2

AGENCY_CATCH_AREA_NAME

CC ID: 831671
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

State agency catch area name (ODFW only)
General Data Type: VARCHAR2

WATER_FISHED_COUNTRY_NAME

CC ID: 831672
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Country where the fishing trip occurred
General Data Type: VARCHAR2

AGENCY_MODE_CODE

CC ID: 831673
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency fishing mode code
General Data Type: VARCHAR2

RECFIN_MODE_CODE

CC ID: 831674
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard fishing mode code
General Data Type: NUMBER

RECFIN_MODE_NAME

CC ID: 831675
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

RecFIN fishing mode name
General Data Type: VARCHAR2

DESCENDING_DEVICE_USED

CC ID: 831676
Seq. Order: 41
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Descending device present (CDFW only)
General Data Type: CHAR

FISHING_DEPTH

CC ID: 831677
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Depth in feet.
General Data Type: NUMBER

AGENCY_SPECIES_CODE

CC ID: 831678
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

State agency species code
General Data Type: VARCHAR2

RECFIN_SPECIES_CODE

CC ID: 831679
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard species code
General Data Type: NUMBER

SPECIES_NAME

CC ID: 831680
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Species common name
General Data Type: VARCHAR2

SCIENTIFIC_NAME

CC ID: 831681
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Species scientific name
General Data Type: VARCHAR2

FISHERY_MANAGEMENT_PLAN

CC ID: 831682
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

PFMC Fishery Management Plan
General Data Type: VARCHAR2

SPECIES_GROUP_NAME

CC ID: 831683
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Species group name
General Data Type: VARCHAR2

STOCK_COMPLEX_NAME

CC ID: 831684
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Species complex designation (e.g., nearshore deep demersal, etc.)
General Data Type: VARCHAR2

PACFIN_SPECIES_CODE

CC ID: 831685
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

PacFIN standard species code
General Data Type: VARCHAR2

FISH_SEX

CC ID: 831686
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State agency fish sex code
General Data Type: VARCHAR2

AGENCY_LENGTH

CC ID: 831687
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured length of sample
General Data Type: NUMBER

AGENCY_LENGTH_UNITS

CC ID: 831688
Seq. Order: 53
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Units of the agency measured length of sample (C = centimeters, M = millimeters)
General Data Type: CHAR

AGENCY_LENGTH_TYPE

CC ID: 831689
Seq. Order: 54
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Type of length measurement of sample (T = Total, F = Fork)
General Data Type: CHAR

IS_AGENCY_LENGTH_WITHIN_MAX

CC ID: 831690
Seq. Order: 55
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False)
General Data Type: CHAR

AGENCY_WEIGHT

CC ID: 831691
Seq. Order: 56
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Measured weight of sample
General Data Type: NUMBER

AGENCY_WEIGHT_UNITS

CC ID: 831692
Seq. Order: 57
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Units of the agency measured weight of sample (G = grams, K = kilograms)
General Data Type: CHAR

RECFIN_LENGTH_MM

CC ID: 831693
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Agency length converted to millimeters
General Data Type: NUMBER

RECFIN_LENGTH_TYPE

CC ID: 831694
Seq. Order: 59
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Type of length measurement of sample (T = Total, F = Fork)
General Data Type: CHAR

RECFIN_IMPUTED_LENGTH

CC ID: 831695
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

RECFIN_IMPUTED_WEIGHT_KG

CC ID: 831696
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters
General Data Type: NUMBER

FISH_DISPOSITION

CC ID: 831697
Seq. Order: 62
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Fish disposition (CDFW CRFS and CDFW and ODFW discard samples only; 3 = Eat, 4 = Bait, 5 = Give Away, 6 = ?, 7 = Other Purpose, 8 = Dont know, 9 = Refused)
General Data Type: NUMBER

FISH_INSPECTED

CC ID: 831698
Seq. Order: 63
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of fish (avail.) (CDFW only)
General Data Type: NUMBER

NUMBER_OF_LOCATIONS

CC ID: 831699
Seq. Order: 64
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only)
General Data Type: NUMBER

NUMBER_OF_SPECIES

CC ID: 831700
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Number of species encountered on a trip (CDFW only)
General Data Type: NUMBER

SALMON_TAG

CC ID: 831701
Seq. Order: 66
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

5-digit salmon tag number (CDFW only)
General Data Type: NUMBER

WHITE_SEABASS_TAG

CC ID: 831702
Seq. Order: 67
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

3-character tag number (e.g., 01N, 02N, 03N; CDFW only)
General Data Type: VARCHAR2

SAMPLE_COMMENT

CC ID: 831703
Seq. Order: 68
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comments for Sample
General Data Type: VARCHAR2

SOURCE_CODE

CC ID: 831704
Seq. Order: 69
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Sampling source code (BIO = ODFW ORBS and CDFW CRFS sampling, BDS = WDFW BDS sampling, CPFV = ODFW and CDFW at-sea CPFV sampling, ORA = ODFW age sampling, SAC = Sportfishing Association of California sampling)
General Data Type: VARCHAR2

IS_RETAINED

CC ID: 831705
Seq. Order: 70
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifies whether the sample was retained or released (T = retained, F = released)
General Data Type: CHAR

RECFIN_VDATE

CC ID: 831706
Seq. Order: 71
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

Support Roles

Metadata Contact

CC ID: 832045
Date Effective From: 2019-03-31
Date Effective To:
Contact (Person): Edwards, Jason
Email Address: jedwards@psmfc.org

Catalog Details

Catalog Item ID: 55989
GUID: gov.noaa.nmfs.inport:55989
Metadata Record Created By: Jason Edwards
Metadata Record Created: 2019-04-01 12:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-04-02
Owner Org: PSMFC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-04-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-04-02