Metadata Rubric

100%

6 / 6

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

View: CTS_INTERACTIONS_EXTRACT_V

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

View Of data starting with 01/01/2003

Description

View Of data starting with 01/01/2003

Entity Type
Data View

Data Attribute / Type	Description
ANIMAL_ID NUMBER	Key to Identifies Animal
AGENCY_ID VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (tag1)
AGENCY_NAME VARCHAR2	Agency Name
TAG_ID VARCHAR2	Tagnumber
EVENT_ID NUMBER	Code to identify tagging event
TAG_DATE VARCHAR2	Date animal was released or recaptured.
NEXT_TAG_AGENCY_ID VARCHAR2	Agency Id associated with value in the nexttag column
NEXT_TAG_ID VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (nexttag)
INTERACTION_ORDER NUMBER	Number denoting the order of the interaction.
LENGTH NUMBER	Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
LENGTHUNIT VARCHAR2	Length Units
LENGTHTYPE VARCHAR2	Type Of Length Measurment Taken
LENGTHDET VARCHAR2	How Length Was Measurment was determined
WEIGHT NUMBER	Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
WEIGHTUNIT VARCHAR2	Weight Units
WEIGHTTYPE VARCHAR2	Type Of Weight Mesurment Taken
WEIGHTDET VARCHAR2	How weight measurement was determined
LATITUDE NUMBER	Numeric value for the latitude of the tagging location.
LONGITUDE NUMBER	Numeric value the the longitude of the tagging location.
STAT_ZONE_ID NUMBER	Code to indciate State Zone
COUNTRY_ID VARCHAR2	Cde to indicate Country
STATE_ID VARCHAR2	Code to indicate state
WATER_BODY_ID NUMBER	Code to Indicate waterbody of where tagging took place
PLACE_ID VARCHAR2	Code to indicate place of wheer tagging took palce
GEAR_ID VARCHAR2	Code for gear used to catch the animal.
GEAR_NAME VARCHAR2	Common Name For Gear used in fishing
BAIT_TYPE VARCHAR2	Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
METHOD_ID NUMBER	Code To indicate tagging methodology Used
SAMPLE_ID NUMBER	Code to indicate Sampling Methodology
CAPTAIN_AGENCY VARCHAR2	COde to indicate agency which assigned angler code for boat captain
CAPTAIN_ID NUMBER	Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
TAGGER_INITIALS VARCHAR2	Initials Of Taggers
TAGGER_AFFILIATION VARCHAR2	Code Of Agency that is affiliated With The Tagger
VESSEL_AGENCY VARCHAR2	Agency For Vessel COode
VESSEL_ID NUMBER	Agency supplied code identifying the vessel involved in the release or recapture of the animal.
PHYSICAL_DATA_ID NUMBER	Physical Data Identification Number
NOTES NUMBER	Any Other Notes On Tagging
FIGHTHRS NUMBER	Whole Number Of houirs spent landing The animal
FIGHTMINS NUMBER	Number Of minutes (up to 59) landing the animal
ANGLER_AGENCY_ID VARCHAR2	Agency Id associated with the angler number is
ANGLER_ID NUMBER	Unique identifier for each person in the database.
ID NUMBER	Identifies Ang;er
DATE_ENTERED VARCHAR2	The date the data was entered.
SPECIES_ID VARCHAR2	Species Code
SEX VARCHAR2	Code to indicate sex of the animal

Data Attribute / Type

Description

ANIMAL_ID
NUMBER

Key to Identifies Animal

AGENCY_ID
VARCHAR2

Code to Indicate Tagging agency of identifying tag on animal (tag1)

AGENCY_NAME
VARCHAR2

Agency Name

TAG_ID
VARCHAR2

Tagnumber

EVENT_ID
NUMBER

Code to identify tagging event

TAG_DATE
VARCHAR2

Date animal was released or recaptured.

NEXT_TAG_AGENCY_ID
VARCHAR2

Agency Id associated with value in the nexttag column

NEXT_TAG_ID
VARCHAR2

Code to Indicate Tagging agency of identifying tag on animal (nexttag)

INTERACTION_ORDER
NUMBER

Number denoting the order of the interaction.

LENGTH
NUMBER

Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.

LENGTHUNIT
VARCHAR2

Length Units

LENGTHTYPE
VARCHAR2

Type Of Length Measurment Taken

LENGTHDET
VARCHAR2

How Length Was Measurment was determined

WEIGHT
NUMBER

Weight of an animal tagged, based upon weightunit, weighttype and weightdet.

WEIGHTUNIT
VARCHAR2

Weight Units

WEIGHTTYPE
VARCHAR2

Type Of Weight Mesurment Taken

WEIGHTDET
VARCHAR2

How weight measurement was determined

LATITUDE
NUMBER

Numeric value for the latitude of the tagging location.

LONGITUDE
NUMBER

Numeric value the the longitude of the tagging location.

STAT_ZONE_ID
NUMBER

Code to indciate State Zone

COUNTRY_ID
VARCHAR2

Cde to indicate Country

STATE_ID
VARCHAR2

Code to indicate state

WATER_BODY_ID
NUMBER

Code to Indicate waterbody of where tagging took place

PLACE_ID
VARCHAR2

Code to indicate place of wheer tagging took palce

GEAR_ID
VARCHAR2

Code for gear used to catch the animal.

GEAR_NAME
VARCHAR2

Common Name For Gear used in fishing

BAIT_TYPE
VARCHAR2

Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown

METHOD_ID
NUMBER

Code To indicate tagging methodology Used

SAMPLE_ID
NUMBER

Code to indicate Sampling Methodology

CAPTAIN_AGENCY
VARCHAR2

COde to indicate agency which assigned angler code for boat captain

CAPTAIN_ID
NUMBER

Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.

TAGGER_INITIALS
VARCHAR2

Initials Of Taggers

TAGGER_AFFILIATION
VARCHAR2

Code Of Agency that is affiliated With The Tagger

VESSEL_AGENCY
VARCHAR2

Agency For Vessel COode

VESSEL_ID
NUMBER

Agency supplied code identifying the vessel involved in the release or recapture of the animal.

PHYSICAL_DATA_ID
NUMBER

Physical Data Identification Number

NOTES
NUMBER

Any Other Notes On Tagging

FIGHTHRS
NUMBER

Whole Number Of houirs spent landing The animal

FIGHTMINS
NUMBER

Number Of minutes (up to 59) landing the animal

ANGLER_AGENCY_ID
VARCHAR2

Agency Id associated with the angler number is

ANGLER_ID
NUMBER

Unique identifier for each person in the database.

ID
NUMBER

Identifies Ang;er

DATE_ENTERED
VARCHAR2

The date the data was entered.

SPECIES_ID
VARCHAR2

Species Code

SEX
VARCHAR2

Code to indicate sex of the animal

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_INTERACTIONS_EXTRACT_V
Short Name:	CTS_INTERACTIONS_EXTRACT_V
Status:	Completed
Abstract:	View Of data starting with 01/01/2003
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	CTSPAT
Description:	View Of data starting with 01/01/2003

Attribute Summary

	Name	Type	Description
