Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity records the amount of each species retained, for that species in a haul.

Description

This entity records the amount of each species retained, for that species in a haul.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
HAUL_SEQ
NUMBER
Sequence generated unique identifier for a haul record
SPECIES_CODE
NUMBER
Unique identifier for a species imported from Norpac
TOTAL_PERCENT_RETAINED
NUMBER
Percent retained value for that species for this haul.

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

This entity records the amount of each species retained, for that species in a haul.

Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

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

This entity records the amount of each species retained, for that species in a haul.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record
100
Primary Key SPECIES_CODE NUMBER Unique identifier for a species imported from Norpac
100
TOTAL_PERCENT_RETAINED NUMBER Percent retained value for that species for this haul.

Attribute Details

HAUL_SEQ

CC ID: 29789
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 haul record

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.HAUL

SPECIES_CODE

CC ID: 29790
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 4
Scale: 0
Status: Active
Description:

Unique identifier for a species imported from Norpac

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.LOV_SPECIES_CODE

TOTAL_PERCENT_RETAINED

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

Percent retained value for that species for this haul.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7545
GUID: gov.noaa.nmfs.inport:7545
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:10+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