Table: TBF_CAPTURE
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 7113
| Published / External
Created: 2008-02-22
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5453
ID: 7113
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: TBF_CAPTURE |
---|---|
Short Name | TBF_CAPTURE |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » 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. |
* Purpose | |
Notes |
Loaded by batch 2083, 02-22-2008 12:10 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
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. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | 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 | No | No | TAG_DATE | DATE | Date animal was released or recaptured. |
100 | Yes | No | FISHCODE | VARCHAR2 | TBF Fish Code |
100 | No | No | FISH | VARCHAR2 | Name Of Fish |
100 | No | No | RERELEASED | VARCHAR2 | Was Fish Released After It was Recaptured |
100 | Yes | Yes | RECAPTURE_DATE | DATE | Date Animal Was Recaptured |
100 | No | No | LOCALITY | VARCHAR2 | Locality Where Fish Was Recaptured |
100 | No | No | LENGTH2 | VARCHAR2 | Length MEasurement at time of second recpature |
100 | No | No | WEIGHT2 | VARCHAR2 | Weight measurement at time of second recapture |
100 | No | No | ANGLER2 | VARCHAR2 | Angler Number Of recapturing Angler |
100 | No | No | A2FIRST | VARCHAR2 | Recapturing Angler First Name |
100 | No | No | A2LAST | VARCHAR2 | Recapturing Angler Last Name |
100 | No | No | FISH_CONDITION | VARCHAR2 | Descriptive Fish Condition at time of recapture |
100 | No | No | DAYSATLARGE | VARCHAR2 | Number Of Days ANimal Was At Large |
100 | No | No | NMFS_SHED | VARCHAR2 | Was The NMFS Tag Shed At time of recapture |
100 | No | No | LAT2 | VARCHAR2 | Latitude at Time Of Recapture |
100 | No | No | LON2 | VARCHAR2 | Longitude at Time Of Recapture |
100 | No | No | REMARKS2 | VARCHAR2 | Remarks About Recapture |
100 | No | No | RETAG | VARCHAR2 | Inicates If animal Was animal retagged |
100 | No | No | NEWTAG | VARCHAR2 | If a new tag is applied to a fish upon re-release, this is the number of that tag |
100 | No | No | LORAN | VARCHAR2 | Loran reading for location of recapture |
100 | No | No | RECAPTURE | VARCHAR2 | Was This a Recapture Record |
100 | No | No | EDIT | VARCHAR2 | Was Recorded Editted After Entry |
100 | No | No | NS | VARCHAR2 | Second Latitude Hemisphere Meaurement |
100 | No | No | EW | VARCHAR2 | Second Longitde Hemiphere Measurement |
100 | No | No | WT1 | VARCHAR2 | Second Weight Measurment |
100 | No | No | LTH1 | VARCHAR2 | Second Length Measurement |
100 | No | No | CODE2 | FLOAT | Second Tagnumber |
100 | No | No | CODE4 | FLOAT | Fourth Tagnumber |
100 | No | No | C2FIRST | VARCHAR2 | Boat Captain First Name |
100 | No | No | C2LAST | VARCHAR2 | Boat Captain Last Name |
100 | No | No | BOAT | VARCHAR2 | Boat Name |
100 | No | No | GEAR | VARCHAR2 | Code for gear used to catch the animal. |
100 | No | No | LASTUPDATE | DATE | Date Record has last been updated |
100 | No | No | OCEAN | VARCHAR2 | Logical Flag to indicate If Fish was caught in the opern waters of an ocean |
100 | No | No | KILLED | VARCHAR2 | Was Fished Killed Upon Recapture |
100 | No | No | NMFS_STUDY | VARCHAR2 | Is This data used as part of NMFS (tag shedding) study |
100 | No | No | LONGLINE | VARCHAR2 | Was a longline used to catch fish |
100 | No | No | LJFT | VARCHAR2 | LJFT Measurement |
100 | No | No | ORIG_FOUND | VARCHAR2 | Was original tag still on fish |
100 | No | No | OLD_LOCALITY | VARCHAR2 | Old Location Code |
100 | No | No | LATDEG | FLOAT | Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees. |
100 | No | No | LATMIN | FLOAT | Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes. |
100 | No | No | LATHEM | VARCHAR2 | Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown |
100 | No | No | LONDEG | FLOAT | Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees |
100 | No | No | LONMIN | FLOAT | Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes. |
100 | No | No | LONHEM | VARCHAR2 | Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown |
100 | No | No | LENGTH | FLOAT | Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. |
100 | No | No | LENGTHUNIT | VARCHAR2 | Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters |
100 | No | No | 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 | No | No | LENGTHDETERMINATION | VARCHAR2 | How Length Was Determined |
100 | No | No | WEIGHT | FLOAT | Weight of an animal tagged, based upon weightunit, weighttype and weightdet. |
100 | No | No | WEIGHTUNIT | VARCHAR2 | Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown |
100 | No | No | WEIGHTTYPE | VARCHAR2 | Weight measurement type: (R)ound, (D)ressed, (U)nknown |
100 | No | No | WEIGHTDETERMINATION | VARCHAR2 | How Weight Was Determined |
100 | No | No | FIGHT_HRS | FLOAT | Number Of Hours Spent Fighting FIsh Until Landings |
100 | No | No | FIGHT_MINS | FLOAT | Number Of Minutes Spent Fighting FIsh Until Landings |
100 | No | No | DUPLICATE_NAME | VARCHAR2 | Tag Number To Refernce For Doubly Tagged Fished |
Attribute Details
Attribute Name | TAG_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TAG_DATE |
---|---|
Seq. Order | 2 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date animal was released or recaptured. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISHCODE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
TBF Fish Code |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISH |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name Of Fish |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RERELEASED |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was Fish Released After It was Recaptured |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECAPTURE_DATE |
---|---|
Seq. Order | 6 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Date Animal Was Recaptured |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCALITY |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 130 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Locality Where Fish Was Recaptured |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTH2 |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length MEasurement at time of second recpature |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHT2 |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight measurement at time of second recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ANGLER2 |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Angler Number Of recapturing Angler |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | A2FIRST |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Recapturing Angler First Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | A2LAST |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Recapturing Angler Last Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FISH_CONDITION |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Descriptive Fish Condition at time of recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DAYSATLARGE |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number Of Days ANimal Was At Large |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NMFS_SHED |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was The NMFS Tag Shed At time of recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAT2 |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude at Time Of Recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LON2 |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude at Time Of Recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REMARKS2 |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 130 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Remarks About Recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RETAG |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Inicates If animal Was animal retagged |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEWTAG |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LORAN |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Loran reading for location of recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECAPTURE |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was This a Recapture Record |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EDIT |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was Recorded Editted After Entry |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NS |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Second Latitude Hemisphere Meaurement |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EW |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Second Longitde Hemiphere Measurement |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WT1 |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Second Weight Measurment |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LTH1 |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Second Length Measurement |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODE2 |
---|---|
Seq. Order | 28 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Second Tagnumber |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CODE4 |
---|---|
Seq. Order | 29 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Fourth Tagnumber |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | C2FIRST |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Boat Captain First Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | C2LAST |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Boat Captain Last Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BOAT |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Boat Name |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for gear used to catch the animal. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LASTUPDATE |
---|---|
Seq. Order | 34 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date Record has last been updated |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OCEAN |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Logical Flag to indicate If Fish was caught in the opern waters of an ocean |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | KILLED |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was Fished Killed Upon Recapture |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NMFS_STUDY |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is This data used as part of NMFS (tag shedding) study |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGLINE |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was a longline used to catch fish |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LJFT |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
LJFT Measurement |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ORIG_FOUND |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Was original tag still on fish |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OLD_LOCALITY |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Old Location Code |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATDEG |
---|---|
Seq. Order | 42 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Degrees latitude where animal was released/recaptured. Range 0 to 90 degrees. |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATMIN |
---|---|
Seq. Order | 43 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Minutes of latitude where animal was released/recaptured. Range 0 - 59.99 minutes. |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATHEM |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hemisphere of latitude where animal was released/recaptured. (N)orth, (S)outh, (U)nknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONDEG |
---|---|
Seq. Order | 45 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Degrees of longitude where animal was released/recaptured. Range 0 to 180 degrees |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONMIN |
---|---|
Seq. Order | 46 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Minutes of longitude where animal was released/recaptured. Range 0 - 59.99 minutes. |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONHEM |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hemisphere of longitude where animal was released/recaptured: (E)ast, (W)est, (U)nknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTH |
---|---|
Seq. Order | 48 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Length of animal tagged based on the lengthunit, lengthtype, and lengthdet. |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTHUNIT |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Length measurement used: (IN) inches, (FT) feet, (MM) millimeters, (M ) meters, (UN) unknown, (CM) centimeters |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTHTYPE |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LENGTHDETERMINATION |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
How Length Was Determined |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHT |
---|---|
Seq. Order | 52 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Weight of an animal tagged, based upon weightunit, weighttype and weightdet. |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHTUNIT |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight measurement used: (OZ) ounces, (LB) pounds, (GM) grams, (KG) Kilograms, (UN) Unknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHTTYPE |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Weight measurement type: (R)ound, (D)ressed, (U)nknown |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHTDETERMINATION |
---|---|
Seq. Order | 55 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
How Weight Was Determined |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIGHT_HRS |
---|---|
Seq. Order | 56 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Number Of Hours Spent Fighting FIsh Until Landings |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIGHT_MINS |
---|---|
Seq. Order | 57 |
Data Storage Type | FLOAT |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 126 |
Scale | |
Status | Active |
Description |
Number Of Minutes Spent Fighting FIsh Until Landings |
General Data Type | FLOAT |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DUPLICATE_NAME |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tag Number To Refernce For Doubly Tagged Fished |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2021-05-05 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-05 |
Tags |
---|