Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Describes about sturgeon biological details

Description

Describes about sturgeon biological details

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
STURGEON_SCUTES_ID
NUMBER
The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
STURGEON_ID
VARCHAR2
The ID name for sturgeon issued by the researcher.
SPECIES
15
The individual sturgeon (i.e., shortnose sturgeon or Atlantic sturgeon)
SEX
VARCHAR2
sex
CREATED_BY
VARCHAR2
created by whom?
DATE_CREATED
DATE
created date
MODIFIED_BY
VARCHAR2
modified by whom?
DATE_MODIFIED
DATE
modified date
ORIGINAL_STURGEON_SCUTES_ID
NUMBER
The ID name for sturgeon that have been tagged with a SCUTES-issued tag that were initially placed in or on a sturgeon.
DATE_RECORD_DELETED
DATE
The date the data has been omitted
SOURCE
VARCHAR2
Originating source.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (GARFO) for inquiries on this record.

Item Identification

Title: STURGEON_SCUTES
Abstract:

Describes about sturgeon biological details

Entity Information

Entity Type: Data Table
Description:

Describes about sturgeon biological details

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
100
STURGEON_ID VARCHAR2 The ID name for sturgeon issued by the researcher.
100
SPECIES 15 The individual sturgeon (i.e., shortnose sturgeon or Atlantic sturgeon)
100
SEX VARCHAR2 sex
100
CREATED_BY VARCHAR2 created by whom?
100
DATE_CREATED DATE created date
100
MODIFIED_BY VARCHAR2 modified by whom?
100
DATE_MODIFIED DATE modified date
100
ORIGINAL_STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag that were initially placed in or on a sturgeon.
100
DATE_RECORD_DELETED DATE The date the data has been omitted
100
SOURCE VARCHAR2 Originating source.

Attribute Details

STURGEON_SCUTES_ID

CC ID: 574131
Seq. Order: 1
Data Storage Type: NUMBER
Required: Yes
Primary Key: Yes
Status: Active
Description:

The ID name for sturgeon that have been tagged with a SCUTES-issued tag.

STURGEON_ID

CC ID: 574130
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

The ID name for sturgeon issued by the researcher.

SPECIES

CC ID: 574129
Seq. Order: 3
Data Storage Type: 15
Required: No
Primary Key: No
Status: Active
Description:

The individual sturgeon (i.e., shortnose sturgeon or Atlantic sturgeon)

SEX

CC ID: 574127
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

sex

CREATED_BY

CC ID: 574121
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

created by whom?

DATE_CREATED

CC ID: 574122
Seq. Order: 6
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

created date

MODIFIED_BY

CC ID: 574125
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

modified by whom?

DATE_MODIFIED

CC ID: 574123
Seq. Order: 8
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

modified date

ORIGINAL_STURGEON_SCUTES_ID

CC ID: 574126
Seq. Order: 9
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The ID name for sturgeon that have been tagged with a SCUTES-issued tag that were initially placed in or on a sturgeon.

DATE_RECORD_DELETED

CC ID: 574124
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

The date the data has been omitted

SOURCE

CC ID: 574128
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Originating source.

Catalog Details

Catalog Item ID: 46628
GUID: gov.noaa.nmfs.inport:46628
Metadata Record Created By: Sandeep Thumma
Metadata Record Created: 2017-07-26 10:49+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-09-26
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-09-26