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

Table: COMPREHENSIVE_REC_AGEING

Entity (ENT)  |  Pacific States Marine Fisheries Commission (PSMFC)
GUID: gov.noaa.nmfs.inport:55982  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Catalog Details

Summary

Abstract

The RecFIN Comprehensive Recreational 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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SAMPLE_ID
NUMBER 		Numeric identifier for the parent sample record
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.)
AGEING_ID
NUMBER 		Numeric unique identifier for the age record
SAMPLING_AGENCY_CODE
NUMBER 		RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
SAMPLING_AGENCY_NAME
VARCHAR2 		State code (i.e., W = WDFW, O = ODFW)
AGEING_LOCATION
VARCHAR2 		Location of ageing lab
AGEING_AGENCY_NAME
VARCHAR2 		Name of ageing agency
AGED_BY
VARCHAR2 		Identifier for the age reader.
DATE_SENT_OUT
DATE 		Date age structure was sent to another lab (WDFW only)
DATE_RETURNED
DATE 		Date when age structure was returned to WDFW (WDFW only)
READ_DATE
DATE 		Date age was determined.
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.)
EQUIPMENT_DESCRIPTION
VARCHAR2 		Description of ageing equipment.
AGENCY_STRUCTURE_CODE
VARCHAR2 		Identifier for the ageing structure. Unique when used in combination with the Agency Code
AGENCY_STRUCTURE_DESCRIPTION
VARCHAR2 		Description of ageing structure.
RECFIN_STRUCTURE_ID
NUMBER 		Unique (numeric) identifier for age structure.
RECFIN_STRUCTURE_DESCRIPTION
VARCHAR2 		Unique description of age structure.
CLARITY_DESCRIPTION
VARCHAR2 		Unique description of age structure clarity (ability to read).
AGENCY_AGEING_METHOD_CODE
VARCHAR2 		Identifier for the ageing method. Unique when used in combination with the Agency Code.
AGENCY_AGEING_METHOD_DESC
VARCHAR2 		Description of ageing method.
RECFIN_AGEING_METHOD_ID
NUMBER 		Unique (numeric) identifier for ageing method.
RECFIN_AGEING_METHOD_DESC
VARCHAR2 		Unique description of ageing method.
AGENCY_SELECTION_METHOD_CODE
VARCHAR2 		Identifier for the selection method. Unique when used in combination with the Agency Code.
AGENCY_SELECTION_METHOD_DESC
VARCHAR2 		Description of selection method.
RECFIN_SELECTION_METHOD_ID
NUMBER 		Unique (numeric) identifier for selection method.
RECFIN_SELECTION_METHOD_DESC
VARCHAR2 		Unique description of selection method.
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.
EDGE_TYPE_DESCRIPTION
VARCHAR2 		Unique description of edge type.
READ_ESTIMATE
VARCHAR2
AGE_COMMENTS
VARCHAR2 		Comments from age reader.
AGENCY_PORT_CODE
VARCHAR2 		State agency port code
PORT_NAME
VARCHAR2 		Name of Port
VESSEL_NAME
VARCHAR2 		Vessel or boat name.
REEF_NUMBER
VARCHAR2 		Reef number where majority of fishing took place. OR only.
CUBICLE_NUMBER
NUMBER 		Cubicle or bin number. OR only.
SAMPLER_NAME
VARCHAR2 		Sampler code per ODFW and PSMFC.
AGENCY_MODE_CODE
VARCHAR2 		State agency fishing mode code
AGENCY_MODE_NAME
VARCHAR2 		Short name of the (fishing) mode (e.g., Shore, Charter, Pier).
RECFIN_MODE_CODE
NUMBER 		RecFIN standard fishing mode code
RECFIN_MODE_NAME
VARCHAR2 		RecFIN fishing mode name
AGENCY_SPECIES_CODE
VARCHAR2 		State agency species code
RECFIN_SPECIES_CODE
NUMBER 		RecFIN standard species code
RECFIN_SPECIES_NAME
VARCHAR2 		Species common name
SAMPLE_DATE
DATE 		Date sample was taken.
SAMPLE_YEAR
NUMBER 		Year from sample date
SAMPLE_MONTH
NUMBER 		Month from sample date
MULTIPLE_READS
CHAR 		Indicates whether the age structure has been read multiple times (Y = yes, N = no)
NUMBER_OF_READS
NUMBER 		Number of times the age structure has been read
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)
AGE_READABILITY_DESCRIPTION
VARCHAR2 		Description of age readability value.
AGENCY_SEX_CODE
VARCHAR2 		Agency-supplied code categorizing sample sex (e.g., M, F, 1, 2, 3).
RECFIN_SEX_CODE
CHAR 		RecFIN standard sex code
MEASURED_LENGTH
NUMBER 		Measured length of sample
LENGTH_UNITS
VARCHAR2 		Length units of measurement. (e.g., MM, C).
LENGTH_TYPE
CHAR 		Type of length measurement. (e.g., T, F).
RECFIN_LENGTH_MM
NUMBER 		Agency length converted to millimeters
SAMPLE_COMMENTS
VARCHAR2
RECFIN_VDATE
DATE

