Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

Table: CTS_PAT_INVESTIGATORS

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

Summary

Abstract

Table Of Popup ARchival Tag Investigators

Description

Table Of Popup ARchival Tag Investigators

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AGENCY_ID
VARCHAR2 		Foreign Key To Agency Table
INVESTIGATOR_ID
NUMBER 		Primary Key
NAME
VARCHAR2 		Investigator Name
ADDRESS_1
VARCHAR2 		First Line Of Address For Investigator
ADDRESS_2
VARCHAR2 		Second Line Of Address For Investigator
CITY
VARCHAR2 		City of Mailing address For Investigator
STATE
VARCHAR2 		State of Mailing address For Investigator
ZIPCODE
VARCHAR2 		Zipcode of Mailing address For Investigator
COUNTRY
VARCHAR2 		Country of Mailing address For Investigator
PHONE
VARCHAR2 		Phone Number of Investigator
FAX
VARCHAR2 		Facsimilie Number For Investigator
EMAIL
VARCHAR2 		Electronic mail address For Investigator

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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

Table Of Popup ARchival Tag Investigators
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

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

Table Of Popup ARchival Tag Investigators

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AGENCY_ID VARCHAR2 Foreign Key To Agency Table
100
 Primary Key INVESTIGATOR_ID NUMBER Primary Key
100
 NAME VARCHAR2 Investigator Name
100
 ADDRESS_1 VARCHAR2 First Line Of Address For Investigator
100
 ADDRESS_2 VARCHAR2 Second Line Of Address For Investigator
100
 CITY VARCHAR2 City of Mailing address For Investigator
100
 STATE VARCHAR2 State of Mailing address For Investigator
100
 ZIPCODE VARCHAR2 Zipcode of Mailing address For Investigator
100
 COUNTRY VARCHAR2 Country of Mailing address For Investigator
100
 PHONE VARCHAR2 Phone Number of Investigator
100
 FAX VARCHAR2 Facsimilie Number For Investigator
100
 EMAIL VARCHAR2 Electronic mail address For Investigator

Attribute Details

AGENCY_ID

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

Foreign Key To Agency Table
General Data Type: VARCHAR2

INVESTIGATOR_ID

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

Primary Key
General Data Type: NUMBER

NAME

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

Investigator Name
General Data Type: VARCHAR2

ADDRESS_1

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

First Line Of Address For Investigator
General Data Type: VARCHAR2

ADDRESS_2

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

Second Line Of Address For Investigator
General Data Type: VARCHAR2

CITY

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

City of Mailing address For Investigator
General Data Type: VARCHAR2

STATE

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

State of Mailing address For Investigator
General Data Type: VARCHAR2

ZIPCODE

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

Zipcode of Mailing address For Investigator
General Data Type: VARCHAR2

COUNTRY

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

Country of Mailing address For Investigator
General Data Type: VARCHAR2

PHONE

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

Phone Number of Investigator
General Data Type: VARCHAR2

FAX

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

Facsimilie Number For Investigator
General Data Type: VARCHAR2

EMAIL

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

Electronic mail address For Investigator
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7057
GUID: gov.noaa.nmfs.inport:7057
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-05
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-05
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-05