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... >

STURGEON_TAGS

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

Item Identification

Title: STURGEON_TAGS
Abstract:

It details about the tags that are attached to sturgeons.

Entity Information

Entity Type: Data Table
Description:

It details about the tags that are attached to sturgeons.

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
 TAG_TYPE VARCHAR2 Type of the tag
100
 DATE_TAG_EXPIRED DATE Tag expiration date
100
 REASON_DATE_EXPIRED VARCHAR2 Reason for the tag expiration
100
 TAG_LOCATION VARCHAR2 Location of the Tag
100
 TAG_NUMBER VARCHAR2 Tag number
100
 CREATED_BY VARCHAR2 Who created the record?
100
 DATE_CREATED DATE Creation date
100
 MODIFIED_BY VARCHAR2 Who modified the record?
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
 RECORD_IS_DELETED NUMBER Data has been omitted
100
 DATE_RECORD_DELETED DATE Record deletion date
100
 SOURCE VARCHAR2 Origination source
100
 TABLE_SOURCE_ID NUMBER The ID number of the origination source

Attribute Details

STURGEON_TAGS_ID

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

Character sequence used to identify bio acoustic tags

TAG_TYPE

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

Type of the tag

DATE_TAG_EXPIRED

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

Tag expiration date

REASON_DATE_EXPIRED

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

Reason for the tag expiration

TAG_LOCATION

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

Location of the Tag

TAG_NUMBER

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

Tag number

CREATED_BY

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

Who created the record?

DATE_CREATED

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

Creation date

MODIFIED_BY

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

Who modified the record?

DATE_MODIFIED

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

Modified date

ORIGINAL_STURGEON_TAGS_ID

CC ID: 574179
Seq. Order: 11
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)

RECORD_IS_DELETED

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

Data has been omitted

DATE_RECORD_DELETED

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

Record deletion date

SOURCE

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

Origination source

TABLE_SOURCE_ID

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

The ID number of the origination source

Catalog Details

Catalog Item ID: 46630
GUID: gov.noaa.nmfs.inport:46630
Metadata Record Created By: Sandeep Thumma
Metadata Record Created: 2017-07-26 10:51+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