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_AGE

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

Item Identification

Title:	Table: FOREIGN_AGE
Short Name:	FOREIGN_AGE
Status:	Completed
Abstract:	This table contains age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery.
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 age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery.

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	DT	DATE	Similar to NORPAC.DOMESTIC_AGE.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	SPECIMEN_NUMBER	NUMBER	A unique number assigned a single specimen within a collection.
100	SEX	VARCHAR2	A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown.
100	LENGTH	NUMBER	The fork length in centimeters.
100	AGE	NUMBER	The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory.
100	INDIV_WEIGHT	NUMBER	The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken.
100	SPECIAL_HANDLING	NUMBER	A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes.
100	TOTAL_AGE	NUMBER	Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223.
100	MATURITY_CODE	NUMBER	A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes.
100	FILENAME	VARCHAR2	he original filename on the Burroughs computer system from which this data record came.
100	HAUL_JOIN	NUMBER	Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table.

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

Similar to NORPAC.DOMESTIC_AGE.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

SPECIMEN_NUMBER

NUMBER

A unique number assigned a single specimen within a collection.

100

SEX

VARCHAR2

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

100

LENGTH

NUMBER

The fork length in centimeters.

100

AGE

NUMBER

The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory.

100

INDIV_WEIGHT

NUMBER

The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken.

100

SPECIAL_HANDLING

NUMBER

A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes.

100

TOTAL_AGE

NUMBER

Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223.

100

MATURITY_CODE

NUMBER

A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes.

100

FILENAME

VARCHAR2

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

100

HAUL_JOIN

NUMBER

Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table.

Attribute Details

CRUISE

CC ID: 37116

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

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

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Similar to NORPAC.DOMESTIC_AGE.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: 37130

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

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
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: 37126

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

SPECIMEN_NUMBER

CC ID: 37127

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	3
Scale:	0
Status:	Active
Description:	A unique number assigned a single specimen within a collection.
General Data Type:	NUMBER

SEX

CC ID: 37124

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

LENGTH

CC ID: 37122

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The fork length in centimeters.
General Data Type:	NUMBER

AGE

CC ID: 37115

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory.
General Data Type:	NUMBER

INDIV_WEIGHT

CC ID: 37121

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken.
General Data Type:	NUMBER

SPECIAL_HANDLING

CC ID: 37125

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_SPECIAL_HANDLIN

TOTAL_AGE

CC ID: 37128

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223.
General Data Type:	NUMBER

MATURITY_CODE

CC ID: 37123

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_MATURITY_CODE

FILENAME

CC ID: 37118

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

HAUL_JOIN

CC ID: 37120

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	6
Scale:	0
Status:	Active
Description:	Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table.
General Data Type:	NUMBER
Foreign Key Relations:	NORPAC.FOREIGN_HAUL

Catalog Details

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