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

Table: COMPREHENSIVE_REC_SAMPLE

Entity (ENT)  |  Pacific States Marine Fisheries Commission (PSMFC)
GUID: gov.noaa.nmfs.inport:55983  |  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 Recreational Sample table provides trip-level interview data of retained and released fish from dockside interviews and other landing locations from ocean recreational fisheries in California, Oregon, and Washington. Records in this table are from samples provided by California Department of Fish and Wildlife CRFSS, Oregon Department of Fish and Wildlife ORBS, and Washington Department of Fish and Wildlife OSP sampling programs.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SAMPLE_ID
NUMBER 		Numeric unique identifier for the sample record
ANGLER_ID
NUMBER 		Numeric identifier for the parent angler trip record
LOCATION_ID
NUMBER 		Numeric identifier for the parent location record
CATCH_ID
NUMBER 		Numeric identifier for the parent catch record
RECFIN_YEAR
NUMBER 		Year of fishing trip
RECFIN_MONTH
NUMBER 		Month of fishing trip
RECFIN_DAY
NUMBER 		Day of fishing trip
ANGLER_TRIP_DATE
DATE 		Date of fishing trip
ANGLER_TRIP_WEEK
NUMBER 		Week of fishing trip (WA only)
FISHERY_CODE
CHAR 		ODFW agency fishery code (O = ocean, E = estuary)
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)
INT_COUNTY_NAME
VARCHAR2 		County name where interview occurred (CDFW only)
INTERVIEW_SITE_NAME
VARCHAR2 		Interview site name where interview occurred; distinct combination of interview county and interview site (CDFW 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
RECFIN_SUBREGION_CODE
NUMBER 		RecFIN standard subregion code
RECFIN_SUBREGION_NAME
VARCHAR2 		RecFIN subregion name (S. California, N. California, S. Oregon, N. Oregon, S. Washington, N. Washington)
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
TRIP_TYPE_DETAIL_NAME
VARCHAR2 		Specific state-defined trip type (targeted species)
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
VARCHAR2 		Descending device present (CDFW only)
FISHING_DEPTH
NUMBER 		Depth in feet.
DEPTH_MINIMUM
NUMBER 		Depth in feet.
DEPTH_MAXIMUM
NUMBER 		Depth in feet.
NUMBER_HOURS_FISHED
NUMBER 		Number of hours fished during the trip (ODFW only)
NUMBER_OF_ANGLERS
NUMBER 		Number of anglers fishing
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
NUMBER_RELEASED
NUMBER 		Number of fish released.
NUMBER_RELEASED_ALIVE
NUMBER 		Number of fish released alive. NUM_FISH when Dispo = 1,2,8,9,0,. (CDFW only)
NUMBER_RELEASED_DEAD
NUMBER 		Number of fish released dead. NUM_FISH when Dispo = 6 (CDFW only)
NUMBER_KEPT_OBSERVED
NUMBER 		Number of fish kept (observed).
NUMBER_KEPT_UNOBSERVED
NUMBER 		Number of fish kept (unobserved). Source: CA: NUM_FISH when Dispo = 3,4,5,7
TOTAL_CATCH
NUMBER 		Sum of total kept and released fish
ANGLER_CPUE
NUMBER 		Catch per angler for the fishing trip calculated as TOTAL_CATCH/NUMBER_OF_ANGLERS
HOURS_FISHED_CPUE
NUMBER 		Catch per hour for the fishing trip calculated as TOTAL_CATCH/NUMBER_HOURS_FISHED
COUNTY
NUMBER 		State agency county code where interview occurred (CDFW only)
ISLAND_ID
NUMBER 		California island: Boat fishing within 3 miles of an island (CDFW only)
USED_KAYAK
NUMBER 		Code identifying whether boat is a kayak (1 = Y, 0 or null = N) (CDFW only)
NUMBER_OF_UNLICENSED_ANGLERS
NUMBER 		Number of unlicensed anglers on the trip (CDFW only)
SURVEY
VARCHAR2 		CDFW survey identifier
RECFIN_VDATE
DATE 		Version Date (i.e., when the table was last refreshed)
PRIMARY_TARGET_SPECIES_ID
NUMBER 		RecFIN standard species code of primary target species sought during the trip (CDFW only)
PRIMARY_TARGET_SPECIES_NAME
VARCHAR2 		Species common name of primary target species sought during the trip (CDFW only)
SECONDARY_TARGET_SPECIES_ID
NUMBER 		RecFIN standard species code of secondary target species sought during the trip (CDFW only)
SECONDARY_TARGET_SPECIES_NAME
VARCHAR2 		Species common name of secondary target species sought during the trip (CDFW only)

Child Items

No Child Items for this record.

Contact Information

Metadata Contact
Jason Edwards
jedwards@psmfc.org

Item Identification

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

The RecFIN Comprehensive Recreational Sample table provides trip-level interview data of retained and released fish from dockside interviews and other landing locations from ocean recreational fisheries in California, Oregon, and Washington. Records in this table are from samples provided by California Department of Fish and Wildlife CRFSS, Oregon Department of Fish and Wildlife ORBS, and Washington Department of Fish and Wildlife OSP sampling programs.
Purpose:

The purpose of the RecFIN Comprehensive Recreational Sample table is to provide trip-level interview data on retained and released fish from the ocean recreational fisheries of California, Oregon, and Washington.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None agency
None anglers
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 Fishing Statistical Survey
None CDFW
None cpfv
None CRFSS
None depth
None descending device
None island
None kayak
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 target species
None trip type
None Washington Department of Fish and Wildlife
None WDFW
None weight

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None month
None week
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 SAMPLE_ID NUMBER Numeric unique identifier for the sample record
100
 ANGLER_ID NUMBER Numeric identifier for the parent angler trip record
100
 LOCATION_ID NUMBER Numeric identifier for the parent location record
100
 CATCH_ID NUMBER Numeric identifier for the parent catch record
100
 RECFIN_YEAR NUMBER Year of fishing trip
100
 RECFIN_MONTH NUMBER Month of fishing trip
100
 RECFIN_DAY NUMBER Day of fishing trip
100
 ANGLER_TRIP_DATE DATE Date of fishing trip
100
 ANGLER_TRIP_WEEK NUMBER Week of fishing trip (WA only)
100
 FISHERY_CODE CHAR ODFW agency fishery code (O = ocean, E = estuary)
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
 INT_COUNTY_NAME VARCHAR2 County name where interview occurred (CDFW only)
100
 INTERVIEW_SITE_NAME VARCHAR2 Interview site name where interview occurred; distinct combination of interview county and interview site (CDFW 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
 RECFIN_SUBREGION_CODE NUMBER RecFIN standard subregion code
100
 RECFIN_SUBREGION_NAME VARCHAR2 RecFIN subregion name (S. California, N. California, S. Oregon, N. Oregon, S. Washington, N. Washington)
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
 TRIP_TYPE_DETAIL_NAME VARCHAR2 Specific state-defined trip type (targeted species)
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 VARCHAR2 Descending device present (CDFW only)
100
 FISHING_DEPTH NUMBER Depth in feet.
100
 DEPTH_MINIMUM NUMBER Depth in feet.
100
 DEPTH_MAXIMUM NUMBER Depth in feet.
100
 NUMBER_HOURS_FISHED NUMBER Number of hours fished during the trip (ODFW only)
100
 NUMBER_OF_ANGLERS NUMBER Number of anglers fishing
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
 NUMBER_RELEASED NUMBER Number of fish released.
100
 NUMBER_RELEASED_ALIVE NUMBER Number of fish released alive. NUM_FISH when Dispo = 1,2,8,9,0,. (CDFW only)
100
 NUMBER_RELEASED_DEAD NUMBER Number of fish released dead. NUM_FISH when Dispo = 6 (CDFW only)
100
 NUMBER_KEPT_OBSERVED NUMBER Number of fish kept (observed).
100
 NUMBER_KEPT_UNOBSERVED NUMBER Number of fish kept (unobserved). Source: CA: NUM_FISH when Dispo = 3,4,5,7
100
 TOTAL_CATCH NUMBER Sum of total kept and released fish
100
 ANGLER_CPUE NUMBER Catch per angler for the fishing trip calculated as TOTAL_CATCH/NUMBER_OF_ANGLERS
100
 HOURS_FISHED_CPUE NUMBER Catch per hour for the fishing trip calculated as TOTAL_CATCH/NUMBER_HOURS_FISHED
100
 COUNTY NUMBER State agency county code where interview occurred (CDFW only)
100
 ISLAND_ID NUMBER California island: Boat fishing within 3 miles of an island (CDFW only)
100
 USED_KAYAK NUMBER Code identifying whether boat is a kayak (1 = Y, 0 or null = N) (CDFW only)
100
 NUMBER_OF_UNLICENSED_ANGLERS NUMBER Number of unlicensed anglers on the trip (CDFW only)
100
 SURVEY VARCHAR2 CDFW survey identifier
100
 RECFIN_VDATE DATE Version Date (i.e., when the table was last refreshed)
100
 PRIMARY_TARGET_SPECIES_ID NUMBER RecFIN standard species code of primary target species sought during the trip (CDFW only)
100
 PRIMARY_TARGET_SPECIES_NAME VARCHAR2 Species common name of primary target species sought during the trip (CDFW only)
100
 SECONDARY_TARGET_SPECIES_ID NUMBER RecFIN standard species code of secondary target species sought during the trip (CDFW only)
100
 SECONDARY_TARGET_SPECIES_NAME VARCHAR2 Species common name of secondary target species sought during the trip (CDFW only)

Attribute Details

SAMPLE_ID

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

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

ANGLER_ID

CC ID: 831310
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

LOCATION_ID

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

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

CATCH_ID

CC ID: 831312
Seq. Order: 4
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

RECFIN_YEAR

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

Year of fishing trip
General Data Type: NUMBER

RECFIN_MONTH

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

Month of fishing trip
General Data Type: NUMBER

RECFIN_DAY

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

Day of fishing trip
General Data Type: NUMBER

ANGLER_TRIP_DATE

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

Date of fishing trip
General Data Type: DATE

ANGLER_TRIP_WEEK

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

Week of fishing trip (WA only)
General Data Type: NUMBER

FISHERY_CODE

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

ODFW agency fishery code (O = ocean, E = estuary)
General Data Type: CHAR

AGENCY_CODE

CC ID: 831319
Seq. Order: 11
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: 831320
Seq. Order: 12
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: 831321
Seq. Order: 13
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: 831322
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

INTERVIEW_SITE

CC ID: 831323
Seq. Order: 15
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

INT_COUNTY_NAME

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

County name where interview occurred (CDFW only)
General Data Type: VARCHAR2

INTERVIEW_SITE_NAME

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

Interview site name where interview occurred; distinct combination of interview county and interview site (CDFW only)
General Data Type: VARCHAR2

AGENCY_PORT_CODE

CC ID: 831326
Seq. Order: 18
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: 831327
Seq. Order: 19
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: 831328
Seq. Order: 20
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: 831329
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard district name
General Data Type: VARCHAR2

RECFIN_SUBREGION_CODE

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

RecFIN standard subregion code
General Data Type: NUMBER

RECFIN_SUBREGION_NAME

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

RecFIN subregion name (S. California, N. California, S. Oregon, N. Oregon, S. Washington, N. Washington)
General Data Type: VARCHAR2

AGENCY_TRIP_TYPE_CODE

CC ID: 831332
Seq. Order: 24
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: 831333
Seq. Order: 25
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: 831334
Seq. Order: 26
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

TRIP_TYPE_DETAIL_NAME

CC ID: 831335
Seq. Order: 27
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

AGENCY_WATER_AREA_CODE

CC ID: 831336
Seq. Order: 28
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: 831337
Seq. Order: 29
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: 831338
Seq. Order: 30
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: 831339
Seq. Order: 31
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: 831340
Seq. Order: 32
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: 831341
Seq. Order: 33
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: 831342
Seq. Order: 34
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: 831343
Seq. Order: 35
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: 831344
Seq. Order: 36
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: 831345
Seq. Order: 37
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: 831346
Seq. Order: 38
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: 831347
Seq. Order: 39
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: 831348
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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

FISHING_DEPTH

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

Depth in feet.
General Data Type: NUMBER

DEPTH_MINIMUM

CC ID: 831350
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

DEPTH_MAXIMUM

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

Depth in feet.
General Data Type: NUMBER

NUMBER_HOURS_FISHED

CC ID: 831352
Seq. Order: 44
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

NUMBER_OF_ANGLERS

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

Number of anglers fishing
General Data Type: NUMBER

AGENCY_SPECIES_CODE

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

State agency species code
General Data Type: VARCHAR2

RECFIN_SPECIES_CODE

CC ID: 831355
Seq. Order: 47
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: 831356
Seq. Order: 48
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: 831357
Seq. Order: 49
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: 831358
Seq. Order: 50
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: 831359
Seq. Order: 51
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: 831360
Seq. Order: 52
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: 831361
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

PacFIN standard species code
General Data Type: VARCHAR2

NUMBER_RELEASED

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

Number of fish released.
General Data Type: NUMBER

NUMBER_RELEASED_ALIVE

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

Number of fish released alive. NUM_FISH when Dispo = 1,2,8,9,0,. (CDFW only)
General Data Type: NUMBER

NUMBER_RELEASED_DEAD

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

Number of fish released dead. NUM_FISH when Dispo = 6 (CDFW only)
General Data Type: NUMBER

NUMBER_KEPT_OBSERVED

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

Number of fish kept (observed).
General Data Type: NUMBER

NUMBER_KEPT_UNOBSERVED

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

Number of fish kept (unobserved). Source: CA: NUM_FISH when Dispo = 3,4,5,7
General Data Type: NUMBER

TOTAL_CATCH

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

Sum of total kept and released fish
General Data Type: NUMBER

ANGLER_CPUE

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

Catch per angler for the fishing trip calculated as TOTAL_CATCH/NUMBER_OF_ANGLERS
General Data Type: NUMBER

HOURS_FISHED_CPUE

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

Catch per hour for the fishing trip calculated as TOTAL_CATCH/NUMBER_HOURS_FISHED
General Data Type: NUMBER

COUNTY

CC ID: 831370
Seq. Order: 62
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

ISLAND_ID

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

California island: Boat fishing within 3 miles of an island (CDFW only)
General Data Type: NUMBER

USED_KAYAK

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

Code identifying whether boat is a kayak (1 = Y, 0 or null = N) (CDFW only)
General Data Type: NUMBER

NUMBER_OF_UNLICENSED_ANGLERS

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

Number of unlicensed anglers on the trip (CDFW only)
General Data Type: NUMBER

SURVEY

CC ID: 831374
Seq. Order: 66
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

CDFW survey identifier
General Data Type: VARCHAR2

RECFIN_VDATE

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

Version Date (i.e., when the table was last refreshed)
General Data Type: DATE

PRIMARY_TARGET_SPECIES_ID

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

RecFIN standard species code of primary target species sought during the trip (CDFW only)
General Data Type: NUMBER

PRIMARY_TARGET_SPECIES_NAME

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

Species common name of primary target species sought during the trip (CDFW only)
General Data Type: VARCHAR2

SECONDARY_TARGET_SPECIES_ID

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

RecFIN standard species code of secondary target species sought during the trip (CDFW only)
General Data Type: NUMBER

SECONDARY_TARGET_SPECIES_NAME

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

Species common name of secondary target species sought during the trip (CDFW only)
General Data Type: VARCHAR2

Support Roles

Metadata Contact

CC ID: 832130
Date Effective From: 2019-04-01
Date Effective To:
Contact (Person): Edwards, Jason
Email Address: jedwards@psmfc.org

Catalog Details

Catalog Item ID: 55983
GUID: gov.noaa.nmfs.inport:55983
Metadata Record Created By: Jason Edwards
Metadata Record Created: 2019-03-30 10:14+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