Table: TBF_TAGGED
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7124 | Updated: August 9, 2022 | Published / External
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
Name | Type | Description | ||
---|---|---|---|---|
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
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |