Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Cooperative Tagging System > Cooperative Tagging Center (CTC) >

View: CTS_ANGLERS_V

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

View Of Anglers with decodes

Description

View Of Anglers with decodes

Entity Type
Data View

Data Attribute / Type	Description
ANGLER_ID NUMBER	Unique numeric code assigned to an individual angler. Must be greater than zero.
AGENCY_ID VARCHAR2	Code for the agency assigning angler codes.
AGENCY_NAME VARCHAR2	Agency Name Corresponding To Agency ID
FNAME VARCHAR2	The angler's first name.
M_INITIAL VARCHAR2	The angler's middle initial.
LNAME VARCHAR2	The angler's last name.
TITLE VARCHAR2	The title or salutation for greeting this angler when letters are sent.
SUFFIX VARCHAR2	The suffix such as Jr. or Sr. for an angler.
ADDRESS_1 VARCHAR2	The first line of the angler's address.
ADDRESS_2 VARCHAR2	The second line of the angler's address.
CITY VARCHAR2	City where angler receives mail.
STATE_ID VARCHAR2	U.S. state where angler receives mail. Not allowed for a foreign address.
STATE_NAME VARCHAR2	State Name COrresponding to State Code
COUNTRY_ID VARCHAR2	Country where angler receives mail.
COUNTRY_NAME VARCHAR2	Country Name Corresponding to Country Code
ZIPCODE VARCHAR2	The angler's zip code.
HOME_NUMBER VARCHAR2	The angler's home phone number.
WORK_NUMBER VARCHAR2	The angler's work phone number.
MOBILE_NUMBER VARCHAR2	The angler's mobilephone number.
FAX_NUMBER VARCHAR2	The angler's facsimile phone number.
EMAIL VARCHAR2	The angler's email address
NOTES NUMBER	The number for a note on the angler.
NOTE_DESCRIPTION VARCHAR2	Description Of Note Code

Data Attribute / Type

Description

ANGLER_ID
NUMBER

Unique numeric code assigned to an individual angler. Must be greater than zero.

AGENCY_ID
VARCHAR2

Code for the agency assigning angler codes.

AGENCY_NAME
VARCHAR2

Agency Name Corresponding To Agency ID

FNAME
VARCHAR2

The angler's first name.

M_INITIAL
VARCHAR2

The angler's middle initial.

LNAME
VARCHAR2

The angler's last name.

TITLE
VARCHAR2

The title or salutation for greeting this angler when letters are sent.

SUFFIX
VARCHAR2

The suffix such as Jr. or Sr. for an angler.

ADDRESS_1
VARCHAR2

The first line of the angler's address.

ADDRESS_2
VARCHAR2

The second line of the angler's address.

CITY
VARCHAR2

City where angler receives mail.

STATE_ID
VARCHAR2

U.S. state where angler receives mail. Not allowed for a foreign address.

STATE_NAME
VARCHAR2

State Name COrresponding to State Code

COUNTRY_ID
VARCHAR2

Country where angler receives mail.

COUNTRY_NAME
VARCHAR2

Country Name Corresponding to Country Code

ZIPCODE
VARCHAR2

The angler's zip code.

HOME_NUMBER
VARCHAR2

The angler's home phone number.

WORK_NUMBER
VARCHAR2

The angler's work phone number.

MOBILE_NUMBER
VARCHAR2

The angler's mobilephone number.

FAX_NUMBER
VARCHAR2

The angler's facsimile phone number.

EMAIL
VARCHAR2

The angler's email address

NOTES
NUMBER

The number for a note on the angler.

NOTE_DESCRIPTION
VARCHAR2

Description Of Note Code

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: CTS_ANGLERS_V
Short Name:	CTS_ANGLERS_V
Status:	Completed
Abstract:	View Of Anglers with decodes
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	CTSPAT
Description:	View Of Anglers with decodes

Attribute Summary

	Name	Type	Description
100	ANGLER_ID	NUMBER	Unique numeric code assigned to an individual angler. Must be greater than zero.
100	AGENCY_ID	VARCHAR2	Code for the agency assigning angler codes.
100	AGENCY_NAME	VARCHAR2	Agency Name Corresponding To Agency ID
100	FNAME	VARCHAR2	The angler's first name.
100	M_INITIAL	VARCHAR2	The angler's middle initial.
100	LNAME	VARCHAR2	The angler's last name.
100	TITLE	VARCHAR2	The title or salutation for greeting this angler when letters are sent.
100	SUFFIX	VARCHAR2	The suffix such as Jr. or Sr. for an angler.
100	ADDRESS_1	VARCHAR2	The first line of the angler's address.
100	ADDRESS_2	VARCHAR2	The second line of the angler's address.
100	CITY	VARCHAR2	City where angler receives mail.
100	STATE_ID	VARCHAR2	U.S. state where angler receives mail. Not allowed for a foreign address.
100	STATE_NAME	VARCHAR2	State Name COrresponding to State Code
100	COUNTRY_ID	VARCHAR2	Country where angler receives mail.
100	COUNTRY_NAME	VARCHAR2	Country Name Corresponding to Country Code
100	ZIPCODE	VARCHAR2	The angler's zip code.
100	HOME_NUMBER	VARCHAR2	The angler's home phone number.
100	WORK_NUMBER	VARCHAR2	The angler's work phone number.
100	MOBILE_NUMBER	VARCHAR2	The angler's mobilephone number.
100	FAX_NUMBER	VARCHAR2	The angler's facsimile phone number.
100	EMAIL	VARCHAR2	The angler's email address
100	NOTES	NUMBER	The number for a note on the angler.
100	NOTE_DESCRIPTION	VARCHAR2	Description Of Note Code

