Metadata Rubric

98%

5.87 / 6

Alaska Fisheries Science Center Metadata Librar... > Resource Assessment and Conservation Engineerin... > Groundfish Assessment Program > AFSC/RACE/GAP: RACEBASE Database >

Table: SPECIMEN

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:69750 | Updated: October 26, 2023 | Published / External

Item Identification

Title:	Table: SPECIMEN
Short Name:	SPECIMEN
Status:	Completed
Abstract:	Raw, biological specimen data for each haul

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	RACEBASE
Description:	Raw, biological specimen data for each haul

Data Attributes

Attribute Summary

	Name	Type	Description
100	CRUISEJOIN	NUMBER	This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
100	HAULJOIN	NUMBER	This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination
100	REGION	VARCHAR2	Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.
100	VESSEL	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	CRUISE	NUMBER	This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.
100	HAUL	NUMBER	This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence.
100	SPECIMENID	NUMBER	(0001 to 9999; Each individual examined must have a number assigned to it that is unique within each haul. However, specimen numbers may be repeated between hauls
100	BIOSTRATUM	NUMBER	Domain: Historical RACE ADP Codebooks; (this attribute is historical and its codeset domain, at present, is unable to be found. This was a stratification scheme for otoliths that is different from geographic stratum. CAUTION: There are cases where the biostratum column field was used for data other than biostratum data. Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	SPECIES_CODE	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	LENGTH	NUMBER	Millimeter (mm)
100	SEX	NUMBER	Valid Values: 1=male, 2=female, 3=undetermined
100	WEIGHT	NUMBER	Grams (g).
100	AGE	NUMBER	Whole Numbers and null. This value represents the age of fish in years
100	MATURITY	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	MATURITY_TABLE	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	GONAD_WT	NUMBER	grams (g)
100	AUDITJOIN	NUMBER	This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table
100	SPECIMEN_SUBSAMPLE_METHOD	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	SPECIMEN_SAMPLE_TYPE	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100	AGE_DETERMINATION_METHOD	NUMBER	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
67	MINIMUM_AGE	NUMBER
67	MAXIMUM_AGE	NUMBER
67	COMMENTS	VARCHAR2

Name

Type

Description

100

CRUISEJOIN

NUMBER

This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination

100

HAULJOIN

NUMBER

This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination

100

REGION

VARCHAR2

Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.

100

VESSEL

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

CRUISE

NUMBER

This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.

100

HAUL

NUMBER

This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence.

100

SPECIMENID

NUMBER

(0001 to 9999; Each individual examined must have a number assigned to it that is unique within each haul. However, specimen numbers may be repeated between hauls

100

BIOSTRATUM

NUMBER

Domain: Historical RACE ADP Codebooks; (this attribute is historical and its codeset domain, at present, is unable to be found. This was a stratification scheme for otoliths that is different from geographic stratum. CAUTION: There are cases where the biostratum column field was used for data other than biostratum data. Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

SPECIES_CODE

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

LENGTH

NUMBER

Millimeter (mm)

100

SEX

NUMBER

Valid Values: 1=male, 2=female, 3=undetermined

100

WEIGHT

NUMBER

Grams (g).

100

AGE

NUMBER

Whole Numbers and null. This value represents the age of fish in years

100

MATURITY

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

MATURITY_TABLE

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

GONAD_WT

NUMBER

grams (g)

100

AUDITJOIN

NUMBER

This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table

100

SPECIMEN_SUBSAMPLE_METHOD

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

SPECIMEN_SAMPLE_TYPE

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

100

AGE_DETERMINATION_METHOD

NUMBER

Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual

MINIMUM_AGE

NUMBER

MAXIMUM_AGE

NUMBER

COMMENTS

VARCHAR2

Attribute Details

CRUISEJOIN

CC ID: 1230021

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	12
Scale:	0
Status:	Active
Description:	This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
General Data Type:	NUMBER

HAULJOIN

CC ID: 1230022

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	12
Scale:	0
Status:	Active
Description:	This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination
General Data Type:	NUMBER

REGION

CC ID: 1230023

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Valid Values: AI=Aleutian Islands, BS=Bering Sea, GOA=Gulf of Alaska, WC=West Coast,HBS=Hydroacoustic Bering Sea, HG=Hydroacoustic Gulf of Alaska, HWC=Hydroacoustic West Coast, TAG=Denotes that no biological data exist for this cruise other than those related to tags released or recovered.
General Data Type:	VARCHAR2

VESSEL

CC ID: 1230024

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

CRUISE

CC ID: 1230025

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	This is a six-digit number identifying the Cruise number of the form: YYYY99 (where YYYY = year of the cruise; 99 = 2-digit number and is sequential; 01 denotes the first cruise that vessel made in this year, 02 is the second, etc.
General Data Type:	NUMBER

HAUL

CC ID: 1230026

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence.
General Data Type:	NUMBER

SPECIMENID

CC ID: 1230027

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	(0001 to 9999; Each individual examined must have a number assigned to it that is unique within each haul. However, specimen numbers may be repeated between hauls
General Data Type:	NUMBER

BIOSTRATUM

CC ID: 1230028

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Domain: Historical RACE ADP Codebooks; (this attribute is historical and its codeset domain, at present, is unable to be found. This was a stratification scheme for otoliths that is different from geographic stratum. CAUTION: There are cases where the biostratum column field was used for data other than biostratum data. Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

SPECIES_CODE

CC ID: 1230029

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

LENGTH

CC ID: 1230030

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Millimeter (mm)
General Data Type:	NUMBER

SEX

CC ID: 1230031

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Valid Values: 1=male, 2=female, 3=undetermined
General Data Type:	NUMBER

WEIGHT

CC ID: 1230032

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Grams (g).
General Data Type:	NUMBER

AGE

CC ID: 1230033

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Whole Numbers and null. This value represents the age of fish in years
General Data Type:	NUMBER

MATURITY

CC ID: 1230034

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

MATURITY_TABLE

CC ID: 1230035

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

GONAD_WT

CC ID: 1230036

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	grams (g)
General Data Type:	NUMBER

AUDITJOIN

CC ID: 1230037

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	12
Scale:	0
Status:	Active
Description:	This is a unique identifier for each record in the base table, to be used in corresponding audit tables to identify the original record in the base table
General Data Type:	NUMBER

SPECIMEN_SUBSAMPLE_METHOD

CC ID: 1230038

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

SPECIMEN_SAMPLE_TYPE

CC ID: 1230039

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

AGE_DETERMINATION_METHOD

CC ID: 1230040

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
General Data Type:	NUMBER

MINIMUM_AGE

CC ID: 1230041

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	NUMBER

MAXIMUM_AGE

CC ID: 1230042

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	NUMBER

COMMENTS

CC ID: 1230043

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	300
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	69750
GUID:	gov.noaa.nmfs.inport:69750
Metadata Record Created By:	Nancy Roberson
Metadata Record Created:	2023-05-01 17:44+0000
Metadata Record Last Modified By:	Nancy Roberson
Metadata Record Last Modified:	2023-10-26 19:06+0000
Metadata Record Published:	2023-10-26
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2023-10-26
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2024-10-26