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