Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Specimen curation and analysis > Tissue Tracking > Tissue Tracking System >

Table: TTSAMPLES

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35922 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Sample holdings in the tissue tracking database

Description

Sample holdings in the tissue tracking database

Entity Type
Data Table

Data Attribute / Type	Description
TAGNUM VARCHAR2	animal identifier
SAMPTYPE VARCHAR2	type/organ of sample; see lookup table samptype
SEQNUM NUMBER	I think unnecessary
SAMPCOMMENTS VARCHAR2	Comments and notes
UE VARCHAR2	User entry
DE DATE	Date entry
UC VARCHAR2	User last change
DC DATE	Date last change
RECEIVER VARCHAR2	person/entity receiving sample; see TTCONTACT
HANDLINGDATE DATE	date of sample transfer
PRESERVATION VARCHAR2	e.g. frozen, DMSO, etc.
SAMPNUM NUMBER	unique sample number
SOURCE VARCHAR2	see lookup table SOURCE
SAMPLOC VARCHAR2	physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)
ANIMALID VARCHAR2	animal identifier
EVENTNUM NUMBER	In case of recapture/resample at different time/location. Default=1
SENDER VARCHAR2	person/entity sending sample; see TTCONTACT
RECEIVERPERMIT VARCHAR2	Not used, moved to table TTSHIPMENT
SENDERPERMIT VARCHAR2	Not used, moved to table TTSHIPMENT
TRANSFERTYPE VARCHAR2	P for permanent, T for temporary, N for no transfer
ORIGSAMPNUM NUMBER	if split from another sample

Data Attribute / Type

Description

TAGNUM
VARCHAR2

animal identifier

SAMPTYPE
VARCHAR2

type/organ of sample; see lookup table samptype

SEQNUM
NUMBER

I think unnecessary

SAMPCOMMENTS
VARCHAR2

Comments and notes

UE
VARCHAR2

User entry

DE
DATE

Date entry

UC
VARCHAR2

User last change

DC
DATE

Date last change

RECEIVER
VARCHAR2

person/entity receiving sample; see TTCONTACT

HANDLINGDATE
DATE

date of sample transfer

PRESERVATION
VARCHAR2

e.g. frozen, DMSO, etc.

SAMPNUM
NUMBER

unique sample number

SOURCE
VARCHAR2

see lookup table SOURCE

SAMPLOC
VARCHAR2

physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)

ANIMALID
VARCHAR2

animal identifier

EVENTNUM
NUMBER

In case of recapture/resample at different time/location. Default=1

SENDER
VARCHAR2

person/entity sending sample; see TTCONTACT

RECEIVERPERMIT
VARCHAR2

Not used, moved to table TTSHIPMENT

SENDERPERMIT
VARCHAR2

Not used, moved to table TTSHIPMENT

TRANSFERTYPE
VARCHAR2

P for permanent, T for temporary, N for no transfer

ORIGSAMPNUM
NUMBER

if split from another sample

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: TTSAMPLES
Short Name:	TTSAMPLES
Status:	Completed
Abstract:	Sample holdings in the tissue tracking database
Notes:	Loaded by batch 9570, 12-12-2016 13:35

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	TTS
Description:	Sample holdings in the tissue tracking database

Attribute Summary

	Name	Type	Description
100	TAGNUM	VARCHAR2	animal identifier
100	SAMPTYPE	VARCHAR2	type/organ of sample; see lookup table samptype
100	SEQNUM	NUMBER	I think unnecessary
100	SAMPCOMMENTS	VARCHAR2	Comments and notes
100	UE	VARCHAR2	User entry
100	DE	DATE	Date entry
100	UC	VARCHAR2	User last change
100	DC	DATE	Date last change
100	RECEIVER	VARCHAR2	person/entity receiving sample; see TTCONTACT
100	HANDLINGDATE	DATE	date of sample transfer
100	PRESERVATION	VARCHAR2	e.g. frozen, DMSO, etc.
100	SAMPNUM	NUMBER	unique sample number
100	SOURCE	VARCHAR2	see lookup table SOURCE
100	SAMPLOC	VARCHAR2	physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)
100	ANIMALID	VARCHAR2	animal identifier
100	EVENTNUM	NUMBER	In case of recapture/resample at different time/location. Default=1
100	SENDER	VARCHAR2	person/entity sending sample; see TTCONTACT
100	RECEIVERPERMIT	VARCHAR2	Not used, moved to table TTSHIPMENT
100	SENDERPERMIT	VARCHAR2	Not used, moved to table TTSHIPMENT
100	TRANSFERTYPE	VARCHAR2	P for permanent, T for temporary, N for no transfer
100	ORIGSAMPNUM	NUMBER	if split from another sample

Name

Type

Description

100

TAGNUM

VARCHAR2

animal identifier

100

SAMPTYPE

VARCHAR2

type/organ of sample; see lookup table samptype

100

SEQNUM

NUMBER

I think unnecessary

100

SAMPCOMMENTS

VARCHAR2

Comments and notes

100

VARCHAR2

User entry

100

DATE

Date entry

100

VARCHAR2

User last change

100

DATE

Date last change

100

RECEIVER

VARCHAR2

person/entity receiving sample; see TTCONTACT

100

HANDLINGDATE

DATE

date of sample transfer

100

PRESERVATION

VARCHAR2

e.g. frozen, DMSO, etc.

100

SAMPNUM

NUMBER

unique sample number

100

SOURCE

VARCHAR2

see lookup table SOURCE

100

SAMPLOC

VARCHAR2

physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)

100

ANIMALID

VARCHAR2

animal identifier

100

EVENTNUM

NUMBER

In case of recapture/resample at different time/location. Default=1

100

SENDER

VARCHAR2

person/entity sending sample; see TTCONTACT

100

RECEIVERPERMIT

VARCHAR2

Not used, moved to table TTSHIPMENT

100

SENDERPERMIT

VARCHAR2

Not used, moved to table TTSHIPMENT

100

TRANSFERTYPE

VARCHAR2

P for permanent, T for temporary, N for no transfer

100

ORIGSAMPNUM

NUMBER

if split from another sample

Attribute Details

TAGNUM

CC ID: 362521

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	Yes
Primary Key:	No
Status:	Active
Description:	animal identifier
General Data Type:	VARCHAR2

SAMPTYPE

CC ID: 362532

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	type/organ of sample; see lookup table samptype
General Data Type:	VARCHAR2

SEQNUM

CC ID: 362535

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	I think unnecessary
General Data Type:	NUMBER

SAMPCOMMENTS

CC ID: 362536

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments and notes
General Data Type:	VARCHAR2

UE

CC ID: 362537

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	User entry
General Data Type:	VARCHAR2

DE

CC ID: 362538

Seq. Order:	6
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date entry
General Data Type:	DATE

UC

CC ID: 362539

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	User last change
General Data Type:	VARCHAR2

DC

CC ID: 362540

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date last change
General Data Type:	DATE

RECEIVER

CC ID: 362541

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	person/entity receiving sample; see TTCONTACT
General Data Type:	VARCHAR2

HANDLINGDATE

CC ID: 362522

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	date of sample transfer
General Data Type:	DATE

PRESERVATION

CC ID: 362523

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	e.g. frozen, DMSO, etc.
General Data Type:	VARCHAR2

SAMPNUM

CC ID: 362524

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	unique sample number
General Data Type:	NUMBER

SOURCE

CC ID: 362525

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	see lookup table SOURCE
General Data Type:	VARCHAR2

SAMPLOC

CC ID: 362526

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	physical location (see samploc table) or SENT_T (sent temporarty) or SENT_P (sent permanent)
General Data Type:	VARCHAR2

ANIMALID

CC ID: 362527

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	animal identifier
General Data Type:	VARCHAR2

EVENTNUM

CC ID: 362528

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	In case of recapture/resample at different time/location. Default=1
General Data Type:	NUMBER

SENDER

CC ID: 362529

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	person/entity sending sample; see TTCONTACT
General Data Type:	VARCHAR2

RECEIVERPERMIT

CC ID: 362530

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Not used, moved to table TTSHIPMENT
General Data Type:	VARCHAR2

SENDERPERMIT

CC ID: 362531

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Not used, moved to table TTSHIPMENT
General Data Type:	VARCHAR2

TRANSFERTYPE

CC ID: 362533

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	P for permanent, T for temporary, N for no transfer
General Data Type:	VARCHAR2

ORIGSAMPNUM

CC ID: 362534

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	if split from another sample
General Data Type:	NUMBER

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

Table: TTSAMPLES

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TAGNUM

SAMPTYPE

SEQNUM

SAMPCOMMENTS

UE

DE

UC

DC

RECEIVER

HANDLINGDATE

PRESERVATION

SAMPNUM

SOURCE

SAMPLOC

ANIMALID

EVENTNUM

SENDER

RECEIVERPERMIT

SENDERPERMIT

TRANSFERTYPE

ORIGSAMPNUM

Catalog Details