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

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

Summary

Abstract

View providing Detailed Tournament Summary

Description

View providing Detailed Tournament Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ICCAT
VARCHAR2 		ICCAT Area Code
STATE
VARCHAR2 		State Where tournament took place
SOURCE
VARCHAR2 		Source Of Survey
CODE
NUMBER 		Tournament Code
YEAR
NUMBER 		Year When tournament took place
MONTH
VARCHAR2 		Month when tournament took place
START_DATE
DATE 		Date Fishing Started
END_DATE
DATE 		Date Fishing Ended
SPECIES
VARCHAR2 		Mnemonic Species Code
CATCH
NUMBER 		Number Caught
KEPT
NUMBER 		Number Kept
DEAD
NUMBER 		Number Dead
RELEASED
NUMBER 		Number Released
WEIGHT_COUNT
NUMBER 		Number with Weight Information
WEIGHT_SUM
NUMBER 		Summary of Weighs When Weight Information is provided
MISSING
NUMBER 		Records Missing Information

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

View providing Detailed Tournament Summary
Notes:

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

Entity Information

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

View providing Detailed Tournament Summary

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ICCAT VARCHAR2 ICCAT Area Code
100
 STATE VARCHAR2 State Where tournament took place
100
 SOURCE VARCHAR2 Source Of Survey
100
 CODE NUMBER Tournament Code
100
 YEAR NUMBER Year When tournament took place
100
 MONTH VARCHAR2 Month when tournament took place
100
 START_DATE DATE Date Fishing Started
100
 END_DATE DATE Date Fishing Ended
100
 SPECIES VARCHAR2 Mnemonic Species Code
100
 CATCH NUMBER Number Caught
100
 KEPT NUMBER Number Kept
100
 DEAD NUMBER Number Dead
100
 RELEASED NUMBER Number Released
100
 WEIGHT_COUNT NUMBER Number with Weight Information
100
 WEIGHT_SUM NUMBER Summary of Weighs When Weight Information is provided
100
 MISSING NUMBER Records Missing Information

Attribute Details

ICCAT

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

ICCAT Area Code
General Data Type: VARCHAR2

STATE

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

State Where tournament took place
General Data Type: VARCHAR2

SOURCE

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

Source Of Survey
General Data Type: VARCHAR2

CODE

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

Tournament Code
General Data Type: NUMBER

YEAR

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

Year When tournament took place
General Data Type: NUMBER

MONTH

CC ID: 20859
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month when tournament took place
General Data Type: VARCHAR2

START_DATE

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

Date Fishing Started
General Data Type: DATE

END_DATE

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

Date Fishing Ended
General Data Type: DATE

SPECIES

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

Mnemonic Species Code
General Data Type: VARCHAR2

CATCH

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

Number Caught
General Data Type: NUMBER

KEPT

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

Number Kept
General Data Type: NUMBER

DEAD

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

Number Dead
General Data Type: NUMBER

RELEASED

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

Number Released
General Data Type: NUMBER

WEIGHT_COUNT

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

Number with Weight Information
General Data Type: NUMBER

WEIGHT_SUM

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

Summary of Weighs When Weight Information is provided
General Data Type: NUMBER

MISSING

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

Records Missing Information
General Data Type: NUMBER

Catalog Details

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