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

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

Summary

Abstract

View Of Tournaments

Description

View Of Tournaments

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_NAME
VARCHAR2 		Tournament Name
TOURNAMENT_CODE
NUMBER 		Tournament Cide
CREATION_DATE
DATE 		Creation Date
ANNUAL_REGISTRATION_DATE
DATE 		The Date That The Tournament is registered
START_DATE
DATE 		Tournament Start Date
END_DATE
DATE 		Tournament End Date
TOURNAMENT_YEAR
NUMBER 		Year Of Tournament
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 		Type Of Tournament
HOOK_RESTRICTIONS
VARCHAR2 		Description Of Hook Restrictions
BAIT_RESTRICTIONS
VARCHAR2 		Description Of Bait Restrictions
SURVEY_SOURCE
VARCHAR2 		Source Of Survey
SUMMARY_REPORT
VARCHAR2 		Was A Summary Report Provided
DIRECTOR_NAME
VARCHAR2 		Name Of Tournament Director
DIRECTOR_ADDRESS
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
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 		Key to Registration Table

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

View Of Tournaments
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Tournaments

Entity Information

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

View Of Tournaments

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_NAME VARCHAR2 Tournament Name
100
 TOURNAMENT_CODE NUMBER Tournament Cide
100
 CREATION_DATE DATE Creation Date
100
 ANNUAL_REGISTRATION_DATE DATE The Date That The Tournament is registered
100
 START_DATE DATE Tournament Start Date
100
 END_DATE DATE Tournament End Date
100
 TOURNAMENT_YEAR NUMBER Year Of Tournament
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 Type Of Tournament
100
 HOOK_RESTRICTIONS VARCHAR2 Description Of Hook Restrictions
100
 BAIT_RESTRICTIONS VARCHAR2 Description Of Bait Restrictions
100
 SURVEY_SOURCE VARCHAR2 Source Of Survey
100
 SUMMARY_REPORT VARCHAR2 Was A Summary Report Provided
100
 DIRECTOR_NAME VARCHAR2 Name Of Tournament 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 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
 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 Key to Registration Table

Attribute Details

TOURNAMENT_NAME

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

Tournament Name
General Data Type: VARCHAR2

TOURNAMENT_CODE

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

Tournament Cide
General Data Type: NUMBER

CREATION_DATE

CC ID: 20746
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: 20750
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The Date That The Tournament is registered
General Data Type: DATE

START_DATE

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

Year Of Tournament
General Data Type: NUMBER

TERMINATION_DATE

CC ID: 20768
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: 20756
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: 20765
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: 20769
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: 20772
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: 20745
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: 20767
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: 20777
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Type Of Tournament
General Data Type: VARCHAR2

HOOK_RESTRICTIONS

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

Description Of Hook Restrictions
General Data Type: VARCHAR2

BAIT_RESTRICTIONS

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

Description Of Bait Restrictions
General Data Type: VARCHAR2

SURVEY_SOURCE

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

Source Of Survey
General Data Type: VARCHAR2

SUMMARY_REPORT

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

Was A Summary Report Provided
General Data Type: VARCHAR2

DIRECTOR_NAME

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

Name Of Tournament Director
General Data Type: VARCHAR2

DIRECTOR_ADDRESS

CC ID: 20775
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: 20744
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: 20752
Seq. Order: 23
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: 20770
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: 20763
Seq. Order: 25
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: 20758
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: 20774
Seq. Order: 27
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: 20766
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: 20749
Seq. Order: 29
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: 20751
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: 20754
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: 20760
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: 20771
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: 20759
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Registration Table
General Data Type: NUMBER

Catalog Details

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