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_DETAIL_PRO_SEX_COMP

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

Item Identification

Title:	Table: FOREIGN_DETAIL_PRO_SEX_COMP
Short Name:	FOREIGN_DETAIL_PRO_SEX_COMP
Status:	Completed
Abstract:	This table contains species composition data for the prohibited species found within the haul samples.
Notes:	Loaded by batch 2364, 06-29-2009 18:15

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	NORPAC
Description:	This table contains species composition data for the prohibited species found within the haul samples.

Data Attributes

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	YEAR	NUMBER	A four-digit number identifying the year in which the gear retrieval of the haul began.
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	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	SAMPLE_NUMBER	NUMBER	In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set, (usually 1, 2, or 3).
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	NUMBER_IN_SAMPLE	NUMBER	The number (count) of the specified species which occurred within the sample.
100	WEIGHT_IN_SAMPLE	NUMBER	The total weight in kilograms of the specified species which occurred within the sample.
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_FDPSC	NUMBER	For internal 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

YEAR

NUMBER

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

100

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

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

SAMPLE_NUMBER

NUMBER

In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set, (usually 1, 2, or 3).

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

NUMBER_IN_SAMPLE

NUMBER

The number (count) of the specified species which occurred within the sample.

100

WEIGHT_IN_SAMPLE

NUMBER

The total weight in kilograms of the specified species which occurred within the sample.

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_FDPSC

NUMBER

For internal use only.

Attribute Details

CRUISE

CC ID: 37214

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

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

YEAR

CC ID: 37225

Seq. Order:	3
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

DT

CC ID: 37215

Seq. Order:	4
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

HAUL

CC ID: 37216

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

SAMPLE_NUMBER

CC ID: 37220

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	In sampling a longline set or a day's mothership operation or a day's joint venture operation, each portion of the set or delivery that was sampled received a unique sample_number within the set, (usually 1, 2, or 3).
General Data Type:	NUMBER

SPECIES

CC ID: 37222

Seq. Order:	7
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: 37221

Seq. Order:	8
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

NUMBER_IN_SAMPLE

CC ID: 37218

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	The number (count) of the specified species which occurred within the sample.
General Data Type:	NUMBER

WEIGHT_IN_SAMPLE

CC ID: 37224

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	The total weight in kilograms of the specified species which occurred within the sample.
General Data Type:	NUMBER

HAUL_JOIN

CC ID: 37217

Seq. Order:	11
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_FDPSC

CC ID: 37219

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

Catalog Details

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