View: TOURNAMENT_SUMMARY_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6266 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Summary View Of Tournaments
DescriptionSummary 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |