25694 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 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 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 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 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 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 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 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 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 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 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 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 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 35917 Entity 35918 Entity 35919 Entity 35920 Entity 35921 Entity 35922 Entity 35923 Entity 35924 Entity 35925 Entity 35926 Entity 35927 Entity 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 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No No 2016-12-12 1 Year 2017-12-12