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_HAUL_HOOK_COUNT

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis.

Description

Entity Type
Data Table

Data Attribute / Type	Description
T_TABLE VARCHAR2	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 for a haul record
HAUL_JOIN NUMBER	This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
HAUL_NUMBER NUMBER	Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer.
COLLECTION_NUMBER NUMBER	User Defined Hook Count Set number unique for a cruise permit.
SEGMENT_NUMBER NUMBER	This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.
NUMBER_OF_HOOKS NUMBER	Number of hooks as determined by the observer for this segment, contained within a counted set.
HOOK_SPACING_IN_CM NUMBER	Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip
VESSEL VARCHAR2	Vessel code from the ATL_LOV vessel table.

Data Attribute / Type

Description

T_TABLE
VARCHAR2

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 for a haul record

HAUL_JOIN
NUMBER

This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

HAUL_NUMBER
NUMBER

Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer.

COLLECTION_NUMBER
NUMBER

User Defined Hook Count Set number unique for a cruise permit.

SEGMENT_NUMBER
NUMBER

This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.

NUMBER_OF_HOOKS
NUMBER

Number of hooks as determined by the observer for this segment, contained within a counted set.

HOOK_SPACING_IN_CM
NUMBER

Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip

VESSEL
VARCHAR2

Vessel code from the ATL_LOV vessel table.

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_HAUL_HOOK_COUNT
Short Name:	DEBRIEFED_HAUL_HOOK_COUNT
Status:	Completed
Abstract:	This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis.
Notes:	Loaded by batch 2535, 11-09-2010 10:55

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	OBSINT
Description:	This table contains a flattened view of longline hook count data. Observers are required to determine the number and spacing of hooks used in fishing operations. These counts are assembled into deployable sets of hooks and assigned by the observer to a haul. Average hook counts and spacing is insufficient as mixed gear is allowed (sablefish and halobut for example). So this presentation layer provides detail information for analysis.

Attribute Summary

	Name	Type	Description
100	T_TABLE	VARCHAR2	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 for a haul record
100	HAUL_JOIN	NUMBER	This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
100	HAUL_NUMBER	NUMBER	Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer.
100	COLLECTION_NUMBER	NUMBER	User Defined Hook Count Set number unique for a cruise permit.
100	SEGMENT_NUMBER	NUMBER	This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.
100	NUMBER_OF_HOOKS	NUMBER	Number of hooks as determined by the observer for this segment, contained within a counted set.
100	HOOK_SPACING_IN_CM	NUMBER	Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip
100	VESSEL	VARCHAR2	Vessel code from the ATL_LOV vessel table.

Name

Type

Description

100

T_TABLE

VARCHAR2

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 for a haul record

100

HAUL_JOIN

NUMBER

This is a uniquie identifier of a haul record composed by concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

100

HAUL_NUMBER

NUMBER

Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer.

100

COLLECTION_NUMBER

NUMBER

User Defined Hook Count Set number unique for a cruise permit.

100

SEGMENT_NUMBER

NUMBER

This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.

100

NUMBER_OF_HOOKS

NUMBER

Number of hooks as determined by the observer for this segment, contained within a counted set.

100

HOOK_SPACING_IN_CM

NUMBER

Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip

100

VESSEL

VARCHAR2

Vessel code from the ATL_LOV vessel table.

Attribute Details

T_TABLE

CC ID: 42684

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

CRUISE

CC ID: 42685

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

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	Yes
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: 42687

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

HAUL_JOIN

CC ID: 42688

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	This is a uniquie identifier of a haul record composed by 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

HAUL_NUMBER

CC ID: 42689

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Unique haul for an observer vessel cruise, defaulted to an incremented sequence by the GUI. May be entered and defined by the observer.
General Data Type:	NUMBER

COLLECTION_NUMBER

CC ID: 42690

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	User Defined Hook Count Set number unique for a cruise permit.
General Data Type:	NUMBER

SEGMENT_NUMBER

CC ID: 42691

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	This attribute represents a user defined integer identifying a unit of line for counting and spacing hooks. It must be unique within a hook_count_set.
General Data Type:	NUMBER

NUMBER_OF_HOOKS

CC ID: 42692

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Number of hooks as determined by the observer for this segment, contained within a counted set.
General Data Type:	NUMBER

HOOK_SPACING_IN_CM

CC ID: 42693

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Spacing between hooks on a segment. This value is optional for any specific segment except the first set of spacing-count on a trip
General Data Type:	NUMBER

VESSEL

CC ID: 42694

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel code from the ATL_LOV vessel table.
General Data Type:	VARCHAR2

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

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

HAUL_NUMBER

COLLECTION_NUMBER

SEGMENT_NUMBER

NUMBER_OF_HOOKS

HOOK_SPACING_IN_CM

VESSEL

Catalog Details