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

Table: COMPREHENSIVE_REC_CATCH_EST

Entity (ENT)  |  Pacific States Marine Fisheries Commission (PSMFC)
GUID: gov.noaa.nmfs.inport:55977  |  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 Catch Estimate table provides a standardized data set of recreational retained and release estimates for all finfish species caught in the West Coast recreational ocean fisheries. Records in this table are from estimates 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.

Description

A standardized data set of recreational catch and release estimates for all finfish species caught in the west coast recreational ocean fisheries

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CATCH_RELEASE_ID
NUMBER 		A unique number assigned to each summarized species catch record
EFFORT_ID
NUMBER 		A unique number assigned to each summarized angler trips
RECFIN_YEAR
NUMBER 		Catch year from the CATCH_RELEASE_DATE column
RECFIN_MONTH
NUMBER 		Catch month from the CATCH_RELEASE_DATE column
RECFIN_WEEK
NUMBER 		Oregon and Washington statistical week
ESTIMATE_START_DATE
DATE 		Start date of estimate calculation date range (WA)
ESTIMATE_END_DATE
DATE 		End date of estimate calculation date range (WA)
DAY_TYPE_CODE
VARCHAR2 		Identifier for day stratification type (WDFW only; 0 = Weekday, 1 = Weekend, 2 = Weekend/Week Days - non stratified only applied to Port Code 6 - North Jetty)
ESTIMATE_SOURCE
VARCHAR2 		Sampled vs. unsampled (imputed) catch estimates
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
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
DISTRICT_CODE
NUMBER 		Code (additional identifier) for District.
DISTRICT_NAME
VARCHAR2 		Name or short description of District.
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_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
RECFIN_SUBREGION_CODE
NUMBER 		RecFIN standard subregion code
RECFIN_SUBREGION_NAME
VARCHAR2 		RecFIN subregion name
WATER_FISHED_COUNTRY_NAME
VARCHAR2 		Country where fishing 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
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
PFMC_FISHERY_MANAGEMENT_PLAN
VARCHAR2 		Federal species 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 species code
RELEASED_DEAD_NUM
NUMBER 		State agency released dead estimate in number of fish
RELEASED_ALIVE_NUM
NUMBER 		State agency released alive estimate in number of fish
RELEASED_NUM
NUMBER 		Total number of released fish estimate
RETAINED_NUM
NUMBER 		Retained catch estimate in number of fish
TOTAL_MORTALITY_NUM
NUMBER 		Retained catch + state agency released_dead_num estimate in number of fish
RETAINED_AVERAGE_WEIGHT
NUMBER 		Average weight of retained fish
RELEASED_AVERAGE_WEIGHT
NUMBER 		Averge weight of released fish
RELEASED_DEAD_KG
NUMBER 		State agency released dead estimate in kilograms
RELEASED_ALIVE_KG
NUMBER 		State agency released alive estimate in kilograms
RELEASED_KG
NUMBER 		Total number of released fish estimate in kilograms
RETAINED_KG
NUMBER 		Retained catch estimate in kilograms
TOTAL_MORTALITY_KG
NUMBER 		Retained kg + state agency released_dead_kg in kilograms
MORTALITY_PROPORTION
NUMBER 		Proportion of released fish deemed to be dead given depth of catch and associated mortality rate at depth
MORTALITY_LEVEL
NUMBER 		Level of aggregation that was used to calculate depth-based mortality proportion, when applicable
RETAINED_AVERAGE_WEIGHT_LEVEL
NUMBER 		Level of aggregation that was used to calculate retained average weight, when applicable
RELEASED_AVERAGE_WEIGHT_LEVEL
NUMBER 		Level of aggregation that was used to calculate released average weight, when applicable
RECFIN_VDATE
DATE 		Version Date (i.e., when the table was last refreshed)
ACL_CODE
VARCHAR2 		Assigned based on Species/Area/Year as defined in ACL_STOCK_SET. Fixed list of ACL_CODE values in ACL_CODE table.

Child Items

No Child Items for this record.

Contact Information

Metadata Contact
Jason Edwards
jedwards@psmfc.org

Item Identification

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

The RecFIN Comprehensive Recreational Catch Estimate table provides a standardized data set of recreational retained and release estimates for all finfish species caught in the West Coast recreational ocean fisheries. Records in this table are from estimates 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 Catch Estimate table is to provide a standardized data set of estimates of retained and released fish from the ocean recreational fisheries of California, Oregon, and Washington.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None California Department of Fish and Wildlife
None California Recreational Fishing Statistical Survey
None CDFW
None Ocean Recreational Boat Survey
None Ocean Sampling Project
None Oregon Department of Fish and Wildlife
None Washington Department of Fish and Wildlife
None average weight
None catch
None CRFSS
None effort
None estimate
None mortality
None ODFW
None ORBS
None recreational fisheries
None release
None retained
None trip type
None WDFW

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None month
None week
None year

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None California
None Oregon
None state
None subregion
None Washington
None water area

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None agency
None district
None mode
None port
None species

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
Description:

