Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/North Pacific Groundfish and Halibut O... >

Table: ATL_LOV_SPECIES_CODE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:9719  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This entity maps to the Norpac domestic_species table

Description

This entity maps to the Norpac domestic_species table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_CODE
NUMBER 		Unique identifier for a species imported from Norpac
PROHIB_SPECIES_GROUP_CODE
VARCHAR2 		Alpha code identifying the group that a species may belong to.
EGGS_REQUIRED_FLAG
VARCHAR2 		For prohibited crab species where sex = F. The flag identifies whether the observer must record the presence or absence of eggs.
SPECIES_COMP_SEX_REQUIRED_FLAG
VARCHAR2 		For species with this flag set to yes, the user interface will require that the sex of the species composition record be recorded.
WEIGHT_AND_NUMBER_REQD
VARCHAR2 		Indicates whether the weight and number of animals are required for a subsequent species composition record.
COMMON_NAME
VARCHAR2 		Common or Management name for a species.
SCIENTIFIC_NAME
VARCHAR2 		Scientific Name (genus-species)
LENGTH_ACCEPTED_FLAG
VARCHAR2 		Length data is not collected for all species. This flag identifies those for whom legth and specimen data may be collected.
AVIAN_SPECIES_CODE
VARCHAR2 		Bird identification - species code from fish and wildlife Used to limit species presented in the bird interaction table.

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

This entity maps to the Norpac domestic_species table
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None AFSC
None ATL
None ATLAS
None BYCATCH
None FMA
None GROUNDFISH
None NORPAC
None OBSERVER

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None AI
None ALEUTIAN ISLANDS
None BERING SEA
None BS
None BSAI
None GOA
None GULF OF ALASKA

Entity Information

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

This entity maps to the Norpac domestic_species table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SPECIES_CODE NUMBER Unique identifier for a species imported from Norpac
100
 PROHIB_SPECIES_GROUP_CODE VARCHAR2 Alpha code identifying the group that a species may belong to.
100
 EGGS_REQUIRED_FLAG VARCHAR2 For prohibited crab species where sex = F. The flag identifies whether the observer must record the presence or absence of eggs.
100
 SPECIES_COMP_SEX_REQUIRED_FLAG VARCHAR2 For species with this flag set to yes, the user interface will require that the sex of the species composition record be recorded.
100
 WEIGHT_AND_NUMBER_REQD VARCHAR2 Indicates whether the weight and number of animals are required for a subsequent species composition record.
100
 COMMON_NAME VARCHAR2 Common or Management name for a species.
100
 SCIENTIFIC_NAME VARCHAR2 Scientific Name (genus-species)
100
 LENGTH_ACCEPTED_FLAG VARCHAR2 Length data is not collected for all species. This flag identifies those for whom legth and specimen data may be collected.
100
 AVIAN_SPECIES_CODE VARCHAR2 Bird identification - species code from fish and wildlife Used to limit species presented in the bird interaction table.

Attribute Details

SPECIES_CODE

CC ID: 38617
Seq. Order: 1
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

PROHIB_SPECIES_GROUP_CODE

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

Alpha code identifying the group that a species may belong to.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.ATL_LOV_PROHIB_SPECIES_

EGGS_REQUIRED_FLAG

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

For prohibited crab species where sex = F. The flag identifies whether the observer must record the presence or absence of eggs.
General Data Type: VARCHAR2

SPECIES_COMP_SEX_REQUIRED_FLAG

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

For species with this flag set to yes, the user interface will require that the sex of the species composition record be recorded.
General Data Type: VARCHAR2

WEIGHT_AND_NUMBER_REQD

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

Indicates whether the weight and number of animals are required for a subsequent species composition record.
General Data Type: VARCHAR2

COMMON_NAME

CC ID: 38612
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

Common or Management name for a species.
General Data Type: VARCHAR2

SCIENTIFIC_NAME

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

Scientific Name (genus-species)
General Data Type: VARCHAR2

LENGTH_ACCEPTED_FLAG

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

Length data is not collected for all species. This flag identifies those for whom legth and specimen data may be collected.
General Data Type: VARCHAR2

AVIAN_SPECIES_CODE

CC ID: 38611
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

Bird identification - species code from fish and wildlife Used to limit species presented in the bird interaction table.
General Data Type: VARCHAR2

Catalog Details

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