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

Item Identification

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 Information

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

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

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

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 Details

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