A standardized data set of recreational catch and release estimates for all finfish species caught in the west coast recreational ocean fisheries

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 CATCH_RELEASE_ID NUMBER A unique number assigned to each summarized species catch record
100
 EFFORT_ID NUMBER A unique number assigned to each summarized angler trips
100
 RECFIN_YEAR NUMBER Catch year from the CATCH_RELEASE_DATE column
100
 RECFIN_MONTH NUMBER Catch month from the CATCH_RELEASE_DATE column
100
 RECFIN_WEEK NUMBER Oregon and Washington statistical week
100
 ESTIMATE_START_DATE DATE Start date of estimate calculation date range (WA)
100
 ESTIMATE_END_DATE DATE End date of estimate calculation date range (WA)
100
 DAY_TYPE_CODE VARCHAR2 Identifier for day stratification type (WDFW only; 0 = Weekday, 1 = Weekend, 2 = Weekend/Week Days - non stratified only applied to Port Code 6 - North Jetty)
100
 ESTIMATE_SOURCE VARCHAR2 Sampled vs. unsampled (imputed) catch estimates
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
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
 DISTRICT_CODE NUMBER Code (additional identifier) for District.
100
 DISTRICT_NAME VARCHAR2 Name or short description of District.
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_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
 RECFIN_SUBREGION_CODE NUMBER RecFIN standard subregion code
100
 RECFIN_SUBREGION_NAME VARCHAR2 RecFIN subregion name
100
 WATER_FISHED_COUNTRY_NAME VARCHAR2 Country where fishing 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
 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
 PFMC_FISHERY_MANAGEMENT_PLAN VARCHAR2 Federal species 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 species code
100
 RELEASED_DEAD_NUM NUMBER State agency released dead estimate in number of fish
100
 RELEASED_ALIVE_NUM NUMBER State agency released alive estimate in number of fish
100
 RELEASED_NUM NUMBER Total number of released fish estimate
100
 RETAINED_NUM NUMBER Retained catch estimate in number of fish
100
 TOTAL_MORTALITY_NUM NUMBER Retained catch + state agency released_dead_num estimate in number of fish
100
 RETAINED_AVERAGE_WEIGHT NUMBER Average weight of retained fish
100
 RELEASED_AVERAGE_WEIGHT NUMBER Averge weight of released fish
100
 RELEASED_DEAD_KG NUMBER State agency released dead estimate in kilograms
100
 RELEASED_ALIVE_KG NUMBER State agency released alive estimate in kilograms
100
 RELEASED_KG NUMBER Total number of released fish estimate in kilograms
100
 RETAINED_KG NUMBER Retained catch estimate in kilograms
100
 TOTAL_MORTALITY_KG NUMBER Retained kg + state agency released_dead_kg in kilograms
100
 MORTALITY_PROPORTION NUMBER Proportion of released fish deemed to be dead given depth of catch and associated mortality rate at depth
100
 MORTALITY_LEVEL NUMBER Level of aggregation that was used to calculate depth-based mortality proportion, when applicable
100
 RETAINED_AVERAGE_WEIGHT_LEVEL NUMBER Level of aggregation that was used to calculate retained average weight, when applicable
100
 RELEASED_AVERAGE_WEIGHT_LEVEL NUMBER Level of aggregation that was used to calculate released average weight, when applicable
100
 RECFIN_VDATE DATE Version Date (i.e., when the table was last refreshed)
100
 ACL_CODE VARCHAR2 Assigned based on Species/Area/Year as defined in ACL_STOCK_SET. Fixed list of ACL_CODE values in ACL_CODE table.

Attribute Details

CATCH_RELEASE_ID

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

A unique number assigned to each summarized species catch record
General Data Type: NUMBER

EFFORT_ID

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

A unique number assigned to each summarized angler trips
General Data Type: NUMBER

RECFIN_YEAR

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

Catch year from the CATCH_RELEASE_DATE column
General Data Type: NUMBER

RECFIN_MONTH

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

Catch month from the CATCH_RELEASE_DATE column
General Data Type: NUMBER

RECFIN_WEEK

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

Oregon and Washington statistical week
General Data Type: NUMBER

ESTIMATE_START_DATE

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

Start date of estimate calculation date range (WA)
General Data Type: DATE

ESTIMATE_END_DATE

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

End date of estimate calculation date range (WA)
General Data Type: DATE

DAY_TYPE_CODE

CC ID: 831165
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifier for day stratification type (WDFW only; 0 = Weekday, 1 = Weekend, 2 = Weekend/Week Days - non stratified only applied to Port Code 6 - North Jetty)
General Data Type: VARCHAR2

