Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: TBF_CAPTURE
Short Name: TBF_CAPTURE
Status: Completed
Abstract:

CTS.TBF_CAPTURE 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 Information

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

CTS.TBF_CAPTURE 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.

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
TAG_DATE DATE Date animal was released or recaptured.
100
FISHCODE VARCHAR2 TBF Fish Code
100
FISH VARCHAR2 Name Of Fish
100
RERELEASED VARCHAR2 Was Fish Released After It was Recaptured
100
Primary Key RECAPTURE_DATE DATE Date Animal Was Recaptured
100
LOCALITY VARCHAR2 Locality Where Fish Was Recaptured
100
LENGTH2 VARCHAR2 Length MEasurement at time of second recpature
100
WEIGHT2 VARCHAR2 Weight measurement at time of second recapture
100
ANGLER2 VARCHAR2 Angler Number Of recapturing Angler
100
A2FIRST VARCHAR2 Recapturing Angler First Name
100
A2LAST VARCHAR2 Recapturing Angler Last Name
100
FISH_CONDITION VARCHAR2 Descriptive Fish Condition at time of recapture
100
DAYSATLARGE VARCHAR2 Number Of Days ANimal Was At Large
100
NMFS_SHED VARCHAR2 Was The NMFS Tag Shed At time of recapture
100
LAT2 VARCHAR2 Latitude at Time Of Recapture
100
LON2 VARCHAR2 Longitude at Time Of Recapture
100
REMARKS2 VARCHAR2 Remarks About Recapture
100
RETAG VARCHAR2 Inicates If animal Was animal retagged
100
NEWTAG VARCHAR2 If a new tag is applied to a fish upon re-release, this is the number of that tag
100
LORAN VARCHAR2 Loran reading for location of recapture
100
RECAPTURE VARCHAR2 Was This a Recapture Record
100
EDIT VARCHAR2 Was Recorded Editted After Entry
100
NS VARCHAR2 Second Latitude Hemisphere Meaurement
100
EW VARCHAR2 Second Longitde Hemiphere Measurement
100
WT1 VARCHAR2 Second Weight Measurment
100
LTH1 VARCHAR2 Second Length Measurement
100
CODE2 FLOAT Second Tagnumber
100
CODE4 FLOAT Fourth Tagnumber
100
C2FIRST VARCHAR2 Boat Captain First Name
100
C2LAST VARCHAR2 Boat Captain Last Name
100
BOAT VARCHAR2 Boat Name
100
GEAR VARCHAR2 Code for gear used to catch the animal.
100
LASTUPDATE DATE Date Record has last been updated
100
OCEAN VARCHAR2 Logical Flag to indicate If Fish was caught in the opern waters of an ocean
100
KILLED VARCHAR2 Was Fished Killed Upon Recapture
100
NMFS_STUDY VARCHAR2 Is This data used as part of NMFS (tag shedding) study
100
LONGLINE VARCHAR2 Was a longline used to catch fish
100
LJFT VARCHAR2 LJFT Measurement
100
ORIG_FOUND VARCHAR2 Was original tag still on fish
100
OLD_LOCALITY VARCHAR2 Old Location Code
100
LATDEG FLOAT Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees.
100
LATMIN FLOAT Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes.
100
LATHEM VARCHAR2 Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown
100
LONDEG FLOAT Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees
100
LONMIN FLOAT Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes.
100
LONHEM VARCHAR2 Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown
100
LENGTH FLOAT 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
LENGTHDETERMINATION VARCHAR2 How Length Was Determined
100
WEIGHT FLOAT 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
WEIGHTDETERMINATION VARCHAR2 How Weight Was Determined
100
FIGHT_HRS FLOAT Number Of Hours Spent Fighting FIsh Until Landings
100
FIGHT_MINS FLOAT Number Of Minutes Spent Fighting FIsh Until Landings
100
DUPLICATE_NAME VARCHAR2 Tag Number To Refernce For Doubly Tagged Fished

Attribute Details

TAG_ID

CC ID: 26804
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: 26805
Seq. Order: 2
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date animal was released or recaptured.

General Data Type: DATE

FISHCODE

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

TBF Fish Code

General Data Type: VARCHAR2

FISH

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

Name Of Fish

General Data Type: VARCHAR2

RERELEASED

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

Was Fish Released After It was Recaptured

General Data Type: VARCHAR2

RECAPTURE_DATE

CC ID: 26809
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

Date Animal Was Recaptured

General Data Type: DATE

LOCALITY

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

Locality Where Fish Was Recaptured