Child Items

No Child Items for this record.

Contact Information

Metadata Contact
Jason Edwards
jedwards@psmfc.org

Item Identification

Title: Table: COMPREHENSIVE_REC_AGEING
Short Name: COMPREHENSIVE_REC_AGEING Table
Status: On Going
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.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
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
UNCONTROLLED
None month
None year

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Oregon
None port
None state
None Washington

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

Rubric Score Primary Key? Name Type Description
100
 Primary Key SAMPLE_ID NUMBER Numeric identifier for the parent sample record
100
 Primary Key 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
 AGEING_ID NUMBER Numeric unique identifier for the age record
100
 SAMPLING_AGENCY_CODE NUMBER RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
100
 SAMPLING_AGENCY_NAME VARCHAR2 State code (i.e., W = WDFW, O = ODFW)
100
 AGEING_LOCATION VARCHAR2 Location of ageing lab
100
 AGEING_AGENCY_NAME VARCHAR2 Name of ageing agency
100
 AGED_BY VARCHAR2 Identifier for the age reader.
100
 DATE_SENT_OUT DATE Date age structure was sent to another lab (WDFW only)
100
 DATE_RETURNED DATE Date when age structure was returned to WDFW (WDFW only)
100
 READ_DATE DATE Date age was determined.
100
 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
 EQUIPMENT_DESCRIPTION VARCHAR2 Description of ageing equipment.
100
 AGENCY_STRUCTURE_CODE VARCHAR2 Identifier for the ageing structure. Unique when used in combination with the Agency Code
100
 AGENCY_STRUCTURE_DESCRIPTION VARCHAR2 Description of ageing structure.
100
 RECFIN_STRUCTURE_ID NUMBER Unique (numeric) identifier for age structure.
100
 RECFIN_STRUCTURE_DESCRIPTION VARCHAR2 Unique description of age structure.
100
 CLARITY_DESCRIPTION VARCHAR2 Unique description of age structure clarity (ability to read).
100
 AGENCY_AGEING_METHOD_CODE VARCHAR2 Identifier for the ageing method. Unique when used in combination with the Agency Code.
100
 AGENCY_AGEING_METHOD_DESC VARCHAR2 Description of ageing method.
100
 RECFIN_AGEING_METHOD_ID NUMBER Unique (numeric) identifier for ageing method.
100
 RECFIN_AGEING_METHOD_DESC VARCHAR2 Unique description of ageing method.
100
 AGENCY_SELECTION_METHOD_CODE VARCHAR2 Identifier for the selection method. Unique when used in combination with the Agency Code.
100
 AGENCY_SELECTION_METHOD_DESC VARCHAR2 Description of selection method.
100
 RECFIN_SELECTION_METHOD_ID NUMBER Unique (numeric) identifier for selection method.
100
 RECFIN_SELECTION_METHOD_DESC VARCHAR2 Unique description of selection method.
100
 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
 EDGE_TYPE_DESCRIPTION VARCHAR2 Unique description of edge type.
67
 READ_ESTIMATE VARCHAR2
100
 AGE_COMMENTS VARCHAR2 Comments from age reader.
100
 AGENCY_PORT_CODE VARCHAR2 State agency port code
100
 PORT_NAME VARCHAR2 Name of Port
100
 VESSEL_NAME VARCHAR2 Vessel or boat name.
100
 REEF_NUMBER VARCHAR2 Reef number where majority of fishing took place. OR only.
