Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Bycatch characterization in the Pacific halibut... > AFSC/FMA/NPRB Halibut Bycatch Video Field Test >

Table: SPECIES_COMPOSITION

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:7482  |  Updated: August 9, 2022  |  Published / External 

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