100	ANIMAL_ID	NUMBER	Key to Identifies Animal
100	AGENCY_ID	VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (tag1)
100	AGENCY_NAME	VARCHAR2	Agency Name
100	TAG_ID	VARCHAR2	Tagnumber
100	EVENT_ID	NUMBER	Code to identify tagging event
100	TAG_DATE	VARCHAR2	Date animal was released or recaptured.
100	NEXT_TAG_AGENCY_ID	VARCHAR2	Agency Id associated with value in the nexttag column
100	NEXT_TAG_ID	VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (nexttag)
100	INTERACTION_ORDER	NUMBER	Number denoting the order of the interaction.
100	LENGTH	NUMBER	Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
100	LENGTHUNIT	VARCHAR2	Length Units
100	LENGTHTYPE	VARCHAR2	Type Of Length Measurment Taken
100	LENGTHDET	VARCHAR2	How Length Was Measurment was determined
100	WEIGHT	NUMBER	Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
100	WEIGHTUNIT	VARCHAR2	Weight Units
100	WEIGHTTYPE	VARCHAR2	Type Of Weight Mesurment Taken
100	WEIGHTDET	VARCHAR2	How weight measurement was determined
100	LATITUDE	NUMBER	Numeric value for the latitude of the tagging location.
100	LONGITUDE	NUMBER	Numeric value the the longitude of the tagging location.
100	STAT_ZONE_ID	NUMBER	Code to indciate State Zone
100	COUNTRY_ID	VARCHAR2	Cde to indicate Country
100	STATE_ID	VARCHAR2	Code to indicate state
100	WATER_BODY_ID	NUMBER	Code to Indicate waterbody of where tagging took place
100	PLACE_ID	VARCHAR2	Code to indicate place of wheer tagging took palce
100	GEAR_ID	VARCHAR2	Code for gear used to catch the animal.
100	GEAR_NAME	VARCHAR2	Common Name For Gear used in fishing
100	BAIT_TYPE	VARCHAR2	Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
100	METHOD_ID	NUMBER	Code To indicate tagging methodology Used
100	SAMPLE_ID	NUMBER	Code to indicate Sampling Methodology
100	CAPTAIN_AGENCY	VARCHAR2	COde to indicate agency which assigned angler code for boat captain
100	CAPTAIN_ID	NUMBER	Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.
100	TAGGER_INITIALS	VARCHAR2	Initials Of Taggers
100	TAGGER_AFFILIATION	VARCHAR2	Code Of Agency that is affiliated With The Tagger
100	VESSEL_AGENCY	VARCHAR2	Agency For Vessel COode
100	VESSEL_ID	NUMBER	Agency supplied code identifying the vessel involved in the release or recapture of the animal.
100	PHYSICAL_DATA_ID	NUMBER	Physical Data Identification Number
100	NOTES	NUMBER	Any Other Notes On Tagging
100	FIGHTHRS	NUMBER	Whole Number Of houirs spent landing The animal
100	FIGHTMINS	NUMBER	Number Of minutes (up to 59) landing the animal
100	ANGLER_AGENCY_ID	VARCHAR2	Agency Id associated with the angler number is
100	ANGLER_ID	NUMBER	Unique identifier for each person in the database.
100	ID	NUMBER	Identifies Ang;er
100	DATE_ENTERED	VARCHAR2	The date the data was entered.
100	SPECIES_ID	VARCHAR2	Species Code
100	SEX	VARCHAR2	Code to indicate sex of the animal

Name

Type

Description

100

ANIMAL_ID

NUMBER

Key to Identifies Animal

100

AGENCY_ID

VARCHAR2

Code to Indicate Tagging agency of identifying tag on animal (tag1)

100

AGENCY_NAME

VARCHAR2

Agency Name

100

TAG_ID

VARCHAR2

Tagnumber

100

EVENT_ID

NUMBER

Code to identify tagging event

100

TAG_DATE

VARCHAR2

Date animal was released or recaptured.

100

NEXT_TAG_AGENCY_ID

VARCHAR2

Agency Id associated with value in the nexttag column

100

NEXT_TAG_ID

VARCHAR2

Code to Indicate Tagging agency of identifying tag on animal (nexttag)

100

INTERACTION_ORDER

NUMBER

Number denoting the order of the interaction.

100

LENGTH

NUMBER

Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.

100

LENGTHUNIT

VARCHAR2

Length Units

100

LENGTHTYPE

VARCHAR2

Type Of Length Measurment Taken

100

LENGTHDET

VARCHAR2

How Length Was Measurment was determined

100

WEIGHT

NUMBER

Weight of an animal tagged, based upon weightunit, weighttype and weightdet.

100

WEIGHTUNIT

VARCHAR2

Weight Units

100

WEIGHTTYPE

VARCHAR2

Type Of Weight Mesurment Taken

100

WEIGHTDET

VARCHAR2

How weight measurement was determined

100

LATITUDE

NUMBER

Numeric value for the latitude of the tagging location.

100

LONGITUDE

NUMBER

Numeric value the the longitude of the tagging location.

100

STAT_ZONE_ID

NUMBER

Code to indciate State Zone

100

COUNTRY_ID

VARCHAR2

Cde to indicate Country

100

STATE_ID

VARCHAR2

Code to indicate state

100

WATER_BODY_ID

NUMBER

Code to Indicate waterbody of where tagging took place

100

PLACE_ID

VARCHAR2

