View: TOURNAMENT_CATCH_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6258 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Of Catches Of Tournaments
DescriptionView Of Catches Of Tournaments
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 |
Date Tournament is officially 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 |
Hook Restrictions On Tournament Fishing |
BAIT_RESTRICTIONS
VARCHAR2 |
Bait Restrictions On Tournament Fishing |
SURVEY_SOURCE
VARCHAR2 |
Source OfInformation From This tournament |
SUMMARY_REPORT
VARCHAR2 |
Wss a Tournament SUmmray Report Provided |
DIRECTOR_NAME
VARCHAR2 |
Name Of Tournament Director |
DIRECTOR_ADDRESS
VARCHAR2 |
First Line of Tournament Directors Address |
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 |
url of tournament website |
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 |
CATCH_TOURNAMENT_CODE
NUMBER |
Catch Tournament Code |
CATCH_TOURNAMENT_YEAR
NUMBER |
Catch Tournament Year |
SPECIES_ID
VARCHAR2 |
Mnemonic Species Code |
RECORD_COUNT
NUMBER |
Number Of Records |
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_CATCH_V |
---|---|
Short Name: | TOURNAMENT_CATCH_V |
Status: | Completed |
Abstract: |
View Of Catches Of Tournaments |
Notes: |
Loaded by batch 1863, 11-02-2007 09:24 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Catch |
None | Tournaments |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | RBS |
Description: |
View Of Catches Of Tournaments |
Data Attributes
Attribute Summary
![]() |
![]() |
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 | Date Tournament is officially 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 | Hook Restrictions On Tournament Fishing | |
100
|
BAIT_RESTRICTIONS | VARCHAR2 | Bait Restrictions On Tournament Fishing | |
100
|
SURVEY_SOURCE | VARCHAR2 | Source OfInformation From This tournament | |
100
|
SUMMARY_REPORT | VARCHAR2 | Wss a Tournament SUmmray Report Provided | |
100
|
DIRECTOR_NAME | VARCHAR2 | Name Of Tournament Director | |
100
|
DIRECTOR_ADDRESS | VARCHAR2 | First Line of Tournament Directors Address | |
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 | url of tournament website | |
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 | |
100
|
CATCH_TOURNAMENT_CODE | NUMBER | Catch Tournament Code | |
100
|
CATCH_TOURNAMENT_YEAR | NUMBER | Catch Tournament Year | |
100
|
SPECIES_ID | VARCHAR2 | Mnemonic Species Code | |
100
|
RECORD_COUNT | NUMBER | Number Of Records | |
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_NAME
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
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
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
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Tournament is officially Registered |
General Data Type: | DATE |
START_DATE
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook Restrictions On Tournament Fishing |
General Data Type: | VARCHAR2 |
BAIT_RESTRICTIONS
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bait Restrictions On Tournament Fishing |
General Data Type: | VARCHAR2 |
SURVEY_SOURCE
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
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Wss a Tournament SUmmray Report Provided |
General Data Type: | VARCHAR2 |
DIRECTOR_NAME
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
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First Line of Tournament Directors Address |
General Data Type: | VARCHAR2 |
DIRECTOR_ADDRESS2
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
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
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
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
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
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
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
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
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
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
url of tournament website |
General Data Type: | VARCHAR2 |
CLUB_SPONSOR
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
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
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 |
CATCH_TOURNAMENT_CODE
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Catch Tournament Code |
General Data Type: | NUMBER |
CATCH_TOURNAMENT_YEAR
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Catch Tournament Year |
General Data Type: | NUMBER |
SPECIES_ID
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 |
RECORD_COUNT
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Of Records |
General Data Type: | NUMBER |
NUMBER_KEPT
Seq. Order: | 39 |
---|---|
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
Seq. Order: | 40 |
---|---|
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
Seq. Order: | 41 |
---|---|
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
Seq. Order: | 42 |
---|---|
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
Seq. Order: | 43 |
---|---|
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
Seq. Order: | 44 |
---|---|
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: | 6258 |
---|---|
GUID: | gov.noaa.nmfs.inport:6258 |
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 |