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_TOURNAMENT_EFFORT_SUM_V

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

Summary

Abstract

View Summarizing Raw Tournament Effort

Description

View Summarizing Raw Tournament Effort

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Tournament Code
TOURNAMENT_YEAR
NUMBER 		Tournament Year
TOURNAMENT_DISPOSITION
VARCHAR2 		Tournament Disposition
BOATS
NUMBER 		Total Number If Boats
FISHING_TIME
NUMBER 		Time Fished
TOTAL_EFFORT
NUMBER 		Total Effort
REPORT_RECEIVED_DATE
DATE 		Date Report was Report Received
RECORDER_NAME
VARCHAR2 		Name Of Recorder
RECORDER_PHONE
VARCHAR2 		Recorder Phone Number
FISHING_DATE_START
DATE 		Date Fishing Started
FISHING_DATE_END
DATE 		Date Fishing Ended
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: View: RAW_TOURNAMENT_EFFORT_SUM_V
Short Name: RAW_TOURNAMENT_EFFORT_SUM_V
Status: Completed
Abstract:

View Summarizing Raw Tournament Effort
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None tournament summary data

Entity Information

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

View Summarizing Raw Tournament Effort

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Tournament Code
100
 TOURNAMENT_YEAR NUMBER Tournament Year
100
 TOURNAMENT_DISPOSITION VARCHAR2 Tournament Disposition
100
 BOATS NUMBER Total Number If Boats
100
 FISHING_TIME NUMBER Time Fished
100
 TOTAL_EFFORT NUMBER Total Effort
100
 REPORT_RECEIVED_DATE DATE Date Report was Report Received
100
 RECORDER_NAME VARCHAR2 Name Of Recorder
100
 RECORDER_PHONE VARCHAR2 Recorder Phone Number
100
 FISHING_DATE_START DATE Date Fishing Started
100
 FISHING_DATE_END DATE Date Fishing Ended
100
 ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

CC ID: 20669
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

TOURNAMENT_YEAR

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

Tournament Year
General Data Type: NUMBER

TOURNAMENT_DISPOSITION

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

Tournament Disposition
General Data Type: VARCHAR2

BOATS

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

Total Number If Boats
General Data Type: NUMBER

FISHING_TIME

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

Time Fished
General Data Type: NUMBER

TOTAL_EFFORT

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

Total Effort
General Data Type: NUMBER

REPORT_RECEIVED_DATE

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

Date Report was Report Received
General Data Type: DATE

RECORDER_NAME

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

Name Of Recorder
General Data Type: VARCHAR2

RECORDER_PHONE

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

Recorder Phone Number
General Data Type: VARCHAR2

FISHING_DATE_START

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

Date Fishing Started
General Data Type: DATE

FISHING_DATE_END

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

Date Fishing Ended
General Data Type: DATE

ID

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

Sequential Key
General Data Type: NUMBER

Catalog Details

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