Table: SPECIES_LIST
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28555 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
A unique list of Species.
DescriptionA unique list of Species.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SPECIES_CD
VARCHAR2 |
Primary key for this table. |
SPECIES_FAMILY_CD
VARCHAR2 |
FK to SPECIES_FAMILY_LIST. Identify the Species Family for the Species. Multiple Species can be associated to a Species Family, such as Coney and Graysby are both Groupes. |
ERDMANS_CD
VARCHAR2 |
The 3 digit Erdmans code for the species. |
SPECIES_NM
VARCHAR2 |
Unique Name for a Species. |
SPECIES_DESC
VARCHAR2 |
Description of a Species. |
LU_DT
DATE |
Last update date. |
LU_USER_ID
NUMBER |
Last update user. |
IS_ENABLED
NUMBER |
Is the value enabled for use. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Table: SPECIES_LIST |
---|---|
Short Name: | SPECIES_LIST |
Status: | Completed |
Abstract: |
A unique list of Species. |
Notes: |
Loaded by batch 7533, 11-05-2015 16:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CCL |
Description: |
A unique list of Species. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
SPECIES_CD | VARCHAR2 | Primary key for this table. | |
100
|
SPECIES_FAMILY_CD | VARCHAR2 | FK to SPECIES_FAMILY_LIST. Identify the Species Family for the Species. Multiple Species can be associated to a Species Family, such as Coney and Graysby are both Groupes. | |
100
|
ERDMANS_CD | VARCHAR2 | The 3 digit Erdmans code for the species. | |
100
|
SPECIES_NM | VARCHAR2 | Unique Name for a Species. | |
100
|
SPECIES_DESC | VARCHAR2 | Description of a Species. | |
100
|
LU_DT | DATE | Last update date. | |
100
|
LU_USER_ID | NUMBER | Last update user. | |
100
|
IS_ENABLED | NUMBER | Is the value enabled for use. |
Attribute Details
SPECIES_CD
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Primary key for this table. |
General Data Type: | VARCHAR2 |
SPECIES_FAMILY_CD
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
FK to SPECIES_FAMILY_LIST. Identify the Species Family for the Species. Multiple Species can be associated to a Species Family, such as Coney and Graysby are both Groupes. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
CCL.SPECIES_FAMILY_LIST |
ERDMANS_CD
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 3 digit Erdmans code for the species. |
General Data Type: | VARCHAR2 |
SPECIES_NM
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 60 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Name for a Species. |
General Data Type: | VARCHAR2 |
SPECIES_DESC
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of a Species. |
General Data Type: | VARCHAR2 |
LU_DT
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last update date. |
General Data Type: | DATE |
LU_USER_ID
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last update user. |
General Data Type: | NUMBER |
IS_ENABLED
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Is the value enabled for use. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 28555 |
---|---|
GUID: | gov.noaa.nmfs.inport:28555 |
Metadata Record Created By: | Joshua Bennett |
Metadata Record Created: | 2015-11-05 16:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |