Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

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

Sample holdings in the tissue tracking database

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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

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 Details

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