Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Access Info
Catalog Details

Summary

Abstract

The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.

Description

The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
T_TABLE
VARCHAR2
Identifier of Source Table. Length statistics may be sourced directly from hauls or offloads, or by the more usual path of observer sampling ans species composition.
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. This is a legacy value from the pre 2008 data model and is for the convenience of the users only. Permit is the unique identifier of a vessel and the appropriate join value.
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_TYPE
Number
Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
NMFS_AREA
number
Inherited from parent haul when appropriate NULL for offloads and domestic table data.
LATDD_START
NUMBER
Latitude decimal degrees is computed from the deployment latitude.
LONDD_START
Number
Longitude decimal degrees is computed from the deploymentl longitude.
LATDD_END
Number
Latitude decimal degrees is computed from the deployment latitude of a haul.
LONDD_END
NUMBER
Longitude decimal degrees is computed from the retrieval longitude.
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 in cm.
FREQUENCY
Number
Number of animals measured of a given length.
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.
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

Point of Contact
Julie A Blair
julie.blair@noaa.gov
206 526 4053

Metadata Contact
Renold E Narita
ren.narita@noaa.gov

Item Identification

Title: CURRENT_LENGTH
Short Name: CURRENT LENGTH
Status: In Work
Abstract:

The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.

Supplemental Information:

Populated in batch by the execution of the procedure load_current_length which is run every two hours.

Keywords

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2008 AND FORWARD

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None BS, AI, BSAI, GOA

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None OBSERVER, CURRENT DATA, FISHERY STATISTICS

Physical Location

Organization: Fisheries Monitoring and Analysis
City: Seattle
State/Province: WA
Country: USA
Location Description:

Alaska Fisheries Science Center

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: CURRENT_LENGTH
Schema Name: OBSINT
Description:

The current length data object is a denormalized view of haul, species composition and length fisheries statistics. It is derived from the observer production data and in inclusive from 2008 through the current date. The primary users are industry for inseason montoring of production.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
T_TABLE VARCHAR2 Identifier of Source Table. Length statistics may be sourced directly from hauls or offloads, or by the more usual path of observer sampling ans species composition.
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. This is a legacy value from the pre 2008 data model and is for the convenience of the users only. Permit is the unique identifier of a vessel and the appropriate join value.
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_TYPE Number Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record
100
NMFS_AREA number Inherited from parent haul when appropriate NULL for offloads and domestic table data.
100
LATDD_START NUMBER Latitude decimal degrees is computed from the deployment latitude.
100
LONDD_START Number Longitude decimal degrees is computed from the deploymentl longitude.
100
LATDD_END Number Latitude decimal degrees is computed from the deployment latitude of a haul.
100
LONDD_END NUMBER Longitude decimal degrees is computed from the retrieval longitude.
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 in cm.
100
FREQUENCY Number Number of animals measured of a given length.
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
GEAR_PERFORMANCE NUMBER Unique performance code for a gear type. FK to atl_lov_gear_performance

Attribute Details

T_TABLE

CC ID: 241434
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

Identifier of Source Table. Length statistics may be sourced directly from hauls or offloads, or by the more usual path of observer sampling ans species composition.

General Data Type: Character
Case Restriction: Upper

CRUISE

CC ID: 241477
Seq. Order: 15
Data Storage Type: Number
Max Length: 8
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: Integer

PERMIT

CC ID: 241478
Seq. Order: 20
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: Chracter
Case Restriction: Upper

HAUL_JOIN

CC ID: 241479
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 32
Required: No
Primary Key: No
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: INTEGER

PORT_JOIN

CC ID: 241480
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 23
Required: No
Primary Key: No
Precision: 23
Scale: 0
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: INTEGER

LENGTH_SEQ

CC ID: 241481
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 8
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of an atl_length.

General Data Type: INTEGER

VESSEL

CC ID: 241583
Seq. Order: 40
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. This is a legacy value from the pre 2008 data model and is for the convenience of the users only. Permit is the unique identifier of a vessel and the appropriate join value.

HAUL_OFFLOAD_DATE

CC ID: 241584
Seq. Order: 45
Data Storage Type: DATE
Max Length: 12
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: 241608
Seq. Order: 50
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
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: Integer

GEAR_TYPE

CC ID: 241609
Seq. Order: 55
Data Storage Type: Number
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Numeric value from Norpac Domestic Gear that combined with the Form defines the unique identifier for a gear record

