Metadata Rubric

100%

6 / 6

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

It details about the tags that are attached to sturgeons.

Description

It details about the tags that are attached to sturgeons.

Entity Type
Data Table

Data Attribute / Type	Description
STURGEON_TAGS_ID NUMBER	Character sequence used to identify bio acoustic tags
TAG_TYPE VARCHAR2	Type of the tag
DATE_TAG_EXPIRED DATE	Tag expiration date
REASON_DATE_EXPIRED VARCHAR2	Reason for the tag expiration
TAG_LOCATION VARCHAR2	Location of the Tag
TAG_NUMBER VARCHAR2	Tag number
CREATED_BY VARCHAR2	Who created the record?
DATE_CREATED DATE	Creation date
MODIFIED_BY VARCHAR2	Who modified the record?
DATE_MODIFIED DATE	Modified date
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)
RECORD_IS_DELETED NUMBER	Data has been omitted
DATE_RECORD_DELETED DATE	Record deletion date
SOURCE VARCHAR2	Origination source
TABLE_SOURCE_ID NUMBER	The ID number of the origination source

Data Attribute / Type

Description

STURGEON_TAGS_ID
NUMBER

Character sequence used to identify bio acoustic tags

TAG_TYPE
VARCHAR2

Type of the tag

DATE_TAG_EXPIRED
DATE

Tag expiration date

REASON_DATE_EXPIRED
VARCHAR2

Reason for the tag expiration

TAG_LOCATION
VARCHAR2

Location of the Tag

TAG_NUMBER
VARCHAR2

Tag number

CREATED_BY
VARCHAR2

Who created the record?

DATE_CREATED
DATE

Creation date

MODIFIED_BY
VARCHAR2

Who modified the record?

DATE_MODIFIED
DATE

Modified date

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)

RECORD_IS_DELETED
NUMBER

Data has been omitted

DATE_RECORD_DELETED
DATE

Record deletion date

SOURCE
VARCHAR2

Origination source

TABLE_SOURCE_ID
NUMBER

The ID number of the origination source

No Child Items for this record.

No contact information is available for this record.

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

Title:	STURGEON_TAGS
Abstract:	It details about the tags that are attached to sturgeons.

Entity Type:	Data Table
Description:	It details about the tags that are attached to sturgeons.

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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

STURGEON_TAGS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

STURGEON_TAGS_ID

TAG_TYPE

DATE_TAG_EXPIRED

REASON_DATE_EXPIRED

TAG_LOCATION

TAG_NUMBER

CREATED_BY

DATE_CREATED

MODIFIED_BY

DATE_MODIFIED

ORIGINAL_STURGEON_TAGS_ID

RECORD_IS_DELETED

DATE_RECORD_DELETED

SOURCE

TABLE_SOURCE_ID

Catalog Details