Metadata Rubric

100%

6 / 6

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

View: TBF_RELEASES_V

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

CTS.TBF_RELEASES_V contains informat on releases by TBF.

Description

CTS.TBF_RELEASES_V contains informat on releases by TBF.

Entity Type
Data View

Data Attribute / Type	Description
ANIMAL_ID NUMBER	Unique identifier for each animal
SPECIES_ID VARCHAR2	Species Code (used in MIA Tagging System)
SEX VARCHAR2	Code to Indicate Sex Of Animal
ID NUMBER	A unique identifier for each interaction.
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
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.
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.
ANGLER_AGENCY_ID VARCHAR2	The agency code for the angler.
ANGLER_ID NUMBER	Unique identifier for each person in the database.
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.

Data Attribute / Type

Description

ANIMAL_ID
NUMBER

Unique identifier for each animal

SPECIES_ID
VARCHAR2

Species Code (used in MIA Tagging System)

SEX
VARCHAR2

Code to Indicate Sex Of Animal

ID
NUMBER

A unique identifier for each interaction.

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

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.

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.

ANGLER_AGENCY_ID
VARCHAR2

The agency code for the angler.

ANGLER_ID
NUMBER

Unique identifier for each person in the database.

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.

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:	View: TBF_RELEASES_V
Short Name:	TBF_RELEASES_V
Status:	Completed
Abstract:	CTS.TBF_RELEASES_V contains informat on releases by TBF.
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	CTSPAT
Description:	CTS.TBF_RELEASES_V contains informat on releases by TBF.

Attribute Summary

	Name	Type	Description
100	ANIMAL_ID	NUMBER	Unique identifier for each animal
100	SPECIES_ID	VARCHAR2	Species Code (used in MIA Tagging System)
100	SEX	VARCHAR2	Code to Indicate Sex Of Animal
100	ID	NUMBER	A unique identifier for each interaction.
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	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	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	ANGLER_AGENCY_ID	VARCHAR2	The agency code for the angler.
100	ANGLER_ID	NUMBER	Unique identifier for each person in the database.
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.

Name

Type

Description

100

ANIMAL_ID

NUMBER

Unique identifier for each animal

100

SPECIES_ID

VARCHAR2

Species Code (used in MIA Tagging System)

100

SEX

VARCHAR2

Code to Indicate Sex Of Animal

100

NUMBER

A unique identifier for each interaction.

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

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

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

ANGLER_AGENCY_ID

VARCHAR2

The agency code for the angler.

100

ANGLER_ID

NUMBER

Unique identifier for each person in the database.

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.

Attribute Details

ANIMAL_ID

CC ID: 26977

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

SPECIES_ID

CC ID: 26965

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Species Code (used in MIA Tagging System)
General Data Type:	VARCHAR2

SEX

CC ID: 26981

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to Indicate Sex Of Animal
General Data Type:	VARCHAR2

ID

CC ID: 26980

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

TAG_ID

CC ID: 26983

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

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

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

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

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: 26975

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: 26962

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: 26976

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: 26967

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: 26966

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: 26963

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: 26959

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: 26973

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

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

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

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

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

FIGHTHRS

CC ID: 26969

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

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

CAPTAIN_AGENCY_ID

CC ID: 26982

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

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

ANGLER_AGENCY_ID

CC ID: 26968

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

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

VESSEL_AGENCY_ID

CC ID: 26961

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

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

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

View: TBF_RELEASES_V

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ID

SPECIES_ID

SEX

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

FIGHTHRS

FIGHTMINS

CAPTAIN_AGENCY_ID

CAPTAIN_ID

ANGLER_AGENCY_ID

ANGLER_ID

VESSEL_AGENCY_ID

VESSEL_ID

Catalog Details