Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_HAUL_HOOK_COUNT_H

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9678  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample.

Description

This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SEQ_NUMBER
NUMBER 		Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.
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
CHANGED_BY
VARCHAR2 		Oracle user who made a change to the transaction table record.
DATE_CHANGED
DATE 		Timestamp of change to transaction record.
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record
SET_SEQ
NUMBER 		Sequence generated unique identifier of a hook spacing set.
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 Sent number unique for a cruise permit.

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: ATL_HAUL_HOOK_COUNT_H
Short Name: ATL_HAUL_HOOK_COUNT_H
Status: Completed
Abstract:

This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample.
Purpose:

Histories of all changes to data are maintained by trigger code on the parent table; allowing change control by user and datetime for all updates and delete events.. These modules both on the Atlas Client and NORPAC go live Jan 2010.
Notes:

Loaded by batch 2390, 06-30-2009 16:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

This entity represents the observer matching of hauls by haul number to hook count sets by set number. That value is used to compute and populate the haul total hooks, and sample sample hooks-pots. Both total hooks and sample hooks may be overwritten by the observer, however as a general rule will be computed by the average hooks per segment computed for a hook count set * number of segments in the haul or number of segments sampled in the sample.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SEQ_NUMBER NUMBER Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.
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
 CHANGED_BY VARCHAR2 Oracle user who made a change to the transaction table record.
100
 DATE_CHANGED DATE Timestamp of change to transaction record.
100
 HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
 SET_SEQ NUMBER Sequence generated unique identifier of a hook spacing set.
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 Sent number unique for a cruise permit.

Attribute Details

SEQ_NUMBER

CC ID: 38463
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a history table. Every history table has a unique sequence assigned to it all start with 1, icrement by 1 and do not cycle.
General Data Type: NUMBER

CRUISE

CC ID: 38458
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: 38462
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

CHANGED_BY

CC ID: 38456
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle user who made a change to the transaction table record.
General Data Type: VARCHAR2

DATE_CHANGED

CC ID: 38459
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Timestamp of change to transaction record.
General Data Type: DATE

HAUL_SEQ

CC ID: 38461
Seq. Order: 6
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

SET_SEQ

CC ID: 38464
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a hook spacing set.
General Data Type: NUMBER

HAUL_NUMBER

CC ID: 38460
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
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: 38457
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

User Defined Hook Count Sent number unique for a cruise permit.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 9678
GUID: gov.noaa.nmfs.inport:9678
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-30 16:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26