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

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

Summary

Abstract

List of All Fishing Tournaments

Description

List of All Fishing Tournaments

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TOURNAMENT_NAME
VARCHAR2 		Name Of Tournament
TOURNAMENT_CODE
NUMBER 		Tournament Foreign Key to Tournaments Table
START_DATE
DATE 		Start Date Of Tournament
END_DATE
DATE 		End Date Of Tournament
DIRECTOR_NAME
VARCHAR2 		Name Of The Director Of The Tournament
ADDRESS
VARCHAR2 		First Line Of address For Tournament Contact
ADDRESS2
VARCHAR2 		Second Line Of address For Tournament Contact
CITY
VARCHAR2 		City Part Of Contact Person Address
STATE
VARCHAR2 		State Part of Contact Address
ZIP
VARCHAR2 		Zip Code Part of Contact Address
COUNTRY
VARCHAR2 		Country Where Tournament Wa Held
PHONE
VARCHAR2 		Phone Number For Calling Contact Of Tournament
FAX
VARCHAR2 		Fax Number For Calling Contact Of Tournament
MOBILE
VARCHAR2 		Mobile Number For Calling Contact Of Tournament
EMAIL
VARCHAR2 		email address of the tournament contact
WEB_URL
VARCHAR2 		Tournament Website
SUMMARY_REPORT
VARCHAR2 		Is there a tournament Summary Report
TOURNAMENT_TYPE
VARCHAR2 		Type of Tournament
REGISTRATION_DATE
DATE 		Date of Registration
COMMENTS
VARCHAR2 		Any Other Comments About this record
ID
NUMBER 		Sequential Key
HOOK_RESTRICTIONS
VARCHAR2 		Were There any Hook Restrictions For This Tournament
BAIT_RESTRICTIONS
VARCHAR2 		Were There any Bait Restrictions For This Tournament
CPUE_CATEGORY_ID
NUMBER 		Column used primarily for computations of CPUE series. Indentify the pure tournaments. Ex. tournaments that target only billfish.

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

List of All Fishing Tournaments
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Fishing Tournaments

Entity Information

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

List of All Fishing Tournaments

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_NAME VARCHAR2 Name Of Tournament
100
 TOURNAMENT_CODE NUMBER Tournament Foreign Key to Tournaments Table
100
 START_DATE DATE Start Date Of Tournament
100
 END_DATE DATE End Date Of Tournament
100
 DIRECTOR_NAME VARCHAR2 Name Of The Director Of The Tournament
100
 ADDRESS VARCHAR2 First Line Of address For Tournament Contact
100
 ADDRESS2 VARCHAR2 Second Line Of address For Tournament Contact
100
 CITY VARCHAR2 City Part Of Contact Person Address
100
 STATE VARCHAR2 State Part of Contact Address
100
 ZIP VARCHAR2 Zip Code Part of Contact Address
100
 COUNTRY VARCHAR2 Country Where Tournament Wa Held
100
 PHONE VARCHAR2 Phone Number For Calling Contact Of Tournament
100
 FAX VARCHAR2 Fax Number For Calling Contact Of Tournament
100
 MOBILE VARCHAR2 Mobile Number For Calling Contact Of Tournament
100
 EMAIL VARCHAR2 email address of the tournament contact
100
 WEB_URL VARCHAR2 Tournament Website
100
 SUMMARY_REPORT VARCHAR2 Is there a tournament Summary Report
100
 TOURNAMENT_TYPE VARCHAR2 Type of Tournament
100
 REGISTRATION_DATE DATE Date of Registration
100
 COMMENTS VARCHAR2 Any Other Comments About this record
100
 Primary Key ID NUMBER Sequential Key
100
 HOOK_RESTRICTIONS VARCHAR2 Were There any Hook Restrictions For This Tournament
100
 BAIT_RESTRICTIONS VARCHAR2 Were There any Bait Restrictions For This Tournament
100
 CPUE_CATEGORY_ID NUMBER Column used primarily for computations of CPUE series. Indentify the pure tournaments. Ex. tournaments that target only billfish.

Attribute Details

TOURNAMENT_NAME

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

Name Of Tournament
General Data Type: VARCHAR2

TOURNAMENT_CODE

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

Tournament Foreign Key to Tournaments Table
General Data Type: NUMBER

START_DATE

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

End Date Of Tournament
General Data Type: DATE

DIRECTOR_NAME

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

Name Of The Director Of The Tournament
General Data Type: VARCHAR2

ADDRESS

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

First Line Of address For Tournament Contact
General Data Type: VARCHAR2

ADDRESS2

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

Second Line Of address For Tournament Contact
General Data Type: VARCHAR2

CITY

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

City Part Of Contact Person Address
General Data Type: VARCHAR2

STATE

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

State Part of Contact Address
General Data Type: VARCHAR2

ZIP

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

Zip Code Part of Contact Address
General Data Type: VARCHAR2

COUNTRY

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

Country Where Tournament Wa Held
General Data Type: VARCHAR2

PHONE

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

Phone Number For Calling Contact Of Tournament
General Data Type: VARCHAR2

FAX

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

Fax Number For Calling Contact Of Tournament
General Data Type: VARCHAR2

MOBILE

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

Mobile Number For Calling Contact Of Tournament
General Data Type: VARCHAR2

EMAIL

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

email address of the tournament contact
General Data Type: VARCHAR2

WEB_URL

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

Tournament Website
General Data Type: VARCHAR2

SUMMARY_REPORT

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

Is there a tournament Summary Report
General Data Type: VARCHAR2

TOURNAMENT_TYPE

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

Type of Tournament
General Data Type: VARCHAR2

REGISTRATION_DATE

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

Date of Registration
General Data Type: DATE

COMMENTS

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

Any Other Comments About this record
General Data Type: VARCHAR2

ID

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

Sequential Key
General Data Type: NUMBER

HOOK_RESTRICTIONS

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

Were There any Hook Restrictions For This Tournament
General Data Type: VARCHAR2

BAIT_RESTRICTIONS

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

Were There any Bait Restrictions For This Tournament
General Data Type: VARCHAR2

CPUE_CATEGORY_ID

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

Column used primarily for computations of CPUE series. Indentify the pure tournaments. Ex. tournaments that target only billfish.
General Data Type: NUMBER

Catalog Details

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