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_INTERACTIONS

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

Summary

Abstract

Table Of All Tagging Interactions

Description

Table Of All Tagging Interactions

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANIMAL_ID
NUMBER 		Foreign Key to Animals Table
AGENCY_ID
VARCHAR2 		Identifies Agency/Organization That Issued The Tag
TAG_ID
VARCHAR2 		Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
EVENT_ID
NUMBER 		A code indicating (1) release or (2) recapture.
TAG_DATE
DATE 		Date animal was released or recaptured.
NEXT_TAG_AGENCY_ID
VARCHAR2 		Indetifies Agency That Supplied The Next_tag_id for the animal
NEXT_TAG_ID
VARCHAR2 		Additional tag applied to another animal. Used if two or more tags are applied at the same time.
INTERACTION_ORDER
NUMBER 		Number denoting which tag on a multi-tagged animal.
LENGTH
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
LENGTHUNIT
VARCHAR2 		Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
LENGTHTYPE
VARCHAR2 		Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
LENGTHDET
VARCHAR2 		Method of determining length: (E)stimated, (M)easured, (U)nknown
WEIGHT
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
WEIGHTUNIT
VARCHAR2 		Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
WEIGHTTYPE
VARCHAR2 		Weight measurement type: (R)ound, (D)ressed, (U)nknown
WEIGHTDET
VARCHAR2 		Method of determining weight: (E)stimated, (M)easured, (U)nknown.
LATITUDE
NUMBER 		Latitufe of location where Tagging operation was done
LONGITUDE
NUMBER 		Longitude of location where Tagging operation was done
STAT_ZONE_ID
NUMBER 		Statistical Zone Code where the release occurred. Gulf of Mexico 1.0 - 40.9, Caribbean 41.0 -75.0, Atlantic 630.0 - 751.0
COUNTRY_ID
VARCHAR2 		FIPS territorial Country Code where release/recapture occurred.
STATE_ID
VARCHAR2 		U.S. state code if Country is US.
WATER_BODY_ID
NUMBER 		Statistical Zone Code for an in shore bay, river or water body.
PLACE_ID
VARCHAR2 		Code identifying an unusual place where TAG1 was found.
GEAR_ID
VARCHAR2 		Code for gear used to catch the animal.
BAIT_TYPE
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
METHOD_ID
NUMBER 		Code identifying a record in CTS_METHODS that contains the description of the methodology used in tagging this animal.
SAMPLE_ID
NUMBER 		Code identifying a record in CTS_SAMPLES describing this sample.
CAPTAIN_AGENCY
VARCHAR2 		Identifies Agency Associated With Captain_id
CAPTAIN_ID
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
TAGGER_INITIALS
VARCHAR2 		Initials of person attaching or removing a tag. 3 characters are required. Use X for any missing characters.
TAGGER_TYPE
VARCHAR2 		Classification of the person who releases or recaptures an animal. (C)ommercial fishermen, (N)mfs worker, (R)ecreational fisherman, (S)cientist, (U)nknown or missing.
TAGGER_AFFILIATION
VARCHAR2 		Code for the agency the tagging is affiliated with.
VESSEL_AGENCY
VARCHAR2 		Indentifies Agency That indicated vesseld code
VESSEL_ID
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal.
PHYSICAL_DATA_ID
NUMBER 		Code to identify a record in CTS_Environ describing the conditions at the release/recapture site.
NOTES
NUMBER 		Note code for the first message associated with this record.
FIGHTHRS
NUMBER 		The number of hours spent fighting the fish before it was tagged.
FIGHTMINS
NUMBER 		The minutes part of the time spent fighting the fish before it was tagged.
ANGLER_AGENCY_ID
VARCHAR2 		Identifies Agency Associated With Angler_id
ANGLER_ID
NUMBER 		Number Of Angler That Did The tagging
GEOM
SDO_GEOMETRY 		GIS component Of record
ID
NUMBER 		Sequential Key
DATE_ENTERED
DATE 		Date Record was entered into the system

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_INTERACTIONS
Short Name: CTS_INTERACTIONS
Status: Completed
Abstract:

Table Of All Tagging Interactions
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 All Tagging Interactions

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANIMAL_ID NUMBER Foreign Key to Animals Table
100
 AGENCY_ID VARCHAR2 Identifies Agency/Organization That Issued The Tag
100
 TAG_ID VARCHAR2 Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
100
 EVENT_ID NUMBER A code indicating (1) release or (2) recapture.
100
 TAG_DATE DATE Date animal was released or recaptured.
