Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Specimen curation and analysis > Tissue Tracking > Tissue Tracking System >

Table: TTSHIPMENT

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35925  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Shipment level information for sample transfer.

Description

Shipment level information for sample transfer.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SHIPMENTNUM
NUMBER 		unique identification for shipment
SENDER
VARCHAR2 		person initiating the tranbsfer. See contact.
SENTTO
VARCHAR2 		person receiving sample. see contacts.
SENTDATE
DATE 		date sent
SHIPMETHOD
VARCHAR2 		method of shipping
TRACKNUM
VARCHAR2 		tracking number
RECEIPTCONFIRMED
DATE 		confirmation of receipt, date or conf. number or y/n
SENDERPERMIT
VARCHAR2 		permit number for sender
RECEIVERPERMIT
VARCHAR2 		permit number for receiver
SHIPCOMMENTS
VARCHAR2 		notes
ANALYSIS
VARCHAR2 		what the sample will be used for, general description
TRANSFERTYPE
VARCHAR2 		P for permanent, T for temporary, N for no transfer

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: TTSHIPMENT
Short Name: TTSHIPMENT
Status: Completed
Abstract:

Shipment level information for sample transfer.
Notes:

Loaded by batch 9570, 12-12-2016 13:35

Entity Information

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

Shipment level information for sample transfer.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SHIPMENTNUM NUMBER unique identification for shipment
100
 SENDER VARCHAR2 person initiating the tranbsfer. See contact.
100
 SENTTO VARCHAR2 person receiving sample. see contacts.
100
 SENTDATE DATE date sent
100
 SHIPMETHOD VARCHAR2 method of shipping
100
 TRACKNUM VARCHAR2 tracking number
100
 RECEIPTCONFIRMED DATE confirmation of receipt, date or conf. number or y/n
100
 SENDERPERMIT VARCHAR2 permit number for sender
100
 RECEIVERPERMIT VARCHAR2 permit number for receiver
100
 SHIPCOMMENTS VARCHAR2 notes
100
 ANALYSIS VARCHAR2 what the sample will be used for, general description
100
 TRANSFERTYPE VARCHAR2 P for permanent, T for temporary, N for no transfer

Attribute Details

SHIPMENTNUM

CC ID: 362555
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 5
Scale: 0
Status: Active
Description:

unique identification for shipment
General Data Type: NUMBER

SENDER

CC ID: 362559
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

person initiating the tranbsfer. See contact.
General Data Type: VARCHAR2

SENTTO

CC ID: 362560
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

person receiving sample. see contacts.
General Data Type: VARCHAR2

SENTDATE

CC ID: 362561
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

date sent
General Data Type: DATE

SHIPMETHOD

CC ID: 362562
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

method of shipping
General Data Type: VARCHAR2

TRACKNUM

CC ID: 362563
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

tracking number
General Data Type: VARCHAR2

RECEIPTCONFIRMED

CC ID: 362564
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

confirmation of receipt, date or conf. number or y/n
General Data Type: DATE

SENDERPERMIT

CC ID: 362565
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

permit number for sender
General Data Type: VARCHAR2

RECEIVERPERMIT

CC ID: 362566
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

permit number for receiver
General Data Type: VARCHAR2

SHIPCOMMENTS

CC ID: 362556
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

notes
General Data Type: VARCHAR2

ANALYSIS

CC ID: 362557
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

what the sample will be used for, general description
General Data Type: VARCHAR2

TRANSFERTYPE

CC ID: 362558
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

P for permanent, T for temporary, N for no transfer
General Data Type: VARCHAR2

Catalog Details

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