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

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

Summary

Abstract

List Of Tagging Events From The Billfish Foundation

Description

List Of Tagging Events From The Billfish Foundation

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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.
LOCALITY
VARCHAR2 		General Description Of Tagging Location
GRANT_TAGS
VARCHAR2 		Grant Tags ?
NMFS_TAG_ID
VARCHAR2 		NMFS Tagnumber On Animal (If present)
FISHCODE
VARCHAR2 		Code For Species Of Animal Tagged
FISH
VARCHAR2 		Common Name For Species Of Animal Tagged
DOUBLETAG
VARCHAR2 		Was This animal Double Tagged
ANGLERFIRST
VARCHAR2 		Angler First Name
ANGLERLAST
VARCHAR2 		Angler Last Name
CAPTAINFIRST
VARCHAR2 		Captain First Name
CAPTAINLAST
VARCHAR2 		Captain Last Name
FISH_CONDITION
VARCHAR2 		Description Of Fish Condition at Time of Tagging
BAIT_TYPE
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
REMARKS
VARCHAR2 		Any Extra Remark About Tagging Event
RERELEASED
VARCHAR2 		Was Fished ReReleased After a Recapture
RECAPTURE_DATE
DATE 		Date Animal Was Recaptured
DUPLICATE_NAME
VARCHAR2 		Number Of Other Tag Associated WIth This Animal
SPECIES
VARCHAR2 		Species Code
GEAR
VARCHAR2 		Gear Used to Land Fish
NMFS
VARCHAR2 		NMFS Tag Series Associated With This animal
BOAT
VARCHAR2 		Name Of Boat That Tagged Fish
LORAN
VARCHAR2 		Loran Number Of where tagging took place
RECAPTURE
VARCHAR2 		Is This event Tagging event a recapture
EDIT
VARCHAR2 		Has The Record Been Editted
CODE
FLOAT 		Code #1
CODE3
FLOAT 		Code #3
LASTUPDATE
DATE 		Date Record was last updated
PICTURE
VARCHAR2 		Was Image Of Fish Provided
OCEAN
VARCHAR2 		Coded item for the body of water from which the animal was landed.
RCREQUEST
VARCHAR2 		Rcrequest
OLD_LOCATION
VARCHAR2 		Old Location Code
LATDEG
FLOAT 		Latitude Degrees Of Location Of Tagging Event
LATMIN
FLOAT 		Latitude Minutes Of Location Of Tagging Event
LATHEM
VARCHAR2 		Latitude Hemisphere Of Location Of Tagging Event
LONDEG
FLOAT 		Longitude Degrees Of Location Of Tagging Event
LONMIN
FLOAT 		Longitude Minutes Of Location Of Tagging Event
LONHEM
VARCHAR2 		Longitude Hemisphere Of Location Of Tagging Event
LENGTH
FLOAT 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
LENGTH_UNIT
VARCHAR2 		Code To Indicate Units of Recorded Length Measurement
LENGTH_TYPE
VARCHAR2 		Code to Indicate Type Of Length Measurement Taken
LENGTH_DETERMINATION
VARCHAR2 		Code to indicate how length measurement was determined
WEIGHT
FLOAT 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
WEIGHT_UNIT
VARCHAR2 		Code For Units associated with weight
WEIGHT_TYPE
VARCHAR2 		Code to Indicate the Type Of Wieght measurement was taken
WEIGHT_DETERMINATION
VARCHAR2 		Code to indicate how weight measurement was determined.
FIGHT_HRS
FLOAT 		Whole Number Of Hours Spent Landing The Fish
FIGHT_MINS
FLOAT 		Whole Number Of MInutes up to 59 spent Landing The Fish
ENTRY_DATE
DATE 		Date Record was entered
NMFSSWFC_T
VARCHAR2 		NMFS South West Fisheries Center Tag
NMFSSWFC_N
VARCHAR2 		NMFS South West Fisheries Center Tag

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

List Of Tagging Events From The Billfish Foundation
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CTSPAT
Description:

List Of Tagging Events From The Billfish Foundation

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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
 Primary Key TAG_DATE DATE Date animal was released or recaptured.
100
 LOCALITY VARCHAR2 General Description Of Tagging Location
100
 GRANT_TAGS VARCHAR2 Grant Tags ?
100
 NMFS_TAG_ID VARCHAR2 NMFS Tagnumber On Animal (If present)
