Metadata Rubric

100%

6 / 6

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

View: SECOND_INTERACTIONS_V

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

View of First Recapture Records

Description

View of First Recapture Records

Entity Type
Data View

Data Attribute / Type	Description
ANIMAL_ID NUMBER	Key to Identifies Animal
SPECIES VARCHAR2	Species Code Used In NMFS Tagging Program
SEX VARCHAR2	Code to indicate sex of the animal
AGENCY_ID VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (tag1)
TAG_ID VARCHAR2	Tagnumber
EVENT_ID NUMBER	Code to identify tagging event
TAG_DATE DATE	Date animal was released or recaptured.
NEXT_TAG_AGENCY VARCHAR2	Code For Agency That Issued the next tag (second tag) on this record
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.
LENGTH_UNIT VARCHAR2	Units for Length Measurement
LENGTH_TYPE VARCHAR2	Code to determine The Type Of Length MEasurement taken
LENGTH_DETERMINATION VARCHAR2	Code To Indicate How Length Was determined
WEIGHT NUMBER	Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
WEIGHT_UNIT VARCHAR2	Units for Weight Measurement
WEIGHT_TYPE VARCHAR2	Code For Type Of Weight Measurement
WEIGHT_DETERMINATION VARCHAR2	Code For How Weight 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.
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_TYPE VARCHAR2	Indicates Type Of Tagger
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
FIGHT_HOURS NUMBER	Number Of Hours Spent FIghting/Landings Fish
FIGHT_MINUTES NUMBER	Number Of Minutes (up to 59) spent FIghting/Landings Fish
ANGLER_AGENCY VARCHAR2	Agency That Has Angler Code list
ANGLER_ID NUMBER	Unique identifier for each person in the database.
DATE_ENTERED DATE	The date the data was entered.

Data Attribute / Type

Description

ANIMAL_ID
NUMBER

Key to Identifies Animal

SPECIES
VARCHAR2

Species Code Used In NMFS Tagging Program

SEX
VARCHAR2

Code to indicate sex of the animal

AGENCY_ID
VARCHAR2

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

TAG_ID
VARCHAR2

Tagnumber

EVENT_ID
NUMBER

Code to identify tagging event

TAG_DATE
DATE

Date animal was released or recaptured.

NEXT_TAG_AGENCY
VARCHAR2

Code For Agency That Issued the next tag (second tag) on this record

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.

LENGTH_UNIT
VARCHAR2

Units for Length Measurement

LENGTH_TYPE
VARCHAR2

Code to determine The Type Of Length MEasurement taken

LENGTH_DETERMINATION
VARCHAR2

Code To Indicate How Length Was determined

WEIGHT
NUMBER

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

WEIGHT_UNIT
VARCHAR2

Units for Weight Measurement

WEIGHT_TYPE
VARCHAR2

Code For Type Of Weight Measurement

WEIGHT_DETERMINATION
VARCHAR2

Code For How Weight 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.

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_TYPE
VARCHAR2

Indicates Type Of Tagger

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

FIGHT_HOURS
NUMBER

Number Of Hours Spent FIghting/Landings Fish

FIGHT_MINUTES
NUMBER

Number Of Minutes (up to 59) spent FIghting/Landings Fish

ANGLER_AGENCY
VARCHAR2

Agency That Has Angler Code list

ANGLER_ID
NUMBER

Unique identifier for each person in the database.

DATE_ENTERED
DATE

The date the data was entered.

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: SECOND_INTERACTIONS_V
Short Name:	SECOND_INTERACTIONS_V
Status:	Completed
Abstract:	View of First Recapture Records
Notes:	Loaded by batch 2083, 02-22-2008 12:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	CTSPAT
Description:	View of First Recapture Records

Attribute Summary

	Name	Type	Description
100	ANIMAL_ID	NUMBER	Key to Identifies Animal
100	SPECIES	VARCHAR2	Species Code Used In NMFS Tagging Program
100	SEX	VARCHAR2	Code to indicate sex of the animal
100	AGENCY_ID	VARCHAR2	Code to Indicate Tagging agency of identifying tag on animal (tag1)
100	TAG_ID	VARCHAR2	Tagnumber
100	EVENT_ID	NUMBER	Code to identify tagging event
100	TAG_DATE	DATE	Date animal was released or recaptured.
100	NEXT_TAG_AGENCY	VARCHAR2	Code For Agency That Issued the next tag (second tag) on this record
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	LENGTH_UNIT	VARCHAR2	Units for Length Measurement
100	LENGTH_TYPE	VARCHAR2	Code to determine The Type Of Length MEasurement taken
100	LENGTH_DETERMINATION	VARCHAR2	Code To Indicate How Length Was determined
100	WEIGHT	NUMBER	Weight of an animal tagged, based upon weightunit, weighttype and weightdet.
100	WEIGHT_UNIT	VARCHAR2	Units for Weight Measurement
100	WEIGHT_TYPE	VARCHAR2	Code For Type Of Weight Measurement
100	WEIGHT_DETERMINATION	VARCHAR2	Code For How Weight 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	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_TYPE	VARCHAR2	Indicates Type Of Tagger
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	FIGHT_HOURS	NUMBER	Number Of Hours Spent FIghting/Landings Fish
100	FIGHT_MINUTES	NUMBER	Number Of Minutes (up to 59) spent FIghting/Landings Fish
100	ANGLER_AGENCY	VARCHAR2	Agency That Has Angler Code list
100	ANGLER_ID	NUMBER	Unique identifier for each person in the database.
100	DATE_ENTERED	DATE	The date the data was entered.

Name