100
 CUBICLE_NUMBER NUMBER Cubicle or bin number. OR only.
100
 SAMPLER_NAME VARCHAR2 Sampler code per ODFW and PSMFC.
100
 AGENCY_MODE_CODE VARCHAR2 State agency fishing mode code
100
 AGENCY_MODE_NAME VARCHAR2 Short name of the (fishing) mode (e.g., Shore, Charter, Pier).
100
 RECFIN_MODE_CODE NUMBER RecFIN standard fishing mode code
100
 RECFIN_MODE_NAME VARCHAR2 RecFIN fishing mode name
100
 AGENCY_SPECIES_CODE VARCHAR2 State agency species code
100
 RECFIN_SPECIES_CODE NUMBER RecFIN standard species code
100
 RECFIN_SPECIES_NAME VARCHAR2 Species common name
100
 SAMPLE_DATE DATE Date sample was taken.
100
 SAMPLE_YEAR NUMBER Year from sample date
100
 SAMPLE_MONTH NUMBER Month from sample date
100
 MULTIPLE_READS CHAR Indicates whether the age structure has been read multiple times (Y = yes, N = no)
100
 NUMBER_OF_READS NUMBER Number of times the age structure has been read
100
 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
 AGE_READABILITY_DESCRIPTION VARCHAR2 Description of age readability value.
100
 AGENCY_SEX_CODE VARCHAR2 Agency-supplied code categorizing sample sex (e.g., M, F, 1, 2, 3).
100
 RECFIN_SEX_CODE CHAR RecFIN standard sex code
100
 MEASURED_LENGTH NUMBER Measured length of sample
100
 LENGTH_UNITS VARCHAR2 Length units of measurement. (e.g., MM, C).
100
 LENGTH_TYPE CHAR Type of length measurement. (e.g., T, F).
100
 RECFIN_LENGTH_MM NUMBER Agency length converted to millimeters
67
 SAMPLE_COMMENTS VARCHAR2
67
 RECFIN_VDATE DATE

Attribute Details

SAMPLE_ID

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

Numeric identifier for the parent sample record
General Data Type: NUMBER

RECFIN_READ_NUMBER

CC ID: 831252
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
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

AGEING_ID

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

Numeric unique identifier for the age record
General Data Type: NUMBER

SAMPLING_AGENCY_CODE

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

RecFIN state code (i.e., 53 = WDFW, 41 = ODFW, 6 = CDFW)
General Data Type: NUMBER

SAMPLING_AGENCY_NAME

CC ID: 831255
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

State code (i.e., W = WDFW, O = ODFW)
General Data Type: VARCHAR2

AGEING_LOCATION

CC ID: 831256
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Location of ageing lab
General Data Type: VARCHAR2

AGEING_AGENCY_NAME

CC ID: 831257
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of ageing agency
General Data Type: VARCHAR2

AGED_BY

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

Identifier for the age reader.
General Data Type: VARCHAR2

DATE_SENT_OUT

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

Date age structure was sent to another lab (WDFW only)
General Data Type: DATE

DATE_RETURNED

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

Date when age structure was returned to WDFW (WDFW only)
General Data Type: DATE

READ_DATE

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

Date age was determined.
General Data Type: DATE

READ_NUMBER

CC ID: 831262
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

EQUIPMENT_DESCRIPTION

CC ID: 831263
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of ageing equipment.
General Data Type: VARCHAR2

AGENCY_STRUCTURE_CODE

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

Identifier for the ageing structure. Unique when used in combination with the Agency Code
General Data Type: VARCHAR2

AGENCY_STRUCTURE_DESCRIPTION

CC ID: 831265
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Description of ageing structure.
General Data Type: VARCHAR2

RECFIN_STRUCTURE_ID

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

Unique (numeric) identifier for age structure.
General Data Type: NUMBER

RECFIN_STRUCTURE_DESCRIPTION

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

Unique description of age structure.
General Data Type: VARCHAR2

CLARITY_DESCRIPTION

CC ID: 831268
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 130
Required: No
Primary Key: No
Status: Active
Description:

Unique description of age structure clarity (ability to read).
General Data Type: VARCHAR2

AGENCY_AGEING_METHOD_CODE

CC ID: 831269
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Identifier for the ageing method. Unique when used in combination with the Agency Code.
General Data Type: VARCHAR2

