Table: COMPREHENSIVE_REC_AGEING
Pacific States Marine Fisheries Commission
Entity
(ENT)
| ID: 55982
| Published / External
Created: 2019-03-30
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 55991
ID: 55982
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: COMPREHENSIVE_REC_AGEING |
---|---|
Short Name | COMPREHENSIVE_REC_AGEING Table |
* Status | On Going |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
The RecFIN Comprehensive Recreational Ageing table provides samples of age structures and associated age data from recreational fisheries collected by Oregon Department of Fish and Wildlife and Washington Department of Fish and Wildlife sampling programs. |
* Purpose |
The purpose of the RecFIN Comprehensive Recreational Ageing table is to provide information from age structures and associated sampling data of retained fish from the ocean recreational fisheries of 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 | age |
None | age structure |
None | ageing |
None | agency |
None | BDS |
None | bio-detail |
None | Biological Data System |
None | biological detail |
None | biological sample |
None | fin ray |
None | length |
None | mode |
None | ODFW |
None | Oregon Department of Fish and Wildlife |
None | otolith |
None | recreational fisheries |
None | retained |
None | sample |
None | sex |
None | species |
None | Washington Department of Fish and Wildlife |
None | WDFW |
None | weight |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | month |
None | year |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | Oregon |
None | port |
None | state |
None | Washington |
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 | SAMPLE_ID | NUMBER | Numeric identifier for the parent sample record |
100 | Yes | Yes | RECFIN_READ_NUMBER | NUMBER | Indicates if age is from the first read or subsequent read (e.g. 0 = not read, 1 = first read, 2 = second read, etc.) |
100 | No | No | AGEING_ID | NUMBER | Numeric unique identifier for the age record |
100 | No | No | SAMPLING_AGENCY_CODE | NUMBER | RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW) |
100 | No | No | SAMPLING_AGENCY_NAME | VARCHAR2 | State code (i.e., W = WDFW, O = ODFW) |
100 | No | No | AGEING_LOCATION | VARCHAR2 | Location of ageing lab |
100 | No | No | AGEING_AGENCY_NAME | VARCHAR2 | Name of ageing agency |
100 | No | No | AGED_BY | VARCHAR2 | Identifier for the age reader. |
100 | No | No | DATE_SENT_OUT | DATE | Date age structure was sent to another lab (WDFW only) |
100 | No | No | DATE_RETURNED | DATE | Date when age structure was returned to WDFW (WDFW only) |
100 | No | No | READ_DATE | DATE | Date age was determined. |
100 | No | No | READ_NUMBER | NUMBER | Indicates if age is from the first read or subsequent read (e.g. 0 = not read, 1 = first read, 2 = second read, etc.) |
100 | No | No | EQUIPMENT_DESCRIPTION | VARCHAR2 | Description of ageing equipment. |
100 | No | No | AGENCY_STRUCTURE_CODE | VARCHAR2 | Identifier for the ageing structure. Unique when used in combination with the Agency Code |
100 | No | No | AGENCY_STRUCTURE_DESCRIPTION | VARCHAR2 | Description of ageing structure. |
100 | No | No | RECFIN_STRUCTURE_ID | NUMBER | Unique (numeric) identifier for age structure. |
100 | No | No | RECFIN_STRUCTURE_DESCRIPTION | VARCHAR2 | Unique description of age structure. |
100 | No | No | CLARITY_DESCRIPTION | VARCHAR2 | Unique description of age structure clarity (ability to read). |
100 | No | No | AGENCY_AGEING_METHOD_CODE | VARCHAR2 | Identifier for the ageing method. Unique when used in combination with the Agency Code. |
100 | No | No | AGENCY_AGEING_METHOD_DESC | VARCHAR2 | Description of ageing method. |
100 | No | No | RECFIN_AGEING_METHOD_ID | NUMBER | Unique (numeric) identifier for ageing method. |
100 | No | No | RECFIN_AGEING_METHOD_DESC | VARCHAR2 | Unique description of ageing method. |
100 | No | No | AGENCY_SELECTION_METHOD_CODE | VARCHAR2 | Identifier for the selection method. Unique when used in combination with the Agency Code. |
100 | No | No | AGENCY_SELECTION_METHOD_DESC | VARCHAR2 | Description of selection method. |
100 | No | No | RECFIN_SELECTION_METHOD_ID | NUMBER | Unique (numeric) identifier for selection method. |
100 | No | No | RECFIN_SELECTION_METHOD_DESC | VARCHAR2 | Unique description of selection method. |
100 | No | No | USE_THIS_AGE | NUMBER | Age reading. Data users are directed to use this age when there are values in both the Surface and ReadAge fields. |
100 | No | No | EDGE_TYPE_DESCRIPTION | VARCHAR2 | Unique description of edge type. |
67 | No | No | READ_ESTIMATE | VARCHAR2 | |
100 | No | No | AGE_COMMENTS | VARCHAR2 | Comments from age reader. |
100 | No | No | AGENCY_PORT_CODE | VARCHAR2 | State agency port code |
100 | No | No | PORT_NAME | VARCHAR2 | Name of Port |
100 | No | No | VESSEL_NAME | VARCHAR2 | Vessel or boat name. |
100 | No | No | REEF_NUMBER | VARCHAR2 | Reef number where majority of fishing took place. OR only. |
100 | No | No | CUBICLE_NUMBER | NUMBER | Cubicle or bin number. OR only. |
100 | No | No | SAMPLER_NAME | VARCHAR2 | Sampler code per ODFW and PSMFC. |
100 | No | No | AGENCY_MODE_CODE | VARCHAR2 | State agency fishing mode code |
100 | No | No | AGENCY_MODE_NAME | VARCHAR2 | Short name of the (fishing) mode (e.g., Shore, Charter, Pier). |
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 | RECFIN_SPECIES_NAME | VARCHAR2 | Species common name |
100 | No | No | SAMPLE_DATE | DATE | Date sample was taken. |
100 | No | No | SAMPLE_YEAR | NUMBER | Year from sample date |
100 | No | No | SAMPLE_MONTH | NUMBER | Month from sample date |
100 | No | No | MULTIPLE_READS | CHAR | Indicates whether the age structure has been read multiple times (Y = yes, N = no) |
100 | No | No | NUMBER_OF_READS | NUMBER | Number of times the age structure has been read |
100 | No | No | AGE_READABILITY | NUMBER | Code for age structure readability (1-Excellent, 2-Average, 3-Difficult, 4-Minimum age only, 5-Not aged-structure not discernable, 6-Not aged-process storage or collectors error, 7-Double read structure; WDFW only) |
100 | No | No | AGE_READABILITY_DESCRIPTION | VARCHAR2 | Description of age readability value. |
100 | No | No | AGENCY_SEX_CODE | VARCHAR2 | Agency-supplied code categorizing sample sex (e.g., M, F, 1, 2, 3). |
100 | No | No | RECFIN_SEX_CODE | CHAR | RecFIN standard sex code |
100 | No | No | MEASURED_LENGTH | NUMBER | Measured length of sample |
100 | No | No | LENGTH_UNITS | VARCHAR2 | Length units of measurement. (e.g., MM, C). |
100 | No | No | LENGTH_TYPE | CHAR | Type of length measurement. (e.g., T, F). |
100 | No | No | RECFIN_LENGTH_MM | NUMBER | Agency length converted to millimeters |
67 | No | No | SAMPLE_COMMENTS | VARCHAR2 | |
67 | No | No | RECFIN_VDATE | DATE |
Attribute Details
Attribute Name | SAMPLE_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Numeric identifier for the parent 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 | RECFIN_READ_NUMBER |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if age is from the first read or subsequent read (e.g. 0 = not read, 1 = first read, 2 = second read, etc.) |
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 | AGEING_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Numeric unique identifier for the age 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 | SAMPLING_AGENCY_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 | SAMPLING_AGENCY_NAME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State code (i.e., W = WDFW, O = ODFW) |
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 | AGEING_LOCATION |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Location of ageing lab |
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 | AGEING_AGENCY_NAME |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of ageing agency |
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 | AGED_BY |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier for the age reader. |
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 | DATE_SENT_OUT |
---|---|
Seq. Order | 9 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date age structure was sent to another lab (WDFW only) |
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 | DATE_RETURNED |
---|---|
Seq. Order | 10 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when age structure was returned to WDFW (WDFW only) |
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 | READ_DATE |
---|---|
Seq. Order | 11 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date age was determined. |
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 | READ_NUMBER |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if age is from the first read or subsequent read (e.g. 0 = not read, 1 = first read, 2 = second read, etc.) |
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 | EQUIPMENT_DESCRIPTION |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of ageing equipment. |
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_STRUCTURE_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier for the ageing structure. Unique when used in combination with the Agency 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_STRUCTURE_DESCRIPTION |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of ageing structure. |
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_STRUCTURE_ID |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique (numeric) identifier for age structure. |
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_STRUCTURE_DESCRIPTION |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique description of age structure. |
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 | CLARITY_DESCRIPTION |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 130 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique description of age structure clarity (ability to read). |
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_AGEING_METHOD_CODE |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier for the ageing method. Unique when used in combination with the Agency 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_AGEING_METHOD_DESC |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of ageing method. |
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_AGEING_METHOD_ID |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique (numeric) identifier for ageing method. |
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_AGEING_METHOD_DESC |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique description of ageing method. |
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_SELECTION_METHOD_CODE |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifier for the selection method. Unique when used in combination with the Agency 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_SELECTION_METHOD_DESC |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of selection method. |
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_SELECTION_METHOD_ID |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique (numeric) identifier for selection method. |
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_SELECTION_METHOD_DESC |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique description of selection method. |
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 | USE_THIS_AGE |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Age reading. Data users are directed to use this age when there are values in both the Surface and ReadAge fields. |
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 | EDGE_TYPE_DESCRIPTION |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 75 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique description of edge type. |
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 | READ_ESTIMATE |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
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 | AGE_COMMENTS |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments from age reader. |
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 | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State agency port 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 | PORT_NAME |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of Port |
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 | VESSEL_NAME |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 80 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Vessel or boat 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 | REEF_NUMBER |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Reef number where majority of fishing took place. OR 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 | CUBICLE_NUMBER |
---|---|
Seq. Order | 35 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Cubicle or bin number. OR 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 | SAMPLER_NAME |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sampler code per ODFW and PSMFC. |
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 | 37 |
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 | AGENCY_MODE_NAME |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Short name of the (fishing) mode (e.g., Shore, Charter, Pier). |
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 | AGENCY_SPECIES_CODE |
---|---|
Seq. Order | 41 |
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 | 42 |
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 | RECFIN_SPECIES_NAME |
---|---|
Seq. Order | 43 |
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 | SAMPLE_DATE |
---|---|
Seq. Order | 44 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date sample was taken. |
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 | SAMPLE_YEAR |
---|---|
Seq. Order | 45 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year from sample date |
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 | SAMPLE_MONTH |
---|---|
Seq. Order | 46 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month from sample date |
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 | MULTIPLE_READS |
---|---|
Seq. Order | 47 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates whether the age structure has been read multiple times (Y = yes, N = no) |
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 | NUMBER_OF_READS |
---|---|
Seq. Order | 48 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of times the age structure has been read |
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 | AGE_READABILITY |
---|---|
Seq. Order | 49 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for age structure readability (1-Excellent, 2-Average, 3-Difficult, 4-Minimum age only, 5-Not aged-structure not discernable, 6-Not aged-process storage or collectors error, 7-Double read structure; WDFW 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 | AGE_READABILITY_DESCRIPTION |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of age readability value. |
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_SEX_CODE |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Agency-supplied code categorizing sample sex (e.g., M, F, 1, 2, 3). |
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_SEX_CODE |
---|---|
Seq. Order | 52 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
RecFIN standard sex code |
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 | MEASURED_LENGTH |
---|---|
Seq. Order | 53 |
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 | LENGTH_UNITS |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length units of measurement. (e.g., MM, C). |
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 | LENGTH_TYPE |
---|---|
Seq. Order | 55 |
Data Storage Type | CHAR |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of length measurement. (e.g., T, F). |
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 | 56 |
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 | SAMPLE_COMMENTS |
---|---|
Seq. Order | 57 |
Data Storage Type | VARCHAR2 |
Max Length | 4000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
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 | RECFIN_VDATE |
---|---|
Seq. Order | 58 |
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 | 55982 |
---|---|
Metadata Record Created By | Jason Edwards |
Metadata Record Created | 2019-03-30 10:01+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 |
---|