Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

Table: TBF_INTERACTIONS

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7119 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.

Description

CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.

Entity Type
Data Table

Data Attribute / Type	Description
ANIMAL_ID NUMBER	Unique identifier for each animal
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.
TAG_DATE DATE	Date animal was released or recaptured.
PRIOR_TAG VARCHAR2	Any previous tag that may have been on the animal.
INTERACTION_ORDER NUMBER	Number denoting the order of the interaction.
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	Numeric value for the latitude of the tagging location.
LONGITUDE NUMBER	Numeric value the the longitude of the tagging location.
LOCATION_NAME VARCHAR2	Text string describing the location where the animal was caught.
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
CAPTAIN_AGENCY_ID VARCHAR2	The agency code for the captain.
CAPTAIN_ID NUMBER	Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
VESSEL_AGENCY_ID VARCHAR2	The agency code for the vessel.
VESSEL_ID NUMBER	Agency supplied code identifying the vessel involved in the release or recapture of the animal.
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	The agency code for the angler.
ANGLER_ID NUMBER	Unique identifier for each person in the database.
GEOM SDO_GEOMETRY	Oracle Spatial vector geometry object to store the track.
ID NUMBER	A unique identifier for each interaction.
DATE_ENTERED DATE	The date the data was entered.

Data Attribute / Type

Description

ANIMAL_ID
NUMBER

Unique identifier for each animal

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.

TAG_DATE
DATE

Date animal was released or recaptured.

PRIOR_TAG
VARCHAR2

Any previous tag that may have been on the animal.

INTERACTION_ORDER
NUMBER

Number denoting the order of the interaction.

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

Numeric value for the latitude of the tagging location.

LONGITUDE
NUMBER

Numeric value the the longitude of the tagging location.

LOCATION_NAME
VARCHAR2

Text string describing the location where the animal was caught.

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

CAPTAIN_AGENCY_ID
VARCHAR2

The agency code for the captain.

CAPTAIN_ID
NUMBER

Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.

VESSEL_AGENCY_ID
VARCHAR2

The agency code for the vessel.

VESSEL_ID
NUMBER

Agency supplied code identifying the vessel involved in the release or recapture of the animal.

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

The agency code for the angler.

ANGLER_ID
NUMBER

Unique identifier for each person in the database.

GEOM
SDO_GEOMETRY

Oracle Spatial vector geometry object to store the track.

ID
NUMBER

A unique identifier for each interaction.

DATE_ENTERED
DATE

The date the data was entered.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: TBF_INTERACTIONS
Short Name:	TBF_INTERACTIONS
Status:	Completed
Abstract:	CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CTSPAT
Description:	CTS.TBF_INTERACTIONS is the primary table of the CTS systems.It contains the information on the actual tagging event, such as,the initial release, the recapture or the re-release of an animal.

Attribute Summary

	Name	Type	Description
100	ANIMAL_ID	NUMBER	Unique identifier for each animal
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	TAG_DATE	DATE	Date animal was released or recaptured.
100	PRIOR_TAG	VARCHAR2	Any previous tag that may have been on the animal.
100	INTERACTION_ORDER	NUMBER	Number denoting the order of the interaction.
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	Numeric value for the latitude of the tagging location.
100	LONGITUDE	NUMBER	Numeric value the the longitude of the tagging location.
100	LOCATION_NAME	VARCHAR2	Text string describing the location where the animal was caught.
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	CAPTAIN_AGENCY_ID	VARCHAR2	The agency code for the captain.
100	CAPTAIN_ID	NUMBER	Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
100	VESSEL_AGENCY_ID	VARCHAR2	The agency code for the vessel.
100	VESSEL_ID	NUMBER	Agency supplied code identifying the vessel involved in the release or recapture of the animal.
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	The agency code for the angler.
100	ANGLER_ID	NUMBER	Unique identifier for each person in the database.
100	GEOM	SDO_GEOMETRY	Oracle Spatial vector geometry object to store the track.
100	ID	NUMBER	A unique identifier for each interaction.
100	DATE_ENTERED	DATE	The date the data was entered.

Name

Type

Description

100

ANIMAL_ID

NUMBER

Unique identifier for each animal

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

TAG_DATE

DATE

Date animal was released or recaptured.

100

PRIOR_TAG

VARCHAR2

Any previous tag that may have been on the animal.

100

INTERACTION_ORDER

NUMBER