General Data Type: Integer

NMFS_AREA

CC ID: 241610
Seq. Order: 60
Data Storage Type: number
Max Length: 3
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: Integer

LATDD_START

CC ID: 241617
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 7
Required: No
Primary Key: No
Precision: 7
Scale: 5
Status: Active
Description:

Latitude decimal degrees is computed from the deployment latitude.

General Data Type: Number

LONDD_START

CC ID: 241618
Seq. Order: 70
Data Storage Type: Number
Max Length: 8
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Longitude decimal degrees is computed from the deploymentl longitude.

General Data Type: Number

LATDD_END

CC ID: 241637
Seq. Order: 75
Data Storage Type: Number
Max Length: 7
Required: No
Primary Key: No
Precision: 7
Scale: 5
Status: Active
Description:

Latitude decimal degrees is computed from the deployment latitude of a haul.

General Data Type: Number

LONDD_END

CC ID: 241638
Seq. Order: 80
Data Storage Type: NUMBER
Max Length: 8
Required: No
Primary Key: No
Precision: 8
Scale: 5
Status: Active
Description:

Longitude decimal degrees is computed from the retrieval longitude.

General Data Type: Number

SPECIES

CC ID: 241639
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Precision: 4
Scale: 0
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: Integer

SEX

CC ID: 241640
Seq. Order: 90
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sex of length frequency animals

General Data Type: Character
Case Restriction: Upper
Allowed Values: M, F, U

LENGTH

CC ID: 241644
Seq. Order: 95
Data Storage Type: NUMBER
Max Length: 33
Required: No
Primary Key: No
Status: Active
Description:

Measured length of organism in cm.

General Data Type: Real Number

FREQUENCY

CC ID: 241645
Seq. Order: 100
Data Storage Type: Number
Max Length: 23
Required: No
Primary Key: No
Status: Active
Description:

Number of animals measured of a given length.

General Data Type: Integer

EGGS

CC ID: 241646
Seq. Order: 105
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: CHARACTER
Case Restriction: Upper
Allowed Values: Y,N,U

YEAR

CC ID: 241647
Seq. Order: 110
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Year extracted from haul retrieval date or offload deleivery end date

General Data Type: INTEGER

VIABILITY

CC ID: 241648
Seq. Order: 115
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Halibut viability code.

General Data Type: CHARACTER

INJURY

CC ID: 241649
Seq. Order: 120
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Halibut injury code.

SAMPLE_SYSTEM

CC ID: 241650
Seq. Order: 125
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code for sampling system employed by the observer.

General Data Type: INTEGER

GEAR_PERFORMANCE

CC ID: 241651
Seq. Order: 130
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Unique performance code for a gear type. FK to atl_lov_gear_performance

General Data Type: INTEGER

Support Roles

Data Steward

CC ID: 241429
Date Effective From: 2008
Date Effective To:
Contact (Person): Narita, Renold E
Email Address: ren.narita@noaa.gov
Contact Instructions:

Email

Data Steward

CC ID: 241433
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Distributor

CC ID: 241431
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Metadata Contact

CC ID: 241432
Date Effective From: 2008
Date Effective To:
Contact (Person): Narita, Renold E
Email Address: ren.narita@noaa.gov
Contact Instructions:

Email

Point of Contact

CC ID: 241430
Date Effective From: 2008
Date Effective To:
Contact (Person): Blair, Julie A
Address: 7600 Sandpoint Way NE
Seattle, WA 98115
USA
Email Address: julie.blair@noaa.gov
Phone: 206 526 4053
Fax: (206)526-4066
Business Hours: 0700-1630
Contact Instructions:

Email

Access Information

Security Class: Confidential
Security Classification System:

Confidential under Magnuson Stevens.

Security Handling Description:

Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements

Data Access Policy:

Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements

Data Access Procedure:

Made available to OLE, NMFS Staff, and vessel managers with valid confidentiality agreements, requests must be made through Ren Narita.

Data Access Constraints:

Confidential data may not be published in raw form

Data Use Constraints:

Confidential data may only be used for fisheries management and approved research.

Metadata Access Constraints:

None

Metadata Use Constraints:

None

Catalog Details

Catalog Item ID: 28415
GUID: gov.noaa.nmfs.inport:28415
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-10-30 11:12+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04