Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Listing Effort By Tournament

Description

View Listing Effort By Tournament

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_NAME
VARCHAR2
Name Of The tournament
TOURNAMENT_CODE
NUMBER
Tournament Code
CREATION_DATE
DATE
Creation Date
ANNUAL_REGISTRATION_DATE
DATE
Annual registration Date
START_DATE
DATE
Tournament Start Date
END_DATE
DATE
Tournament End Date
TOURNAMENT_YEAR
NUMBER
Year Tournament Took Place
TERMINATION_DATE
DATE
Termination Date
LATITUDE
NUMBER
Latitude Where Tournament Took Place
LONGITUDE
NUMBER
Longitude Where Tournament Took Place
CITY
VARCHAR2
City Of Tournament
STATE
VARCHAR2
State Where tournament was held
COUNTRY
VARCHAR2
Country Where Tournament Was Held
ICCAT_AREA
VARCHAR2
ICCAT Area Of Reporting
TOURNAMENT_TYPE
VARCHAR2
Tpe Of Tournament
HOOK_RESTRICTIONS
VARCHAR2
Restrictions On Hook usage
BAIT_RESTRICTIONS
VARCHAR2
Restrictions On Bait usage
SURVEY_SOURCE
VARCHAR2
Source OfInformation From This tournament
SUMMARY_REPORT
VARCHAR2
Was A Summary Report Received
DIRECTOR_NAME
VARCHAR2
Name Of Director
DIRECTOR_ADDRESS
VARCHAR2
First Line Of Address Of DIrector
DIRECTOR_ADDRESS2
VARCHAR2
Second Line Of Address Of Director
DIRECTOR_CITY
VARCHAR2
CIty in Address Of Director
DIRECTOR_STATE
VARCHAR2
State In Address Of Director
DIRECTOR_ZIP
VARCHAR2
Zip Code Of Director
DIRECTOR_COUNTRY
VARCHAR2
Country In Address Of Director
DIRECTOR_PHONE
VARCHAR2
Office Number Of Director
DIRECTOR_FAX
VARCHAR2
Fax Number Of Director
DIRECTOR_MOBILE
VARCHAR2
Mobile/Cellular Number Of Director
DIRECTOR_EMAIL
VARCHAR2
Email Address Of Director
DIRECTOR_WEB_URL
VARCHAR2
Tournament url
CLUB_SPONSOR
VARCHAR2
Sponsor Of The Tournament
COMMENTS
VARCHAR2
Any Extra Comments about the tournament including all information Associated With it
REGISTRATION_ID
NUMBER
To Lookup Registration Information
EFFORT_TOURNAMENT_CODE
NUMBER
Tournament Number
EFFORT_TOURNAMENT_YEAR
NUMBER
Year Of Tournament
REPORT_COUNT
NUMBER
Number Of Reports Received
MAX_REPORT_DATE
DATE
Date Report Was Received
FISHING_DATE_START
DATE
Date Fishing Started
FISHING_DATE_END
DATE
Date Fishing Ended
BOATS
NUMBER
Number Of Boats
FISHING_TIME
NUMBER
Total Fishing Time
TOTAL_EFFORT
NUMBER
Total Fishing Effort
TOURNAMENT_DISPOSITION
VARCHAR2
How The Tournament FInsished

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

View Listing Effort By Tournament

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Effort
None Tournaments

Entity Information

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

View Listing Effort By Tournament

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TOURNAMENT_NAME VARCHAR2 Name Of The tournament
100
TOURNAMENT_CODE NUMBER Tournament Code
100
CREATION_DATE DATE Creation Date
100
ANNUAL_REGISTRATION_DATE DATE Annual registration Date
100
START_DATE DATE Tournament Start Date
100
END_DATE DATE Tournament End Date
100
TOURNAMENT_YEAR NUMBER Year Tournament Took Place
100
TERMINATION_DATE DATE Termination Date
100
LATITUDE NUMBER Latitude Where Tournament Took Place
100
LONGITUDE NUMBER Longitude Where Tournament Took Place
100
CITY VARCHAR2 City Of Tournament
100
STATE VARCHAR2 State Where tournament was held
100
COUNTRY VARCHAR2 Country Where Tournament Was Held
100
ICCAT_AREA VARCHAR2 ICCAT Area Of Reporting
100
TOURNAMENT_TYPE VARCHAR2 Tpe Of Tournament
100
HOOK_RESTRICTIONS VARCHAR2 Restrictions On Hook usage
100
BAIT_RESTRICTIONS VARCHAR2 Restrictions On Bait usage
100
SURVEY_SOURCE VARCHAR2 Source OfInformation From This tournament
100
SUMMARY_REPORT VARCHAR2 Was A Summary Report Received
100
DIRECTOR_NAME VARCHAR2 Name Of Director
100
DIRECTOR_ADDRESS VARCHAR2 First Line Of Address Of DIrector
100
DIRECTOR_ADDRESS2 VARCHAR2 Second Line Of Address Of Director
100
DIRECTOR_CITY VARCHAR2 CIty in Address Of Director
100
DIRECTOR_STATE VARCHAR2 State In Address Of Director
100
DIRECTOR_ZIP VARCHAR2 Zip Code Of Director
100
DIRECTOR_COUNTRY VARCHAR2 Country In Address Of Director
100
DIRECTOR_PHONE VARCHAR2 Office Number Of Director
100
DIRECTOR_FAX VARCHAR2 Fax Number Of Director
100
DIRECTOR_MOBILE VARCHAR2 Mobile/Cellular Number Of Director
100
DIRECTOR_EMAIL VARCHAR2 Email Address Of Director
100
DIRECTOR_WEB_URL VARCHAR2 Tournament url
100
CLUB_SPONSOR VARCHAR2 Sponsor Of The Tournament
100
COMMENTS VARCHAR2 Any Extra Comments about the tournament including all information Associated With it
100
REGISTRATION_ID NUMBER To Lookup Registration Information
100
EFFORT_TOURNAMENT_CODE NUMBER Tournament Number
100
EFFORT_TOURNAMENT_YEAR NUMBER Year Of Tournament
100
REPORT_COUNT NUMBER Number Of Reports Received
100
MAX_REPORT_DATE DATE Date Report Was Received
100
FISHING_DATE_START DATE Date Fishing Started
100
FISHING_DATE_END DATE Date Fishing Ended
100
BOATS NUMBER Number Of Boats
100
FISHING_TIME NUMBER Total Fishing Time
100
TOTAL_EFFORT NUMBER Total Fishing Effort
100
TOURNAMENT_DISPOSITION VARCHAR2 How The Tournament FInsished