Type

Description

100

ANIMAL_ID

NUMBER

Key to Identifies Animal

100

SPECIES

VARCHAR2

Species Code Used In NMFS Tagging Program

100

SEX

VARCHAR2

Code to indicate sex of the animal

100

AGENCY_ID

VARCHAR2

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

100

TAG_ID

VARCHAR2

Tagnumber

100

EVENT_ID

NUMBER

Code to identify tagging event

100

TAG_DATE

DATE

Date animal was released or recaptured.

100

NEXT_TAG_AGENCY

VARCHAR2

Code For Agency That Issued the next tag (second tag) on this record

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

LENGTH_UNIT

VARCHAR2

Units for Length Measurement

100

LENGTH_TYPE

VARCHAR2

Code to determine The Type Of Length MEasurement taken

100

LENGTH_DETERMINATION

VARCHAR2

Code To Indicate How Length Was determined

100

WEIGHT

NUMBER

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

100

WEIGHT_UNIT

VARCHAR2

Units for Weight Measurement

100

WEIGHT_TYPE

VARCHAR2

Code For Type Of Weight Measurement

100

WEIGHT_DETERMINATION

VARCHAR2

Code For How Weight 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

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_TYPE

VARCHAR2

Indicates Type Of Tagger

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

FIGHT_HOURS

NUMBER

Number Of Hours Spent FIghting/Landings Fish

100

FIGHT_MINUTES

NUMBER

Number Of Minutes (up to 59) spent FIghting/Landings Fish

100

ANGLER_AGENCY

VARCHAR2

Agency That Has Angler Code list

100

ANGLER_ID

NUMBER

Unique identifier for each person in the database.

100

DATE_ENTERED

DATE

The date the data was entered.

Attribute Details

ANIMAL_ID

CC ID: 26737

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

SPECIES

CC ID: 26733

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Species Code Used In NMFS Tagging Program
General Data Type:	VARCHAR2

SEX

CC ID: 26769

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

AGENCY_ID

CC ID: 26770

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

TAG_ID

CC ID: 26757

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

EVENT_ID

CC ID: 26753

Seq. Order:	6
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: 26731

Seq. Order:	7
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date animal was released or recaptured.
General Data Type:	DATE

NEXT_TAG_AGENCY

CC ID: 26761

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code For Agency That Issued the next tag (second tag) on this record
General Data Type:	VARCHAR2

NEXT_TAG_ID

CC ID: 26759

Seq. Order:	9
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: 26734

Seq. Order:	10
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: 26760

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

LENGTH_UNIT

CC ID: 26754

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

LENGTH_TYPE

CC ID: 26745

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to determine The Type Of Length MEasurement taken
General Data Type:	VARCHAR2

LENGTH_DETERMINATION

CC ID: 26752

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code To Indicate How Length Was determined
General Data Type:	VARCHAR2

WEIGHT

CC ID: 26762

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

WEIGHT_UNIT

CC ID: 26740

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

WEIGHT_TYPE

CC ID: 26755

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code For Type Of Weight Measurement
General Data Type:	VARCHAR2

WEIGHT_DETERMINATION

CC ID: 26764

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code For How Weight Was Determined
General Data Type:	VARCHAR2

LATITUDE

CC ID: 26758

Seq. Order:	19
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: 26735

Seq. Order:	20
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: 26744

Seq. Order:	21
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: 26750

Seq. Order:	22
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: 26765

Seq. Order:	23
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: 26768

Seq. Order:	24
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: 26736

Seq. Order:	25
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: 26742

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

BAIT_TYPE

CC ID: 26749

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: 26766

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: 26756

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: 26751

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: 26747

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: 26767

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_TYPE

CC ID: 26771

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates Type Of Tagger
General Data Type:	VARCHAR2

TAGGER_AFFILIATION

CC ID: 26730

Seq. Order:	34
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: 26738

Seq. Order:	35
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: 26743

Seq. Order:	36
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: 26746

Seq. Order:	37
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: 26732

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

FIGHT_HOURS

CC ID: 26748

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number Of Hours Spent FIghting/Landings Fish
General Data Type:	NUMBER

FIGHT_MINUTES

CC ID: 26729

Seq. Order:	40
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) spent FIghting/Landings Fish
General Data Type:	NUMBER

ANGLER_AGENCY

CC ID: 26741

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Agency That Has Angler Code list
General Data Type:	VARCHAR2

ANGLER_ID

CC ID: 26739

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

DATE_ENTERED

CC ID: 26763

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

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ANIMAL_ID

SPECIES

SEX

AGENCY_ID

TAG_ID

EVENT_ID

TAG_DATE

NEXT_TAG_AGENCY

NEXT_TAG_ID

INTERACTION_ORDER

LENGTH

LENGTH_UNIT

LENGTH_TYPE

LENGTH_DETERMINATION

WEIGHT

WEIGHT_UNIT

WEIGHT_TYPE

WEIGHT_DETERMINATION

LATITUDE

LONGITUDE

STAT_ZONE_ID

COUNTRY_ID

STATE_ID

WATER_BODY_ID

PLACE_ID

GEAR_ID

BAIT_TYPE

METHOD_ID

SAMPLE_ID

CAPTAIN_AGENCY

CAPTAIN_ID

TAGGER_INITIALS

TAGGER_TYPE

TAGGER_AFFILIATION

VESSEL_AGENCY

VESSEL_ID

PHYSICAL_DATA_ID

NOTES

FIGHT_HOURS

FIGHT_MINUTES

ANGLER_AGENCY

ANGLER_ID

DATE_ENTERED

Catalog Details