Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

View: TOURNAMENT_DETAILS_V

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6261 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Keywords

Entity Info

Data Attributes

Catalog Details

Abstract

View Listing Tournaments Details

Description

View Listing Tournaments Details

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 Of The 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	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 Provided
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	Indicates Tournament Registration Record
DETAILS_TOURNAMENT_CODE NUMBER	Code Iindicating Tournament SOurce Of Detail Records
DETAILS_TOURNAMENT_YEAR NUMBER	Year Of Tournament Detail Records
SPECIES_ID VARCHAR2	Mnemonic Species Code
MIN_FISHING_DATE VARCHAR2	Date Fishing Started
MAX_FISHING_DATE VARCHAR2	Date Fishing Ended
RECORD_COUNT NUMBER	Number Of Records
LENGTH_COUNT NUMBER	Number Of Records Having Length Information
LENGTH_SUM NUMBER	Total Summed Lengtht of records having length information
WEIGHT_COUNT NUMBER	Number Of Records Having Weight Information
WEIGHT_SUM NUMBER	Total Summed Weight of records having weight information

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 Of The 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

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 Provided

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

Indicates Tournament Registration Record

DETAILS_TOURNAMENT_CODE
NUMBER

Code Iindicating Tournament SOurce Of Detail Records

DETAILS_TOURNAMENT_YEAR
NUMBER

Year Of Tournament Detail Records

SPECIES_ID
VARCHAR2

Mnemonic Species Code

MIN_FISHING_DATE
VARCHAR2

Date Fishing Started

MAX_FISHING_DATE
VARCHAR2

Date Fishing Ended

RECORD_COUNT
NUMBER

Number Of Records

LENGTH_COUNT
NUMBER

Number Of Records Having Length Information

LENGTH_SUM
NUMBER

Total Summed Lengtht of records having length information

WEIGHT_COUNT
NUMBER

Number Of Records Having Weight Information

WEIGHT_SUM
NUMBER

Total Summed Weight of records having weight information

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	View: TOURNAMENT_DETAILS_V
Short Name:	TOURNAMENT_DETAILS_V
Status:	Completed
Abstract:	View Listing Tournaments Details
Notes:	Loaded by batch 1863, 11-02-2007 09:24

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Tournaments

Thesaurus

Keyword

UNCONTROLLED

None

Tournaments

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

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 Of The 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	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 Provided
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	Indicates Tournament Registration Record
100	DETAILS_TOURNAMENT_CODE	NUMBER	Code Iindicating Tournament SOurce Of Detail Records
100	DETAILS_TOURNAMENT_YEAR	NUMBER	Year Of Tournament Detail Records
100	SPECIES_ID	VARCHAR2	Mnemonic Species Code
100	MIN_FISHING_DATE	VARCHAR2	Date Fishing Started
100	MAX_FISHING_DATE	VARCHAR2	Date Fishing Ended
100	RECORD_COUNT	NUMBER	Number Of Records
100	LENGTH_COUNT	NUMBER	Number Of Records Having Length Information
100	LENGTH_SUM	NUMBER	Total Summed Lengtht of records having length information
100	WEIGHT_COUNT	NUMBER	Number Of Records Having Weight Information
100	WEIGHT_SUM	NUMBER	Total Summed Weight of records having weight information

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 Of The 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

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 Provided

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

Indicates Tournament Registration Record

100

DETAILS_TOURNAMENT_CODE

NUMBER

Code Iindicating Tournament SOurce Of Detail Records

100

DETAILS_TOURNAMENT_YEAR

NUMBER

Year Of Tournament Detail Records

100

SPECIES_ID

VARCHAR2

Mnemonic Species Code

100

MIN_FISHING_DATE

VARCHAR2

Date Fishing Started

100

MAX_FISHING_DATE

VARCHAR2

Date Fishing Ended

100

RECORD_COUNT

NUMBER

Number Of Records

100

LENGTH_COUNT

NUMBER

Number Of Records Having Length Information

100

LENGTH_SUM

NUMBER

Total Summed Lengtht of records having length information

100

WEIGHT_COUNT

NUMBER

Number Of Records Having Weight Information

100

WEIGHT_SUM

NUMBER

Total Summed Weight of records having weight information

Attribute Details

TOURNAMENT_NAME

CC ID: 20880

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

CC ID: 20888

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

CC ID: 20911

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

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

CC ID: 20909

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

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

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year Of The Tournament
General Data Type:	NUMBER

TERMINATION_DATE

CC ID: 20901

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

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

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

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

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

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

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

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

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

CC ID: 20872

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

CC ID: 20905

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

CC ID: 20874

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

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

CC ID: 20910

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

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

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

CC ID: 20904

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

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

CC ID: 20897

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

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

CC ID: 20893

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

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

CC ID: 20902

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

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

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

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

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Indicates Tournament Registration Record
General Data Type:	NUMBER

DETAILS_TOURNAMENT_CODE

CC ID: 20892

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Code Iindicating Tournament SOurce Of Detail Records
General Data Type:	NUMBER

DETAILS_TOURNAMENT_YEAR

CC ID: 20876

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year Of Tournament Detail Records
General Data Type:	NUMBER

SPECIES_ID

CC ID: 20896

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Mnemonic Species Code
General Data Type:	VARCHAR2

MIN_FISHING_DATE

CC ID: 20883

Seq. Order:	38
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Fishing Started
General Data Type:	VARCHAR2

MAX_FISHING_DATE

CC ID: 20881

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Fishing Ended
General Data Type:	VARCHAR2

RECORD_COUNT

CC ID: 20887

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Records
General Data Type:	NUMBER

LENGTH_COUNT

CC ID: 20899

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Records Having Length Information
General Data Type:	NUMBER

LENGTH_SUM

CC ID: 20903

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Total Summed Lengtht of records having length information
General Data Type:	NUMBER

WEIGHT_COUNT

CC ID: 20877

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number Of Records Having Weight Information
General Data Type:	NUMBER

WEIGHT_SUM

CC ID: 20894

Seq. Order:	44
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Total Summed Weight of records having weight information
General Data Type:	NUMBER

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Keywords

Theme Keywords

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TOURNAMENT_NAME

TOURNAMENT_CODE

CREATION_DATE

ANNUAL_REGISTRATION_DATE

START_DATE

END_DATE

TOURNAMENT_YEAR

TERMINATION_DATE

LATITUDE

LONGITUDE

CITY

STATE

COUNTRY

ICCAT_AREA

TOURNAMENT_TYPE

HOOK_RESTRICTIONS

BAIT_RESTRICTIONS

SURVEY_SOURCE

SUMMARY_REPORT

DIRECTOR_NAME

DIRECTOR_ADDRESS

DIRECTOR_ADDRESS2

DIRECTOR_CITY

DIRECTOR_STATE

DIRECTOR_ZIP

DIRECTOR_COUNTRY

DIRECTOR_PHONE

DIRECTOR_FAX

DIRECTOR_MOBILE

DIRECTOR_EMAIL

DIRECTOR_WEB_URL

CLUB_SPONSOR

COMMENTS

REGISTRATION_ID

DETAILS_TOURNAMENT_CODE

DETAILS_TOURNAMENT_YEAR

SPECIES_ID

MIN_FISHING_DATE

MAX_FISHING_DATE

RECORD_COUNT

LENGTH_COUNT

LENGTH_SUM

WEIGHT_COUNT

WEIGHT_SUM

Catalog Details