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: CATCH

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens

Description

Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens

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
WEIGHT NUMBER	Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg
NUMBER_FISH NUMBER	Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul.
SUBSAMPLE_CODE VARCHAR2	Unused attribute
VOUCHER NUMBER	Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul
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

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

WEIGHT
NUMBER

Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg

NUMBER_FISH
NUMBER

Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul.

SUBSAMPLE_CODE
VARCHAR2

Unused attribute

VOUCHER
NUMBER

Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul

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

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: CATCH
Short Name:	CATCH
Status:	Completed
Abstract:	Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	RACEBASE
Description:	Summary values for organisms caught in the net, summarized by species and haul. Fields contain total weight and number of each species and whether any organisms were collected for voucher specimens

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	WEIGHT	NUMBER	Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg
100	NUMBER_FISH	NUMBER	Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul.
100	SUBSAMPLE_CODE	VARCHAR2	Unused attribute
100	VOUCHER	NUMBER	Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul
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

100

VESSEL

NUMBER

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

100

CRUISE

NUMBER

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

WEIGHT

NUMBER

Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg

100

NUMBER_FISH

NUMBER

Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul.

100

SUBSAMPLE_CODE

VARCHAR2

Unused attribute

100

VOUCHER

NUMBER

Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul

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: 1229950

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: 1229951

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: 1229952

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
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: 1229953

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: 1229954

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: 1229955

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: 1229956

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: 1229957

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

WEIGHT

CC ID: 1229958

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Kilogram (kg). This value is the extrapolated Weight, to nearest thousandth of a kg, for each species in the catch. Collected in pounds in 1993 and prior years and has since been converted to kg
General Data Type:	NUMBER

NUMBER_FISH

CC ID: 1229959

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Valid Values: whole numbers, 0, and null. This value is the extrapolated total number of individuals of this species caught in the haul.
General Data Type:	NUMBER

SUBSAMPLE_CODE

CC ID: 1229960

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unused attribute
General Data Type:	VARCHAR2

VOUCHER

CC ID: 1229961

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Reference number given to specimens that are collected and preserved for taxonomic identification purposes. These are assigned sequentially beginning with 1 and re-initiated for each haul
General Data Type:	NUMBER

AUDITJOIN

CC ID: 1229962

Seq. Order:	13
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 Item ID:	69746
GUID:	gov.noaa.nmfs.inport:69746
Metadata Record Created By:	Nancy Roberson
Metadata Record Created:	2023-05-01 17:42+0000
Metadata Record Last Modified By:	Nancy Roberson
Metadata Record Last Modified:	2023-10-26 16:31+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

Table: CATCH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISEJOIN

HAULJOIN

CATCHJOIN

REGION

VESSEL

CRUISE

HAUL

SPECIES_CODE

WEIGHT

NUMBER_FISH

SUBSAMPLE_CODE

VOUCHER

AUDITJOIN

Catalog Details