Metadata Rubric

100%

6 / 6

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

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

	Name	Type	Description
100	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

Name

Type

Description

100

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