Table: SPECIES_FAMILY_LIST
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28554 | 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 Families, such as Groupers or Jacks.
DescriptionA unique list of Species Families, such as Groupers or Jacks.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SPECIES_FAMILY_CD
VARCHAR2 |
Primary key for this table. |
SPECIES_FAMILY_NM
VARCHAR2 |
Unique name for the Species Family, such as Grouper(s). |
SPECIES_FAMILY_DESC
VARCHAR2 |
Description of the Species Family. |
IS_ENABLED
NUMBER |
Is the value enabled for use. |
LU_DT
DATE |
Last update date. |
LU_USER_ID
NUMBER |
Last update user. |
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_FAMILY_LIST |
---|---|
Short Name: | SPECIES_FAMILY_LIST |
Status: | Completed |
Abstract: |
A unique list of Species Families, such as Groupers or Jacks. |
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 Families, such as Groupers or Jacks. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
SPECIES_FAMILY_CD | VARCHAR2 | Primary key for this table. |
100
|
SPECIES_FAMILY_NM | VARCHAR2 | Unique name for the Species Family, such as Grouper(s). | |
100
|
SPECIES_FAMILY_DESC | VARCHAR2 | Description of the Species Family. | |
100
|
IS_ENABLED | NUMBER | Is the value enabled for use. | |
100
|
LU_DT | DATE | Last update date. | |
100
|
LU_USER_ID | NUMBER | Last update user. |
Attribute Details
SPECIES_FAMILY_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_NM
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 60 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique name for the Species Family, such as Grouper(s). |
General Data Type: | VARCHAR2 |
SPECIES_FAMILY_DESC
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of the Species Family. |
General Data Type: | VARCHAR2 |
IS_ENABLED
Seq. Order: | 4 |
---|---|
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 |
LU_DT
Seq. Order: | 5 |
---|---|
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: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Last update user. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 28554 |
---|---|
GUID: | gov.noaa.nmfs.inport:28554 |
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 |