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 > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_LOV_SPECIES_CODE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:19026  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
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 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
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: 112095
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: 112094
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:

NPRB_1017.ATL_LOV_PROHIB_SPECI

EGGS_REQUIRED_FLAG

CC ID: 112096
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: 112097
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: 112098
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: 112099
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: 112100
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: 112101
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: 112102
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
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: 19026
GUID: gov.noaa.nmfs.inport:19026
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+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