Metadata Rubric

100%

6 / 6

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

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

	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

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