Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Resource Assessment and Conservation Engineerin... > Groundfish Assessment Program > AFSC/RACE/GAP: RACEBASE Database >

Table: LENGTH

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:69749  |  Updated: October 26, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Summarizes length frequency by species and sex for each haul

Description

Summarizes length frequency by species and sex 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
CATCHJOIN
NUMBER 		This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) 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.
SPECIES_CODE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
LENGTH
NUMBER 		Millimeter (mm)
FREQUENCY
NUMBER 		Must be at least 001
SEX
NUMBER 		Valid Values: 1=male, 2=female, 3=undetermined
SAMPLE_TYPE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
LENGTH_TYPE
NUMBER 		Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
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

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: LENGTH
Short Name: LENGTH
Status: Completed
Abstract:

Summarizes length frequency by species and sex for each haul

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: RACEBASE
Description:

Summarizes length frequency by species and sex 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
 CATCHJOIN NUMBER This is a unique numeric identifier assigned to each (VESSEL, CRUISE, HAUL, SPECIES_CODE) 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
 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
 FREQUENCY NUMBER Must be at least 001
100
 SEX NUMBER Valid Values: 1=male, 2=female, 3=undetermined
100
 SAMPLE_TYPE NUMBER Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
100
 LENGTH_TYPE NUMBER Codebooks: https://www.fisheries.noaa.gov/resource/document/groundfish-survey-species-code-manual-and-data-codes-manual
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

Attribute Details

CRUISEJOIN

CC ID: 1230007
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: 1230008
Seq. Order: 2
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, HAUL) combination
General Data Type: NUMBER

CATCHJOIN

CC ID: 1230009
Seq. Order: 3
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, HAUL, SPECIES_CODE) combination
General Data Type: NUMBER

REGION

CC ID: 1230010
Seq. Order: 4
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: 1230011
Seq. Order: 5
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: 1230012
Seq. Order: 6
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: 1230013
Seq. Order: 7
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

SPECIES_CODE

CC ID: 1230014
Seq. Order: 8
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: 1230015
Seq. Order: 9
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

FREQUENCY

CC ID: 1230016
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Must be at least 001
General Data Type: NUMBER

SEX

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

SAMPLE_TYPE

CC ID: 1230018
Seq. Order: 12
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

LENGTH_TYPE

CC ID: 1230019
Seq. Order: 13
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

AUDITJOIN

CC ID: 1230020
Seq. Order: 14
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

Catalog Details

Catalog Item ID: 69749
GUID: gov.noaa.nmfs.inport:69749
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