Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

Table: CATCH_DETAILS

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6226 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Keywords

Entity Info

Data Attributes

Catalog Details

Abstract

Provides Detailed Information On Each Reported Catch

Description

Provides Detailed Information On Each Reported Catch

Entity Type
Data Table

Data Attribute / Type	Description
TOURNAMENT_CODE NUMBER	Foriegn key To Specify The Tournament where the catch took place
FISHING_DATE DATE	Date Fishing Took Place
SPECIES_ID VARCHAR2	Mnemonic Species Code
LENGTH_CM FLOAT	Length Of Catch In Centimeters
LENGTH_TYPE VARCHAR2	Method Of How Length was measured
WEIGHT_KG FLOAT	Weight Of catch in kilograms
WEIGHT_TYPE VARCHAR2	Type Of weight Of the catch
SEX VARCHAR2	The sex of the individual catch.
BOAT_NAME VARCHAR2	Name of Boat Used For Catch
BAIT VARCHAR2	Bait Used For The catch
FISHING_TECHNIQUE VARCHAR2	Techniue of fishing used for the catch
HOOK_TYPE VARCHAR2	Type Of Hook Used For Catch
CATCH_DISPOSITION VARCHAR2	How was catch disposed of
RELEASE_DISPOSITION VARCHAR2	If it was released, how was it released
LATITUDE NUMBER	Latitude of where catch was made
LONGITUDE NUMBER	Longitude of where catch was made
ID NUMBER	Sequential Key to this table
CONVENTIONAL_TAG_AGENCY VARCHAR2	If there was a conventional tagging action on this catch, what is the tagging agency
CONVENTIONAL_TAG_ID VARCHAR2	If there was a conventional tagging action on this catch, what is the tag number
LENGTH_DET VARCHAR2	How was Length Determined/Measured
WEIGHT_DET VARCHAR2	How was Weight Determined/Measured

Data Attribute / Type

Description

TOURNAMENT_CODE
NUMBER

Foriegn key To Specify The Tournament where the catch took place

FISHING_DATE
DATE

Date Fishing Took Place

SPECIES_ID
VARCHAR2

Mnemonic Species Code

LENGTH_CM
FLOAT

Length Of Catch In Centimeters

LENGTH_TYPE
VARCHAR2

Method Of How Length was measured

WEIGHT_KG
FLOAT

Weight Of catch in kilograms

WEIGHT_TYPE
VARCHAR2

Type Of weight Of the catch

SEX
VARCHAR2

The sex of the individual catch.

BOAT_NAME
VARCHAR2

Name of Boat Used For Catch

BAIT
VARCHAR2

Bait Used For The catch

FISHING_TECHNIQUE
VARCHAR2

Techniue of fishing used for the catch

HOOK_TYPE
VARCHAR2

Type Of Hook Used For Catch

CATCH_DISPOSITION
VARCHAR2

How was catch disposed of

RELEASE_DISPOSITION
VARCHAR2

If it was released, how was it released

LATITUDE
NUMBER

Latitude of where catch was made

LONGITUDE
NUMBER

Longitude of where catch was made

ID
NUMBER

Sequential Key to this table

CONVENTIONAL_TAG_AGENCY
VARCHAR2

If there was a conventional tagging action on this catch, what is the tagging agency

CONVENTIONAL_TAG_ID
VARCHAR2

If there was a conventional tagging action on this catch, what is the tag number

LENGTH_DET
VARCHAR2

How was Length Determined/Measured

WEIGHT_DET
VARCHAR2

How was Weight Determined/Measured

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: CATCH_DETAILS
Short Name:	CATCH_DETAILS
Status:	Completed
Abstract:	Provides Detailed Information On Each Reported Catch
Notes:	Loaded by batch 1863, 11-02-2007 09:24

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Landings
None	Tournaments

Thesaurus

Keyword

UNCONTROLLED

None

Landings

None

Tournaments

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	RBS
Description:	Provides Detailed Information On Each Reported Catch

Attribute Summary

	Name	Type	Description
100	TOURNAMENT_CODE	NUMBER	Foriegn key To Specify The Tournament where the catch took place
100	FISHING_DATE	DATE	Date Fishing Took Place
100	SPECIES_ID	VARCHAR2	Mnemonic Species Code
100	LENGTH_CM	FLOAT	Length Of Catch In Centimeters
100	LENGTH_TYPE	VARCHAR2	Method Of How Length was measured
100	WEIGHT_KG	FLOAT	Weight Of catch in kilograms
100	WEIGHT_TYPE	VARCHAR2	Type Of weight Of the catch
100	SEX	VARCHAR2	The sex of the individual catch.
100	BOAT_NAME	VARCHAR2	Name of Boat Used For Catch
100	BAIT	VARCHAR2	Bait Used For The catch
100	FISHING_TECHNIQUE	VARCHAR2	Techniue of fishing used for the catch
100	HOOK_TYPE	VARCHAR2	Type Of Hook Used For Catch
100	CATCH_DISPOSITION	VARCHAR2	How was catch disposed of
100	RELEASE_DISPOSITION	VARCHAR2	If it was released, how was it released
100	LATITUDE	NUMBER	Latitude of where catch was made
100	LONGITUDE	NUMBER	Longitude of where catch was made
100	ID	NUMBER	Sequential Key to this table
100	CONVENTIONAL_TAG_AGENCY	VARCHAR2	If there was a conventional tagging action on this catch, what is the tagging agency
100	CONVENTIONAL_TAG_ID	VARCHAR2	If there was a conventional tagging action on this catch, what is the tag number
100	LENGTH_DET	VARCHAR2	How was Length Determined/Measured
100	WEIGHT_DET	VARCHAR2	How was Weight Determined/Measured