Code to indicate place of wheer tagging took palce

100

GEAR_ID

VARCHAR2

Code for gear used to catch the animal.

100

GEAR_NAME

VARCHAR2

Common Name For Gear used in fishing

100

BAIT_TYPE

VARCHAR2

Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown

100

METHOD_ID

NUMBER

Code To indicate tagging methodology Used

100

SAMPLE_ID

NUMBER

Code to indicate Sampling Methodology

100

CAPTAIN_AGENCY

VARCHAR2

COde to indicate agency which assigned angler code for boat captain

100

CAPTAIN_ID

NUMBER

Unique numeric code assigned to an individual captain. Must be greater than zero or -99999.

100

TAGGER_INITIALS

VARCHAR2

Initials Of Taggers

100

TAGGER_AFFILIATION

VARCHAR2

Code Of Agency that is affiliated With The Tagger

100

VESSEL_AGENCY

VARCHAR2

Agency For Vessel COode

100

VESSEL_ID

NUMBER

Agency supplied code identifying the vessel involved in the release or recapture of the animal.

100

PHYSICAL_DATA_ID

NUMBER

Physical Data Identification Number

100

NOTES

NUMBER

Any Other Notes On Tagging

100

FIGHTHRS

NUMBER

Whole Number Of houirs spent landing The animal

100

FIGHTMINS

NUMBER

Number Of minutes (up to 59) landing the animal

100

ANGLER_AGENCY_ID

VARCHAR2

Agency Id associated with the angler number is

100

ANGLER_ID

NUMBER

Unique identifier for each person in the database.

100

NUMBER

Identifies Ang;er

100

DATE_ENTERED

VARCHAR2

The date the data was entered.

100

SPECIES_ID

VARCHAR2

Species Code

100

SEX

VARCHAR2

Code to indicate sex of the animal

Attribute Details

ANIMAL_ID

CC ID: 25778

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Key to Identifies Animal
General Data Type:	NUMBER

AGENCY_ID

CC ID: 25752

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code to Indicate Tagging agency of identifying tag on animal (tag1)
General Data Type:	VARCHAR2

AGENCY_NAME

CC ID: 25779

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

TAG_ID

CC ID: 25763

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Tagnumber
General Data Type:	VARCHAR2

EVENT_ID

CC ID: 25765

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Code to identify tagging event
General Data Type:	NUMBER

TAG_DATE

CC ID: 25770

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Date animal was released or recaptured.
General Data Type:	VARCHAR2

NEXT_TAG_AGENCY_ID

CC ID: 25750

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Agency Id associated with value in the nexttag column
General Data Type:	VARCHAR2

NEXT_TAG_ID

CC ID: 25769

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to Indicate Tagging agency of identifying tag on animal (nexttag)
General Data Type:	VARCHAR2

INTERACTION_ORDER

CC ID: 25780

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number denoting the order of the interaction.
General Data Type:	NUMBER

LENGTH

CC ID: 25739

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Length of animal tagged based on the lengthunit, lengthtype, and lengthdet.
General Data Type:	NUMBER

LENGTHUNIT

CC ID: 25756

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Length Units
General Data Type:	VARCHAR2

LENGTHTYPE

CC ID: 25755

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type Of Length Measurment Taken
General Data Type:	VARCHAR2

LENGTHDET

CC ID: 25762

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	How Length Was Measurment was determined
General Data Type:	VARCHAR2

WEIGHT

CC ID: 25754

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	2
Status:	Active
Description:	Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
General Data Type:	NUMBER

WEIGHTUNIT

CC ID: 25771

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Weight Units
General Data Type:	VARCHAR2

WEIGHTTYPE

CC ID: 25757

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Type Of Weight Mesurment Taken
General Data Type:	VARCHAR2

WEIGHTDET

CC ID: 25764

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	How weight measurement was determined
General Data Type:	VARCHAR2

LATITUDE

CC ID: 25773

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	30
Scale:	16
Status:	Active
Description:	Numeric value for the latitude of the tagging location.
General Data Type:	NUMBER

LONGITUDE

CC ID: 25741

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	30
Scale:	16
Status:	Active
Description:	Numeric value the the longitude of the tagging location.
General Data Type:	NUMBER