100
 NEXT_TAG_AGENCY_ID VARCHAR2 Indetifies Agency That Supplied The Next_tag_id for the animal
100
 NEXT_TAG_ID VARCHAR2 Additional tag applied to another animal. Used if two or more tags are applied at the same time.
100
 INTERACTION_ORDER NUMBER Number denoting which tag on a multi-tagged animal.
100
 LENGTH NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
100
 LENGTHUNIT VARCHAR2 Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
100
 LENGTHTYPE VARCHAR2 Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
100
 LENGTHDET VARCHAR2 Method of determining length: (E)stimated, (M)easured, (U)nknown
100
 WEIGHT NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
100
 WEIGHTUNIT VARCHAR2 Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
100
 WEIGHTTYPE VARCHAR2 Weight measurement type: (R)ound, (D)ressed, (U)nknown
100
 WEIGHTDET VARCHAR2 Method of determining weight: (E)stimated, (M)easured, (U)nknown.
100
 LATITUDE NUMBER Latitufe of location where Tagging operation was done
100
 LONGITUDE NUMBER Longitude of location where Tagging operation was done
100
 STAT_ZONE_ID NUMBER Statistical Zone Code where the release occurred. Gulf of Mexico 1.0 - 40.9, Caribbean 41.0 -75.0, Atlantic 630.0 - 751.0
100
 COUNTRY_ID VARCHAR2 FIPS territorial Country Code where release/recapture occurred.
100
 STATE_ID VARCHAR2 U.S. state code if Country is US.
100
 WATER_BODY_ID NUMBER Statistical Zone Code for an in shore bay, river or water body.
100
 PLACE_ID VARCHAR2 Code identifying an unusual place where TAG1 was found.
100
 GEAR_ID VARCHAR2 Code for gear used to catch the animal.
100
 BAIT_TYPE VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
100
 METHOD_ID NUMBER Code identifying a record in CTS_METHODS that contains the description of the methodology used in tagging this animal.
100
 SAMPLE_ID NUMBER Code identifying a record in CTS_SAMPLES describing this sample.
100
 CAPTAIN_AGENCY VARCHAR2 Identifies Agency Associated With Captain_id
100
 CAPTAIN_ID NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
100
 TAGGER_INITIALS VARCHAR2 Initials of person attaching or removing a tag. 3 characters are required. Use X for any missing characters.
100
 TAGGER_TYPE VARCHAR2 Classification of the person who releases or recaptures an animal. (C)ommercial fishermen, (N)mfs worker, (R)ecreational fisherman, (S)cientist, (U)nknown or missing.
100
 TAGGER_AFFILIATION VARCHAR2 Code for the agency the tagging is affiliated with.
100
 VESSEL_AGENCY VARCHAR2 Indentifies Agency That indicated vesseld code
100
 VESSEL_ID NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal.
100
 PHYSICAL_DATA_ID NUMBER Code to identify a record in CTS_Environ describing the conditions at the release/recapture site.
100
 NOTES NUMBER Note code for the first message associated with this record.
100
 FIGHTHRS NUMBER The number of hours spent fighting the fish before it was tagged.
100
 FIGHTMINS NUMBER The minutes part of the time spent fighting the fish before it was tagged.
100
 ANGLER_AGENCY_ID VARCHAR2 Identifies Agency Associated With Angler_id
100
 ANGLER_ID NUMBER Number Of Angler That Did The tagging
100
 GEOM SDO_GEOMETRY GIS component Of record
100
 Primary Key ID NUMBER Sequential Key
100
 DATE_ENTERED DATE Date Record was entered into the system

Attribute Details

ANIMAL_ID

CC ID: 25694
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Foreign Key to Animals Table
General Data Type: NUMBER

AGENCY_ID

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

Identifies Agency/Organization That Issued The Tag
General Data Type: VARCHAR2

TAG_ID

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

Initial tag number applied to an animal. It consists of a 2 or 3 letter prefix and a 5 or 6 digit number.
General Data Type: VARCHAR2

EVENT_ID

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

A code indicating (1) release or (2) recapture.
General Data Type: NUMBER

TAG_DATE

CC ID: 25698
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date animal was released or recaptured.
General Data Type: DATE

NEXT_TAG_AGENCY_ID

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

Indetifies Agency That Supplied The Next_tag_id for the animal
General Data Type: VARCHAR2

NEXT_TAG_ID

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

Additional tag applied to another animal. Used if two or more tags are applied at the same time.
General Data Type: VARCHAR2

INTERACTION_ORDER

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

Number denoting which tag on a multi-tagged animal.
General Data Type: NUMBER

