Slide Menu
Search Help Show/Hide Menu

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