Name

Type

Description

100

ANGLER_ID

NUMBER

Unique numeric code assigned to an individual angler. Must be greater than zero.

100

AGENCY_ID

VARCHAR2

Code for the agency assigning angler codes.

100

AGENCY_NAME

VARCHAR2

Agency Name Corresponding To Agency ID

100

FNAME

VARCHAR2

The angler's first name.

100

M_INITIAL

VARCHAR2

The angler's middle initial.

100

LNAME

VARCHAR2

The angler's last name.

100

TITLE

VARCHAR2

The title or salutation for greeting this angler when letters are sent.

100

SUFFIX

VARCHAR2

The suffix such as Jr. or Sr. for an angler.

100

ADDRESS_1

VARCHAR2

The first line of the angler's address.

100

ADDRESS_2

VARCHAR2

The second line of the angler's address.

100

CITY

VARCHAR2

City where angler receives mail.

100

STATE_ID

VARCHAR2

U.S. state where angler receives mail. Not allowed for a foreign address.

100

STATE_NAME

VARCHAR2

State Name COrresponding to State Code

100

COUNTRY_ID

VARCHAR2

Country where angler receives mail.

100

COUNTRY_NAME

VARCHAR2

Country Name Corresponding to Country Code

100

ZIPCODE

VARCHAR2

The angler's zip code.

100

HOME_NUMBER

VARCHAR2

The angler's home phone number.

100

WORK_NUMBER

VARCHAR2

The angler's work phone number.

100

MOBILE_NUMBER

VARCHAR2

The angler's mobilephone number.

100

FAX_NUMBER

VARCHAR2

The angler's facsimile phone number.

100

VARCHAR2

The angler's email address

100

NOTES

NUMBER

The number for a note on the angler.

100

NOTE_DESCRIPTION

VARCHAR2

Description Of Note Code

Attribute Details

ANGLER_ID

CC ID: 25620

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Unique numeric code assigned to an individual angler. Must be greater than zero.
General Data Type:	NUMBER

AGENCY_ID

CC ID: 25611

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code for the agency assigning angler codes.
General Data Type:	VARCHAR2

AGENCY_NAME

CC ID: 25625

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Agency Name Corresponding To Agency ID
General Data Type:	VARCHAR2

FNAME

CC ID: 25621

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's first name.
General Data Type:	VARCHAR2

M_INITIAL

CC ID: 25608

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's middle initial.
General Data Type:	VARCHAR2

LNAME

CC ID: 25622

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The angler's last name.
General Data Type:	VARCHAR2

TITLE

CC ID: 25607

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The title or salutation for greeting this angler when letters are sent.
General Data Type:	VARCHAR2

SUFFIX

CC ID: 25623

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The suffix such as Jr. or Sr. for an angler.
General Data Type:	VARCHAR2

ADDRESS_1

CC ID: 25626

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The first line of the angler's address.
General Data Type:	VARCHAR2

ADDRESS_2

CC ID: 25627

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The second line of the angler's address.
General Data Type:	VARCHAR2

CITY

CC ID: 25606

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	City where angler receives mail.
General Data Type:	VARCHAR2

STATE_ID

CC ID: 25615

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	U.S. state where angler receives mail. Not allowed for a foreign address.
General Data Type:	VARCHAR2

STATE_NAME

CC ID: 25614

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	State Name COrresponding to State Code
General Data Type:	VARCHAR2

COUNTRY_ID

CC ID: 25609

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Country where angler receives mail.
General Data Type:	VARCHAR2

COUNTRY_NAME

CC ID: 25612

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Country Name Corresponding to Country Code
General Data Type:	VARCHAR2

ZIPCODE

CC ID: 25617

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's zip code.
General Data Type:	VARCHAR2

HOME_NUMBER

CC ID: 25624

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's home phone number.
General Data Type:	VARCHAR2

WORK_NUMBER

CC ID: 25610

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's work phone number.
General Data Type:	VARCHAR2

MOBILE_NUMBER

CC ID: 25605

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's mobilephone number.
General Data Type:	VARCHAR2

FAX_NUMBER

CC ID: 25619

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's facsimile phone number.
General Data Type:	VARCHAR2

EMAIL

CC ID: 25613

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The angler's email address
General Data Type:	VARCHAR2

NOTES

CC ID: 25618

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The number for a note on the angler.
General Data Type:	NUMBER

NOTE_DESCRIPTION

CC ID: 25616

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Description Of Note Code
General Data Type:	VARCHAR2

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

View: CTS_ANGLERS_V

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANGLER_ID

AGENCY_ID

AGENCY_NAME

FNAME

M_INITIAL

LNAME

TITLE

SUFFIX

ADDRESS_1

ADDRESS_2

CITY

STATE_ID

STATE_NAME

COUNTRY_ID

COUNTRY_NAME

ZIPCODE

HOME_NUMBER

WORK_NUMBER

MOBILE_NUMBER

FAX_NUMBER

EMAIL

NOTES

NOTE_DESCRIPTION

Catalog Details