Table: CTS_INTERACTIONS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7046 | Updated: August 9, 2022 | Published / External
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
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
|
ID | NUMBER | Sequential Key | |
100
|
DATE_ENTERED | DATE | Date Record was entered into the system |
Attribute Details
ANIMAL_ID
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |