Slide Menu
Jump to Section...
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: TTSCONTACT

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

Item Identification

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

People and institutions involved with sample handling.
Notes:

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

Entity Information

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

People and institutions involved with sample handling.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 CONTACTID VARCHAR2 unique id of contact
100
 CONTACTFNAME VARCHAR2 first name (redacted)
100
 CONTACTLNAME VARCHAR2 last name (redacted)
100
 CONTACTAGENCY VARCHAR2 agency name
100
 CONTACTAGENCYADD1 VARCHAR2 agency address 1
100
 CONTACTAGENCYADD2 VARCHAR2 agency address 2
100
 CONTACTPHONE VARCHAR2 phone number (redacted)
100
 PERMITNUM VARCHAR2 permit number (redacted)
100
 PERMITEXP DATE permit expiration date (redacted)
100
 PERMITTYPE VARCHAR2 permit type (redacted)
100
 EMAIL VARCHAR2 contact email (redacted)

Attribute Details

CONTACTID

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

unique id of contact
General Data Type: VARCHAR2

CONTACTFNAME

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

first name (redacted)
General Data Type: VARCHAR2

CONTACTLNAME

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

last name (redacted)
General Data Type: VARCHAR2

CONTACTAGENCY

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

agency name

General Data Type: VARCHAR2

CONTACTAGENCYADD1

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

agency address 1
General Data Type: VARCHAR2

CONTACTAGENCYADD2

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

agency address 2
General Data Type: VARCHAR2

CONTACTPHONE

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

phone number (redacted)
General Data Type: VARCHAR2

PERMITNUM

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

permit number (redacted)
General Data Type: VARCHAR2

PERMITEXP

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

permit expiration date (redacted)
General Data Type: DATE

PERMITTYPE

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

permit type (redacted)
General Data Type: VARCHAR2

EMAIL

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

contact email (redacted)
General Data Type: VARCHAR2

Catalog Details

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