Metadata Rubric

100%

6 / 6

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

Table: CONTACT_HISTORY

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

Summary

Item Identification

Keywords

Entity Info

Data Attributes

Catalog Details

Abstract

Contains History Of Contacts WIth Tournament Officials

Description

Contains History Of Contacts WIth Tournament Officials

Entity Type
Data Table

Data Attribute / Type	Description
TOURNAMENT_CODE NUMBER	Tournament Foreign Key to Tournaments Table
TOURNAMENT_YEAR NUMBER	Year Tournament Took Place
CONTACT_DATE DATE	Date Contact Took Place
METHOD VARCHAR2	Method Of Contact
PURPOSE VARCHAR2	Purpose Of Contact
PERSON VARCHAR2	Person Contacted
ADDRESS1 VARCHAR2	First Line of Contact Address
ADDRESS2 VARCHAR2	Second Line Of address For Contact
CITY VARCHAR2	City Part Of Contact Person Address
STATE VARCHAR2	State Part of Contact Address
COUNTRY VARCHAR2	Country Where Tournament Wa Held
ACTION VARCHAR2	Action taken upon contact
COMMENTS VARCHAR2	Any Other Comments About this record
DAYS_LATE NUMBER	Number of days late in which contact is late in responding
ID NUMBER	Sequential Key
PHONE VARCHAR2	Phone Number For Calling Contact Of Tournament
ZIP VARCHAR2	Zip Code Part of Contact Address
FAX VARCHAR2	Fax Number For Calling Contact Of Tournament
MOBILE VARCHAR2	Mobile Number For Calling Contact Of Tournament
EMAIL VARCHAR2	email address of the tournament contact

Data Attribute / Type

Description

TOURNAMENT_CODE
NUMBER

Tournament Foreign Key to Tournaments Table

TOURNAMENT_YEAR
NUMBER

Year Tournament Took Place

CONTACT_DATE
DATE

Date Contact Took Place

METHOD
VARCHAR2

Method Of Contact

PURPOSE
VARCHAR2

Purpose Of Contact

PERSON
VARCHAR2

Person Contacted

ADDRESS1
VARCHAR2

First Line of Contact Address

ADDRESS2
VARCHAR2

Second Line Of address For Contact

CITY
VARCHAR2

City Part Of Contact Person Address

STATE
VARCHAR2

State Part of Contact Address

COUNTRY
VARCHAR2

Country Where Tournament Wa Held

ACTION
VARCHAR2

Action taken upon contact

COMMENTS
VARCHAR2

Any Other Comments About this record

DAYS_LATE
NUMBER

Number of days late in which contact is late in responding

ID
NUMBER

Sequential Key

PHONE
VARCHAR2

Phone Number For Calling Contact Of Tournament

ZIP
VARCHAR2

Zip Code Part of Contact Address

FAX
VARCHAR2

Fax Number For Calling Contact Of Tournament

MOBILE
VARCHAR2

Mobile Number For Calling Contact Of Tournament

EMAIL
VARCHAR2

email address of the tournament contact

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:	Table: CONTACT_HISTORY
Short Name:	CONTACT_HISTORY
Status:	Completed
Abstract:	Contains History Of Contacts WIth Tournament Officials
Notes:	Loaded by batch 1863, 11-02-2007 09:24

Theme Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Contact History

Thesaurus

Keyword

UNCONTROLLED

None

Contact History

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	RBS
Description:	Contains History Of Contacts WIth Tournament Officials

Attribute Summary

	Name	Type	Description
100	TOURNAMENT_CODE	NUMBER	Tournament Foreign Key to Tournaments Table
100	TOURNAMENT_YEAR	NUMBER	Year Tournament Took Place
100	CONTACT_DATE	DATE	Date Contact Took Place
100	METHOD	VARCHAR2	Method Of Contact
100	PURPOSE	VARCHAR2	Purpose Of Contact
100	PERSON	VARCHAR2	Person Contacted
100	ADDRESS1	VARCHAR2	First Line of Contact Address
100	ADDRESS2	VARCHAR2	Second Line Of address For Contact
100	CITY	VARCHAR2	City Part Of Contact Person Address
100	STATE	VARCHAR2	State Part of Contact Address
100	COUNTRY	VARCHAR2	Country Where Tournament Wa Held
100	ACTION	VARCHAR2	Action taken upon contact
100	COMMENTS	VARCHAR2	Any Other Comments About this record
100	DAYS_LATE	NUMBER	Number of days late in which contact is late in responding
100	ID	NUMBER	Sequential Key
100	PHONE	VARCHAR2	Phone Number For Calling Contact Of Tournament
100	ZIP	VARCHAR2	Zip Code Part of Contact Address
100	FAX	VARCHAR2	Fax Number For Calling Contact Of Tournament
100	MOBILE	VARCHAR2	Mobile Number For Calling Contact Of Tournament
100	EMAIL	VARCHAR2	email address of the tournament contact

