Table: COMPREHENSIVE_REC_CATCH_EST
Pacific States Marine Fisheries Commission
Entity
(ENT)
| ID: 55977
| Published / External
Created: 2019-03-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 55991
ID: 55977
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: COMPREHENSIVE_REC_CATCH_EST |
---|---|
Short Name | COMPREHENSIVE_REC_CATCH_EST Table |
* Status | On Going |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
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 |
---|---|
None | month |
None | week |
None | year |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | California |
None | Oregon |
None | state |
None | subregion |
None | Washington |
None | water area |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | agency |
None | district |
None | mode |
None | port |
None | species |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Pacific States Marine Fisheries Commission |
---|---|
• » City | Portland |
• » State/Province | OR |
• Country | United States of America |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
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 |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | CATCH_RELEASE_ID | NUMBER | A unique number assigned to each summarized species catch record |
100 | No | No | EFFORT_ID | NUMBER | A unique number assigned to each summarized angler trips |
100 | No | No | RECFIN_YEAR | NUMBER | Catch year from the CATCH_RELEASE_DATE column |
100 | No | No | RECFIN_MONTH | NUMBER | Catch month from the CATCH_RELEASE_DATE column |
100 | No | No | RECFIN_WEEK | NUMBER | Oregon and Washington statistical week |
100 | No | No | ESTIMATE_START_DATE | DATE | Start date of estimate calculation date range (WA) |
100 | No | No | ESTIMATE_END_DATE | DATE | End date of estimate calculation date range (WA) |
100 | No | No | 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 | No | No | ESTIMATE_SOURCE | VARCHAR2 | Sampled vs. unsampled (imputed) catch estimates |
100 | No | No | AGENCY_CODE | NUMBER | RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW) |
100 | No | No | AGENCY | CHAR | PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW) |
100 | No | No | STATE_NAME | VARCHAR2 | State name |
100 | No | No | AGENCY_PORT_CODE | NUMBER | State agency port code |
100 | No | No | RECFIN_PORT_CODE | NUMBER | RecFIN standard port or district code |
100 | No | No | RECFIN_PORT_NAME | VARCHAR2 | RecFIN port name |
100 | No | No | DISTRICT_CODE | NUMBER | Code (additional identifier) for District. |
100 | No | No | DISTRICT_NAME | VARCHAR2 | Name or short description of District. |
100 | No | No | AGENCY_TRIP_TYPE_CODE | VARCHAR2 | State agency trip type (targeted species) code |
100 | No | No | RECFIN_TRIP_TYPE_CODE | NUMBER | RecFIN standard trip type (targeted species) code |
100 | No | No | RECFIN_TRIP_TYPE_NAME | VARCHAR2 | RecFIN trip type (targeted species) name |
100 | No | No | TRIP_TYPE_DETAIL_NAME | VARCHAR2 | Specific state-defined trip type (targeted species) |
100 | No | No | AGENCY_WATER_AREA_CODE | VARCHAR2 | State agency water area code |
100 | No | No | AGENCY_FISHED_AREA_CODE | VARCHAR2 | State agency specific fishing location code used |
100 | No | No | AGENCY_FISHED_AREA_NAME | VARCHAR2 | State agency specific fishing location name |
100 | No | No | RECFIN_WATER_AREA_CODE | NUMBER | RecFIN standard water area code |
100 | No | No | RECFIN_WATER_AREA_NAME | VARCHAR2 | RecFIN water area name |
100 | No | No | RECFIN_SUBREGION_CODE | NUMBER | RecFIN standard subregion code |
100 | No | No | RECFIN_SUBREGION_NAME | VARCHAR2 | RecFIN subregion name |
100 | No | No | WATER_FISHED_COUNTRY_NAME | VARCHAR2 | Country where fishing occurred |
100 | No | No | AGENCY_MODE_CODE | VARCHAR2 | State agency fishing mode code |
100 | No | No | RECFIN_MODE_CODE | NUMBER | RecFIN standard fishing mode code |
100 | No | No | RECFIN_MODE_NAME | VARCHAR2 | RecFIN fishing mode name |
100 | No | No | AGENCY_SPECIES_CODE | VARCHAR2 | State agency species code |
100 | No | No | RECFIN_SPECIES_CODE | NUMBER | RecFIN standard species code |
100 | No | No | SPECIES_NAME | VARCHAR2 | Species common name |
100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | Species scientific name |
100 | No | No | PFMC_FISHERY_MANAGEMENT_PLAN | VARCHAR2 | Federal species fishery management plan |
100 | No | No | SPECIES_GROUP_NAME | VARCHAR2 | Species group name |
100 | No | No | STOCK_COMPLEX_NAME | VARCHAR2 | Species complex designation (e.g., nearshore deep demersal, etc.) |
100 | No | No | PACFIN_SPECIES_CODE | VARCHAR2 | PacFIN species code |
100 | No | No | RELEASED_DEAD_NUM | NUMBER | State agency released dead estimate in number of fish |
100 | No | No | RELEASED_ALIVE_NUM | NUMBER | State agency released alive estimate in number of fish |
100 | No | No | RELEASED_NUM | NUMBER | Total number of released fish estimate |
100 | No | No | RETAINED_NUM | NUMBER | Retained catch estimate in number of fish |
100 | No | No | TOTAL_MORTALITY_NUM | NUMBER | Retained catch + state agency released_dead_num estimate in number of fish |
100 | No | No | RETAINED_AVERAGE_WEIGHT | NUMBER | Average weight of retained fish |
100 | No | No | RELEASED_AVERAGE_WEIGHT | NUMBER | Averge weight of released fish |
100 | No | No | RELEASED_DEAD_KG | NUMBER | State agency released dead estimate in kilograms |
100 | No | No | RELEASED_ALIVE_KG | NUMBER | State agency released alive estimate in kilograms |
100 | No | No | RELEASED_KG | NUMBER | Total number of released fish estimate in kilograms |
100 | No | No | RETAINED_KG | NUMBER | Retained catch estimate in kilograms |
100 | No | No | TOTAL_MORTALITY_KG | NUMBER | Retained kg + state agency released_dead_kg in kilograms |
100 | No | No | MORTALITY_PROPORTION | NUMBER | Proportion of released fish deemed to be dead given depth of catch and associated mortality rate at depth |
100 | No | No | MORTALITY_LEVEL | NUMBER | Level of aggregation that was used to calculate depth-based mortality proportion, when applicable |
100 | No | No | RETAINED_AVERAGE_WEIGHT_LEVEL | NUMBER | Level of aggregation that was used to calculate retained average weight, when applicable |
100 | No | No | RELEASED_AVERAGE_WEIGHT_LEVEL | NUMBER | Level of aggregation that was used to calculate released average weight, when applicable |
100 | No | No | RECFIN_VDATE | DATE | Version Date (i.e., when the table was last refreshed) |
100 | No | No | 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
Attribute Name | CATCH_RELEASE_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A unique number assigned to each summarized species catch record |
General Data Type | NUMBER |
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 | EFFORT_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A unique number assigned to each summarized angler trips |
General Data Type | NUMBER |
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 | RECFIN_YEAR |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
Catch year from the CATCH_RELEASE_DATE column |
General Data Type | NUMBER |
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 | RECFIN_MONTH |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
Catch month from the CATCH_RELEASE_DATE column |
General Data Type | NUMBER |
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 | RECFIN_WEEK |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Oregon and Washington statistical week |
General Data Type | NUMBER |
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 | ESTIMATE_START_DATE |
---|---|
Seq. Order | 6 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Start date of estimate calculation date range (WA) |
General Data Type | DATE |
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 | ESTIMATE_END_DATE |
---|---|
Seq. Order | 7 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
End date of estimate calculation date range (WA) |
General Data Type | DATE |
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_TYPE_CODE |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | ESTIMATE_SOURCE |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sampled vs. unsampled (imputed) catch estimates |
General Data Type | VARCHAR2 |
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 | AGENCY_CODE |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW) |
General Data Type | NUMBER |
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 | AGENCY |
---|---|
Seq. Order | 11 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW) |
General Data Type | CHAR |
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 | STATE_NAME |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State name |
General Data Type | VARCHAR2 |
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 | AGENCY_PORT_CODE |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency port code |
General Data Type | NUMBER |
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 | RECFIN_PORT_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard port or district code |
General Data Type | NUMBER |
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 | RECFIN_PORT_NAME |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN port name |
General Data Type | VARCHAR2 |
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 | DISTRICT_CODE |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code (additional identifier) for District. |
General Data Type | NUMBER |
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 | DISTRICT_NAME |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name or short description of District. |
General Data Type | VARCHAR2 |
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 | AGENCY_TRIP_TYPE_CODE |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency trip type (targeted species) code |
General Data Type | VARCHAR2 |
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 | RECFIN_TRIP_TYPE_CODE |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard trip type (targeted species) code |
General Data Type | NUMBER |
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 | RECFIN_TRIP_TYPE_NAME |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN trip type (targeted species) name |
General Data Type | VARCHAR2 |
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_TYPE_DETAIL_NAME |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Specific state-defined trip type (targeted species) |
General Data Type | VARCHAR2 |
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 | AGENCY_WATER_AREA_CODE |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency water area code |
General Data Type | VARCHAR2 |
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 | AGENCY_FISHED_AREA_CODE |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency specific fishing location code used |
General Data Type | VARCHAR2 |
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 | AGENCY_FISHED_AREA_NAME |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency specific fishing location name |
General Data Type | VARCHAR2 |
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 | RECFIN_WATER_AREA_CODE |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard water area code |
General Data Type | NUMBER |
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 | RECFIN_WATER_AREA_NAME |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN water area name |
General Data Type | VARCHAR2 |
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 | RECFIN_SUBREGION_CODE |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard subregion code |
General Data Type | NUMBER |
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 | RECFIN_SUBREGION_NAME |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN subregion name |
General Data Type | VARCHAR2 |
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 | WATER_FISHED_COUNTRY_NAME |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Country where fishing occurred |
General Data Type | VARCHAR2 |
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 | AGENCY_MODE_CODE |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency fishing mode code |
General Data Type | VARCHAR2 |
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 | RECFIN_MODE_CODE |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard fishing mode code |
General Data Type | NUMBER |
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 | RECFIN_MODE_NAME |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN fishing mode name |
General Data Type | VARCHAR2 |
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 | AGENCY_SPECIES_CODE |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency species code |
General Data Type | VARCHAR2 |
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 | RECFIN_SPECIES_CODE |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard species code |
General Data Type | NUMBER |
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_NAME |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species common name |
General Data Type | VARCHAR2 |
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 | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species scientific name |
General Data Type | VARCHAR2 |
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 | PFMC_FISHERY_MANAGEMENT_PLAN |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Federal species fishery management plan |
General Data Type | VARCHAR2 |
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_NAME |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species group name |
General Data Type | VARCHAR2 |
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 | STOCK_COMPLEX_NAME |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species complex designation (e.g., nearshore deep demersal, etc.) |
General Data Type | VARCHAR2 |
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 | PACFIN_SPECIES_CODE |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
PacFIN species code |
General Data Type | VARCHAR2 |
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 | RELEASED_DEAD_NUM |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency released dead estimate in number of fish |
General Data Type | NUMBER |
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 | RELEASED_ALIVE_NUM |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency released alive estimate in number of fish |
General Data Type | NUMBER |
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 | RELEASED_NUM |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total number of released fish estimate |
General Data Type | NUMBER |
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 | RETAINED_NUM |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Retained catch estimate in number of fish |
General Data Type | NUMBER |
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_MORTALITY_NUM |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Retained catch + state agency released_dead_num estimate in number of fish |
General Data Type | NUMBER |
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 | RETAINED_AVERAGE_WEIGHT |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Average weight of retained fish |
General Data Type | NUMBER |
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 | RELEASED_AVERAGE_WEIGHT |
---|---|
Seq. Order | 47 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Averge weight of released fish |
General Data Type | NUMBER |
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 | RELEASED_DEAD_KG |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency released dead estimate in kilograms |
General Data Type | NUMBER |
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 | RELEASED_ALIVE_KG |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency released alive estimate in kilograms |
General Data Type | NUMBER |
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 | RELEASED_KG |
---|---|
Seq. Order | 50 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Total number of released fish estimate in kilograms |
General Data Type | NUMBER |
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 | RETAINED_KG |
---|---|
Seq. Order | 51 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Retained catch estimate in kilograms |
General Data Type | NUMBER |
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_MORTALITY_KG |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Retained kg + state agency released_dead_kg in kilograms |
General Data Type | NUMBER |
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 | MORTALITY_PROPORTION |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | MORTALITY_LEVEL |
---|---|
Seq. Order | 54 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Level of aggregation that was used to calculate depth-based mortality proportion, when applicable |
General Data Type | NUMBER |
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 | RETAINED_AVERAGE_WEIGHT_LEVEL |
---|---|
Seq. Order | 55 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Level of aggregation that was used to calculate retained average weight, when applicable |
General Data Type | NUMBER |
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 | RELEASED_AVERAGE_WEIGHT_LEVEL |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Level of aggregation that was used to calculate released average weight, when applicable |
General Data Type | NUMBER |
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 | RECFIN_VDATE |
---|---|
Seq. Order | 57 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Version Date (i.e., when the table was last refreshed) |
General Data Type | DATE |
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 | ACL_CODE |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | Metadata Contact |
---|---|
* » Date Effective From | 2019-03-31 |
Date Effective To | |
Person | Edwards, Jason |
Email Address | jedwards@psmfc.org |
Phone | |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » 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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2019-04-02 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-04-02 |
Tags |
---|