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) >

View: TOURNAMENT_CONTACTS_V

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

Summary

Abstract

View Of Contact Infromation From Tournaments

Description

View Of Contact Infromation From Tournaments

Entity Information

Entity Type
Data View

Data Attribute / Type Description
TOURNAMENT_ID
NUMBER 		Sequence Key to Tournament Table
TOURNAMENT_CODE
NUMBER 		Historial Tournament Code
TOURNAMENT_NAME
VARCHAR2 		Name Of The Tournament
SURVEY_SOURCE
VARCHAR2 		SOurce Of SUrvey information from tournament
CLUB_SPONSOR
VARCHAR2 		Club That sponsors the tournament
TERMINATION_DATE
DATE 		Termination Date
REGISTRATION_DATE
DATE 		Date Tournament Is registered
TOURNAMENT_YEAR
NUMBER 		Year Of The Tournament
CONTACT_ID
NUMBER 		Key to Contact History Table
METHOD
VARCHAR2 		Method Of communication with contact
CONTACT_DATE
DATE 		Contact Date
PURPOSE
VARCHAR2 		Purpose Of Contact
PERSON
VARCHAR2 		Person Contacted
ACTION
VARCHAR2 		Action taken upon contact
ZIP
VARCHAR2 		Zip Code Of Contact
ADDRESS1
VARCHAR2 		First LIne Of Address Of Contact
ADDRESS2
VARCHAR2 		Second Line Of Address Of Contact
CITY
VARCHAR2 		CIty in Address Of Contact
STATE
VARCHAR2 		State In Address Of Contact

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

View Of Contact Infromation From Tournaments
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Contact Information
None Tournaments

Entity Information

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

View Of Contact Infromation From Tournaments

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_ID NUMBER Sequence Key to Tournament Table
100
 TOURNAMENT_CODE NUMBER Historial Tournament Code
100
 TOURNAMENT_NAME VARCHAR2 Name Of The Tournament
100
 SURVEY_SOURCE VARCHAR2 SOurce Of SUrvey information from tournament
100
 CLUB_SPONSOR VARCHAR2 Club That sponsors the tournament
100
 TERMINATION_DATE DATE Termination Date
100
 REGISTRATION_DATE DATE Date Tournament Is registered
100
 TOURNAMENT_YEAR NUMBER Year Of The Tournament
100
 CONTACT_ID NUMBER Key to Contact History Table
100
 METHOD VARCHAR2 Method Of communication with contact
100
 CONTACT_DATE DATE Contact Date
100
 PURPOSE VARCHAR2 Purpose Of Contact
100
 PERSON VARCHAR2 Person Contacted
100
 ACTION VARCHAR2 Action taken upon contact
100
 ZIP VARCHAR2 Zip Code Of Contact
100
 ADDRESS1 VARCHAR2 First LIne Of Address Of Contact
100
 ADDRESS2 VARCHAR2 Second Line Of Address Of Contact
100
 CITY VARCHAR2 CIty in Address Of Contact
100
 STATE VARCHAR2 State In Address Of Contact

Attribute Details

TOURNAMENT_ID

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

Sequence Key to Tournament Table
General Data Type: NUMBER

TOURNAMENT_CODE

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

Historial Tournament Code
General Data Type: NUMBER

TOURNAMENT_NAME

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

Name Of The Tournament
General Data Type: VARCHAR2

SURVEY_SOURCE

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

SOurce Of SUrvey information from tournament
General Data Type: VARCHAR2

CLUB_SPONSOR

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

Club That sponsors the tournament
General Data Type: VARCHAR2

TERMINATION_DATE

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

Termination Date
General Data Type: DATE

REGISTRATION_DATE

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

Date Tournament Is registered
General Data Type: DATE

TOURNAMENT_YEAR

CC ID: 20837
Seq. Order: 8
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

CONTACT_ID

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

Key to Contact History Table
General Data Type: NUMBER

METHOD

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

Method Of communication with contact
General Data Type: VARCHAR2

CONTACT_DATE

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

Contact Date
General Data Type: DATE

PURPOSE

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

Purpose Of Contact
General Data Type: VARCHAR2

PERSON

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

Person Contacted
General Data Type: VARCHAR2

ACTION

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

Action taken upon contact
General Data Type: VARCHAR2

ZIP

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

Zip Code Of Contact
General Data Type: VARCHAR2

ADDRESS1

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

First LIne Of Address Of Contact
General Data Type: VARCHAR2

ADDRESS2

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

Second Line Of Address Of Contact
General Data Type: VARCHAR2

CITY

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

CIty in Address Of Contact
General Data Type: VARCHAR2

STATE

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

State In Address Of Contact
General Data Type: VARCHAR2

Catalog Details

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