100
 FISHCODE VARCHAR2 Code For Species Of Animal Tagged
100
 FISH VARCHAR2 Common Name For Species Of Animal Tagged
100
 DOUBLETAG VARCHAR2 Was This animal Double Tagged
100
 ANGLERFIRST VARCHAR2 Angler First Name
100
 ANGLERLAST VARCHAR2 Angler Last Name
100
 CAPTAINFIRST VARCHAR2 Captain First Name
100
 CAPTAINLAST VARCHAR2 Captain Last Name
100
 FISH_CONDITION VARCHAR2 Description Of Fish Condition at Time of Tagging
100
 BAIT_TYPE VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
100
 REMARKS VARCHAR2 Any Extra Remark About Tagging Event
100
 RERELEASED VARCHAR2 Was Fished ReReleased After a Recapture
100
 RECAPTURE_DATE DATE Date Animal Was Recaptured
100
 DUPLICATE_NAME VARCHAR2 Number Of Other Tag Associated WIth This Animal
100
 SPECIES VARCHAR2 Species Code
100
 GEAR VARCHAR2 Gear Used to Land Fish
100
 NMFS VARCHAR2 NMFS Tag Series Associated With This animal
100
 BOAT VARCHAR2 Name Of Boat That Tagged Fish
100
 LORAN VARCHAR2 Loran Number Of where tagging took place
100
 RECAPTURE VARCHAR2 Is This event Tagging event a recapture
100
 EDIT VARCHAR2 Has The Record Been Editted
100
 CODE FLOAT Code #1
100
 CODE3 FLOAT Code #3
100
 LASTUPDATE DATE Date Record was last updated
100
 PICTURE VARCHAR2 Was Image Of Fish Provided
100
 OCEAN VARCHAR2 Coded item for the body of water from which the animal was landed.
100
 RCREQUEST VARCHAR2 Rcrequest
100
 OLD_LOCATION VARCHAR2 Old Location Code
100
 LATDEG FLOAT Latitude Degrees Of Location Of Tagging Event
100
 LATMIN FLOAT Latitude Minutes Of Location Of Tagging Event
100
 LATHEM VARCHAR2 Latitude Hemisphere Of Location Of Tagging Event
100
 LONDEG FLOAT Longitude Degrees Of Location Of Tagging Event
100
 LONMIN FLOAT Longitude Minutes Of Location Of Tagging Event
100
 LONHEM VARCHAR2 Longitude Hemisphere Of Location Of Tagging Event
100
 LENGTH FLOAT Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
100
 LENGTH_UNIT VARCHAR2 Code To Indicate Units of Recorded Length Measurement
100
 LENGTH_TYPE VARCHAR2 Code to Indicate Type Of Length Measurement Taken
100
 LENGTH_DETERMINATION VARCHAR2 Code to indicate how length measurement was determined
100
 WEIGHT FLOAT Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
100
 WEIGHT_UNIT VARCHAR2 Code For Units associated with weight
100
 WEIGHT_TYPE VARCHAR2 Code to Indicate the Type Of Wieght measurement was taken
100
 WEIGHT_DETERMINATION VARCHAR2 Code to indicate how weight measurement was determined.
100
 FIGHT_HRS FLOAT Whole Number Of Hours Spent Landing The Fish
100
 FIGHT_MINS FLOAT Whole Number Of MInutes up to 59 spent Landing The Fish
100
 ENTRY_DATE DATE Date Record was entered
100
 NMFSSWFC_T VARCHAR2 NMFS South West Fisheries Center Tag
100
 NMFSSWFC_N VARCHAR2 NMFS South West Fisheries Center Tag

Attribute Details

TAG_ID

CC ID: 27017
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 8
Required: Yes
Primary Key: Yes
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: 27018
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

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

LOCALITY

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

General Description Of Tagging Location
General Data Type: VARCHAR2

GRANT_TAGS

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

Grant Tags ?
General Data Type: VARCHAR2

NMFS_TAG_ID

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

NMFS Tagnumber On Animal (If present)
General Data Type: VARCHAR2

FISHCODE

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

Code For Species Of Animal Tagged
General Data Type: VARCHAR2

FISH

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

Common Name For Species Of Animal Tagged
General Data Type: VARCHAR2

DOUBLETAG

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

Was This animal Double Tagged
General Data Type: VARCHAR2

ANGLERFIRST

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

Angler First Name
General Data Type: VARCHAR2

ANGLERLAST

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

