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

Summary

Abstract

Summary View Of Tournaments

Description

Summary View Of Tournaments

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_CODE
NUMBER
Tournament Code
TOURNAMENT_NAME
VARCHAR2
Name Of The tournament
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
CREATION_DATE
DATE
Creation Date
SURVEY_SOURCE
VARCHAR2
Source OfInformation From This tournament
ICCAT_AREA
VARCHAR2
ICCAT Area Of Reporting
TERMINATION_DATE
DATE
Termination Date
CLUB_SPONSOR
VARCHAR2
Sponsor Of The Tournament
START_DATE
DATE
Start Date Of Tournament
END_DATE
DATE
End Date Of tournament
ANNUAL_REGISTRATION_DATE
DATE
Date Tournament is Registered
TOURNAMENT_TYPE
VARCHAR2
Type Of Tournament
SUMMARY_REPORT
VARCHAR2
Was a Summary Report Provided
HOOK_RESTRICTIONS
VARCHAR2
Hook Restrictions For Tournament
BAIT_RESTRICTIONS
VARCHAR2
Bait Restrictions For Tournament
COMMENTS
VARCHAR2
Any Extra Comments about the tournament including all information Associated With it
DIRECTOR_NAME
VARCHAR2
Name Of Tournament Director
DIRECTOR_ADDRESS1
VARCHAR2
First Line Of Address Of DIrector
DIRECTOR_ADDRESS2
VARCHAR2
Second Line Of Address Of DIrector
DIRECTOR_CITY
VARCHAR2
City In Addess Of Director
DIRECTOR_STATE
VARCHAR2
State In Address Of Director
DIRECTOR_ZIP
VARCHAR2
Zipcode In Address Of Director
DIRECTOR_COUNTRY
VARCHAR2
Country In Address Of Director
DIRECTOR_PHONE
VARCHAR2
Phone Number Of Director
DIRECTOR_FAX
VARCHAR2
Fax Number Of Director
DIRECTOR_MOBILE
VARCHAR2
Mobile Phone Number Of Director
DIRECTOR_EMAIL
VARCHAR2
Email Address Of Director
WEB_URL
VARCHAR2
url of tourname website
TOURNAMENT_YEAR
NUMBER
Year Of Tournament
BOATS
NUMBER
Number Of Boats
FISHING_TIME
NUMBER
Time spent FIshing
TOTAL_EFFORT
NUMBER
Total Fishing 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: TOURNAMENT_SUMMARY_V
Short Name: TOURNAMENT_SUMMARY_V
Status: Completed
Abstract:

Summary View Of Tournaments

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Summary Data
None Tournament Data

Entity Information

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

Summary View Of Tournaments

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TOURNAMENT_CODE NUMBER Tournament Code
100
TOURNAMENT_NAME VARCHAR2 Name Of The tournament
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
CREATION_DATE DATE Creation Date
100
SURVEY_SOURCE VARCHAR2 Source OfInformation From This tournament
100
ICCAT_AREA VARCHAR2 ICCAT Area Of Reporting
100
TERMINATION_DATE DATE Termination Date
100
CLUB_SPONSOR VARCHAR2 Sponsor Of The Tournament
100
START_DATE DATE Start Date Of Tournament
100
END_DATE DATE End Date Of tournament
100
ANNUAL_REGISTRATION_DATE DATE Date Tournament is Registered
100
TOURNAMENT_TYPE VARCHAR2 Type Of Tournament
100
SUMMARY_REPORT VARCHAR2 Was a Summary Report Provided
100
HOOK_RESTRICTIONS VARCHAR2 Hook Restrictions For Tournament
100
BAIT_RESTRICTIONS VARCHAR2 Bait Restrictions For Tournament
100
COMMENTS VARCHAR2 Any Extra Comments about the tournament including all information Associated With it
100
DIRECTOR_NAME VARCHAR2 Name Of Tournament Director
100
DIRECTOR_ADDRESS1 VARCHAR2 First Line Of Address Of DIrector
100
DIRECTOR_ADDRESS2 VARCHAR2 Second Line Of Address Of DIrector
100
DIRECTOR_CITY VARCHAR2 City In Addess Of Director
100
DIRECTOR_STATE VARCHAR2 State In Address Of Director
100
DIRECTOR_ZIP VARCHAR2 Zipcode In Address Of Director
100
DIRECTOR_COUNTRY VARCHAR2 Country In Address Of Director
100
DIRECTOR_PHONE VARCHAR2 Phone Number Of Director
100
DIRECTOR_FAX VARCHAR2 Fax Number Of Director
100
DIRECTOR_MOBILE VARCHAR2 Mobile Phone Number Of Director
100
DIRECTOR_EMAIL VARCHAR2 Email Address Of Director
100
WEB_URL VARCHAR2 url of tourname website
100
TOURNAMENT_YEAR NUMBER Year Of Tournament
100
BOATS NUMBER Number Of Boats
100
FISHING_TIME NUMBER Time spent FIshing
100
TOTAL_EFFORT NUMBER Total Fishing 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: 21008
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_NAME

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