Name

Type

Description

100

TOURNAMENT_CODE

NUMBER

Tournament Foreign Key to Tournaments Table

100

TOURNAMENT_YEAR

NUMBER

Year Tournament Took Place

100

CONTACT_DATE

DATE

Date Contact Took Place

100

METHOD

VARCHAR2

Method Of Contact

100

PURPOSE

VARCHAR2

Purpose Of Contact

100

PERSON

VARCHAR2

Person Contacted

100

ADDRESS1

VARCHAR2

First Line of Contact Address

100

ADDRESS2

VARCHAR2

Second Line Of address For Contact

100

CITY

VARCHAR2

City Part Of Contact Person Address

100

STATE

VARCHAR2

State Part of Contact Address

100

COUNTRY

VARCHAR2

Country Where Tournament Wa Held

100

ACTION

VARCHAR2

Action taken upon contact

100

COMMENTS

VARCHAR2

Any Other Comments About this record

100

DAYS_LATE

NUMBER

Number of days late in which contact is late in responding

100

NUMBER

Sequential Key

100

PHONE

VARCHAR2

Phone Number For Calling Contact Of Tournament

100

ZIP

VARCHAR2

Zip Code Part of Contact Address

100

FAX

VARCHAR2

Fax Number For Calling Contact Of Tournament

100

MOBILE

VARCHAR2

Mobile Number For Calling Contact Of Tournament

100

VARCHAR2

email address of the tournament contact

Attribute Details

TOURNAMENT_CODE

CC ID: 20571

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Tournament Foreign Key to Tournaments Table
General Data Type:	NUMBER

TOURNAMENT_YEAR

CC ID: 20572

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year Tournament Took Place
General Data Type:	NUMBER

CONTACT_DATE

CC ID: 20573

Seq. Order:	3
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date Contact Took Place
General Data Type:	DATE

METHOD

CC ID: 20574

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Method Of Contact
General Data Type:	VARCHAR2

PURPOSE

CC ID: 20575

Seq. Order:	5
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: 20576

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Person Contacted
General Data Type:	VARCHAR2

ADDRESS1

CC ID: 20577

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	First Line of Contact Address
General Data Type:	VARCHAR2

ADDRESS2

CC ID: 20578

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Second Line Of address For Contact
General Data Type:	VARCHAR2

CITY

CC ID: 20579

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	City Part Of Contact Person Address
General Data Type:	VARCHAR2

STATE

CC ID: 20580

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	State Part of Contact Address
General Data Type:	VARCHAR2

COUNTRY

CC ID: 20581

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	Country Where Tournament Wa Held
General Data Type:	VARCHAR2

ACTION

CC ID: 20582

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Action taken upon contact
General Data Type:	VARCHAR2

COMMENTS

CC ID: 20583

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	500
Required:	No
Primary Key:	No
Status:	Active
Description:	Any Other Comments About this record
General Data Type:	VARCHAR2

DAYS_LATE

CC ID: 20584

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Number of days late in which contact is late in responding
General Data Type:	NUMBER

ID

CC ID: 20585

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	38
Status:	Active
Description:	Sequential Key
General Data Type:	NUMBER

PHONE

CC ID: 20586

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone Number For Calling Contact Of Tournament
General Data Type:	VARCHAR2

ZIP

CC ID: 20587

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Zip Code Part of Contact Address
General Data Type:	VARCHAR2

FAX

CC ID: 20588

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Fax Number For Calling Contact Of Tournament
General Data Type:	VARCHAR2

MOBILE

CC ID: 20589

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Mobile Number For Calling Contact Of Tournament
General Data Type:	VARCHAR2

EMAIL

CC ID: 20590

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	email address of the tournament contact
General Data Type:	VARCHAR2

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

Table: CONTACT_HISTORY

Summary

Entity Information

Child Items

Contact Information

Item Identification

Keywords

Theme Keywords

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TOURNAMENT_CODE

TOURNAMENT_YEAR

CONTACT_DATE

METHOD

PURPOSE

PERSON

ADDRESS1

ADDRESS2

CITY

STATE

COUNTRY

ACTION

COMMENTS

DAYS_LATE

ID

PHONE

ZIP

FAX

MOBILE

EMAIL

Catalog Details