Slide Menu
Search Help Show/Hide Menu

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