Metadata Rubric

100%

6 / 6

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

View: TBF_FIRST_RECAPTURES_V

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

Item Identification

Title:	View: TBF_FIRST_RECAPTURES_V
Short Name:	TBF_FIRST_RECAPTURES_V
Status:	Completed
Abstract:	CTS.TBF_FIRST_RECAPTURES_V contains informat on first recaptures by TBF.
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Information

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

Data Attributes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Details

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