Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: ATL_OBSINT_FIXED_HAUL_V
Short Name: ATL_OBSINT_FIXED_HAUL_V
Status: Completed
Abstract:

This view was created by and is owned by AKRO. It is an object used in the computation of extrapolated weights and counts for fixed gear fishing. These values are recalled by the obsint (Observer Interface) schema.

Notes:

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

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
CRUISE NUMBER
67
PERMIT VARCHAR2
67
HAUL_SEQ NUMBER
67
HAUL_NUMBER NUMBER
67
TRIP_SEQ NUMBER
67
HAUL_DATE DATE
67
SAMPLED_BY NUMBER
67
NUMBER_OF_SKATES NUMBER
67
NUMBER_OF_HOOKS_PER_SKATE NUMBER
67
TOTAL_HOOKS_POTS NUMBER

Attribute Details

CRUISE

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

PERMIT

CC ID: 38811
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 6
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

HAUL_SEQ

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

HAUL_NUMBER

CC ID: 38807
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
General Data Type: NUMBER

TRIP_SEQ

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

HAUL_DATE

CC ID: 38806
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
General Data Type: DATE

SAMPLED_BY

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

NUMBER_OF_SKATES

CC ID: 38810
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
General Data Type: NUMBER

NUMBER_OF_HOOKS_PER_SKATE

CC ID: 38809
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
General Data Type: NUMBER

TOTAL_HOOKS_POTS

CC ID: 38813
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

Catalog Details

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