Attribute Details

TOURNAMENT_NAME

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

Name Of The tournament

General Data Type: VARCHAR2

TOURNAMENT_CODE

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

Tournament Code

General Data Type: NUMBER

CREATION_DATE

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

Creation Date

General Data Type: DATE

ANNUAL_REGISTRATION_DATE

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

Annual registration Date

General Data Type: DATE

START_DATE

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

Tournament Start Date

General Data Type: DATE

END_DATE

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

Tournament End Date

General Data Type: DATE

TOURNAMENT_YEAR

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

Year Tournament Took Place

General Data Type: NUMBER

TERMINATION_DATE

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

Termination Date

General Data Type: DATE

LATITUDE

CC ID: 20927
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Latitude Where Tournament Took Place

General Data Type: NUMBER

LONGITUDE

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

Longitude Where Tournament Took Place

General Data Type: NUMBER

CITY

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

City Of Tournament

General Data Type: VARCHAR2

STATE

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

State Where tournament was held

General Data Type: VARCHAR2

COUNTRY

CC ID: 20950
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Country Where Tournament Was Held

General Data Type: VARCHAR2

ICCAT_AREA

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

ICCAT Area Of Reporting

General Data Type: VARCHAR2

TOURNAMENT_TYPE

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

Tpe Of Tournament

General Data Type: VARCHAR2

HOOK_RESTRICTIONS

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

Restrictions On Hook usage

General Data Type: VARCHAR2

BAIT_RESTRICTIONS

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

Restrictions On Bait usage

General Data Type: VARCHAR2

SURVEY_SOURCE

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

Source OfInformation From This tournament

General Data Type: VARCHAR2

SUMMARY_REPORT

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

Was A Summary Report Received

General Data Type: VARCHAR2

DIRECTOR_NAME

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

Name Of Director

General Data Type: VARCHAR2

DIRECTOR_ADDRESS

CC ID: 20956
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

First Line Of Address Of DIrector

General Data Type: VARCHAR2

DIRECTOR_ADDRESS2

CC ID: 20953
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Second Line Of Address Of Director

General Data Type: VARCHAR2

DIRECTOR_CITY

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

CIty in Address Of Director

General Data Type: VARCHAR2

DIRECTOR_STATE

CC ID: 20939
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

State In Address Of Director

General Data Type: VARCHAR2

DIRECTOR_ZIP

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

Zip Code Of Director

General Data Type: VARCHAR2

DIRECTOR_COUNTRY

CC ID: 20952
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Country In Address Of Director

General Data Type: VARCHAR2

DIRECTOR_PHONE

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

Office Number Of Director

General Data Type: VARCHAR2

DIRECTOR_FAX

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

Fax Number Of Director

General Data Type: VARCHAR2

DIRECTOR_MOBILE

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

Mobile/Cellular Number Of Director

General Data Type: VARCHAR2

DIRECTOR_EMAIL

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

Email Address Of Director

General Data Type: VARCHAR2

DIRECTOR_WEB_URL

CC ID: 20944
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Tournament url

General Data Type: VARCHAR2

CLUB_SPONSOR

CC ID: 20937
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Sponsor Of The Tournament

General Data Type: VARCHAR2

COMMENTS

CC ID: 20935
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Any Extra Comments about the tournament including all information Associated With it

General Data Type: VARCHAR2

REGISTRATION_ID

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

To Lookup Registration Information

General Data Type: NUMBER

EFFORT_TOURNAMENT_CODE

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

Tournament Number

General Data Type: NUMBER

EFFORT_TOURNAMENT_YEAR

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

Year Of Tournament

General Data Type: NUMBER

REPORT_COUNT

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

Number Of Reports Received

General Data Type: NUMBER

MAX_REPORT_DATE

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

Date Report Was Received

General Data Type: DATE

FISHING_DATE_START

CC ID: 20954
Seq. Order: 39
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: 20958
Seq. Order: 40
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date Fishing Ended

General Data Type: DATE

BOATS

CC ID: 20940
Seq. Order: 41
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: 20959
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total Fishing Time

General Data Type: NUMBER

TOTAL_EFFORT

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

Total Fishing Effort

General Data Type: NUMBER

TOURNAMENT_DISPOSITION

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

How The Tournament FInsished

General Data Type: VARCHAR2

Catalog Details

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