Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Debriefed Observer Data Interface > AFSC/FMA/North Pacific Observer Debriefed Data... >

Table: DEBRIEFED_SPCOMP

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model.

Description

Entity Type
Data Table

Data Attribute / Type	Description
T_TABLE VARCHAR2	Identifier of Source Table
CRUISE NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
HAUL_SEQ NUMBER	Sequence generated unique identifier of an atl_haul record.
HAUL_JOIN NUMBER	Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
VESSEL VARCHAR2	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
HAUL_DATE DATE	Date of haul retrieval.
HAUL NUMBER	Number which is entered by the observer identifying a unique haul within a trip.
SEX VARCHAR2	Sex if so identified.
SPECIES NUMBER	Unique identifier for a species imported from Norpac
SPECIES_NAME VARCHAR2	Common Name for a species imported from Norpac
SAMPLE_TYPE VARCHAR2	Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.
SAMPLE_NUMBER NUMBER	Sum of the count of a species for a haul
SAMPLE_SIZE NUMBER	Sum of all parent samples recorded for a haul
SAMPLE_WEIGHT NUMBER	Sum of the weights of a species for a haul
EXTRAPOLATED_WEIGHT NUMBER	Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.
EXTRAPOLATED_NUMBER NUMBER	Number of a species extrapolated to the haul. This algorithm differs by gear type.
PERCENT_RETAINED NUMBER	Percent of this species that was retained from the total catch.
YEAR NUMBER	Year extracted from haul retrieval date
DATE_OF_ENTRY DATE	Computed value for date of entry from haul - has little meaning.

Data Attribute / Type

Description

T_TABLE
VARCHAR2

Identifier of Source Table

CRUISE
NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

PERMIT
VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

HAUL_SEQ
NUMBER

Sequence generated unique identifier of an atl_haul record.

HAUL_JOIN
NUMBER

Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

VESSEL
VARCHAR2

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel

HAUL_DATE
DATE

Date of haul retrieval.

HAUL
NUMBER

Number which is entered by the observer identifying a unique haul within a trip.

SEX
VARCHAR2

Sex if so identified.

SPECIES
NUMBER

Unique identifier for a species imported from Norpac

SPECIES_NAME
VARCHAR2

Common Name for a species imported from Norpac

SAMPLE_TYPE
VARCHAR2

Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.

SAMPLE_NUMBER
NUMBER

Sum of the count of a species for a haul

SAMPLE_SIZE
NUMBER

Sum of all parent samples recorded for a haul

SAMPLE_WEIGHT
NUMBER

Sum of the weights of a species for a haul

EXTRAPOLATED_WEIGHT
NUMBER

Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.

EXTRAPOLATED_NUMBER
NUMBER

Number of a species extrapolated to the haul. This algorithm differs by gear type.

PERCENT_RETAINED
NUMBER

Percent of this species that was retained from the total catch.

YEAR
NUMBER

Year extracted from haul retrieval date

DATE_OF_ENTRY
DATE

Computed value for date of entry from haul - has little meaning.

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: DEBRIEFED_SPCOMP
Short Name:	DEBRIEFED_SPCOMP
Status:	Completed
Abstract:	This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model.
Notes:	Loaded by batch 2535, 11-09-2010 10:55

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	OBSINT
Description:	This table contains species composition data that bridges the gap between the domestic data (pre 2008) and current data collection protocols (post 2008). The old system did not provide for discrete and repteated sampling of an observer haul. To provide this longitudinal view that newer feature has been flattened and the presentation mirrors the domestic model.

Attribute Summary

	Name	Type	Description
100	T_TABLE	VARCHAR2	Identifier of Source Table
100	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	PERMIT	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100	HAUL_SEQ	NUMBER	Sequence generated unique identifier of an atl_haul record.
100	HAUL_JOIN	NUMBER	Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
100	VESSEL	VARCHAR2	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
100	HAUL_DATE	DATE	Date of haul retrieval.
100	HAUL	NUMBER	Number which is entered by the observer identifying a unique haul within a trip.
100	SEX	VARCHAR2	Sex if so identified.
100	SPECIES	NUMBER	Unique identifier for a species imported from Norpac
100	SPECIES_NAME	VARCHAR2	Common Name for a species imported from Norpac
100	SAMPLE_TYPE	VARCHAR2	Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.
100	SAMPLE_NUMBER	NUMBER	Sum of the count of a species for a haul
100	SAMPLE_SIZE	NUMBER	Sum of all parent samples recorded for a haul
100	SAMPLE_WEIGHT	NUMBER	Sum of the weights of a species for a haul
100	EXTRAPOLATED_WEIGHT	NUMBER	Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.
100	EXTRAPOLATED_NUMBER	NUMBER	Number of a species extrapolated to the haul. This algorithm differs by gear type.
100	PERCENT_RETAINED	NUMBER	Percent of this species that was retained from the total catch.
100	YEAR	NUMBER	Year extracted from haul retrieval date
100	DATE_OF_ENTRY	DATE	Computed value for date of entry from haul - has little meaning.