Name

Type

Description

100

TOURNAMENT_CODE

NUMBER

Foriegn key To Specify The Tournament where the catch took place

100

FISHING_DATE

DATE

Date Fishing Took Place

100

SPECIES_ID

VARCHAR2

Mnemonic Species Code

100

LENGTH_CM

FLOAT

Length Of Catch In Centimeters

100

LENGTH_TYPE

VARCHAR2

Method Of How Length was measured

100

WEIGHT_KG

FLOAT

Weight Of catch in kilograms

100

WEIGHT_TYPE

VARCHAR2

Type Of weight Of the catch

100

SEX

VARCHAR2

The sex of the individual catch.

100

BOAT_NAME

VARCHAR2

Name of Boat Used For Catch

100

BAIT

VARCHAR2

Bait Used For The catch

100

FISHING_TECHNIQUE

VARCHAR2

Techniue of fishing used for the catch

100

HOOK_TYPE

VARCHAR2

Type Of Hook Used For Catch

100

CATCH_DISPOSITION

VARCHAR2

How was catch disposed of

100

RELEASE_DISPOSITION

VARCHAR2

If it was released, how was it released

100

LATITUDE

NUMBER

Latitude of where catch was made

100

LONGITUDE

NUMBER

Longitude of where catch was made

100

NUMBER

Sequential Key to this table

100

CONVENTIONAL_TAG_AGENCY

VARCHAR2

If there was a conventional tagging action on this catch, what is the tagging agency

100

CONVENTIONAL_TAG_ID

VARCHAR2

If there was a conventional tagging action on this catch, what is the tag number

100

LENGTH_DET

VARCHAR2

How was Length Determined/Measured

100

WEIGHT_DET

VARCHAR2

How was Weight Determined/Measured

Attribute Details

TOURNAMENT_CODE

CC ID: 20521

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Foriegn key To Specify The Tournament where the catch took place
General Data Type:	NUMBER

FISHING_DATE

CC ID: 20522

Seq. Order:	2
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date Fishing Took Place
General Data Type:	DATE

SPECIES_ID

CC ID: 20523

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

Seq. Order:	4
Data Storage Type:	FLOAT
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Status:	Active
Description:	Length Of Catch In Centimeters
General Data Type:	FLOAT

LENGTH_TYPE

CC ID: 20525

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Method Of How Length was measured
General Data Type:	VARCHAR2

WEIGHT_KG

CC ID: 20526

Seq. Order:	6
Data Storage Type:	FLOAT
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Status:	Active
Description:	Weight Of catch in kilograms
General Data Type:	FLOAT

WEIGHT_TYPE

CC ID: 20527

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Type Of weight Of the catch
General Data Type:	VARCHAR2

SEX

CC ID: 20528

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The sex of the individual catch.
General Data Type:	VARCHAR2

BOAT_NAME

CC ID: 20529

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Name of Boat Used For Catch
General Data Type:	VARCHAR2

BAIT

CC ID: 20530

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Bait Used For The catch
General Data Type:	VARCHAR2

FISHING_TECHNIQUE

CC ID: 20531

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Techniue of fishing used for the catch
General Data Type:	VARCHAR2

HOOK_TYPE

CC ID: 20532

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Type Of Hook Used For Catch
General Data Type:	VARCHAR2

CATCH_DISPOSITION

CC ID: 20533

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	How was catch disposed of
General Data Type:	VARCHAR2

RELEASE_DISPOSITION

CC ID: 20534

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	If it was released, how was it released
General Data Type:	VARCHAR2

LATITUDE

CC ID: 20535

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Latitude of where catch was made
General Data Type:	NUMBER

LONGITUDE

CC ID: 20536

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Longitude of where catch was made
General Data Type:	NUMBER

ID

CC ID: 20537

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	38
Status:	Active
Description:	Sequential Key to this table
General Data Type:	NUMBER

CONVENTIONAL_TAG_AGENCY

CC ID: 20538

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	If there was a conventional tagging action on this catch, what is the tagging agency
General Data Type:	VARCHAR2

CONVENTIONAL_TAG_ID

CC ID: 20539

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	If there was a conventional tagging action on this catch, what is the tag number
General Data Type:	VARCHAR2

LENGTH_DET

CC ID: 20540

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	How was Length Determined/Measured
General Data Type:	VARCHAR2

WEIGHT_DET

CC ID: 20541

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	How was Weight Determined/Measured
General Data Type:	VARCHAR2

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

Table: CATCH_DETAILS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Keywords

Theme Keywords

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TOURNAMENT_CODE

FISHING_DATE

SPECIES_ID

LENGTH_CM

LENGTH_TYPE

WEIGHT_KG

WEIGHT_TYPE

SEX

BOAT_NAME

BAIT

FISHING_TECHNIQUE

HOOK_TYPE

CATCH_DISPOSITION

RELEASE_DISPOSITION

LATITUDE

LONGITUDE

ID

CONVENTIONAL_TAG_AGENCY

CONVENTIONAL_TAG_ID

LENGTH_DET

WEIGHT_DET

Catalog Details