Table: NIMM_SPECIES_GROUPS
Entity (ENT) | NMFS Office Of Protected Resources (OPR)GUID: gov.noaa.nmfs.inport:27006 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
identifies the various broad categories in which species are grouped
Descriptionidentifies the various broad categories in which species are grouped
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SPECIES_GROUP_ID
NUMBER |
the unique identifier of this species group |
SPG_GROUP_NAME
VARCHAR2 |
the name of the group |
DELETED_FLAG
VARCHAR2 |
indicates whether or not this record has been logically deleted |
DATE_CREATED
DATE |
the date this record was inserted |
CREATED_BY
VARCHAR2 |
the user who inserted this record |
DATE_MODIFIED
DATE |
the date of the most recent modification to this record |
MODIFIED_BY
VARCHAR2 |
the last user who modified this record |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (OPR) for inquiries on this record.
Item Identification
Title: | Table: NIMM_SPECIES_GROUPS |
---|---|
Short Name: | NIMM_SPECIES_GROUPS |
Status: | Completed |
Abstract: |
identifies the various broad categories in which species are grouped |
Notes: |
Loaded by batch 7077, 09-17-2015 08:15 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NIMM_APPS |
Description: |
identifies the various broad categories in which species are grouped |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
SPECIES_GROUP_ID | NUMBER | the unique identifier of this species group | |
100
|
SPG_GROUP_NAME | VARCHAR2 | the name of the group | |
100
|
DELETED_FLAG | VARCHAR2 | indicates whether or not this record has been logically deleted | |
100
|
DATE_CREATED | DATE | the date this record was inserted | |
100
|
CREATED_BY | VARCHAR2 | the user who inserted this record | |
100
|
DATE_MODIFIED | DATE | the date of the most recent modification to this record | |
100
|
MODIFIED_BY | VARCHAR2 | the last user who modified this record |
Attribute Details
SPECIES_GROUP_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
the unique identifier of this species group |
General Data Type: | NUMBER |
SPG_GROUP_NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
the name of the group |
General Data Type: | VARCHAR2 |
DELETED_FLAG
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
indicates whether or not this record has been logically deleted |
General Data Type: | VARCHAR2 |
DATE_CREATED
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
the date this record was inserted |
General Data Type: | DATE |
CREATED_BY
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
the user who inserted this record |
General Data Type: | VARCHAR2 |
DATE_MODIFIED
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
the date of the most recent modification to this record |
General Data Type: | DATE |
MODIFIED_BY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
the last user who modified this record |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 27006 |
---|---|
GUID: | gov.noaa.nmfs.inport:27006 |
Metadata Record Created By: | Nathan Wilson |
Metadata Record Created: | 2015-09-17 08:15+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-05-16 |
Owner Org: | OPR |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-05-16 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-05-16 |