Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Foreign Fishing Observer Data Dictionary > AFSC/FMA/North Pacific Observer Foreign Fishing >

Table: FOREIGN_CRAB_MATURITY

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9563 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981.

Description

This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981.

Entity Type
Data Table

Data Attribute / Type	Description
CRUISE NUMBER	A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
VESSEL VARCHAR2	A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
DT DATE	Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
YEAR NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
HAUL NUMBER	A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
SPECIES NUMBER	A three-digit numeric code representing a marine species.
SEX VARCHAR2	A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
CARAPACE_LENGTH NUMBER	Observed length (cm) of the carapace of the specimen.
CHELA_HEIGHT NUMBER	Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface.
FEMALE_CRAB_MATURITY NUMBER	A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases.
FILENAME VARCHAR2	The original filename on the Burroughs computer system from which this data record came.
HAUL_JOIN NUMBER	An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.
PK_FCM NUMBER	For internall use only.

Data Attribute / Type

Description

CRUISE
NUMBER

A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.

VESSEL
VARCHAR2

A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.

DT
DATE

Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).

YEAR
NUMBER

A four-digit number identifying the year in which the gear retrieval of the haul began.

HAUL
NUMBER

A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.

SPECIES
NUMBER

A three-digit numeric code representing a marine species.

SEX
VARCHAR2

A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.

CARAPACE_LENGTH
NUMBER

Observed length (cm) of the carapace of the specimen.

CHELA_HEIGHT
NUMBER

Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface.

FEMALE_CRAB_MATURITY
NUMBER

A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases.

FILENAME
VARCHAR2

The original filename on the Burroughs computer system from which this data record came.

HAUL_JOIN
NUMBER

An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

PK_FCM
NUMBER

For internall use only.

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: FOREIGN_CRAB_MATURITY
Short Name:	FOREIGN_CRAB_MATURITY
Status:	Completed
Abstract:	This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This table contains golden king crab maturity data collected aboard 3 Japanese stern trawlers in 1981.

Attribute Summary

	Name	Type	Description
100	CRUISE	NUMBER	A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
100	VESSEL	VARCHAR2	A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
100	DT	DATE	Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
100	YEAR	NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
100	HAUL	NUMBER	A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
100	SPECIES	NUMBER	A three-digit numeric code representing a marine species.
100	SEX	VARCHAR2	A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
100	CARAPACE_LENGTH	NUMBER	Observed length (cm) of the carapace of the specimen.
100	CHELA_HEIGHT	NUMBER	Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface.
100	FEMALE_CRAB_MATURITY	NUMBER	A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases.
100	FILENAME	VARCHAR2	The original filename on the Burroughs computer system from which this data record came.
100	HAUL_JOIN	NUMBER	An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.
100	PK_FCM	NUMBER	For internall use only.

Name

Type

Description

100

CRUISE

NUMBER

A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.

100

VESSEL

VARCHAR2

A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.

100

DATE

100

YEAR

NUMBER

A four-digit number identifying the year in which the gear retrieval of the haul began.

100

HAUL

NUMBER

A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.

100

SPECIES

NUMBER

A three-digit numeric code representing a marine species.

100

SEX

VARCHAR2

A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.

100

CARAPACE_LENGTH

NUMBER

Observed length (cm) of the carapace of the specimen.

100

CHELA_HEIGHT

NUMBER

100

FEMALE_CRAB_MATURITY

NUMBER

A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases.

100

FILENAME

VARCHAR2

The original filename on the Burroughs computer system from which this data record came.

100

HAUL_JOIN

NUMBER

An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.

100

PK_FCM

NUMBER

For internall use only.

Attribute Details

CRUISE

CC ID: 37157

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_FISHING_OPERATI

VESSEL

CC ID: 37166

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number.
General Data Type:	VARCHAR2
Foreign Key Relations:	Refers to more than one entity

DT

CC ID: 37158

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Similar to NORPAC.DOMESTIC_HAUL.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00).
General Data Type:	DATE

YEAR

CC ID: 37167

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	A four-digit number identifying the year in which the gear retrieval of the haul began.
General Data Type:	NUMBER

HAUL

CC ID: 37161

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days.
General Data Type:	NUMBER

SPECIES

CC ID: 37165

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	A three-digit numeric code representing a marine species.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.DOMESTIC_SPECIES

SEX

CC ID: 37164

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
General Data Type:	VARCHAR2

CARAPACE_LENGTH

CC ID: 37155

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Observed length (cm) of the carapace of the specimen.
General Data Type:	NUMBER

CHELA_HEIGHT

CC ID: 37156

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Height (mm) of the cheliped (portion of the crab that makes up the pincher), measured from between the anterior two pairs of spines on the dorsal surface of the right chela to the closest point on the ventral surface.
General Data Type:	NUMBER

FEMALE_CRAB_MATURITY

CC ID: 37159

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	A one-digit numeric code to identify the maturity of the female crab. These codes are defined in the NORPAC.FOREIGN_CRAB_MATURITY_CODE table. 1 - no eggs; 2 - eggs; 3 - egg cases.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_CRAB_MATURITY_C

FILENAME

CC ID: 37160

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The original filename on the Burroughs computer system from which this data record came.
General Data Type:	VARCHAR2

HAUL_JOIN

CC ID: 37162

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	An assigned, unique number (up to 6 digits) used to link records in this table back to a single haul record in the NORPAC.FOREIGN_HAUL table.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_HAUL

PK_FCM

CC ID: 37163

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	For internall use only.
General Data Type:	NUMBER

Catalog Item ID:	9563
GUID:	gov.noaa.nmfs.inport:9563
Metadata Record Created By:	Doug Turnbull
Metadata Record Created:	2009-06-29 18:15+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-05-18
Owner Org:	AFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-05-18
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-05-18

Table: FOREIGN_CRAB_MATURITY

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE

VESSEL

DT

YEAR

HAUL

SPECIES

SEX

CARAPACE_LENGTH

CHELA_HEIGHT

FEMALE_CRAB_MATURITY

FILENAME

HAUL_JOIN

PK_FCM

Catalog Details