ESTIMATE_SOURCE

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

Sampled vs. unsampled (imputed) catch estimates
General Data Type: VARCHAR2

AGENCY_CODE

CC ID: 831167
Seq. Order: 10
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: 831168
Seq. Order: 11
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: 831169
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1000
Required: No
Primary Key: No
Status: Active
Description:

State name
General Data Type: VARCHAR2

AGENCY_PORT_CODE

CC ID: 831170
Seq. Order: 13
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: 831171
Seq. Order: 14
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: 831172
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

RecFIN port name
General Data Type: VARCHAR2

DISTRICT_CODE

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

Code (additional identifier) for District.
General Data Type: NUMBER

DISTRICT_NAME

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

Name or short description of District.
General Data Type: VARCHAR2

AGENCY_TRIP_TYPE_CODE

CC ID: 831175
Seq. Order: 18
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: 831176
Seq. Order: 19
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: 831177
Seq. Order: 20
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: 831178
Seq. Order: 21
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: 831179
Seq. Order: 22
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_FISHED_AREA_CODE

CC ID: 831180
Seq. Order: 23
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: 831181
Seq. Order: 24
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: 831182
Seq. Order: 25
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: 831183
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

RecFIN water area name
General Data Type: VARCHAR2

RECFIN_SUBREGION_CODE

CC ID: 831184
Seq. Order: 27
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: 831185
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

RecFIN subregion name
General Data Type: VARCHAR2

WATER_FISHED_COUNTRY_NAME

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

Country where fishing occurred
General Data Type: VARCHAR2

AGENCY_MODE_CODE

CC ID: 831187
Seq. Order: 30
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: 831188
Seq. Order: 31
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: 831189
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

RecFIN fishing mode name
General Data Type: VARCHAR2

AGENCY_SPECIES_CODE

CC ID: 831190
Seq. Order: 33
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: 831191
Seq. Order: 34
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: 831192
Seq. Order: 35
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: 831193
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Species scientific name
General Data Type: VARCHAR2

PFMC_FISHERY_MANAGEMENT_PLAN

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

Federal species fishery management plan
General Data Type: VARCHAR2

SPECIES_GROUP_NAME

CC ID: 831195
Seq. Order: 38
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: 831196
Seq. Order: 39
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: 831197
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

PacFIN species code
General Data Type: VARCHAR2

RELEASED_DEAD_NUM

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

State agency released dead estimate in number of fish
General Data Type: NUMBER

RELEASED_ALIVE_NUM

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

State agency released alive estimate in number of fish
General Data Type: NUMBER

RELEASED_NUM

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

Total number of released fish estimate
General Data Type: NUMBER

RETAINED_NUM

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

Retained catch estimate in number of fish
General Data Type: NUMBER

TOTAL_MORTALITY_NUM

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

Retained catch + state agency released_dead_num estimate in number of fish
General Data Type: NUMBER

RETAINED_AVERAGE_WEIGHT

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

Average weight of retained fish
General Data Type: NUMBER

RELEASED_AVERAGE_WEIGHT

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

Averge weight of released fish
General Data Type: NUMBER

RELEASED_DEAD_KG

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

State agency released dead estimate in kilograms
General Data Type: NUMBER

RELEASED_ALIVE_KG

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

State agency released alive estimate in kilograms
General Data Type: NUMBER

RELEASED_KG

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

Total number of released fish estimate in kilograms
General Data Type: NUMBER

RETAINED_KG

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

Retained catch estimate in kilograms
General Data Type: NUMBER

TOTAL_MORTALITY_KG

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

Retained kg + state agency released_dead_kg in kilograms
General Data Type: NUMBER

MORTALITY_PROPORTION

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

Proportion of released fish deemed to be dead given depth of catch and associated mortality rate at depth
General Data Type: NUMBER

MORTALITY_LEVEL

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

Level of aggregation that was used to calculate depth-based mortality proportion, when applicable
General Data Type: NUMBER

RETAINED_AVERAGE_WEIGHT_LEVEL

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

Level of aggregation that was used to calculate retained average weight, when applicable
General Data Type: NUMBER

RELEASED_AVERAGE_WEIGHT_LEVEL

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

Level of aggregation that was used to calculate released average weight, when applicable
General Data Type: NUMBER

RECFIN_VDATE

CC ID: 831214
Seq. Order: 57
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

ACL_CODE

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

Assigned based on Species/Area/Year as defined in ACL_STOCK_SET. Fixed list of ACL_CODE values in ACL_CODE table.
General Data Type: VARCHAR2

Support Roles

Metadata Contact

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

Catalog Details

Catalog Item ID: 55977
GUID: gov.noaa.nmfs.inport:55977
Metadata Record Created By: Jason Edwards
Metadata Record Created: 2019-03-29 17:21+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