Slide Menu
Jump to Section...
Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
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 

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