Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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... >

BRIDGE_STURGEON_TAGS

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:46627  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: BRIDGE_STURGEON_TAGS
Abstract:

describes about sturgeon tags and the events

Entity Information

Entity Type: Data Table
Description:

BRIDGE_STURGEON_TAGS table describes about sturgeon tags and the events

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key STURGEON_TAGS_ID NUMBER Character sequence used to identify bio acoustic tags
100
 Primary Key STURGEON_SCUTES_EVENTS_ID NUMBER Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag
100
 STURGEON_SCUTES_ID NUMBER The ID name for sturgeon that have been tagged with a SCUTES-issued tag.
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_TAGS_ID NUMBER Character sequence used to identify bioacoustic tags that were initially placed in or on a sturgeon (i.e., first tag number)
100
 ORIGINAL_STURGEON_EVENTS_ID NUMBER Character sequence used to identify researchers' first interaction with an individual sturgeon
100
 RECORD_IS_DELETED NUMBER Data has been omitted
100
 DATE_RECORD_DELETED DATE Date at which the data has been omitted
100
 SOURCE VARCHAR2 The original data source

Attribute Details

STURGEON_TAGS_ID

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

Character sequence used to identify bio acoustic tags

STURGEON_SCUTES_EVENTS_ID

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

Character sequence used to identify researchers' interaction with an individual sturgeon containing a SCUTES-issued tag

STURGEON_SCUTES_ID

CC ID: 574119
Seq. Order: 3
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.

CREATED_BY

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

created by whom?

DATE_CREATED

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

Created date

MODIFIED_BY

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

modified by whom?

DATE_MODIFIED

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

Modified Date

ORIGINAL_STURGEON_TAGS_ID

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

Character sequence used to identify bioacoustic tags that were initially placed in or on a sturgeon (i.e., first tag number)

ORIGINAL_STURGEON_EVENTS_ID

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

Character sequence used to identify researchers' first interaction with an individual sturgeon

RECORD_IS_DELETED

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

Data has been omitted

DATE_RECORD_DELETED

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

Date at which the data has been omitted

SOURCE

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

The original data source

Catalog Details

Catalog Item ID: 46627
GUID: gov.noaa.nmfs.inport:46627
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