Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

Table: TBF_ANGLERS

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

Summary

Abstract

Copy of Angler Table From The Bullfish Foundation

Description

Copy of Angler Table From The Bullfish Foundation

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANGLER_ID
NUMBER 		Angler Number (Artificial Key)
DATEENTERED
DATE 		Date Record Was Entered
ORGANIZATION
VARCHAR2 		Organization Angler Noted to be being a member of
TITLE
VARCHAR2 		Title Of Angler (Mr, Captain, DR etc)
FIRSTNAME
VARCHAR2 		Angler FIrst Name
LASTNAME
VARCHAR2 		Angler Last Name
SUFFIX
VARCHAR2 		Suffic Of Angler Name (Jr. Sr. 111 etc)
ADDRESS1
VARCHAR2 		First Line Of Angler Address
ADDRESS2
VARCHAR2 		Second Line Of Angler Address
CITY
VARCHAR2 		City Of Angler Address
STATE
VARCHAR2 		State Of Angler Address
ZIP
VARCHAR2 		ZIp Code Of Angler Address
COUNTRY
VARCHAR2 		Country Of Angler Address
HOMEPHONE
VARCHAR2 		Home phone Number Of Angler
WORKPHONE
VARCHAR2 		Work phone Number Of Angler
MISC
VARCHAR2 		Miscellaneous Note About the Angler
FAX
VARCHAR2 		Fax Of Angler
LAST_UPDATE
DATE 		Data Record Was Last Updated
CLEAN
VARCHAR2 		Code to indicate cleanliness of data
FOREIGN_ZIP
VARCHAR2 		vetigal column having no use
BOAT
VARCHAR2 		Boat Name Of WHere Angler Fished,
FLEET
VARCHAR2 		Is a fleet associated with the boat. (Y if YEs, otherwise blank(
FLEETNAME
VARCHAR2 		Fleetname When Boat is associated WIth a Fleet

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: Table: TBF_ANGLERS
Short Name: TBF_ANGLERS
Status: Completed
Abstract:

Copy of Angler Table From The Bullfish Foundation
Notes:

Loaded by batch 2083, 02-22-2008 12:10

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CTSPAT
Description:

Copy of Angler Table From The Bullfish Foundation

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ANGLER_ID NUMBER Angler Number (Artificial Key)
100
 DATEENTERED DATE Date Record Was Entered
100
 ORGANIZATION VARCHAR2 Organization Angler Noted to be being a member of
100
 TITLE VARCHAR2 Title Of Angler (Mr, Captain, DR etc)
100
 FIRSTNAME VARCHAR2 Angler FIrst Name
100
 LASTNAME VARCHAR2 Angler Last Name
100
 SUFFIX VARCHAR2 Suffic Of Angler Name (Jr. Sr. 111 etc)
100
 ADDRESS1 VARCHAR2 First Line Of Angler Address
100
 ADDRESS2 VARCHAR2 Second Line Of Angler Address
100
 CITY VARCHAR2 City Of Angler Address
100
 STATE VARCHAR2 State Of Angler Address
100
 ZIP VARCHAR2 ZIp Code Of Angler Address
100
 COUNTRY VARCHAR2 Country Of Angler Address
100
 HOMEPHONE VARCHAR2 Home phone Number Of Angler
100
 WORKPHONE VARCHAR2 Work phone Number Of Angler
100
 MISC VARCHAR2 Miscellaneous Note About the Angler
100
 FAX VARCHAR2 Fax Of Angler
100
 LAST_UPDATE DATE Data Record Was Last Updated
100
 CLEAN VARCHAR2 Code to indicate cleanliness of data
100
 FOREIGN_ZIP VARCHAR2 vetigal column having no use
100
 BOAT VARCHAR2 Boat Name Of WHere Angler Fished,
100
 FLEET VARCHAR2 Is a fleet associated with the boat. (Y if YEs, otherwise blank(
100
 FLEETNAME VARCHAR2 Fleetname When Boat is associated WIth a Fleet

Attribute Details

ANGLER_ID

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

Angler Number (Artificial Key)
General Data Type: NUMBER

DATEENTERED

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

Date Record Was Entered
General Data Type: DATE

ORGANIZATION

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

Organization Angler Noted to be being a member of
General Data Type: VARCHAR2

TITLE

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

Title Of Angler (Mr, Captain, DR etc)
General Data Type: VARCHAR2

FIRSTNAME

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

Angler FIrst Name
General Data Type: VARCHAR2

LASTNAME

CC ID: 26782
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Angler Last Name
General Data Type: VARCHAR2

SUFFIX

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

Suffic Of Angler Name (Jr. Sr. 111 etc)
General Data Type: VARCHAR2

ADDRESS1

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

First Line Of Angler Address
General Data Type: VARCHAR2

ADDRESS2

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

Second Line Of Angler Address
General Data Type: VARCHAR2

CITY

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

City Of Angler Address
General Data Type: VARCHAR2

STATE

CC ID: 26787
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

State Of Angler Address
General Data Type: VARCHAR2

ZIP

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

ZIp Code Of Angler Address
General Data Type: VARCHAR2

COUNTRY

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

Country Of Angler Address
General Data Type: VARCHAR2

HOMEPHONE

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

Home phone Number Of Angler
General Data Type: VARCHAR2

WORKPHONE

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

Work phone Number Of Angler
General Data Type: VARCHAR2

MISC

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

Miscellaneous Note About the Angler
General Data Type: VARCHAR2

FAX

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

Fax Of Angler
General Data Type: VARCHAR2

LAST_UPDATE

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

Data Record Was Last Updated
General Data Type: DATE

CLEAN

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

Code to indicate cleanliness of data
General Data Type: VARCHAR2

FOREIGN_ZIP

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

vetigal column having no use
General Data Type: VARCHAR2

BOAT

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

Boat Name Of WHere Angler Fished,
General Data Type: VARCHAR2

FLEET

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

Is a fleet associated with the boat. (Y if YEs, otherwise blank(
General Data Type: VARCHAR2

FLEETNAME

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

Fleetname When Boat is associated WIth a Fleet
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7111
GUID: gov.noaa.nmfs.inport:7111
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-22 12:11+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