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

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

Summary

Abstract

View Of Summary Data

Description

View Of Summary Data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Code to indicate the tournament
TOURNAMENT_YEAR
NUMBER 		Year Of The Tournament
REPORT_RECEIVED_DATE
DATE 		Year Report Received
RECORDER_NAME
VARCHAR2 		Name Of Tournament Recorder
RECORDER_PHONE
VARCHAR2 		Phone Number Of Recorder
FISHING_DATE_START
DATE 		Fishing Start Date
FISHING_DATE_END
DATE 		Fishing End Date
TOURNAMENT_DISPOSITION
VARCHAR2 		How The Tournament Ended
BOATS
NUMBER 		Number Of Boats
FISHING_TIME
NUMBER 		Time Spent Fishing
TOTAL_EFFORT
NUMBER 		Total Effort
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

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

View Of Summary Data
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Summary Data
None Tournaments

Entity Information

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

View Of Summary Data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Code to indicate the tournament
100
 TOURNAMENT_YEAR NUMBER Year Of The Tournament
100
 REPORT_RECEIVED_DATE DATE Year Report Received
100
 RECORDER_NAME VARCHAR2 Name Of Tournament Recorder
100
 RECORDER_PHONE VARCHAR2 Phone Number Of Recorder
100
 FISHING_DATE_START DATE Fishing Start Date
100
 FISHING_DATE_END DATE Fishing End Date
100
 TOURNAMENT_DISPOSITION VARCHAR2 How The Tournament Ended
100
 BOATS NUMBER Number Of Boats
100
 FISHING_TIME NUMBER Time Spent Fishing
100
 TOTAL_EFFORT NUMBER Total Effort
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

Attribute Details

TOURNAMENT_CODE

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

Code to indicate the tournament
General Data Type: NUMBER

TOURNAMENT_YEAR

CC ID: 20728
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: 20727
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Year Report Received
General Data Type: DATE

RECORDER_NAME

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

Name Of Tournament Recorder
General Data Type: VARCHAR2

RECORDER_PHONE

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

Phone Number Of Recorder
General Data Type: VARCHAR2

FISHING_DATE_START

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

Fishing Start Date
General Data Type: DATE

FISHING_DATE_END

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

Fishing End Date
General Data Type: DATE

TOURNAMENT_DISPOSITION

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

How The Tournament Ended
General Data Type: VARCHAR2

BOATS

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

Number Of Boats
General Data Type: NUMBER

FISHING_TIME

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

Time Spent Fishing
General Data Type: NUMBER

TOTAL_EFFORT

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

Total Effort
General Data Type: NUMBER

SPECIES_ID

CC ID: 20712
Seq. Order: 12
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: 20716
Seq. Order: 13
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: 20724
Seq. Order: 14
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: 20715
Seq. Order: 15
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: 20718
Seq. Order: 16
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: 20717
Seq. Order: 17
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: 20725
Seq. Order: 18
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

Catalog Details

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