Name

Type

Description

100

T_TABLE

VARCHAR2

Identifier of Source Table

100

CRUISE

NUMBER

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.

100

PERMIT

VARCHAR2

Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau

100

HAUL_SEQ

NUMBER

Sequence generated unique identifier of an atl_haul record.

100

HAUL_JOIN

NUMBER

Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

100

VESSEL

VARCHAR2

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel

100

HAUL_DATE

DATE

Date of haul retrieval.

100

HAUL

NUMBER

Number which is entered by the observer identifying a unique haul within a trip.

100

SEX

VARCHAR2

Sex if so identified.

100

SPECIES

NUMBER

Unique identifier for a species imported from Norpac

100

SPECIES_NAME

VARCHAR2

Common Name for a species imported from Norpac

100

SAMPLE_TYPE

VARCHAR2

Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.

100

SAMPLE_NUMBER

NUMBER

Sum of the count of a species for a haul

100

SAMPLE_SIZE

NUMBER

Sum of all parent samples recorded for a haul

100

SAMPLE_WEIGHT

NUMBER

Sum of the weights of a species for a haul

100

EXTRAPOLATED_WEIGHT

NUMBER

Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.

100

EXTRAPOLATED_NUMBER

NUMBER

Number of a species extrapolated to the haul. This algorithm differs by gear type.

100

PERCENT_RETAINED

NUMBER

Percent of this species that was retained from the total catch.

100

YEAR

NUMBER

Year extracted from haul retrieval date

100

DATE_OF_ENTRY

DATE

Computed value for date of entry from haul - has little meaning.

Attribute Details

T_TABLE

CC ID: 42719

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Identifier of Source Table
General Data Type:	VARCHAR2

CRUISE

CC ID: 42720

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type:	NUMBER

PERMIT

CC ID: 42721

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type:	VARCHAR2

HAUL_SEQ

CC ID: 42722

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Sequence generated unique identifier of an atl_haul record.
General Data Type:	NUMBER

HAUL_JOIN

CC ID: 42723

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
General Data Type:	NUMBER
Foreign Key Relations:	OBSINT.DEBRIEFED_HAUL

VESSEL

CC ID: 42724

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel
General Data Type:	VARCHAR2

HAUL_DATE

CC ID: 42725

Seq. Order:	7
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of haul retrieval.
General Data Type:	DATE

HAUL

CC ID: 42726

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Number which is entered by the observer identifying a unique haul within a trip.
General Data Type:	NUMBER

SEX

CC ID: 42727

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sex if so identified.
General Data Type:	VARCHAR2

SPECIES

CC ID: 42728

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Unique identifier for a species imported from Norpac
General Data Type:	NUMBER

SPECIES_NAME

CC ID: 42729

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Common Name for a species imported from Norpac
General Data Type:	VARCHAR2

SAMPLE_TYPE

CC ID: 42730

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Computed for atl_data - this value was assigned by observers prior to 2008 and reflects the fact that samples were not identified except as within a haul record.
General Data Type:	VARCHAR2

SAMPLE_NUMBER

CC ID: 42731

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Sum of the count of a species for a haul
General Data Type:	NUMBER

SAMPLE_SIZE

CC ID: 42732

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Sum of all parent samples recorded for a haul
General Data Type:	NUMBER

SAMPLE_WEIGHT

CC ID: 42733

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	Sum of the weights of a species for a haul
General Data Type:	NUMBER

EXTRAPOLATED_WEIGHT

CC ID: 42734

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Weight in kilograms of a species extrapolated to the haul. This algorithm differs by gear type.
General Data Type:	NUMBER

EXTRAPOLATED_NUMBER

CC ID: 42735

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of a species extrapolated to the haul. This algorithm differs by gear type.
General Data Type:	NUMBER

PERCENT_RETAINED

CC ID: 42736

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Percent of this species that was retained from the total catch.
General Data Type:	NUMBER

YEAR

CC ID: 42737

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Year extracted from haul retrieval date
General Data Type:	NUMBER

DATE_OF_ENTRY

CC ID: 42738

Seq. Order:	20
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Computed value for date of entry from haul - has little meaning.
General Data Type:	DATE

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

Table: DEBRIEFED_SPCOMP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

T_TABLE

CRUISE

PERMIT

HAUL_SEQ

HAUL_JOIN

VESSEL

HAUL_DATE

HAUL

SEX

SPECIES

SPECIES_NAME

SAMPLE_TYPE

SAMPLE_NUMBER

SAMPLE_SIZE

SAMPLE_WEIGHT

EXTRAPOLATED_WEIGHT

EXTRAPOLATED_NUMBER

PERCENT_RETAINED

YEAR

DATE_OF_ENTRY

Catalog Details