Table: TTSCONTACT
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35923 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
People and institutions involved with sample handling.
DescriptionPeople and institutions involved with sample handling.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
CONTACTID
VARCHAR2 |
unique id of contact |
CONTACTFNAME
VARCHAR2 |
first name (redacted) |
CONTACTLNAME
VARCHAR2 |
last name (redacted) |
CONTACTAGENCY
VARCHAR2 |
agency name |
CONTACTAGENCYADD1
VARCHAR2 |
agency address 1 |
CONTACTAGENCYADD2
VARCHAR2 |
agency address 2 |
CONTACTPHONE
VARCHAR2 |
phone number (redacted) |
PERMITNUM
VARCHAR2 |
permit number (redacted) |
PERMITEXP
DATE |
permit expiration date (redacted) |
PERMITTYPE
VARCHAR2 |
permit type (redacted) |
EMAIL
VARCHAR2 |
contact email (redacted) |
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: 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
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
|
VARCHAR2 | contact email (redacted) |
Attribute Details
CONTACTID
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
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
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
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
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
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
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
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
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
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 |
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 |