Table: LOV_SPECIES_CODE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:7532 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity maps to the Norpac domestic_species table
DescriptionThis 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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 |