Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Specimen curation and analysis > Tissue Tracking > Tissue Tracking System >

Table: STRANDINGSAMPLEMETADATA

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35921  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Animal level information on stranded animals.

Description

Animal level information on stranded animals.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TAGNUM
VARCHAR2 		unique identifier of animal, link to samples
DATESTRAND
DATE 		date of stranding
SPECIES
VARCHAR2 		4 letter code for species
LAT
NUMBER 		decimal latitude of stranding location
LON
NUMBER 		decimal longitude of stranding location
STRANDINGSTATE
VARCHAR2 		geographical state of stranding
NATLDATABASENUM
VARCHAR2 		national database id number
COMMENTS
VARCHAR2 		notes

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: STRANDINGSAMPLEMETADATA
Short Name: STRANDINGSAMPLEMETADATA
Status: Completed
Abstract:

Animal level information on stranded animals.
Notes:

Loaded by batch 9570, 12-12-2016 13:35

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TTS
Description:

Animal level information on stranded animals.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TAGNUM VARCHAR2 unique identifier of animal, link to samples
100
 DATESTRAND DATE date of stranding
100
 SPECIES VARCHAR2 4 letter code for species
100
 LAT NUMBER decimal latitude of stranding location
100
 LON NUMBER decimal longitude of stranding location
100
 STRANDINGSTATE VARCHAR2 geographical state of stranding
100
 NATLDATABASENUM VARCHAR2 national database id number
100
 COMMENTS VARCHAR2 notes

Attribute Details

TAGNUM

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

unique identifier of animal, link to samples
General Data Type: VARCHAR2

DATESTRAND

CC ID: 362514
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

date of stranding
General Data Type: DATE

SPECIES

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

4 letter code for species
General Data Type: VARCHAR2

LAT

CC ID: 362516
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

decimal latitude of stranding location
General Data Type: NUMBER

LON

CC ID: 362517
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

decimal longitude of stranding location
General Data Type: NUMBER

STRANDINGSTATE

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

geographical state of stranding
General Data Type: VARCHAR2

NATLDATABASENUM

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

national database id number
General Data Type: VARCHAR2

COMMENTS

CC ID: 362520
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

notes
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 35921
GUID: gov.noaa.nmfs.inport:35921
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-12-12 13:35+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-12-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-12