35922
Table: TTSAMPLES
TTSAMPLES
Entity
Published / External
25694
Tissue Tracking System
Data Set
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
gov.noaa.nmfs.inport:35922
Patricia Jones
2016-12-12T13:35:09
SysAdmin InPortAdmin
2022-08-09T17:11:16
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
2016-12-12
1 Year
2017-12-12