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_LENGTH

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

The debriefed length table was created as a successor to the debriefed length materialized view. The table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data.

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_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.
PORT_JOIN NUMBER	Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.
LENGTH_SEQ NUMBER	Sequence generated unique identifier of an atl_length.
VESSEL VARCHAR2	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
HAUL_OFFLOAD_DATE DATE	Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.
HAUL_OFFLOAD NUMBER	Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.
GEAR NUMBER	Gear type code.
NMFS_AREA NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
LATDD_START NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
LONDD_START NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
LATDD_END NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
LONDD_END NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
SPECIES NUMBER	Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.
SEX VARCHAR2	Sex of length frequency animals
LENGTH NUMBER	Measured length of organism.
FREQUENCY NUMBER	Number of animals measured.
EGGS VARCHAR2	Indicator of presence or absence of eggs.
YEAR NUMBER	Year extracted from haul retrieval date or offload deleivery end date
VIABILITY VARCHAR2	Halibut viability code.
INJURY VARCHAR2	Halibut injury code.
SAMPLE_SYSTEM NUMBER	Code for sampling system employed by the observer.
VESSEL_TYPE NUMBER	A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul.
GEAR_PERFORMANCE NUMBER	Unique performance code for a gear type. FK to atl_lov_gear_performance

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

PORT_JOIN
NUMBER

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

LENGTH_SEQ
NUMBER

Sequence generated unique identifier of an atl_length.

VESSEL
VARCHAR2

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.

HAUL_OFFLOAD_DATE
DATE

Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.

HAUL_OFFLOAD
NUMBER

Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.

GEAR
NUMBER

Gear type code.

NMFS_AREA
NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

LATDD_START
NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

LONDD_START
NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

LATDD_END
NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

LONDD_END
NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

SPECIES
NUMBER

Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.

SEX
VARCHAR2

Sex of length frequency animals

LENGTH
NUMBER

Measured length of organism.

FREQUENCY
NUMBER

Number of animals measured.

EGGS
VARCHAR2

Indicator of presence or absence of eggs.

YEAR
NUMBER

Year extracted from haul retrieval date or offload deleivery end date

VIABILITY
VARCHAR2

Halibut viability code.

INJURY
VARCHAR2

Halibut injury code.

SAMPLE_SYSTEM
NUMBER

Code for sampling system employed by the observer.

VESSEL_TYPE
NUMBER

A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul.

GEAR_PERFORMANCE
NUMBER

Unique performance code for a gear type. FK to atl_lov_gear_performance

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_LENGTH
Short Name:	DEBRIEFED_LENGTH
Status:	Completed
Abstract:	The debriefed length table was created as a successor to the debriefed length materialized view. The table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data.
Notes:	Loaded by batch 2535, 11-09-2010 10:55

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	OBSINT
Description:	The debriefed length table was created as a successor to the debriefed length materialized view. The table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data.

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_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	PORT_JOIN	NUMBER	Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.
100	LENGTH_SEQ	NUMBER	Sequence generated unique identifier of an atl_length.
100	VESSEL	VARCHAR2	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
100	HAUL_OFFLOAD_DATE	DATE	Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.
100	HAUL_OFFLOAD	NUMBER	Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.
100	GEAR	NUMBER	Gear type code.
100	NMFS_AREA	NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100	LATDD_START	NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100	LONDD_START	NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100	LATDD_END	NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100	LONDD_END	NUMBER	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100	SPECIES	NUMBER	Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.
100	SEX	VARCHAR2	Sex of length frequency animals
100	LENGTH	NUMBER	Measured length of organism.
100	FREQUENCY	NUMBER	Number of animals measured.
100	EGGS	VARCHAR2	Indicator of presence or absence of eggs.
100	YEAR	NUMBER	Year extracted from haul retrieval date or offload deleivery end date
100	VIABILITY	VARCHAR2	Halibut viability code.
100	INJURY	VARCHAR2	Halibut injury code.
100	SAMPLE_SYSTEM	NUMBER	Code for sampling system employed by the observer.
100	VESSEL_TYPE	NUMBER	A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul.
100	GEAR_PERFORMANCE	NUMBER	Unique performance code for a gear type. FK to atl_lov_gear_performance

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

PORT_JOIN

NUMBER

100

LENGTH_SEQ

NUMBER

Sequence generated unique identifier of an atl_length.

100

VESSEL

VARCHAR2

Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.

100

HAUL_OFFLOAD_DATE

DATE

Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.

100

HAUL_OFFLOAD

NUMBER

Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.

100