Angler Last Name
General Data Type: VARCHAR2

CAPTAINFIRST

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

Captain First Name
General Data Type: VARCHAR2

CAPTAINLAST

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

Captain Last Name
General Data Type: VARCHAR2

FISH_CONDITION

CC ID: 27029
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Description Of Fish Condition at Time of Tagging
General Data Type: VARCHAR2

BAIT_TYPE

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

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

REMARKS

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

Any Extra Remark About Tagging Event
General Data Type: VARCHAR2

RERELEASED

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

Was Fished ReReleased After a Recapture
General Data Type: VARCHAR2

RECAPTURE_DATE

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

Date Animal Was Recaptured
General Data Type: DATE

DUPLICATE_NAME

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

Number Of Other Tag Associated WIth This Animal
General Data Type: VARCHAR2

SPECIES

CC ID: 27035
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Species Code
General Data Type: VARCHAR2

GEAR

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

Gear Used to Land Fish
General Data Type: VARCHAR2

NMFS

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

NMFS Tag Series Associated With This animal
General Data Type: VARCHAR2

BOAT

CC ID: 27038
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name Of Boat That Tagged Fish
General Data Type: VARCHAR2

LORAN

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

Loran Number Of where tagging took place
General Data Type: VARCHAR2

RECAPTURE

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

Is This event Tagging event a recapture
General Data Type: VARCHAR2

EDIT

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

Has The Record Been Editted
General Data Type: VARCHAR2

CODE

CC ID: 27042
Seq. Order: 26
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Code #1
General Data Type: FLOAT

CODE3

CC ID: 27043
Seq. Order: 27
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Code #3
General Data Type: FLOAT

LASTUPDATE

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

Date Record was last updated
General Data Type: DATE

PICTURE

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

Was Image Of Fish Provided
General Data Type: VARCHAR2

OCEAN

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

Coded item for the body of water from which the animal was landed.
General Data Type: VARCHAR2

RCREQUEST

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

Rcrequest
General Data Type: VARCHAR2

OLD_LOCATION

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

Old Location Code
General Data Type: VARCHAR2

LATDEG

CC ID: 27049
Seq. Order: 33
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Latitude Degrees Of Location Of Tagging Event
General Data Type: FLOAT

LATMIN

CC ID: 27050
Seq. Order: 34
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Latitude Minutes Of Location Of Tagging Event
General Data Type: FLOAT

LATHEM

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

Latitude Hemisphere Of Location Of Tagging Event
General Data Type: VARCHAR2

LONDEG

CC ID: 27052
Seq. Order: 36
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

Longitude Degrees Of Location Of Tagging Event
General Data Type: FLOAT

LONMIN

CC ID: 27053
Seq. Order: 37
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Longitude Minutes Of Location Of Tagging Event
General Data Type: FLOAT

LONHEM

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

Longitude Hemisphere Of Location Of Tagging Event
General Data Type: VARCHAR2

LENGTH

CC ID: 27055
Seq. Order: 39
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

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

LENGTH_UNIT

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

Code To Indicate Units of Recorded Length Measurement
General Data Type: VARCHAR2

LENGTH_TYPE

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

Code to Indicate Type Of Length Measurement Taken
General Data Type: VARCHAR2

LENGTH_DETERMINATION

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

Code to indicate how length measurement was determined
General Data Type: VARCHAR2

WEIGHT

CC ID: 27059
Seq. Order: 43
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

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

WEIGHT_UNIT

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

Code For Units associated with weight
General Data Type: VARCHAR2

WEIGHT_TYPE

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

Code to Indicate the Type Of Wieght measurement was taken
General Data Type: VARCHAR2

WEIGHT_DETERMINATION

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

Code to indicate how weight measurement was determined.
General Data Type: VARCHAR2

FIGHT_HRS

CC ID: 27063
Seq. Order: 47
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Whole Number Of Hours Spent Landing The Fish
General Data Type: FLOAT

FIGHT_MINS

CC ID: 27064
Seq. Order: 48
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Status: Active
Description:

Whole Number Of MInutes up to 59 spent Landing The Fish
General Data Type: FLOAT

ENTRY_DATE

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

Date Record was entered
General Data Type: DATE

NMFSSWFC_T

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

NMFS South West Fisheries Center Tag
General Data Type: VARCHAR2

NMFSSWFC_N

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

NMFS South West Fisheries Center Tag
General Data Type: VARCHAR2

Catalog Details

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