Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Protected Resources Division (PRD) Metadata Po... > Students Collaborating to Undertake Tracking Ef... >

STURGEON_SCUTES

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:46628  |  Updated: August 9, 2022  |  Published / External 
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