AGENCY_AGEING_METHOD_DESC

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

Description of ageing method.
General Data Type: VARCHAR2

RECFIN_AGEING_METHOD_ID

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

Unique (numeric) identifier for ageing method.
General Data Type: NUMBER

RECFIN_AGEING_METHOD_DESC

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

Unique description of ageing method.
General Data Type: VARCHAR2

AGENCY_SELECTION_METHOD_CODE

CC ID: 831273
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Identifier for the selection method. Unique when used in combination with the Agency Code.
General Data Type: VARCHAR2

AGENCY_SELECTION_METHOD_DESC

CC ID: 831274
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Description of selection method.
General Data Type: VARCHAR2

RECFIN_SELECTION_METHOD_ID

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

Unique (numeric) identifier for selection method.
General Data Type: NUMBER

RECFIN_SELECTION_METHOD_DESC

CC ID: 831276
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique description of selection method.
General Data Type: VARCHAR2

USE_THIS_AGE

CC ID: 831277
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

EDGE_TYPE_DESCRIPTION

CC ID: 831278
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 75
Required: No
Primary Key: No
Status: Active
Description:

Unique description of edge type.
General Data Type: VARCHAR2

READ_ESTIMATE

CC ID: 831279
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

AGE_COMMENTS

CC ID: 831280
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comments from age reader.
General Data Type: VARCHAR2

AGENCY_PORT_CODE

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

State agency port code
General Data Type: VARCHAR2

PORT_NAME

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

Name of Port
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 831283
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Vessel or boat name.
General Data Type: VARCHAR2

REEF_NUMBER

CC ID: 831284
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Reef number where majority of fishing took place. OR only.
General Data Type: VARCHAR2

CUBICLE_NUMBER

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

Cubicle or bin number. OR only.
General Data Type: NUMBER

SAMPLER_NAME

CC ID: 831286
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Sampler code per ODFW and PSMFC.
General Data Type: VARCHAR2

AGENCY_MODE_CODE

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

State agency fishing mode code
General Data Type: VARCHAR2

AGENCY_MODE_NAME

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

Short name of the (fishing) mode (e.g., Shore, Charter, Pier).
General Data Type: VARCHAR2

RECFIN_MODE_CODE

CC ID: 831289
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

CC ID: 831290
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

AGENCY_SPECIES_CODE

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

State agency species code
General Data Type: VARCHAR2

RECFIN_SPECIES_CODE

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

RecFIN standard species code
General Data Type: NUMBER

RECFIN_SPECIES_NAME

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

Species common name
General Data Type: VARCHAR2

SAMPLE_DATE

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

Date sample was taken.
General Data Type: DATE

SAMPLE_YEAR

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

Year from sample date
General Data Type: NUMBER

SAMPLE_MONTH

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

Month from sample date
General Data Type: NUMBER

MULTIPLE_READS

CC ID: 831297
Seq. Order: 47
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the age structure has been read multiple times (Y = yes, N = no)
General Data Type: CHAR

NUMBER_OF_READS

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

Number of times the age structure has been read
General Data Type: NUMBER

AGE_READABILITY

CC ID: 831299
Seq. Order: 49
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

AGE_READABILITY_DESCRIPTION

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

Description of age readability value.
General Data Type: VARCHAR2

AGENCY_SEX_CODE

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

Agency-supplied code categorizing sample sex (e.g., M, F, 1, 2, 3).
General Data Type: VARCHAR2

RECFIN_SEX_CODE

CC ID: 831302
Seq. Order: 52
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

RecFIN standard sex code
General Data Type: CHAR

MEASURED_LENGTH

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

Measured length of sample
General Data Type: NUMBER

LENGTH_UNITS

CC ID: 831304
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Length units of measurement. (e.g., MM, C).
General Data Type: VARCHAR2

LENGTH_TYPE

CC ID: 831305
Seq. Order: 55
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Type of length measurement. (e.g., T, F).
General Data Type: CHAR

RECFIN_LENGTH_MM

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

Agency length converted to millimeters
General Data Type: NUMBER

SAMPLE_COMMENTS

CC ID: 831307
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

RECFIN_VDATE

CC ID: 831308
Seq. Order: 58
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

Support Roles

Metadata Contact

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

Catalog Details

Catalog Item ID: 55982
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2019-04-02
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-04-02