Search Help Show/Hide Menu
Metadata Rubric
98%
5.87 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Raw, biological specimen data for each haul

Description

Raw, biological specimen data for each haul

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISEJOIN
NUMBER 		This is a unique numeric identifier assigned to each (VESSEL,CRUISE) combination
HAULJOIN
NUMBER 		This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL) combination
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.
VESSEL
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
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.
HAUL
NUMBER 		This number uniquely identifies a haul within a cruise. It is a sequential number, in chronological order of occurrence.
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
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
SPECIES_CODE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
LENGTH
NUMBER 		Millimeter (mm)
SEX
NUMBER 		Valid Values: 1=male, 2=female, 3=undetermined
WEIGHT
NUMBER 		Grams (g).
AGE
NUMBER 		Whole Numbers and null. This value represents the age of fish in years
MATURITY
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
MATURITY_TABLE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
GONAD_WT
NUMBER 		grams (g)
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
SPECIMEN_SUBSAMPLE_METHOD
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
SPECIMEN_SAMPLE_TYPE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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

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