Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: SPECIES_COMPOSITION
Short Name: SPECIES_COMPOSITION
Status: Completed
Abstract:

This entity maps to the Norpac Species_Comp_Detail Table.

Notes:

Loaded by batch 2183, 03-27-2008 11:52

Entity Information

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

This entity maps to the Norpac Species_Comp_Detail Table.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_COMPOSITION_SEQ NUMBER Sequence Generated unique identifier of a species composition record
100
SAMPLE_SEQ NUMBER Sequence generated unique identifier of a sample
100
SPECIES_CODE NUMBER Unique identifier for a species imported from Norpac
100
SPECIES_WEIGHT NUMBER Weight of each species in the sample. Either the species number or the species weight may be null, but not both.
100
SPECIES_NUMBER NUMBER Number of individual animals in the sample. Either the species number or the species weight may be null, but not both.
100
HOOK_NUMBER NUMBER The sequential number of the sampled hook as assigned by the observer
100
HOOK_STATUS_CODE VARCHAR2 The disposition of the catch for the documented hook.
100
SEX_CODE VARCHAR2 Sex if so identified.

Attribute Details

SPECIES_COMPOSITION_SEQ

CC ID: 29503
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 of a species composition record

General Data Type: NUMBER

SAMPLE_SEQ

CC ID: 29500
Seq. Order: 2
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 sample

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.SAMPLE

SPECIES_CODE

CC ID: 29502
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
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

SPECIES_WEIGHT

CC ID: 29505
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 11
Scale: 2
Status: Active
Description:

Weight of each species in the sample. Either the species number or the species weight may be null, but not both.

General Data Type: NUMBER

SPECIES_NUMBER

CC ID: 29504
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Number of individual animals in the sample. Either the species number or the species weight may be null, but not both.

General Data Type: NUMBER

HOOK_NUMBER

CC ID: 29498
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

The sequential number of the sampled hook as assigned by the observer

General Data Type: NUMBER

HOOK_STATUS_CODE

CC ID: 29499
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The disposition of the catch for the documented hook.

General Data Type: VARCHAR2

SEX_CODE

CC ID: 29501
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sex if so identified.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7482
GUID: gov.noaa.nmfs.inport:7482
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-27 11:52+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