Table: COMPREHENSIVE_BIO_DETAIL
Pacific States Marine Fisheries Commission
Entity
(ENT)
| ID: 55989
| Published / External
Created: 2019-04-01
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 55991
ID: 55989
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: COMPREHENSIVE_BIO_DETAIL |
---|---|
Short Name | COMPREHENSIVE_BIO_DETAIL Table |
* Status | On Going |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
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 |
---|---|
None | month |
None | year |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | California |
None | county |
None | district |
None | interview site |
None | Oregon |
None | port |
None | state |
None | Washington |
None | water area |
Stratum Keywords
Thesaurus | Keyword |
---|---|
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 | |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | BIO_DETAIL_ID | NUMBER | Numeric unique identifier for the bio detail sample record |
100 | No | No | ANGLER_ID | NUMBER | Numeric identifier for the parent angler trip record |
100 | No | No | CATCH_ID | NUMBER | Numeric identifier for the parent catch record |
100 | No | No | CPFV_TRIP_ID | NUMBER | Numeric identifier for the parent CPFV trip record |
100 | No | No | RECFIN_YEAR | NUMBER | Year of sample |
100 | No | No | RECFIN_MONTH | NUMBER | Month of sample |
100 | No | No | RECFIN_DAY | NUMBER | Day of sample |
100 | No | No | RECFIN_DATE | DATE | Date of sample |
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 |
67 | No | No | LOCATION_NUMBER | NUMBER | |
100 | No | No | INTERVIEW_SITE | NUMBER | Numeric interview site code (CDFW only) |
100 | No | No | COUNTY_NUMBER | NUMBER | State agency county code where interview occurred (CDFW only) |
100 | No | No | NUMBER_OF_ANGLERS | NUMBER | Number of anglers fishing |
100 | No | No | NUMBER_HOURS_FISHED | NUMBER | Number of hours fished during the trip (ODFW only) |
100 | No | No | SPORT_GEAR_TYPE | VARCHAR2 | Sport gear used (WDFW only HC Hook and Line SD Dip net SH Hook and Line SS Spear) |
100 | No | No | SPORT_GEAR_MODE | VARCHAR2 | State agency Biological Data System (BDS) fishing mode code (WDFW only) |
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 | RECFIN_DISTRICT_NAME | VARCHAR2 | RecFIN standard district name |
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 | RECFIN_TRIP_TYPE_DETAIL_NAME | VARCHAR2 | Specific state-defined trip type (targeted species) |
100 | No | No | DURATION_TYPE_CODE | NUMBER | CPFV trip duration type code |
100 | No | No | DURATION_TYPE_DESCRIPTION | VARCHAR2 | CPFV trip duration type description |
100 | No | No | AGENCY_WATER_AREA_CODE | VARCHAR2 | State agency water area code |
100 | No | No | AGENCY_WATER_AREA_NAME | VARCHAR2 | State agency water area name |
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 | AGENCY_CATCH_AREA_CODE | VARCHAR2 | State agency catch area code (ODFW only) |
100 | No | No | AGENCY_CATCH_AREA_NAME | VARCHAR2 | State agency catch area name (ODFW only) |
100 | No | No | WATER_FISHED_COUNTRY_NAME | VARCHAR2 | Country where the fishing trip 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 | DESCENDING_DEVICE_USED | CHAR | Descending device present (CDFW only) |
100 | No | No | FISHING_DEPTH | NUMBER | Depth in feet. |
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 | FISHERY_MANAGEMENT_PLAN | VARCHAR2 | PFMC 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 standard species code |
100 | No | No | FISH_SEX | VARCHAR2 | State agency fish sex code |
100 | No | No | AGENCY_LENGTH | NUMBER | Measured length of sample |
100 | No | No | AGENCY_LENGTH_UNITS | CHAR | Units of the agency measured length of sample (C = centimeters, M = millimeters) |
100 | No | No | AGENCY_LENGTH_TYPE | CHAR | Type of length measurement of sample (T = Total, F = Fork) |
100 | No | No | IS_AGENCY_LENGTH_WITHIN_MAX | CHAR | Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False) |
100 | No | No | AGENCY_WEIGHT | NUMBER | Measured weight of sample |
100 | No | No | AGENCY_WEIGHT_UNITS | CHAR | Units of the agency measured weight of sample (G = grams, K = kilograms) |
100 | No | No | RECFIN_LENGTH_MM | NUMBER | Agency length converted to millimeters |
100 | No | No | RECFIN_LENGTH_TYPE | CHAR | Type of length measurement of sample (T = Total, F = Fork) |
67 | No | No | RECFIN_IMPUTED_LENGTH | NUMBER | |
100 | No | No | RECFIN_IMPUTED_WEIGHT_KG | NUMBER | Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters |
100 | No | No | 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 | No | No | FISH_INSPECTED | NUMBER | Number of fish (avail.) (CDFW only) |
100 | No | No | NUMBER_OF_LOCATIONS | NUMBER | Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only) |
100 | No | No | NUMBER_OF_SPECIES | NUMBER | Number of species encountered on a trip (CDFW only) |
100 | No | No | SALMON_TAG | NUMBER | 5-digit salmon tag number (CDFW only) |
100 | No | No | WHITE_SEABASS_TAG | VARCHAR2 | 3-character tag number (e.g., 01N, 02N, 03N; CDFW only) |
100 | No | No | SAMPLE_COMMENT | VARCHAR2 | Comments for Sample |
100 | No | No | 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 | No | No | IS_RETAINED | CHAR | Identifies whether the sample was retained or released (T = retained, F = released) |
67 | No | No | RECFIN_VDATE | DATE |
Attribute Details
Attribute Name | BIO_DETAIL_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Numeric unique identifier for the bio detail sample 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 | ANGLER_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric identifier for the parent angler trip 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 | CATCH_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric identifier for the parent 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 | CPFV_TRIP_ID |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric identifier for the parent CPFV trip 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 | RECFIN_YEAR |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
Year of sample |
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 | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
Month of sample |
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_DAY |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 0 |
Status | Active |
Description |
Day of sample |
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_DATE |
---|---|
Seq. Order | 8 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of sample |
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 | AGENCY_CODE |
---|---|
Seq. Order | 9 |
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 | 10 |
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 | 11 |
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 | LOCATION_NUMBER |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
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 | INTERVIEW_SITE |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric interview site code (CDFW only) |
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 | COUNTY_NUMBER |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency county code where interview occurred (CDFW only) |
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 | NUMBER_OF_ANGLERS |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of anglers fishing |
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 | NUMBER_HOURS_FISHED |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of hours fished during the trip (ODFW only) |
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 | SPORT_GEAR_TYPE |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | SPORT_GEAR_MODE |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency Biological Data System (BDS) fishing mode code (WDFW only) |
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 | 19 |
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 | 20 |
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 | 21 |
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 | RECFIN_DISTRICT_NAME |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 300 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard district 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_TRIP_TYPE_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 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 | 24 |
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 | 25 |
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 | RECFIN_TRIP_TYPE_DETAIL_NAME |
---|---|
Seq. Order | 26 |
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 | DURATION_TYPE_CODE |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
CPFV trip duration type 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 | DURATION_TYPE_DESCRIPTION |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
CPFV trip duration type description |
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 | 29 |
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_WATER_AREA_NAME |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency 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 | AGENCY_FISHED_AREA_CODE |
---|---|
Seq. Order | 31 |
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 | 32 |
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 | 33 |
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 | 34 |
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 | AGENCY_CATCH_AREA_CODE |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency catch area code (ODFW only) |
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_CATCH_AREA_NAME |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency catch area name (ODFW only) |
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 | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Country where the fishing trip 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 | 38 |
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 | 39 |
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 | 40 |
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 | DESCENDING_DEVICE_USED |
---|---|
Seq. Order | 41 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Descending device present (CDFW only) |
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 | FISHING_DEPTH |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth in feet. |
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_SPECIES_CODE |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
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 | 44 |
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 | 45 |
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 | 46 |
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 | FISHERY_MANAGEMENT_PLAN |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
PFMC 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 | 48 |
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 | 49 |
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 | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
PacFIN standard 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 | FISH_SEX |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency fish sex 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_LENGTH |
---|---|
Seq. Order | 52 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured length of sample |
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_LENGTH_UNITS |
---|---|
Seq. Order | 53 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Units of the agency measured length of sample (C = centimeters, M = millimeters) |
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 | AGENCY_LENGTH_TYPE |
---|---|
Seq. Order | 54 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of length measurement of sample (T = Total, F = Fork) |
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 | IS_AGENCY_LENGTH_WITHIN_MAX |
---|---|
Seq. Order | 55 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether length measurement falls within RecFIN maximum length value (T = True, F = False) |
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 | AGENCY_WEIGHT |
---|---|
Seq. Order | 56 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Measured weight of sample |
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_WEIGHT_UNITS |
---|---|
Seq. Order | 57 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Units of the agency measured weight of sample (G = grams, K = kilograms) |
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 | RECFIN_LENGTH_MM |
---|---|
Seq. Order | 58 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Agency length converted to millimeters |
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_LENGTH_TYPE |
---|---|
Seq. Order | 59 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of length measurement of sample (T = Total, F = Fork) |
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 | RECFIN_IMPUTED_LENGTH |
---|---|
Seq. Order | 60 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
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_IMPUTED_WEIGHT_KG |
---|---|
Seq. Order | 61 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight in kilograms calculated using length-weight function and RecFIN species-specific length-weight parameters |
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 | FISH_DISPOSITION |
---|---|
Seq. Order | 62 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | FISH_INSPECTED |
---|---|
Seq. Order | 63 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of fish (avail.) (CDFW only) |
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 | NUMBER_OF_LOCATIONS |
---|---|
Seq. Order | 64 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Used as part of the identifier for relating Bio Detail records to Catch and Location (CDFW only) |
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 | NUMBER_OF_SPECIES |
---|---|
Seq. Order | 65 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of species encountered on a trip (CDFW only) |
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 | SALMON_TAG |
---|---|
Seq. Order | 66 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
5-digit salmon tag number (CDFW only) |
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 | WHITE_SEABASS_TAG |
---|---|
Seq. Order | 67 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-character tag number (e.g., 01N, 02N, 03N; CDFW only) |
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 | SAMPLE_COMMENT |
---|---|
Seq. Order | 68 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments for Sample |
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 | SOURCE_CODE |
---|---|
Seq. Order | 69 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
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 | IS_RETAINED |
---|---|
Seq. Order | 70 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifies whether the sample was retained or released (T = retained, F = released) |
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 | RECFIN_VDATE |
---|---|
Seq. Order | 71 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
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 | |
---|---|
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 | 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 Workflow State | Published / External |
Metadata Last Review Date | 2019-04-02 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-04-02 |
Tags |
---|