Search Help Show/Hide Menu
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)

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

This entity maps to the Norpac domestic_species table

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 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)

Attribute Details

SPECIES_CODE

CC ID: 29697
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: 29695
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:

TURNBULLD.LOV_PROHIB_SPECIES_G

EGGS_REQUIRED_FLAG

CC ID: 29694
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: 29698
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: 29699
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: 29693
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: 29696
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

Catalog Details

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