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

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

Summary

Abstract

View Of Effort Summary

Description

View Of Effort Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
EFFORT_TOURNAMENT_CODE
NUMBER 		Tournament Code
EFFORT_TOURNAMENT_YEAR
NUMBER 		Tournament Year
REPORT_COUNT
NUMBER 		Total Number of Records
MAX_REPORT_DATE
DATE 		Latest Reporting Date
FISHING_DATE_START
DATE 		Fishing Start Daye
FISHING_DATE_END
DATE 		Fishing End Date
BOATS
NUMBER 		Number Of Boats
FISHING_TIME
NUMBER 		Time Fished
TOTAL_EFFORT
NUMBER 		Total Effort
TOURNAMENT_DISPOSITION
VARCHAR2 		How Tournament Ended

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

View Of Effort Summary
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Effort Data
None Summary Data

Entity Information

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

View Of Effort Summary

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 EFFORT_TOURNAMENT_CODE NUMBER Tournament Code
100
 EFFORT_TOURNAMENT_YEAR NUMBER Tournament Year
100
 REPORT_COUNT NUMBER Total Number of Records
100
 MAX_REPORT_DATE DATE Latest Reporting Date
100
 FISHING_DATE_START DATE Fishing Start Daye
100
 FISHING_DATE_END DATE Fishing End Date
100
 BOATS NUMBER Number Of Boats
100
 FISHING_TIME NUMBER Time Fished
100
 TOTAL_EFFORT NUMBER Total Effort
100
 TOURNAMENT_DISPOSITION VARCHAR2 How Tournament Ended

Attribute Details

EFFORT_TOURNAMENT_CODE

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

EFFORT_TOURNAMENT_YEAR

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

REPORT_COUNT

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

Total Number of Records
General Data Type: NUMBER

MAX_REPORT_DATE

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

Latest Reporting Date
General Data Type: DATE

FISHING_DATE_START

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

Fishing Start Daye
General Data Type: DATE

FISHING_DATE_END

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

Fishing End Date
General Data Type: DATE

BOATS

CC ID: 20595
Seq. Order: 7
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: 20596
Seq. Order: 8
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: 20601
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total Effort
General Data Type: NUMBER

TOURNAMENT_DISPOSITION

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

How Tournament Ended
General Data Type: VARCHAR2

Catalog Details

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