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_EFFORT_SUMMARY

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

Summary

Abstract

Provides Summary Effort Information By Tournament

Description

Provides Summary Effort Information By Tournament

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER 		Foriegn Key To Tournament Table
TOURNAMENT_YEAR
NUMBER 		YearThe tournament took place
TOURNAMENT_DISPOSITION
VARCHAR2 		Valid Tournament DIsposition -- Validated Against Tournament _Disposition Code Table
BOATS
NUMBER 		Number Of Boats That participated In The tournament
FISHING_TIME
NUMBER 		Time spent fishing
TOTAL_EFFORT
NUMBER 		Total Effort For Tournament
REPORT_RECEIVED_DATE
DATE 		Date Tournament Report Was Received
RECORDER_NAME
VARCHAR2 		Person Who Recorded Data For The tournament
RECORDER_PHONE
VARCHAR2 		Phone Number of Data Recorder
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: Table: TOURNAMENT_EFFORT_SUMMARY
Short Name: TOURNAMENT_EFFORT_SUMMARY
Status: Completed
Abstract:

Provides Summary Effort Information By Tournament
Notes:

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

Entity Information

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

Provides Summary Effort Information By Tournament

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_CODE NUMBER Foriegn Key To Tournament Table
100
 TOURNAMENT_YEAR NUMBER YearThe tournament took place
100
 TOURNAMENT_DISPOSITION VARCHAR2 Valid Tournament DIsposition -- Validated Against Tournament _Disposition Code Table
100
 BOATS NUMBER Number Of Boats That participated In The tournament
100
 FISHING_TIME NUMBER Time spent fishing
100
 TOTAL_EFFORT NUMBER Total Effort For Tournament
100
 REPORT_RECEIVED_DATE DATE Date Tournament Report Was Received
100
 RECORDER_NAME VARCHAR2 Person Who Recorded Data For The tournament
100
 RECORDER_PHONE VARCHAR2 Phone Number of Data Recorder
100
 FISHING_DATE_START DATE Date Fishing Started
100
 FISHING_DATE_END DATE Date Fishing Ended
100
 Primary Key ID NUMBER Sequential Key

Attribute Details

TOURNAMENT_CODE

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

Foriegn Key To Tournament Table
General Data Type: NUMBER

TOURNAMENT_YEAR

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

YearThe tournament took place
General Data Type: NUMBER

TOURNAMENT_DISPOSITION

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

Valid Tournament DIsposition -- Validated Against Tournament _Disposition Code Table
General Data Type: VARCHAR2

BOATS

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

Number Of Boats That participated In The tournament
General Data Type: NUMBER

FISHING_TIME

CC ID: 20917
Seq. Order: 5
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: 20918
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total Effort For Tournament
General Data Type: NUMBER

REPORT_RECEIVED_DATE

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

Date Tournament Report Was Received
General Data Type: DATE

RECORDER_NAME

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

Person Who Recorded Data For The tournament
General Data Type: VARCHAR2

RECORDER_PHONE

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

Phone Number of Data Recorder
General Data Type: VARCHAR2

FISHING_DATE_START

CC ID: 20922
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: 20923
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: 20924
Seq. Order: 12
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: 6263
GUID: gov.noaa.nmfs.inport:6263
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