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

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

Summary

Abstract

This table has the animal level details for samples from NEFSC directed mammal research.

Description

This table has the animal level details for samples from NEFSC directed mammal research.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TAGNUM
VARCHAR2 		animal identification number
DATELAND
DATE 		date of dart or capture
CRUISENUM
VARCHAR2 		tripid
SPCODE
VARCHAR2 		species
COLLECTLATDEC
NUMBER 		decimal lat of sample collection
COLLECTLONDEC
NUMBER 		decimal lon of sample collection
POSSOURCE
VARCHAR2 		position source - see lookup table positionsource
FIELDSIGHTNUM
VARCHAR2 		sighting number in survey records
COMMENTS
VARCHAR2 		descriptive notes
DARTEDBY
VARCHAR2 		person operating crossbow if dart sample
AGECLASS
VARCHAR2 		i.e. juvenile, pup, calf, adult
REACTION
VARCHAR2 		behavior change as a result of sampling
PERMIT
VARCHAR2 		MMPA or ESA permit number authorizing sampling
SEX
VARCHAR2 		M=male, F=female, U=unk.

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: NEFSCBIOPSY
Short Name: NEFSCBIOPSY
Status: Completed
Abstract:

This table has the animal level details for samples from NEFSC directed mammal research.
Notes:

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

Entity Information

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

This table has the animal level details for samples from NEFSC directed mammal research.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TAGNUM VARCHAR2 animal identification number
100
 DATELAND DATE date of dart or capture
100
 CRUISENUM VARCHAR2 tripid
100
 SPCODE VARCHAR2 species
100
 COLLECTLATDEC NUMBER decimal lat of sample collection
100
 COLLECTLONDEC NUMBER decimal lon of sample collection
100
 POSSOURCE VARCHAR2 position source - see lookup table positionsource
100
 FIELDSIGHTNUM VARCHAR2 sighting number in survey records
100
 COMMENTS VARCHAR2 descriptive notes
100
 DARTEDBY VARCHAR2 person operating crossbow if dart sample
100
 AGECLASS VARCHAR2 i.e. juvenile, pup, calf, adult
100
 REACTION VARCHAR2 behavior change as a result of sampling
100
 PERMIT VARCHAR2 MMPA or ESA permit number authorizing sampling
100
 SEX VARCHAR2 M=male, F=female, U=unk.

Attribute Details

TAGNUM

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

animal identification number
General Data Type: VARCHAR2

DATELAND

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

date of dart or capture
General Data Type: DATE

CRUISENUM

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

tripid
General Data Type: VARCHAR2

SPCODE

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

species
General Data Type: VARCHAR2

COLLECTLATDEC

CC ID: 362496
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 4
Status: Active
Description:

decimal lat of sample collection
General Data Type: NUMBER

COLLECTLONDEC

CC ID: 362497
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 4
Status: Active
Description:

decimal lon of sample collection
General Data Type: NUMBER

POSSOURCE

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

position source - see lookup table positionsource
General Data Type: VARCHAR2

FIELDSIGHTNUM

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

sighting number in survey records
General Data Type: VARCHAR2

COMMENTS

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

descriptive notes
General Data Type: VARCHAR2

DARTEDBY

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

person operating crossbow if dart sample
General Data Type: VARCHAR2

AGECLASS

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

i.e. juvenile, pup, calf, adult
General Data Type: VARCHAR2

REACTION

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

behavior change as a result of sampling
General Data Type: VARCHAR2

PERMIT

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

MMPA or ESA permit number authorizing sampling
General Data Type: VARCHAR2

SEX

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

M=male, F=female, U=unk.
General Data Type: VARCHAR2

Catalog Details

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