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_AGENCIES

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

Summary

Abstract

Table Of Valid Agencies/Organizations

Description

Table Of Valid Agencies/Organizations

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AGENCY_ID
VARCHAR2 		The three character agency code.
NAME
VARCHAR2 		The agency name.
ADDRESS_1
VARCHAR2 		First Line Of Agency Address
ADDRESS_2
VARCHAR2 		Second line of agency address.
ADDRESS_3
VARCHAR2 		Third line of agency address.
ADDRESS_4
VARCHAR2 		Fourth line of agency address.
CONTACT_NAME
VARCHAR2 		The person who can answer questions about this agency's data.
CONTACT_PHONE
VARCHAR2 		The agency phone number.

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_AGENCIES
Short Name: CTS_AGENCIES
Status: Completed
Abstract:

Table Of Valid Agencies/Organizations
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None agency
None code table
None organization

Entity Information

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

Table Of Valid Agencies/Organizations

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key AGENCY_ID VARCHAR2 The three character agency code.
100
 NAME VARCHAR2 The agency name.
100
 ADDRESS_1 VARCHAR2 First Line Of Agency Address
100
 ADDRESS_2 VARCHAR2 Second line of agency address.
100
 ADDRESS_3 VARCHAR2 Third line of agency address.
100
 ADDRESS_4 VARCHAR2 Fourth line of agency address.
100
 CONTACT_NAME VARCHAR2 The person who can answer questions about this agency's data.
100
 CONTACT_PHONE VARCHAR2 The agency phone number.

Attribute Details

AGENCY_ID

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

The three character agency code.
General Data Type: VARCHAR2

NAME

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

The agency name.
General Data Type: VARCHAR2

ADDRESS_1

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

First Line Of Agency Address
General Data Type: VARCHAR2

ADDRESS_2

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

Second line of agency address.
General Data Type: VARCHAR2

ADDRESS_3

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

Third line of agency address.
General Data Type: VARCHAR2

ADDRESS_4

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

Fourth line of agency address.
General Data Type: VARCHAR2

CONTACT_NAME

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

The person who can answer questions about this agency's data.
General Data Type: VARCHAR2

CONTACT_PHONE

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

The agency phone number.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7026
GUID: gov.noaa.nmfs.inport:7026
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:10+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