Table: COMPREHENSIVE_BIO_DETAIL
Entity (ENT) | Pacific States Marine Fisheries Commission (PSMFC)GUID: gov.noaa.nmfs.inport:55989 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: COMPREHENSIVE_BIO_DETAIL |
---|---|
Short Name: | COMPREHENSIVE_BIO_DETAIL Table |
Status: | On Going |
Abstract: |
The RecFIN Comprehensive Bio-Detail table provides bio-detail samples of recreational retained fish from dockside interviews and other landing locations as well as recreational released fish from at-sea commercial passenger fishing vessels (i.e., charter trips). Records in this table are from samples collected from California Department of Fish and Wildlife CRFSS, Oregon Department of Fish and Wildlife ORBS, Washington Department of Fish and Wildlife BDS, and Sportfishing Association of California sampling efforts. |
Purpose: |
The purpose of the RecFIN Comprehensive Bio-Detail table is to provide bio-detail samples (e.g. length, weight, sex) of retained and released fish from the ocean recreational fisheries of California, Oregon, and Washington. |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | agency |
None | BDS |
None | bio-detail |
None | Biological Data System |
None | biological detail |
None | biological sample |
None | California Department of Fish and Wildlife |
None | California Recreational Fisheries Statistical Survey |
None | CDFW |
None | CPFV |
None | CRFSS |
None | length |
None | mode |
None | Ocean Recreational Boat Survey |
None | Ocean Sampling Project |
None | ODFW |
None | ORBS |
None | Oregon Department of Fish and Wildlife |
None | recreational fisheries |
None | release |
None | retained |
None | SAC |
None | sample |
None | sex |
None | species |
None | trip type |
None | Washington Department of Fish and Wildlife |
None | WDFW |
None | weight |
Temporal Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | month |
None | year |
Spatial Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | California |
None | county |
None | district |
None | interview site |
None | Oregon |
None | port |
None | state |
None | Washington |
None | water area |
Physical Location
Organization: | Pacific States Marine Fisheries Commission |
---|---|
City: | Portland |
State/Province: | OR |
Country: | United States of America |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | RECFIN_MARTS |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
BIO_DETAIL_ID | NUMBER | Numeric unique identifier for the bio detail sample record | |
100
|
ANGLER_ID | NUMBER | Numeric identifier for the parent angler trip record | |
100
|
CATCH_ID | NUMBER | Numeric identifier for the parent catch record | |
100
|
CPFV_TRIP_ID | NUMBER | Numeric identifier for the parent CPFV trip record | |
100
|
RECFIN_YEAR | NUMBER | Year of sample | |
100
|
RECFIN_MONTH | NUMBER | Month of sample | |
100
|
RECFIN_DAY | NUMBER | Day of sample | |
100
|
RECFIN_DATE | DATE | Date of sample | |
100
|
AGENCY_CODE | NUMBER | RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW) | |
100
|
AGENCY | CHAR | PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW) | |
100
|
STATE_NAME | VARCHAR2 | State name | |
67
|
LOCATION_NUMBER | NUMBER | ||
100
|
INTERVIEW_SITE | NUMBER | Numeric interview site code (CDFW only) | |
100
|
COUNTY_NUMBER | NUMBER | State agency county code where interview occurred (CDFW only) | |
100
|
NUMBER_OF_ANGLERS | NUMBER | Number of anglers fishing | |
100
|
NUMBER_HOURS_FISHED | NUMBER | Number of hours fished during the trip (ODFW only) | |
100
|
SPORT_GEAR_TYPE | VARCHAR2 | Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear) | |
100
|
SPORT_GEAR_MODE | VARCHAR2 | State agency Biological Data System (BDS) fishing mode code (WDFW only) | |
100
|
AGENCY_PORT_CODE | NUMBER | State agency port code | |
100
|
RECFIN_PORT_CODE | NUMBER | RecFIN standard port or district code | |
100
|
RECFIN_PORT_NAME | VARCHAR2 | RecFIN port name | |
100
|
RECFIN_DISTRICT_NAME | VARCHAR2 | RecFIN standard district name | |
100
|
AGENCY_TRIP_TYPE_CODE | VARCHAR2 | State agency trip type (targeted species) code | |
100
|
RECFIN_TRIP_TYPE_CODE | NUMBER | RecFIN standard trip type (targeted species) code | |
100
|
RECFIN_TRIP_TYPE_NAME | VARCHAR2 | RecFIN trip type (targeted species) name | |
100
|
RECFIN_TRIP_TYPE_DETAIL_NAME | VARCHAR2 | Specific state-defined trip type (targeted species) | |
100
|
DURATION_TYPE_CODE | NUMBER | CPFV trip duration type code | |
100
|
DURATION_TYPE_DESCRIPTION | VARCHAR2 | CPFV trip duration type description | |
100
|
AGENCY_WATER_AREA_CODE | VARCHAR2 | State agency water area code | |
100
|
AGENCY_WATER_AREA_NAME | VARCHAR2 | State agency water area name | |
100
|
AGENCY_FISHED_AREA_CODE | VARCHAR2 | State agency specific fishing location code used | |
100
|
AGENCY_FISHED_AREA_NAME | VARCHAR2 | State agency specific fishing location name | |
100
|
RECFIN_WATER_AREA_CODE | NUMBER | RecFIN standard water area code | |
100
|
RECFIN_WATER_AREA_NAME | VARCHAR2 | RecFIN water area name | |
100
|
AGENCY_CATCH_AREA_CODE | VARCHAR2 | State agency catch area code (ODFW only) | |
100
|
AGENCY_CATCH_AREA_NAME | VARCHAR2 | State agency catch area name (ODFW only) | |
100
|
WATER_FISHED_COUNTRY_NAME | VARCHAR2 | Country where the fishing trip occurred | |
100
|
AGENCY_MODE_CODE | VARCHAR2 | State agency fishing mode code | |
100
|
RECFIN_MODE_CODE | NUMBER | RecFIN standard fishing mode code | |
100
|
RECFIN_MODE_NAME | VARCHAR2 | RecFIN fishing mode name | |
100
|
DESCENDING_DEVICE_USED | CHAR | Descending device present (CDFW only) | |
100
|
FISHING_DEPTH | NUMBER | Depth in feet. | |
100
|
AGENCY_SPECIES_CODE | VARCHAR2 | State agency species code | |
100
|
RECFIN_SPECIES_CODE | NUMBER | RecFIN standard species code | |
100
|
SPECIES_NAME | VARCHAR2 | Species common name | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Species scientific name | |
100
|
FISHERY_MANAGEMENT_PLAN | VARCHAR2 | PFMC Fishery Management Plan | |
100
|
SPECIES_GROUP_NAME | VARCHAR2 | Species group name | |
100
|
STOCK_COMPLEX_NAME | VARCHAR2 | Species complex designation (e.g., nearshore deep demersal, etc.) | |
100
|
PACFIN_SPECIES_CODE | VARCHAR2 | PacFIN standard species code | |
100
|
FISH_SEX | VARCHAR2 | State agency fish sex code | |
100
|
AGENCY_LENGTH | NUMBER | Measured length of sample | |
100
|
AGENCY_LENGTH_UNITS | CHAR | Units of the agency measured length of sample (C = centimeters, M = millimeters) | |
100
|
AGENCY_LENGTH_TYPE | CHAR | Type of length measurement of sample (T = Total, F = Fork) | |
100
|
IS_AGENCY_LENGTH_WITHIN_MAX | CHAR | Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False) | |
100
|
AGENCY_WEIGHT | NUMBER | Measured weight of sample | |
100
|
AGENCY_WEIGHT_UNITS | CHAR | Units of the agency measured weight of sample (G = grams, K = kilograms) | |
100
|
RECFIN_LENGTH_MM | NUMBER | Agency length converted to millimeters | |
100
|
RECFIN_LENGTH_TYPE | CHAR | Type of length measurement of sample (T = Total, F = Fork) | |
67
|
RECFIN_IMPUTED_LENGTH | NUMBER | ||
100
|
RECFIN_IMPUTED_WEIGHT_KG | NUMBER | Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters | |
100
|
FISH_DISPOSITION | NUMBER | Fish disposition (CDFW CRFS and CDFW and ODFW discard samples only; 3 = Eat, 4 = Bait, 5 = Give Away, 6 = ?, 7 = Other Purpose, 8 = Dont know, 9 = Refused) | |
100
|
FISH_INSPECTED | NUMBER | Number of fish (avail.) (CDFW only) | |
100
|
NUMBER_OF_LOCATIONS | NUMBER | Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only) | |
100
|
NUMBER_OF_SPECIES | NUMBER | Number of species encountered on a trip (CDFW only) | |
100
|
SALMON_TAG | NUMBER | 5-digit salmon tag number (CDFW only) | |
100
|
WHITE_SEABASS_TAG | VARCHAR2 | 3-character tag number (e.g., 01N, 02N, 03N; CDFW only) | |
100
|
SAMPLE_COMMENT | VARCHAR2 | Comments for Sample | |
100
|
SOURCE_CODE | VARCHAR2 | Sampling source code (BIO = ODFW ORBS and CDFW CRFS sampling, BDS = WDFW BDS sampling, CPFV = ODFW and CDFW at-sea CPFV sampling, ORA = ODFW age sampling, SAC = Sportfishing Association of California sampling) | |
100
|
IS_RETAINED | CHAR | Identifies whether the sample was retained or released (T = retained, F = released) | |
67
|
RECFIN_VDATE | DATE |
Attribute Details
BIO_DETAIL_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Numeric unique identifier for the bio detail sample record |
General Data Type: | NUMBER |
ANGLER_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric identifier for the parent angler trip record |
General Data Type: | NUMBER |
CATCH_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric identifier for the parent catch record |
General Data Type: | NUMBER |
CPFV_TRIP_ID
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric identifier for the parent CPFV trip record |
General Data Type: | NUMBER |
RECFIN_YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
Year of sample |
General Data Type: | NUMBER |
RECFIN_MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
Month of sample |
General Data Type: | NUMBER |
RECFIN_DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
Day of sample |
General Data Type: | NUMBER |
RECFIN_DATE
Seq. Order: | 8 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of sample |
General Data Type: | DATE |
AGENCY_CODE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW) |
General Data Type: | NUMBER |
AGENCY
Seq. Order: | 10 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
PacFIN state code (i.e., W = WDFW, O = ODFW, C = CDFW) |
General Data Type: | CHAR |
STATE_NAME
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State name |
General Data Type: | VARCHAR2 |
LOCATION_NUMBER
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | NUMBER |
INTERVIEW_SITE
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric interview site code (CDFW only) |
General Data Type: | NUMBER |
COUNTY_NUMBER
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency county code where interview occurred (CDFW only) |
General Data Type: | NUMBER |
NUMBER_OF_ANGLERS
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of anglers fishing |
General Data Type: | NUMBER |
NUMBER_HOURS_FISHED
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hours fished during the trip (ODFW only) |
General Data Type: | NUMBER |
SPORT_GEAR_TYPE
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear) |
General Data Type: | VARCHAR2 |
SPORT_GEAR_MODE
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency Biological Data System (BDS) fishing mode code (WDFW only) |
General Data Type: | VARCHAR2 |
AGENCY_PORT_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency port code |
General Data Type: | NUMBER |
RECFIN_PORT_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard port or district code |
General Data Type: | NUMBER |
RECFIN_PORT_NAME
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN port name |
General Data Type: | VARCHAR2 |
RECFIN_DISTRICT_NAME
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 300 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard district name |
General Data Type: | VARCHAR2 |
AGENCY_TRIP_TYPE_CODE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency trip type (targeted species) code |
General Data Type: | VARCHAR2 |
RECFIN_TRIP_TYPE_CODE
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard trip type (targeted species) code |
General Data Type: | NUMBER |
RECFIN_TRIP_TYPE_NAME
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN trip type (targeted species) name |
General Data Type: | VARCHAR2 |
RECFIN_TRIP_TYPE_DETAIL_NAME
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Specific state-defined trip type (targeted species) |
General Data Type: | VARCHAR2 |
DURATION_TYPE_CODE
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
CPFV trip duration type code |
General Data Type: | NUMBER |
DURATION_TYPE_DESCRIPTION
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
CPFV trip duration type description |
General Data Type: | VARCHAR2 |
AGENCY_WATER_AREA_CODE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency water area code |
General Data Type: | VARCHAR2 |
AGENCY_WATER_AREA_NAME
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency water area name |
General Data Type: | VARCHAR2 |
AGENCY_FISHED_AREA_CODE
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency specific fishing location code used |
General Data Type: | VARCHAR2 |
AGENCY_FISHED_AREA_NAME
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency specific fishing location name |
General Data Type: | VARCHAR2 |
RECFIN_WATER_AREA_CODE
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard water area code |
General Data Type: | NUMBER |
RECFIN_WATER_AREA_NAME
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN water area name |
General Data Type: | VARCHAR2 |
AGENCY_CATCH_AREA_CODE
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency catch area code (ODFW only) |
General Data Type: | VARCHAR2 |
AGENCY_CATCH_AREA_NAME
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency catch area name (ODFW only) |
General Data Type: | VARCHAR2 |
WATER_FISHED_COUNTRY_NAME
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Country where the fishing trip occurred |
General Data Type: | VARCHAR2 |
AGENCY_MODE_CODE
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency fishing mode code |
General Data Type: | VARCHAR2 |
RECFIN_MODE_CODE
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard fishing mode code |
General Data Type: | NUMBER |
RECFIN_MODE_NAME
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN fishing mode name |
General Data Type: | VARCHAR2 |
DESCENDING_DEVICE_USED
Seq. Order: | 41 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Descending device present (CDFW only) |
General Data Type: | CHAR |
FISHING_DEPTH
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth in feet. |
General Data Type: | NUMBER |
AGENCY_SPECIES_CODE
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency species code |
General Data Type: | VARCHAR2 |
RECFIN_SPECIES_CODE
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
RecFIN standard species code |
General Data Type: | NUMBER |
SPECIES_NAME
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species common name |
General Data Type: | VARCHAR2 |
SCIENTIFIC_NAME
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species scientific name |
General Data Type: | VARCHAR2 |
FISHERY_MANAGEMENT_PLAN
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
PFMC Fishery Management Plan |
General Data Type: | VARCHAR2 |
SPECIES_GROUP_NAME
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species group name |
General Data Type: | VARCHAR2 |
STOCK_COMPLEX_NAME
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species complex designation (e.g., nearshore deep demersal, etc.) |
General Data Type: | VARCHAR2 |
PACFIN_SPECIES_CODE
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
PacFIN standard species code |
General Data Type: | VARCHAR2 |
FISH_SEX
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State agency fish sex code |
General Data Type: | VARCHAR2 |
AGENCY_LENGTH
Seq. Order: | 52 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured length of sample |
General Data Type: | NUMBER |
AGENCY_LENGTH_UNITS
Seq. Order: | 53 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units of the agency measured length of sample (C = centimeters, M = millimeters) |
General Data Type: | CHAR |
AGENCY_LENGTH_TYPE
Seq. Order: | 54 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type of length measurement of sample (T = Total, F = Fork) |
General Data Type: | CHAR |
IS_AGENCY_LENGTH_WITHIN_MAX
Seq. Order: | 55 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False) |
General Data Type: | CHAR |
AGENCY_WEIGHT
Seq. Order: | 56 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured weight of sample |
General Data Type: | NUMBER |
AGENCY_WEIGHT_UNITS
Seq. Order: | 57 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Units of the agency measured weight of sample (G = grams, K = kilograms) |
General Data Type: | CHAR |
RECFIN_LENGTH_MM
Seq. Order: | 58 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency length converted to millimeters |
General Data Type: | NUMBER |
RECFIN_LENGTH_TYPE
Seq. Order: | 59 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type of length measurement of sample (T = Total, F = Fork) |
General Data Type: | CHAR |
RECFIN_IMPUTED_LENGTH
Seq. Order: | 60 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | NUMBER |
RECFIN_IMPUTED_WEIGHT_KG
Seq. Order: | 61 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters |
General Data Type: | NUMBER |
FISH_DISPOSITION
Seq. Order: | 62 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fish disposition (CDFW CRFS and CDFW and ODFW discard samples only; 3 = Eat, 4 = Bait, 5 = Give Away, 6 = ?, 7 = Other Purpose, 8 = Dont know, 9 = Refused) |
General Data Type: | NUMBER |
FISH_INSPECTED
Seq. Order: | 63 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of fish (avail.) (CDFW only) |
General Data Type: | NUMBER |
NUMBER_OF_LOCATIONS
Seq. Order: | 64 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only) |
General Data Type: | NUMBER |
NUMBER_OF_SPECIES
Seq. Order: | 65 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of species encountered on a trip (CDFW only) |
General Data Type: | NUMBER |
SALMON_TAG
Seq. Order: | 66 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
5-digit salmon tag number (CDFW only) |
General Data Type: | NUMBER |
WHITE_SEABASS_TAG
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-character tag number (e.g., 01N, 02N, 03N; CDFW only) |
General Data Type: | VARCHAR2 |
SAMPLE_COMMENT
Seq. Order: | 68 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments for Sample |
General Data Type: | VARCHAR2 |
SOURCE_CODE
Seq. Order: | 69 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sampling source code (BIO = ODFW ORBS and CDFW CRFS sampling, BDS = WDFW BDS sampling, CPFV = ODFW and CDFW at-sea CPFV sampling, ORA = ODFW age sampling, SAC = Sportfishing Association of California sampling) |
General Data Type: | VARCHAR2 |
IS_RETAINED
Seq. Order: | 70 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies whether the sample was retained or released (T = retained, F = released) |
General Data Type: | CHAR |
RECFIN_VDATE
Seq. Order: | 71 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
General Data Type: | DATE |
Support Roles
Metadata Contact
Date Effective From: | 2019-03-31 |
---|---|
Date Effective To: | |
Contact (Person): | Edwards, Jason |
Email Address: | jedwards@psmfc.org |
Catalog Details
Catalog Item ID: | 55989 |
---|---|
GUID: | gov.noaa.nmfs.inport:55989 |
Metadata Record Created By: | Jason Edwards |
Metadata Record Created: | 2019-04-01 12:19+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-04-02 |
Owner Org: | PSMFC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-04-02 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-04-02 |