Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

View: RAW_CATCH_DETAILS_V

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

Summary

Abstract

View Of Raw Catch Details

Description

View Of Raw Catch Details

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Tournament Code
FISHING_DATE
DATE 		Fishing Date
SPECIES_ID
VARCHAR2 		Mnemonic Species Code
LENGTH_CM
FLOAT 		Length In Centimeters
LENGTH_TYPE
VARCHAR2 		Length Type (How length was measured)
WEIGHT_KG
FLOAT 		Weight In kilograms
WEIGHT_TYPE
VARCHAR2 		Weight Type (How weight was measured)
SEX
VARCHAR2 		Sex f Fish Caught
BOAT_NAME
VARCHAR2 		Boat Name
BAIT
VARCHAR2 		Kind Of Bait Used
FISHING_TECHNIQUE
VARCHAR2 		Technique Used For Fishing
HOOK_TYPE
VARCHAR2 		Type Of Hook Used
CATCH_DISPOSITION
VARCHAR2 		How as catch disposed
RELEASE_DISPOSITION
VARCHAR2 		Disposition Of released fish
LATITUDE
NUMBER 		Latitude Of Catch
LONGITUDE
NUMBER 		Longitude Of Catch
ID
NUMBER 		Sequential Key
CONVENTIONAL_TAG_AGENCY
VARCHAR2 		Agency Providing COnvential Tags
CONVENTIONAL_TAG_ID
VARCHAR2 		Convential Tag Number
LENGTH_DET
VARCHAR2 		How Length Was Determined
WEIGHT_DET
VARCHAR2 		How Weight Was Determined

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

View Of Raw Catch Details
Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Catch
None Detail
None Torunament

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: RBS
Description:

View Of Raw Catch Details

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Tournament Code
100
 FISHING_DATE DATE Fishing Date
100
 SPECIES_ID VARCHAR2 Mnemonic Species Code
100
 LENGTH_CM FLOAT Length In Centimeters
100
 LENGTH_TYPE VARCHAR2 Length Type (How length was measured)
100
 WEIGHT_KG FLOAT Weight In kilograms
100
 WEIGHT_TYPE VARCHAR2 Weight Type (How weight was measured)
100
 SEX VARCHAR2 Sex f Fish Caught
100
 BOAT_NAME VARCHAR2 Boat Name
100
 BAIT VARCHAR2 Kind Of Bait Used
100
 FISHING_TECHNIQUE VARCHAR2 Technique Used For Fishing
100
 HOOK_TYPE VARCHAR2 Type Of Hook Used
100
 CATCH_DISPOSITION VARCHAR2 How as catch disposed
100
 RELEASE_DISPOSITION VARCHAR2 Disposition Of released fish
100
 LATITUDE NUMBER Latitude Of Catch
100
 LONGITUDE NUMBER Longitude Of Catch
100
 ID NUMBER Sequential Key
100
 CONVENTIONAL_TAG_AGENCY VARCHAR2 Agency Providing COnvential Tags
100
 CONVENTIONAL_TAG_ID VARCHAR2 Convential Tag Number
100
 LENGTH_DET VARCHAR2 How Length Was Determined
100
 WEIGHT_DET VARCHAR2 How Weight Was Determined

Attribute Details

TOURNAMENT_CODE

CC ID: 20647
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Tournament Code
General Data Type: NUMBER

FISHING_DATE

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

Fishing Date
General Data Type: DATE

SPECIES_ID

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

Mnemonic Species Code
General Data Type: VARCHAR2

LENGTH_CM

CC ID: 20630
Seq. Order: 4
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Status: Active
Description:

Length In Centimeters
General Data Type: FLOAT

LENGTH_TYPE

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

Length Type (How length was measured)
General Data Type: VARCHAR2

WEIGHT_KG

CC ID: 20639
Seq. Order: 6
Data Storage Type: FLOAT
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Status: Active
Description:

Weight In kilograms
General Data Type: FLOAT

WEIGHT_TYPE

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

Weight Type (How weight was measured)
General Data Type: VARCHAR2

SEX

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

Sex f Fish Caught
General Data Type: VARCHAR2

BOAT_NAME

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

Boat Name
General Data Type: VARCHAR2

BAIT

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

Kind Of Bait Used
General Data Type: VARCHAR2

FISHING_TECHNIQUE

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

Technique Used For Fishing
General Data Type: VARCHAR2

HOOK_TYPE

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

Type Of Hook Used
General Data Type: VARCHAR2

CATCH_DISPOSITION

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

How as catch disposed
General Data Type: VARCHAR2

RELEASE_DISPOSITION

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

Disposition Of released fish
General Data Type: VARCHAR2

LATITUDE

CC ID: 20642
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude Of Catch
General Data Type: NUMBER

LONGITUDE

CC ID: 20643
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Longitude Of Catch
General Data Type: NUMBER

ID

CC ID: 20638
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Sequential Key
General Data Type: NUMBER

CONVENTIONAL_TAG_AGENCY

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

Agency Providing COnvential Tags
General Data Type: VARCHAR2

CONVENTIONAL_TAG_ID

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

Convential Tag Number
General Data Type: VARCHAR2

LENGTH_DET

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

How Length Was Determined
General Data Type: VARCHAR2

WEIGHT_DET

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

How Weight Was Determined
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6243
GUID: gov.noaa.nmfs.inport:6243
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-11-02 09:24+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