STAT_ZONE_ID

CC ID: 25744

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Code to indciate State Zone
General Data Type:	NUMBER

COUNTRY_ID

CC ID: 25776

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Cde to indicate Country
General Data Type:	VARCHAR2

STATE_ID

CC ID: 25774

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to indicate state
General Data Type:	VARCHAR2

WATER_BODY_ID

CC ID: 25740

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	3
Status:	Active
Description:	Code to Indicate waterbody of where tagging took place
General Data Type:	NUMBER

PLACE_ID

CC ID: 25745

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to indicate place of wheer tagging took palce
General Data Type:	VARCHAR2

GEAR_ID

CC ID: 25753

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for gear used to catch the animal.
General Data Type:	VARCHAR2

GEAR_NAME

CC ID: 25751

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Common Name For Gear used in fishing
General Data Type:	VARCHAR2

BAIT_TYPE

CC ID: 25767

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown
General Data Type:	VARCHAR2

METHOD_ID

CC ID: 25781

Seq. Order:	28
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Code To indicate tagging methodology Used
General Data Type:	NUMBER

SAMPLE_ID

CC ID: 25747

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Code to indicate Sampling Methodology
General Data Type:	NUMBER

CAPTAIN_AGENCY

CC ID: 25749

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	COde to indicate agency which assigned angler code for boat captain
General Data Type:	VARCHAR2

CAPTAIN_ID

CC ID: 25737

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

TAGGER_INITIALS

CC ID: 25761

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Initials Of Taggers
General Data Type:	VARCHAR2

TAGGER_AFFILIATION

CC ID: 25758

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code Of Agency that is affiliated With The Tagger
General Data Type:	VARCHAR2

VESSEL_AGENCY

CC ID: 25742

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Agency For Vessel COode
General Data Type:	VARCHAR2

VESSEL_ID

CC ID: 25766

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Agency supplied code identifying the vessel involved in the release or recapture of the animal.
General Data Type:	NUMBER

PHYSICAL_DATA_ID

CC ID: 25759

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Physical Data Identification Number
General Data Type:	NUMBER

NOTES

CC ID: 25748

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Any Other Notes On Tagging
General Data Type:	NUMBER

FIGHTHRS

CC ID: 25760

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Whole Number Of houirs spent landing The animal
General Data Type:	NUMBER

FIGHTMINS

CC ID: 25738

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number Of minutes (up to 59) landing the animal
General Data Type:	NUMBER

ANGLER_AGENCY_ID

CC ID: 25768

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Agency Id associated with the angler number is
General Data Type:	VARCHAR2

ANGLER_ID

CC ID: 25743

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Unique identifier for each person in the database.
General Data Type:	NUMBER

ID

CC ID: 25775

Seq. Order:	42
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Identifies Ang;er
General Data Type:	NUMBER

DATE_ENTERED

CC ID: 25772

Seq. Order:	43
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The date the data was entered.
General Data Type:	VARCHAR2

SPECIES_ID

CC ID: 25746

Seq. Order:	44
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Species Code
General Data Type:	VARCHAR2

SEX

CC ID: 25777

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to indicate sex of the animal
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ID

AGENCY_ID

AGENCY_NAME

TAG_ID

EVENT_ID

TAG_DATE

NEXT_TAG_AGENCY_ID

NEXT_TAG_ID

INTERACTION_ORDER

LENGTH

LENGTHUNIT

LENGTHTYPE

LENGTHDET

WEIGHT

WEIGHTUNIT

WEIGHTTYPE

WEIGHTDET

LATITUDE

LONGITUDE

STAT_ZONE_ID

COUNTRY_ID

STATE_ID

WATER_BODY_ID

PLACE_ID

GEAR_ID

GEAR_NAME

BAIT_TYPE

METHOD_ID

SAMPLE_ID

CAPTAIN_AGENCY

CAPTAIN_ID

TAGGER_INITIALS

TAGGER_AFFILIATION

VESSEL_AGENCY

VESSEL_ID

PHYSICAL_DATA_ID

NOTES

FIGHTHRS

FIGHTMINS

ANGLER_AGENCY_ID

ANGLER_ID

ID

DATE_ENTERED

SPECIES_ID

SEX

Catalog Details