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_ANGLERS

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

Summary

Abstract

CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.

Description

CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AGENCY_ID
VARCHAR2 		Code for the agency assigning angler codes.
ANGLER_ID
NUMBER 		Unique numeric code assigned to an individual angler. Must be greater than zero.
TITLE
VARCHAR2 		The title or salutation for greeting this angler when letters are sent.
FNAME
VARCHAR2 		The angler's first name.
M_INITIAL
VARCHAR2 		The angler's middle initial.
LNAME
VARCHAR2 		The angler's last name.
SUFFIX
VARCHAR2 		The suffix such as Jr. or Sr. for an angler.
ADDRESS_1
VARCHAR2 		The first line of the angler's address.
ADDRESS_2
VARCHAR2 		The second line of the angler's address.
CITY
VARCHAR2 		City where angler receives mail.
STATE_ID
VARCHAR2 		U.S. state where angler receives mail. Not allowed for a foreign address.
ZIPCODE
VARCHAR2 		The angler's zip code.
COUNTRY_ID
VARCHAR2 		Country where angler receives mail.
HOME_NUMBER
VARCHAR2 		The angler's home phone number.
WORK_NUMBER
VARCHAR2 		The angler's work phone number.
MOBILE_NUMBER
VARCHAR2 		The angler's mobilephone number.
FAX_NUMBER
VARCHAR2 		The angler's facsimile phone number.
EMAIL
VARCHAR2 		The angler's email address
NOTES
NUMBER 		The number for a note on the angler.
EDITCYC
NUMBER 		A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.

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_ANGLERS
Short Name: CTS_ANGLERS
Status: Completed
Abstract:

CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None angler lists

Entity Information

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

CTSPAT.CTS_ANGLERS tells who released or recaptured an animal.Each angler is identified by a unique 1 to 6 digit number assigned bytheir agency.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key AGENCY_ID VARCHAR2 Code for the agency assigning angler codes.
100
 Primary Key ANGLER_ID NUMBER Unique numeric code assigned to an individual angler. Must be greater than zero.
100
 TITLE VARCHAR2 The title or salutation for greeting this angler when letters are sent.
100
 FNAME VARCHAR2 The angler's first name.
100
 M_INITIAL VARCHAR2 The angler's middle initial.
100
 LNAME VARCHAR2 The angler's last name.
100
 SUFFIX VARCHAR2 The suffix such as Jr. or Sr. for an angler.
100
 ADDRESS_1 VARCHAR2 The first line of the angler's address.
100
 ADDRESS_2 VARCHAR2 The second line of the angler's address.
100
 CITY VARCHAR2 City where angler receives mail.
100
 STATE_ID VARCHAR2 U.S. state where angler receives mail. Not allowed for a foreign address.
100
 ZIPCODE VARCHAR2 The angler's zip code.
100
 COUNTRY_ID VARCHAR2 Country where angler receives mail.
100
 HOME_NUMBER VARCHAR2 The angler's home phone number.
100
 WORK_NUMBER VARCHAR2 The angler's work phone number.
100
 MOBILE_NUMBER VARCHAR2 The angler's mobilephone number.
100
 FAX_NUMBER VARCHAR2 The angler's facsimile phone number.
100
 EMAIL VARCHAR2 The angler's email address
100
 NOTES NUMBER The number for a note on the angler.
100
 EDITCYC NUMBER A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.

Attribute Details

AGENCY_ID

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

Code for the agency assigning angler codes.
General Data Type: VARCHAR2

ANGLER_ID

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

Unique numeric code assigned to an individual angler. Must be greater than zero.
General Data Type: NUMBER

TITLE

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

The title or salutation for greeting this angler when letters are sent.
General Data Type: VARCHAR2

FNAME

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

The angler's first name.
General Data Type: VARCHAR2

M_INITIAL

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

The angler's middle initial.
General Data Type: VARCHAR2

LNAME

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

The angler's last name.
General Data Type: VARCHAR2

SUFFIX

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

The suffix such as Jr. or Sr. for an angler.
General Data Type: VARCHAR2

ADDRESS_1

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

The first line of the angler's address.
General Data Type: VARCHAR2

ADDRESS_2

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

The second line of the angler's address.
General Data Type: VARCHAR2

CITY

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

City where angler receives mail.
General Data Type: VARCHAR2

STATE_ID

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

U.S. state where angler receives mail. Not allowed for a foreign address.
General Data Type: VARCHAR2

ZIPCODE

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

The angler's zip code.
General Data Type: VARCHAR2

COUNTRY_ID

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

Country where angler receives mail.
General Data Type: VARCHAR2

HOME_NUMBER

CC ID: 25598
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The angler's home phone number.
General Data Type: VARCHAR2

WORK_NUMBER

CC ID: 25599
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The angler's work phone number.
General Data Type: VARCHAR2

MOBILE_NUMBER

CC ID: 25600
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The angler's mobilephone number.
General Data Type: VARCHAR2

FAX_NUMBER

CC ID: 25601
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The angler's facsimile phone number.
General Data Type: VARCHAR2

EMAIL

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

The angler's email address
General Data Type: VARCHAR2

NOTES

CC ID: 25603
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

The number for a note on the angler.
General Data Type: NUMBER

EDITCYC

CC ID: 25604
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

A control field, (0) indicates an add, (1) indicates an update. Once updated, records are stored with a value of 0 in this field.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 7027
GUID: gov.noaa.nmfs.inport:7027
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