Name Of The tournament

General Data Type: VARCHAR2

LATITUDE

CC ID: 21042
Seq. Order: 3
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: 21026
Seq. Order: 4
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: 21016
Seq. Order: 5
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: 21039
Seq. Order: 6
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: 21034
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Country Where Tournament Was Held

General Data Type: VARCHAR2

CREATION_DATE

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

Creation Date

General Data Type: DATE

SURVEY_SOURCE

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

Source OfInformation From This tournament

General Data Type: VARCHAR2

ICCAT_AREA

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

ICCAT Area Of Reporting

General Data Type: VARCHAR2

TERMINATION_DATE

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

Termination Date

General Data Type: DATE

CLUB_SPONSOR

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

Sponsor Of The Tournament

General Data Type: VARCHAR2

START_DATE

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

Start Date Of Tournament

General Data Type: DATE

END_DATE

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

End Date Of tournament

General Data Type: DATE

ANNUAL_REGISTRATION_DATE

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

Date Tournament is Registered

General Data Type: DATE

TOURNAMENT_TYPE

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

Type Of Tournament

General Data Type: VARCHAR2

SUMMARY_REPORT

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

Was a Summary Report Provided

General Data Type: VARCHAR2

HOOK_RESTRICTIONS

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

Hook Restrictions For Tournament

General Data Type: VARCHAR2

BAIT_RESTRICTIONS

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

Bait Restrictions For Tournament

General Data Type: VARCHAR2

COMMENTS

CC ID: 21036
Seq. Order: 20
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

DIRECTOR_NAME

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

Name Of Tournament Director

General Data Type: VARCHAR2

DIRECTOR_ADDRESS1

CC ID: 21027
Seq. Order: 22
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: 21025
Seq. Order: 23
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: 21035
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

City In Addess Of Director

General Data Type: VARCHAR2

DIRECTOR_STATE

CC ID: 21012
Seq. Order: 25
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: 21011
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Zipcode In Address Of Director

General Data Type: VARCHAR2

DIRECTOR_COUNTRY

CC ID: 21003
Seq. Order: 27
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: 21038
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Phone Number Of Director

General Data Type: VARCHAR2

DIRECTOR_FAX

CC ID: 21023
Seq. Order: 29
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: 21014
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Mobile Phone Number Of Director

General Data Type: VARCHAR2

DIRECTOR_EMAIL

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

Email Address Of Director

General Data Type: VARCHAR2

WEB_URL

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

url of tourname website

General Data Type: VARCHAR2

TOURNAMENT_YEAR

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

Year Of Tournament

General Data Type: NUMBER

BOATS

CC ID: 21022
Seq. Order: 34
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: 21017
Seq. Order: 35
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: 21033
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total Fishing Effort

General Data Type: NUMBER

SPECIES_ID

CC ID: 21006
Seq. Order: 37
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: 21002
Seq. Order: 38
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: 21044
Seq. Order: 39
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: 21024
Seq. Order: 40
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: 21030
Seq. Order: 41
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: 21019
Seq. Order: 42
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: 21015
Seq. Order: 43
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: 6266
GUID: gov.noaa.nmfs.inport:6266
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