GEAR

NUMBER

Gear type code.

100

NMFS_AREA

NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

100

LATDD_START

NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

100

LONDD_START

NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

100

LATDD_END

NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

100

LONDD_END

NUMBER

Inherited from parent haul when appropriate NULL for offloads and domestic table data.

100

SPECIES

NUMBER

Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.

100

SEX

VARCHAR2

Sex of length frequency animals

100

LENGTH

NUMBER

Measured length of organism.

100

FREQUENCY

NUMBER

Number of animals measured.

100

EGGS

VARCHAR2

Indicator of presence or absence of eggs.

100

YEAR

NUMBER

Year extracted from haul retrieval date or offload deleivery end date

100

VIABILITY

VARCHAR2

Halibut viability code.

100

INJURY

VARCHAR2

Halibut injury code.

100

SAMPLE_SYSTEM

NUMBER

Code for sampling system employed by the observer.

100

VESSEL_TYPE

NUMBER

100

GEAR_PERFORMANCE

NUMBER

Unique performance code for a gear type. FK to atl_lov_gear_performance

Attribute Details

T_TABLE

CC ID: 42695

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

CRUISE

CC ID: 42696

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
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: 42697

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_JOIN

CC ID: 42698

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
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

PORT_JOIN

CC ID: 42699

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

LENGTH_SEQ

CC ID: 42700

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Sequence generated unique identifier of an atl_length.
General Data Type:	NUMBER

VESSEL

CC ID: 42701

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

HAUL_OFFLOAD_DATE

CC ID: 42702

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul.
General Data Type:	DATE

HAUL_OFFLOAD

CC ID: 42703

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.
General Data Type:	NUMBER

GEAR

CC ID: 42704

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Gear type code.
General Data Type:	NUMBER

NMFS_AREA

CC ID: 42705

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
General Data Type:	NUMBER

LATDD_START

CC ID: 42706

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
General Data Type:	NUMBER

LONDD_START

CC ID: 42707

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
General Data Type:	NUMBER

LATDD_END

CC ID: 42708

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
General Data Type:	NUMBER

LONDD_END

CC ID: 42709

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Inherited from parent haul when appropriate NULL for offloads and domestic table data.
General Data Type:	NUMBER

SPECIES

CC ID: 42710

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Species either inherited from species composition or recorded in length if different, or if the length record is a child of haul or offload.
General Data Type:	NUMBER

SEX

CC ID: 42711

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Sex of length frequency animals
General Data Type:	VARCHAR2

LENGTH

CC ID: 42712

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Measured length of organism.
General Data Type:	NUMBER

FREQUENCY

CC ID: 42713

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of animals measured.
General Data Type:	NUMBER

EGGS

CC ID: 42714

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of presence or absence of eggs.
General Data Type:	VARCHAR2

YEAR

CC ID: 42715

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year extracted from haul retrieval date or offload deleivery end date
General Data Type:	NUMBER

VIABILITY

CC ID: 42716

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Halibut viability code.
General Data Type:	VARCHAR2

INJURY

CC ID: 42717

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Halibut injury code.
General Data Type:	VARCHAR2

SAMPLE_SYSTEM

CC ID: 42718

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Code for sampling system employed by the observer.
General Data Type:	NUMBER

VESSEL_TYPE

CC ID: 179980

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	A one-digit numeric code that indicates whether the vessel processes fish or delivers it to a processing plant where: 1 = a catcher processor vessel, 2 = a mothership or a ship that receives unsorted codends from other vessels, 3 = a catcher only vessel that delivers unprocessed fish to a shoreside or floating plant or vessel, 4 = a mothership that receives sorted codends, 5 = a vessel that sells the majority of their catch over the side to other fishing vessels who will utilize the fish for bait, 6 = vessels that discard all catch from a haul. Would be used for codend dumping of an entire haul.

GEAR_PERFORMANCE

CC ID: 179981

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique performance code for a gear type. FK to atl_lov_gear_performance

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

T_TABLE

CRUISE

PERMIT

HAUL_JOIN

PORT_JOIN

LENGTH_SEQ

VESSEL

HAUL_OFFLOAD_DATE

HAUL_OFFLOAD

GEAR

NMFS_AREA

LATDD_START

LONDD_START

LATDD_END

LONDD_END

SPECIES

SEX

LENGTH

FREQUENCY

EGGS

YEAR

VIABILITY

INJURY

SAMPLE_SYSTEM

VESSEL_TYPE

GEAR_PERFORMANCE

Catalog Details