View: TOURNAMENT_EFFORT_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6264 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
View Listing Effort By Tournament
DescriptionView Listing Effort By Tournament
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 |
Annual registration Date |
START_DATE
DATE |
Tournament Start Date |
END_DATE
DATE |
Tournament End Date |
TOURNAMENT_YEAR
NUMBER |
Year Tournament Took Place |
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 |
Tpe Of Tournament |
HOOK_RESTRICTIONS
VARCHAR2 |
Restrictions On Hook usage |
BAIT_RESTRICTIONS
VARCHAR2 |
Restrictions On Bait usage |
SURVEY_SOURCE
VARCHAR2 |
Source OfInformation From This tournament |
SUMMARY_REPORT
VARCHAR2 |
Was A Summary Report Received |
DIRECTOR_NAME
VARCHAR2 |
Name Of Director |
DIRECTOR_ADDRESS
VARCHAR2 |
First Line Of Address Of DIrector |
DIRECTOR_ADDRESS2
VARCHAR2 |
Second Line Of Address Of Director |
DIRECTOR_CITY
VARCHAR2 |
CIty in Address Of Director |
DIRECTOR_STATE
VARCHAR2 |
State In Address Of Director |
DIRECTOR_ZIP
VARCHAR2 |
Zip Code Of Director |
DIRECTOR_COUNTRY
VARCHAR2 |
Country In Address Of Director |
DIRECTOR_PHONE
VARCHAR2 |
Office Number Of Director |
DIRECTOR_FAX
VARCHAR2 |
Fax Number Of Director |
DIRECTOR_MOBILE
VARCHAR2 |
Mobile/Cellular 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 |
To Lookup Registration Information |
EFFORT_TOURNAMENT_CODE
NUMBER |
Tournament Number |
EFFORT_TOURNAMENT_YEAR
NUMBER |
Year Of Tournament |
REPORT_COUNT
NUMBER |
Number Of Reports Received |
MAX_REPORT_DATE
DATE |
Date Report Was Received |
FISHING_DATE_START
DATE |
Date Fishing Started |
FISHING_DATE_END
DATE |
Date Fishing Ended |
BOATS
NUMBER |
Number Of Boats |
FISHING_TIME
NUMBER |
Total Fishing Time |
TOTAL_EFFORT
NUMBER |
Total Fishing Effort |
TOURNAMENT_DISPOSITION
VARCHAR2 |
How The Tournament FInsished |
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_EFFORT_V |
---|---|
Short Name: | TOURNAMENT_EFFORT_V |
Status: | Completed |
Abstract: |
View Listing Effort By Tournament |
Notes: |
Loaded by batch 1863, 11-02-2007 09:24 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | Effort |
None | Tournaments |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | RBS |
Description: |
View Listing Effort By Tournament |
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 | Annual registration Date | |
100
|
START_DATE | DATE | Tournament Start Date | |
100
|
END_DATE | DATE | Tournament End Date | |
100
|
TOURNAMENT_YEAR | NUMBER | Year Tournament Took Place | |
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 | Tpe Of Tournament | |
100
|
HOOK_RESTRICTIONS | VARCHAR2 | Restrictions On Hook usage | |
100
|
BAIT_RESTRICTIONS | VARCHAR2 | Restrictions On Bait usage | |
100
|
SURVEY_SOURCE | VARCHAR2 | Source OfInformation From This tournament | |
100
|
SUMMARY_REPORT | VARCHAR2 | Was A Summary Report Received | |
100
|
DIRECTOR_NAME | VARCHAR2 | Name Of 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 Address Of Director | |
100
|
DIRECTOR_STATE | VARCHAR2 | State In Address Of Director | |
100
|
DIRECTOR_ZIP | VARCHAR2 | Zip Code Of Director | |
100
|
DIRECTOR_COUNTRY | VARCHAR2 | Country In Address Of Director | |
100
|
DIRECTOR_PHONE | VARCHAR2 | Office Number Of Director | |
100
|
DIRECTOR_FAX | VARCHAR2 | Fax Number Of Director | |
100
|
DIRECTOR_MOBILE | VARCHAR2 | Mobile/Cellular 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 | To Lookup Registration Information | |
100
|
EFFORT_TOURNAMENT_CODE | NUMBER | Tournament Number | |
100
|
EFFORT_TOURNAMENT_YEAR | NUMBER | Year Of Tournament | |
100
|
REPORT_COUNT | NUMBER | Number Of Reports Received | |
100
|
MAX_REPORT_DATE | DATE | Date Report Was Received | |
100
|
FISHING_DATE_START | DATE | Date Fishing Started | |
100
|
FISHING_DATE_END | DATE | Date Fishing Ended | |
100
|
BOATS | NUMBER | Number Of Boats | |
100
|
FISHING_TIME | NUMBER | Total Fishing Time | |
100
|
TOTAL_EFFORT | NUMBER | Total Fishing Effort | |
100
|
TOURNAMENT_DISPOSITION | VARCHAR2 | How The Tournament FInsished |
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: |
Annual registration Date |
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 Tournament Took Place |
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: |
Tpe 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: |
Restrictions On Hook usage |
General Data Type: | VARCHAR2 |
BAIT_RESTRICTIONS
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Restrictions On Bait usage |
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: |
Was A Summary Report Received |
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 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 Address Of DIrector |
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 Address 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: |
Zip Code 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: |
Office 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/Cellular 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: |
Tournament url |
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: |
To Lookup Registration Information |
General Data Type: | NUMBER |
EFFORT_TOURNAMENT_CODE
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Tournament Number |
General Data Type: | NUMBER |
EFFORT_TOURNAMENT_YEAR
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Year Of Tournament |
General Data Type: | NUMBER |
REPORT_COUNT
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Number Of Reports Received |
General Data Type: | NUMBER |
MAX_REPORT_DATE
Seq. Order: | 38 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Report Was Received |
General Data Type: | DATE |
FISHING_DATE_START
Seq. Order: | 39 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Fishing Started |
General Data Type: | DATE |
FISHING_DATE_END
Seq. Order: | 40 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date Fishing Ended |
General Data Type: | DATE |
BOATS
Seq. Order: | 41 |
---|---|
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: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total Fishing Time |
General Data Type: | NUMBER |
TOTAL_EFFORT
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Total Fishing Effort |
General Data Type: | NUMBER |
TOURNAMENT_DISPOSITION
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
How The Tournament FInsished |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 6264 |
---|---|
GUID: | gov.noaa.nmfs.inport:6264 |
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 |