Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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

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.

Entity Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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

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 Details

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