Slide Menu
Search Help Show/Hide Menu

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