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) >

Table: TOURNAMENT_CATCH_SUMMARY

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

Summary

Abstract

Provides Summary Statistics For a Tournament

Description

Provides Summary Statistics For a Tournament

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Tournament Code (Link to Tournament table)
TOURNAMENT_YEAR
NUMBER 		Year of the tournament
REPORT_RECEIVED_DATE
DATE 		Date Report Recieved
SPECIES_ID
VARCHAR2 		Mnemonic Species Code
NUMBER_KEPT
NUMBER 		Number kept
NUMBER_LOST
NUMBER 		Number Lost
NUMBER_TAGGED
NUMBER 		Number Tagged
NUMBER_NOT_TAGGED
NUMBER 		Number Not tagged
NUMBER_DEAD
NUMBER 		Number Dead
TOTAL_FISH
NUMBER 		Total Number Of Fish
ID
NUMBER 		Sequential Key

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: Table: TOURNAMENT_CATCH_SUMMARY
Short Name: TOURNAMENT_CATCH_SUMMARY
Status: Completed
Abstract:

Provides Summary Statistics For a Tournament
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Catch Summary
None Tournament

Entity Information

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

Provides Summary Statistics For a Tournament

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Tournament Code (Link to Tournament table)
100
 TOURNAMENT_YEAR NUMBER Year of the tournament
100
 REPORT_RECEIVED_DATE DATE Date Report Recieved
100
 SPECIES_ID VARCHAR2 Mnemonic Species Code
100
 NUMBER_KEPT NUMBER Number kept
100
 NUMBER_LOST NUMBER Number Lost
100
 NUMBER_TAGGED NUMBER Number Tagged
100
 NUMBER_NOT_TAGGED NUMBER Number Not tagged
100
 NUMBER_DEAD NUMBER Number Dead
100
 TOTAL_FISH NUMBER Total Number Of Fish
100
 Primary Key ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

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

Tournament Code (Link to Tournament table)
General Data Type: NUMBER

TOURNAMENT_YEAR

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

Year of the tournament
General Data Type: NUMBER

REPORT_RECEIVED_DATE

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

Date Report Recieved
General Data Type: DATE

SPECIES_ID

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

Mnemonic Species Code
General Data Type: VARCHAR2

NUMBER_KEPT

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

Number kept
General Data Type: NUMBER

NUMBER_LOST

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

Number Lost
General Data Type: NUMBER

NUMBER_TAGGED

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

Number Tagged
General Data Type: NUMBER

NUMBER_NOT_TAGGED

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

Number Not tagged
General Data Type: NUMBER

NUMBER_DEAD

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

Number Dead
General Data Type: NUMBER

TOTAL_FISH

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

Total Number Of Fish
General Data Type: NUMBER

ID

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

Sequential Key
General Data Type: NUMBER

Catalog Details

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