General Data Type: VARCHAR2

LENGTH2

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

Length MEasurement at time of second recpature

General Data Type: VARCHAR2

WEIGHT2

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

Weight measurement at time of second recapture

General Data Type: VARCHAR2

ANGLER2

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

Angler Number Of recapturing Angler

General Data Type: VARCHAR2

A2FIRST

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

Recapturing Angler First Name

General Data Type: VARCHAR2

A2LAST

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

Recapturing Angler Last Name

General Data Type: VARCHAR2

FISH_CONDITION

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

Descriptive Fish Condition at time of recapture

General Data Type: VARCHAR2

DAYSATLARGE

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

Number Of Days ANimal Was At Large

General Data Type: VARCHAR2

NMFS_SHED

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

Was The NMFS Tag Shed At time of recapture

General Data Type: VARCHAR2

LAT2

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

Latitude at Time Of Recapture

General Data Type: VARCHAR2

LON2

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

Longitude at Time Of Recapture

General Data Type: VARCHAR2

REMARKS2

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

Remarks About Recapture

General Data Type: VARCHAR2

RETAG

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

Inicates If animal Was animal retagged

General Data Type: VARCHAR2

NEWTAG

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

If a new tag is applied to a fish upon re-release, this is the number of that tag

General Data Type: VARCHAR2

LORAN

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

Loran reading for location of recapture

General Data Type: VARCHAR2

RECAPTURE

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

Was This a Recapture Record

General Data Type: VARCHAR2

EDIT

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

Was Recorded Editted After Entry

General Data Type: VARCHAR2

NS

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

Second Latitude Hemisphere Meaurement

General Data Type: VARCHAR2

EW

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

Second Longitde Hemiphere Measurement

General Data Type: VARCHAR2

WT1

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

Second Weight Measurment

General Data Type: VARCHAR2

LTH1

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

Second Length Measurement

General Data Type: VARCHAR2

CODE2

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

Second Tagnumber

General Data Type: FLOAT

CODE4

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

Fourth Tagnumber

General Data Type: FLOAT

C2FIRST

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

Boat Captain First Name

General Data Type: VARCHAR2

C2LAST

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

Boat Captain Last Name

General Data Type: VARCHAR2

BOAT

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

Boat Name

General Data Type: VARCHAR2

GEAR

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

Code for gear used to catch the animal.

General Data Type: VARCHAR2

LASTUPDATE

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

Date Record has last been updated

General Data Type: DATE

OCEAN

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

Logical Flag to indicate If Fish was caught in the opern waters of an ocean

General Data Type: VARCHAR2

KILLED

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

Was Fished Killed Upon Recapture

General Data Type: VARCHAR2

NMFS_STUDY

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

Is This data used as part of NMFS (tag shedding) study

General Data Type: VARCHAR2

LONGLINE

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

Was a longline used to catch fish

General Data Type: VARCHAR2

LJFT

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

LJFT Measurement

General Data Type: VARCHAR2

ORIG_FOUND

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

Was original tag still on fish

General Data Type: VARCHAR2

OLD_LOCALITY

CC ID: 26844
Seq. Order: 41
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: 26845
Seq. Order: 42
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 126
Status: Active
Description:

Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees.

General Data Type: FLOAT

LATMIN

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

Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes.

General Data Type: FLOAT

LATHEM

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

Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown

General Data Type: VARCHAR2

LONDEG

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

Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees

General Data Type: FLOAT

LONMIN

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

Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes.

General Data Type: FLOAT

LONHEM

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

Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown

General Data Type: VARCHAR2

LENGTH

CC ID: 26851
Seq. Order: 48
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

LENGTHUNIT

CC ID: 26852
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 10
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: 26853
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 10
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

LENGTHDETERMINATION

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

How Length Was Determined

General Data Type: VARCHAR2

WEIGHT

CC ID: 26855
Seq. Order: 52
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

WEIGHTUNIT

CC ID: 26856
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 10
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: 26857
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Weight measurement type: (R)ound, (D)ressed, (U)nknown

General Data Type: VARCHAR2

WEIGHTDETERMINATION

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

How Weight Was Determined

General Data Type: VARCHAR2

FIGHT_HRS

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

Number Of Hours Spent Fighting FIsh Until Landings

General Data Type: FLOAT

FIGHT_MINS

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

Number Of Minutes Spent Fighting FIsh Until Landings

General Data Type: FLOAT

DUPLICATE_NAME

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

Tag Number To Refernce For Doubly Tagged Fished

General Data Type: VARCHAR2

Catalog Details

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