25694
Tissue Tracking System
TTS
Data Set
Published / External
22942
Tissue Tracking
Project
Completed
NEFSC holds a sample inventory of marine mammal parts collected from stranded and bycaught animals as well as from our field research activities. The database holds the metadata for our sample holdings and records transactions of transfer of samples to other labs and researchers.
Tracking tables for managing the chain of custody and archive of marine mammal tissue samples held at NEFSC.
Theme
DNA
Theme
tissue samples
Northeast Fisheries Science Center
Woods Hole
MA
USA
Data Set
Oracle Database
As Needed
Table (digital)
na
na
na
35916
Table: NEFSCBIOPSY
NEFSCBIOPSY
Published / External
Completed
This table has the animal level details for samples from NEFSC directed mammal research.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
This table has the animal level details for samples from NEFSC directed mammal research.
1
TAGNUM
VARCHAR2
25
Yes
No
Active
animal identification number
VARCHAR2
2
DATELAND
DATE
7
No
No
Active
date of dart or capture
DATE
3
CRUISENUM
VARCHAR2
12
No
No
Active
tripid
VARCHAR2
4
SPCODE
VARCHAR2
4
Yes
No
Active
species
VARCHAR2
5
COLLECTLATDEC
NUMBER
22
No
No
6
4
Active
decimal lat of sample collection
NUMBER
6
COLLECTLONDEC
NUMBER
22
No
No
7
4
Active
decimal lon of sample collection
NUMBER
7
POSSOURCE
VARCHAR2
5
No
No
Active
position source - see lookup table positionsource
VARCHAR2
8
FIELDSIGHTNUM
VARCHAR2
60
No
No
Active
sighting number in survey records
VARCHAR2
9
COMMENTS
VARCHAR2
150
No
No
Active
descriptive notes
VARCHAR2
10
DARTEDBY
VARCHAR2
4
No
No
Active
person operating crossbow if dart sample
VARCHAR2
11
AGECLASS
VARCHAR2
20
No
No
Active
i.e. juvenile, pup, calf, adult
VARCHAR2
12
REACTION
VARCHAR2
20
No
No
Active
behavior change as a result of sampling
VARCHAR2
13
PERMIT
VARCHAR2
20
No
No
Active
MMPA or ESA permit number authorizing sampling
VARCHAR2
14
SEX
VARCHAR2
20
No
No
Active
M=male, F=female, U=unk.
VARCHAR2
35917
Table: POSITIONSOURCE
POSITIONSOURCE
Published / External
Completed
Lookup table for position source
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Lookup table for position source
1
POSSOURCE
VARCHAR2
5
Yes
Yes
Active
code for position soource
VARCHAR2
2
DESCRIPTION
VARCHAR2
60
Yes
No
Active
description of position source
VARCHAR2
35918
Table: SAMPLOC
SAMPLOC
Published / External
Completed
Lookup table for location codes.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Lookup table for location codes.
1
SAMPLOC
VARCHAR2
1
Yes
Yes
Active
location code
VARCHAR2
2
SAMPLOCDESC
VARCHAR2
150
No
No
Active
location description
VARCHAR2
3
UE
VARCHAR2
8
No
No
Active
user of entry
VARCHAR2
4
DE
DATE
7
No
No
Active
date of entry
DATE
5
UC
VARCHAR2
8
No
No
Active
user of change
VARCHAR2
6
DC
DATE
7
No
No
Active
date of change
DATE
35919
Table: SAMPTYPE
SAMPTYPE
Published / External
Completed
Type/organ of sample
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Type/organ of sample
1
SAMPTYPE
VARCHAR2
4
Yes
Yes
Active
abbreviation of sample type
VARCHAR2
2
SAMPTYPEDESC
VARCHAR2
150
No
No
Active
full description of sample type
VARCHAR2
35920
Table: SOURCE
SOURCE
Published / External
Completed
Origin of sample
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Origin of sample
1
SOURCECODE
VARCHAR2
1
Yes
Yes
Active
code for sample source
VARCHAR2
2
SOURCEDESC
VARCHAR2
150
No
No
Active
description of sample source
VARCHAR2
35921
Table: STRANDINGSAMPLEMETADATA
STRANDINGSAMPLEMETADATA
Published / External
Completed
Animal level information on stranded animals.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Animal level information on stranded animals.
1
TAGNUM
VARCHAR2
20
No
No
Active
unique identifier of animal, link to samples
VARCHAR2
2
DATESTRAND
DATE
7
No
No
Active
date of stranding
DATE
3
SPECIES
VARCHAR2
20
No
No
Active
4 letter code for species
VARCHAR2
4
LAT
NUMBER
22
No
No
38
Active
decimal latitude of stranding location
NUMBER
5
LON
NUMBER
22
No
No
38
Active
decimal longitude of stranding location
NUMBER
6
STRANDINGSTATE
VARCHAR2
20
No
No
Active
geographical state of stranding
VARCHAR2
7
NATLDATABASENUM
VARCHAR2
20
No
No
Active
national database id number
VARCHAR2
8
COMMENTS
VARCHAR2
150
No
No
Active
notes
VARCHAR2
35922
Table: TTSAMPLES
TTSAMPLES
Published / External
Completed
Sample holdings in the tissue tracking database
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Sample holdings in the tissue tracking database
1
TAGNUM
VARCHAR2
25
Yes
No
Active
animal identifier
VARCHAR2
2
SAMPTYPE
VARCHAR2
4
Yes
No
Active
type/organ of sample; see lookup table samptype
VARCHAR2
3
SEQNUM
NUMBER
22
Yes
No
3
0
Active
I think unnecessary
NUMBER
4
SAMPCOMMENTS
VARCHAR2
150
No
No
Active
Comments and notes
VARCHAR2
5
UE
VARCHAR2
8
No
No
Active
User entry
VARCHAR2
6
DE
DATE
7
No
No
Active
Date entry
DATE
7
UC
VARCHAR2
8
No
No
Active
User last change
VARCHAR2
8
DC
DATE
7
No
No
Active
Date last change
DATE
9
RECEIVER
VARCHAR2
8
No
No
Active
person/entity receiving sample; see TTCONTACT
VARCHAR2
10
HANDLINGDATE
DATE
7
No
No
Active
date of sample transfer
DATE
11
PRESERVATION
VARCHAR2
12
No
No
Active
e.g. frozen, DMSO, etc.
VARCHAR2
12
SAMPNUM
NUMBER
22
No
No
9
0
Active
unique sample number
NUMBER
13
SOURCE
VARCHAR2
1
No
No
Active
see lookup table SOURCE
VARCHAR2
14
SAMPLOC
VARCHAR2
10
No
No
Active
physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)
VARCHAR2
15
ANIMALID
VARCHAR2
20
No
No
Active
animal identifier
VARCHAR2
16
EVENTNUM
NUMBER
22
No
No
38
Active
In case of recapture/resample at different time/location. Default=1
NUMBER
17
SENDER
VARCHAR2
20
No
No
Active
person/entity sending sample; see TTCONTACT
VARCHAR2
18
RECEIVERPERMIT
VARCHAR2
20
No
No
Active
Not used, moved to table TTSHIPMENT
VARCHAR2
19
SENDERPERMIT
VARCHAR2
20
No
No
Active
Not used, moved to table TTSHIPMENT
VARCHAR2
20
TRANSFERTYPE
VARCHAR2
1
No
No
Active
P for permanent, T for temporary, N for no transfer
VARCHAR2
21
ORIGSAMPNUM
NUMBER
22
No
No
38
Active
if split from another sample
NUMBER
35923
Table: TTSCONTACT
TTSCONTACT
Published / External
Completed
People and institutions involved with sample handling.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
People and institutions involved with sample handling.
1
CONTACTID
VARCHAR2
8
Yes
No
Active
unique id of contact
VARCHAR2
2
CONTACTFNAME
VARCHAR2
15
No
No
Active
first name (redacted)
VARCHAR2
3
CONTACTLNAME
VARCHAR2
20
No
No
Active
last name (redacted)
VARCHAR2
4
CONTACTAGENCY
VARCHAR2
150
No
No
Active
agency name
VARCHAR2
5
CONTACTAGENCYADD1
VARCHAR2
150
No
No
Active
agency address 1
VARCHAR2
6
CONTACTAGENCYADD2
VARCHAR2
150
No
No
Active
agency address 2
VARCHAR2
7
CONTACTPHONE
VARCHAR2
12
No
No
Active
phone number (redacted)
VARCHAR2
8
PERMITNUM
VARCHAR2
15
No
No
Active
permit number (redacted)
VARCHAR2
9
PERMITEXP
DATE
7
No
No
Active
permit expiration date (redacted)
DATE
10
PERMITTYPE
VARCHAR2
10
No
No
Active
permit type (redacted)
VARCHAR2
11
EMAIL
VARCHAR2
40
No
No
Active
contact email (redacted)
VARCHAR2
35924
Table: TTSENT
TTSENT
Published / External
Completed
Link between sample and shipment.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Link between sample and shipment.
1
SAMPNUM
NUMBER
22
No
No
9
0
Active
sample number
NUMBER
2
SHIPMENTNUM
NUMBER
22
No
No
38
Active
shipment number
NUMBER
35925
Table: TTSHIPMENT
TTSHIPMENT
Published / External
Completed
Shipment level information for sample transfer.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Shipment level information for sample transfer.
1
SHIPMENTNUM
NUMBER
22
Yes
Yes
5
0
Active
unique identification for shipment
NUMBER
2
SENDER
VARCHAR2
8
Yes
No
Active
person initiating the tranbsfer. See contact.
VARCHAR2
3
SENTTO
VARCHAR2
8
No
No
Active
person receiving sample. see contacts.
VARCHAR2
4
SENTDATE
DATE
7
No
No
Active
date sent
DATE
5
SHIPMETHOD
VARCHAR2
8
No
No
Active
method of shipping
VARCHAR2
6
TRACKNUM
VARCHAR2
20
No
No
Active
tracking number
VARCHAR2
7
RECEIPTCONFIRMED
DATE
7
No
No
Active
confirmation of receipt, date or conf. number or y/n
DATE
8
SENDERPERMIT
VARCHAR2
20
No
No
Active
permit number for sender
VARCHAR2
9
RECEIVERPERMIT
VARCHAR2
20
No
No
Active
permit number for receiver
VARCHAR2
10
SHIPCOMMENTS
VARCHAR2
150
No
No
Active
notes
VARCHAR2
11
ANALYSIS
VARCHAR2
150
No
No
Active
what the sample will be used for, general description
VARCHAR2
12
TRANSFERTYPE
VARCHAR2
20
No
No
Active
P for permanent, T for temporary, N for no transfer
VARCHAR2
35926
Table: TTSNECROP
TTSNECROP
Published / External
Completed
Basic information about necropsy - was one done, link to it.
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
Basic information about necropsy - was one done, link to it.
1
ID
NUMBER
22
Yes
No
38
Active
unique id for this table
NUMBER
2
TAGNUM
VARCHAR2
25
Yes
No
Active
animal identifier
VARCHAR2
3
NECROPDATE
DATE
7
No
No
Active
date of necropsy
DATE
4
NECROPSEX
VARCHAR2
1
No
No
Active
sex as determined in necropsy
VARCHAR2
5
NECROPLENCM
NUMBER
22
No
No
6
1
Active
animal overall length in cm
NUMBER
6
NECROPWGTKG
NUMBER
22
No
No
7
1
Active
animal overall weight in kg
NUMBER
7
NECROPAVAILABLE
VARCHAR2
2
No
No
Active
is necropsy report online y/n
VARCHAR2
8
NECROPCOMMENT
VARCHAR2
20
No
No
Active
notes
VARCHAR2
35927
Table: TTSPEC
TTSPEC
Published / External
Completed
lookup table for species codes
Loaded by batch 9570, 12-12-2016 13:35
Data Table
Yes
TTS
lookup table for species codes
1
SPCODE
VARCHAR2
4
Yes
Yes
Active
4 letter species code
VARCHAR2
2
COMNM
VARCHAR2
30
No
No
Active
common name
VARCHAR2
3
SCIGENUS
VARCHAR2
25
No
No
Active
genus
VARCHAR2
4
SCISPECIES
VARCHAR2
25
No
No
Active
species
VARCHAR2
5
NESPP4
VARCHAR2
4
No
No
Active
numeric species code
VARCHAR2
Data Steward
2014
Person
Josephson, Elizabeth
elizabeth.josephson@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2362
elizabeth.josephson@noaa.gov
Distributor
2014
Person
Josephson, Elizabeth
elizabeth.josephson@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2362
Metadata Contact
2014
Person
Josephson, Elizabeth
elizabeth.josephson@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2362
Point of Contact
2014
Person
Josephson, Elizabeth
elizabeth.josephson@noaa.gov
166 Water Street
Woods Hole
MA
02543-1026
USA
508-495-2362
email
Ground Condition
-80
-60
45
35
Continuing
1989
Collection date of samples in archive date back to 1989.
Unclassified
Available to qualified researchers
Please contact data steward via email
Requester must have network access for direct query of the data.
User must read and fully comprehend the metadata prior to use. Applications or inferences derived from the data should be carefully considered for accuracy. Acknowledgement of NOAA/NMFS/NEFSC as the source from which these data were obtained in any publications and/or other representations of these data is suggested.
https://storage.googleapis.com/nmfs_odp_nefsc/PARR/READ/PSB/25694/25694_TissueTracking_Data.zip
25694_TissueTracking_Data.zip
Compressed Zipped Folder: 25694_TissueTracking_Data
(data is current as of 6/8/2017)
Data entry is visually inspected for errors.
Yes
Unknown
Yes
No
none
No Archiving Intended
none
Data entered into Oracle database on network servers, backed up regularly.
When marine mammal samples and tissues are received, the metadata for samples are entered into the database. When a sample is shipped out the tracking information is recorded.
35916
Entity
Table: NEFSCBIOPSY
35917
Entity
Table: POSITIONSOURCE
35918
Entity
Table: SAMPLOC
35919
Entity
Table: SAMPTYPE
35920
Entity
Table: SOURCE
35921
Entity
Table: STRANDINGSAMPLEMETADATA
35922
Entity
Table: TTSAMPLES
35923
Entity
Table: TTSCONTACT
35924
Entity
Table: TTSENT
35925
Entity
Table: TTSHIPMENT
35926
Entity
Table: TTSNECROP
35927
Entity
Table: TTSPEC
gov.noaa.nmfs.inport:25694
Elizabeth Josephson
2015-06-29T15:57:45
Elizabeth Josephson
2023-06-01T20:19:30
2016-12-12
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
http://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2016-12-12
1 Year
2017-12-12