Table: CTS_AGENCIES
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7026 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table Of Valid Agencies/Organizations
DescriptionTable 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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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
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
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
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
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 |