LENGTH

CC ID: 25702
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
General Data Type: NUMBER

LENGTHUNIT

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

Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters
General Data Type: VARCHAR2

LENGTHTYPE

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

Type of length measurement:(E)ye fork, (F)ork length, (L)ower jaw fork length, (S)tandard length, (T)otal length, (U)nknown length
General Data Type: VARCHAR2

LENGTHDET

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

Method of determining length: (E)stimated, (M)easured, (U)nknown
General Data Type: VARCHAR2

WEIGHT

CC ID: 25706
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
General Data Type: NUMBER

WEIGHTUNIT

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

Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown
General Data Type: VARCHAR2

WEIGHTTYPE

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

Weight measurement type: (R)ound, (D)ressed, (U)nknown
General Data Type: VARCHAR2

WEIGHTDET

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

Method of determining weight: (E)stimated, (M)easured, (U)nknown.
General Data Type: VARCHAR2

LATITUDE

CC ID: 25710
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 30
Scale: 16
Status: Active
Description:

Latitufe of location where Tagging operation was done
General Data Type: NUMBER

LONGITUDE

CC ID: 25711
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 30
Scale: 16
Status: Active
Description:

Longitude of location where Tagging operation was done
General Data Type: NUMBER

STAT_ZONE_ID

CC ID: 25712
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Statistical Zone Code where the release occurred. Gulf of Mexico 1.0 - 40.9, Caribbean 41.0 -75.0, Atlantic 630.0 - 751.0
General Data Type: NUMBER

COUNTRY_ID

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

FIPS territorial Country Code where release/recapture occurred.
General Data Type: VARCHAR2

STATE_ID

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

U.S. state code if Country is US.
General Data Type: VARCHAR2

WATER_BODY_ID

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

Statistical Zone Code for an in shore bay, river or water body.
General Data Type: NUMBER

PLACE_ID

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

Code identifying an unusual place where TAG1 was found.
General Data Type: VARCHAR2

GEAR_ID

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

Code for gear used to catch the animal.
General Data Type: VARCHAR2

BAIT_TYPE

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

Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
General Data Type: VARCHAR2

METHOD_ID

CC ID: 25719
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code identifying a record in CTS_METHODS that contains the description of the methodology used in tagging this animal.
General Data Type: NUMBER

SAMPLE_ID

CC ID: 25720
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code identifying a record in CTS_SAMPLES describing this sample.
General Data Type: NUMBER

CAPTAIN_AGENCY

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

Identifies Agency Associated With Captain_id
General Data Type: VARCHAR2

CAPTAIN_ID

CC ID: 25722
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
General Data Type: NUMBER

TAGGER_INITIALS

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

Initials of person attaching or removing a tag. 3 characters are required. Use X for any missing characters.
General Data Type: VARCHAR2

TAGGER_TYPE

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

Classification of the person who releases or recaptures an animal. (C)ommercial fishermen, (N)mfs worker, (R)ecreational fisherman, (S)cientist, (U)nknown or missing.
General Data Type: VARCHAR2

TAGGER_AFFILIATION

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

Code for the agency the tagging is affiliated with.
General Data Type: VARCHAR2

VESSEL_AGENCY

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

Indentifies Agency That indicated vesseld code
General Data Type: VARCHAR2

VESSEL_ID

CC ID: 25727
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Agency supplied code identifying the vessel involved in the release or recapture of the animal.
General Data Type: NUMBER

PHYSICAL_DATA_ID

CC ID: 25728
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code to identify a record in CTS_Environ describing the conditions at the release/recapture site.
General Data Type: NUMBER

NOTES

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

Note code for the first message associated with this record.
General Data Type: NUMBER

FIGHTHRS

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

The number of hours spent fighting the fish before it was tagged.
General Data Type: NUMBER

FIGHTMINS

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

The minutes part of the time spent fighting the fish before it was tagged.
General Data Type: NUMBER

ANGLER_AGENCY_ID

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

Identifies Agency Associated With Angler_id
General Data Type: VARCHAR2

ANGLER_ID

CC ID: 25733
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Number Of Angler That Did The tagging
General Data Type: NUMBER

GEOM

CC ID: 25736
Seq. Order: 41
Data Storage Type: SDO_GEOMETRY
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

GIS component Of record
General Data Type: SDO_GEOMETRY

ID

CC ID: 25734
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequential Key
General Data Type: NUMBER

DATE_ENTERED

CC ID: 25735
Seq. Order: 43
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Record was entered into the system
General Data Type: DATE

Catalog Details

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