Number denoting the order of the interaction.

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

Numeric value for the latitude of the tagging location.

100

LONGITUDE

NUMBER

Numeric value the the longitude of the tagging location.

100

LOCATION_NAME

VARCHAR2

Text string describing the location where the animal was caught.

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

CAPTAIN_AGENCY_ID

VARCHAR2

The agency code for the captain.

100

CAPTAIN_ID

NUMBER

Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.

100

VESSEL_AGENCY_ID

VARCHAR2

The agency code for the vessel.

100

VESSEL_ID

NUMBER

Agency supplied code identifying the vessel involved in the release or recapture of the animal.

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

The agency code for the angler.

100

ANGLER_ID

NUMBER

Unique identifier for each person in the database.

100

GEOM

SDO_GEOMETRY

Oracle Spatial vector geometry object to store the track.

100

NUMBER

A unique identifier for each interaction.

100

DATE_ENTERED

DATE

The date the data was entered.

Attribute Details

ANIMAL_ID

CC ID: 26910

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Unique identifier for each animal
General Data Type:	NUMBER

TAG_ID

CC ID: 26911

Seq. Order:	2
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

TAG_DATE

CC ID: 26912

Seq. Order:	3
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

PRIOR_TAG

CC ID: 26913

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Any previous tag that may have been on the animal.
General Data Type:	VARCHAR2

INTERACTION_ORDER

CC ID: 26914

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number denoting the order of the interaction.
General Data Type:	NUMBER

LENGTH

CC ID: 26915

Seq. Order:	6
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: 26916

Seq. Order:	7
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: 26917

Seq. Order:	8
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: 26918

Seq. Order:	9
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: 26919

Seq. Order:	10
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: 26920

Seq. Order:	11
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: 26921

Seq. Order:	12
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: 26922

Seq. Order:	13
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: 26923

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	30
Scale:	16
Status:	Active
Description:	Numeric value for the latitude of the tagging location.
General Data Type:	NUMBER

LONGITUDE

CC ID: 26924

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	30
Scale:	16
Status:	Active
Description:	Numeric value the the longitude of the tagging location.
General Data Type:	NUMBER

LOCATION_NAME

CC ID: 26925

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Text string describing the location where the animal was caught.
General Data Type:	VARCHAR2

GEAR_ID

CC ID: 26926

Seq. Order:	17
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: 26927

Seq. Order:	18
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

CAPTAIN_AGENCY_ID

CC ID: 26928

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The agency code for the captain.
General Data Type:	VARCHAR2

CAPTAIN_ID

CC ID: 26929

Seq. Order:	20
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

VESSEL_AGENCY_ID

CC ID: 26930

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The agency code for the vessel.
General Data Type:	VARCHAR2

VESSEL_ID

CC ID: 26931

Seq. Order:	22
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

FIGHTHRS

CC ID: 26932

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	The number of hours spent fighting the fish before it was tagged.
General Data Type:	NUMBER

FIGHTMINS

CC ID: 26933

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
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: 26934

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The agency code for the angler.
General Data Type:	VARCHAR2

ANGLER_ID

CC ID: 26935

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Unique identifier for each person in the database.
General Data Type:	NUMBER

GEOM

CC ID: 26938

Seq. Order:	27
Data Storage Type:	SDO_GEOMETRY
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle Spatial vector geometry object to store the track.
General Data Type:	SDO_GEOMETRY

ID

CC ID: 26936

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	38
Status:	Active
Description:	A unique identifier for each interaction.
General Data Type:	NUMBER

DATE_ENTERED

CC ID: 26937

Seq. Order:	29
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date the data was entered.
General Data Type:	DATE

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

Table: TBF_INTERACTIONS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ID

TAG_ID

TAG_DATE

PRIOR_TAG

INTERACTION_ORDER

LENGTH

LENGTHUNIT

LENGTHTYPE

LENGTHDET

WEIGHT

WEIGHTUNIT

WEIGHTTYPE

WEIGHTDET

LATITUDE

LONGITUDE

LOCATION_NAME

GEAR_ID

BAIT_TYPE

CAPTAIN_AGENCY_ID

CAPTAIN_ID

VESSEL_AGENCY_ID

VESSEL_ID

FIGHTHRS

FIGHTMINS

ANGLER_AGENCY_ID

ANGLER_ID

GEOM

ID

DATE_ENTERED

Catalog Details