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) >

View: ICCAT_V

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

Summary

Abstract

View Of Data That is used for ICCAT Report

Description

View Of Data That is used for ICCAT Report

Entity Information

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_1
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction
TAG_ID_1
VARCHAR2 		Tagnumber at first tagging interaction
EVENT_ID_1
NUMBER 		Code to Indicate Tagging Event at first tagging interaction
TAG_DATE_1
VARCHAR2 		Date animal was released or recaptured t first tagging interaction.
NEXT_TAG_AGENCY_1
VARCHAR2 		Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction
NEXT_TAG_ID_1
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction
INTERACTION_ORDER_1
NUMBER 		Number denoting the order of the interaction at first tagging interaction.
LENGTH_1
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction.
LENGTH_UNIT_1
VARCHAR2 		Units for Length Measurement at first tagging interaction.
LENGTH_TYPE_1
VARCHAR2 		Code to determine The Type Of Length Measurement taken at first tagging interaction.
LENGTH_DETERMINATION_1
VARCHAR2 		Code To Indicate How Length Was determined at first tagging interaction
WEIGHT_1
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction.
WEIGHT_UNIT_1
VARCHAR2 		Units for Weight Measurement t first tagging interaction.
WEIGHT_TYPE_1
VARCHAR2 		Code For Type Of Weight Measurement at first tagging interaction.
WEIGHT_DETERMINATION_1
VARCHAR2 		Code For How Weight Was Determined at first tagging interaction.
LATITUDE_1
NUMBER 		Numeric value for the latitude of the tagging location at first tagging interaction.
LONGITUDE_1
NUMBER 		Numeric value the the longitude of the tagging location at first tagging interaction.
STAT_ZONE_ID_1
NUMBER 		Code to indciate State Zone at first tagging interaction
COUNTRY_ID_1
VARCHAR2 		Code to indicate Country at first tagging interaction
STATE_ID_1
VARCHAR2 		Code to indicate state at first tagging interaction
WATER_BODY_ID_1
NUMBER 		Code to Indicate waterbody of where tagging took place at first tagging interaction
PLACE_ID_1
VARCHAR2 		Code to indicate place of wheer tagging took place at first tagging interaction
GEAR_ID_1
VARCHAR2 		Code for gear used to catch the animal at first tagging interaction.
BAIT_TYPE_1
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction.
METHOD_ID_1
NUMBER 		Code To indicate tagging methodology Used at first tagging interaction
SAMPLE_ID_1
NUMBER 		Code to indicate Sampling Methodology at first tagging interaction
CAPTAIN_AGENCY_1
VARCHAR2 		Code to indicate agency which assigned angler code for boat captain at first tagging interaction.
CAPTAIN_ID_1
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction.
TAGGER_INITIALS_1
VARCHAR2 		Initials Of Taggers at first tagging interaction.
TAGGER_TYPE_1
VARCHAR2 		Indicates Type Of Tagger at first tagging interaction.
TAGGER_AFFILIATION_1
VARCHAR2 		Code Of Agency that is affiliated With The Tagger at first tagging interaction.
VESSEL_AGENCY_1
VARCHAR2 		Agency For Vessel Code at first tagging interaction.
VESSEL_ID_1
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction.
PHYSICAL_DATA_ID_1
NUMBER 		Physical Data Identification Number at first tagging interaction
NOTES_1
NUMBER 		Any Other Notes On Tagging at first tagging interaction
FIGHT_HOURS_1
NUMBER 		Number Of Hours Spent FIghting/Landings Fish at first tagging interaction
FIGHT_MINUTES_1
NUMBER 		Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction
ANGLER_AGENCY_1
VARCHAR2 		Agency That Has Angler Code list at first tagging interaction
ANGLER_ID_1
NUMBER 		Angler Code at first tagging interaction .
DATE_ENTERED_1
DATE 		The date the data was entered at first tagging interaction.
AGENCY_ID_2
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction
TAG_ID_2
VARCHAR2 		Tagnumber at second tagging interaction
EVENT_ID_2
NUMBER 		Code to Indicate Tagging Event at second tagging interaction
TAG_DATE_2
VARCHAR2 		Date animal was released or recaptured t second tagging interaction.
NEXT_TAG_AGENCY_2
VARCHAR2 		Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction
NEXT_TAG_ID_2
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction
INTERACTION_ORDER_2
NUMBER 		Number denoting the order of the interaction at second tagging interaction.
LENGTH_2
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction.
LENGTH_UNIT_2
VARCHAR2 		Units for Length Measurement at second tagging interaction.
LENGTH_TYPE_2
VARCHAR2 		Code to determine The Type Of Length Measurement taken at second tagging interaction.
LENGTH_DETERMINATION_2
VARCHAR2 		Code To Indicate How Length Was determined at second tagging interaction
WEIGHT_2
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction.
WEIGHT_UNIT_2
VARCHAR2 		Units for Weight Measurement t second tagging interaction.
WEIGHT_TYPE_2
VARCHAR2 		Code For Type Of Weight Measurement at second tagging interaction.
WEIGHT_DETERMINATION_2
VARCHAR2 		Code For How Weight Was Determined at second tagging interaction.
LATITUDE_2
NUMBER 		Numeric value for the latitude of the tagging location at second tagging interaction.
LONGITUDE_2
NUMBER 		Numeric value the the longitude of the tagging location at second tagging interaction.
STAT_ZONE_ID_2
NUMBER 		Code to indciate State Zone at second tagging interaction
COUNTRY_ID_2
VARCHAR2 		Code to indicate Country at second tagging interaction
STATE_ID_2
VARCHAR2 		Code to indicate state at second tagging interaction
WATER_BODY_ID_2
NUMBER 		Code to Indicate waterbody of where tagging took place at second tagging interaction
PLACE_ID_2
VARCHAR2 		Code to indicate place of wheer tagging took place at second tagging interaction
GEAR_ID_2
VARCHAR2 		Code for gear used to catch the animal at second tagging interaction.
BAIT_TYPE_2
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction.
METHOD_ID_2
NUMBER 		Code To indicate tagging methodology Used at second tagging interaction
SAMPLE_ID_2
NUMBER 		Code to indicate Sampling Methodology at second tagging interaction
CAPTAIN_AGENCY_2
VARCHAR2 		Code to indicate agency which assigned angler code for boat captain at second tagging interaction.
CAPTAIN_ID_2
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction.
TAGGER_INITIALS_2
VARCHAR2 		Initials Of Taggers at second tagging interaction.
TAGGER_TYPE_2
VARCHAR2 		Indicates Type Of Tagger at second tagging interaction.
TAGGER_AFFILIATION_2
VARCHAR2 		Code Of Agency that is affiliated With The Tagger at second tagging interaction.
VESSEL_AGENCY_2
VARCHAR2 		Agency For Vessel Code at second tagging interaction.
VESSEL_ID_2
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction.
PHYSICAL_DATA_ID_2
NUMBER 		Physical Data Identification Number at second tagging interaction
NOTES_2
NUMBER 		Any Other Notes On Tagging at second tagging interaction
FIGHT_HOURS_2
NUMBER 		Number Of Hours Spent FIghting/Landings Fish at second tagging interaction
FIGHT_MINUTES_2
NUMBER 		Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction
ANGLER_AGENCY_2
VARCHAR2 		Agency That Has Angler Code list at second tagging interaction
ANGLER_ID_2
NUMBER 		Angler Code at second tagging interaction .
DATE_ENTERED_2
DATE 		The date the data was entered at second tagging interaction.
AGENCY_ID_3
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction
TAG_ID_3
VARCHAR2 		Tagnumber at third tagging interaction
EVENT_ID_3
NUMBER 		Code to Indicate Tagging Event at third tagging interaction
TAG_DATE_3
VARCHAR2 		Date animal was released or recaptured t third tagging interaction.
NEXT_TAG_AGENCY_3
VARCHAR2 		Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction
NEXT_TAG_ID_3
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction
INTERACTION_ORDER_3
NUMBER 		Number denoting the order of the interaction at third tagging interaction.
LENGTH_3
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction.
LENGTH_UNIT_3
VARCHAR2 		Units for Length Measurement at third tagging interaction.
LENGTH_TYPE_3
VARCHAR2 		Code to determine The Type Of Length Measurement taken at third tagging interaction.
LENGTH_DETERMINATION_3
VARCHAR2 		Code To Indicate How Length Was determined at third tagging interaction
WEIGHT_3
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction.
WEIGHT_UNIT_3
VARCHAR2 		Units for Weight Measurement t third tagging interaction.
WEIGHT_TYPE_3
VARCHAR2 		Code For Type Of Weight Measurement at third tagging interaction.
WEIGHT_DETERMINATION_3
VARCHAR2 		Code For How Weight Was Determined at third tagging interaction.
LATITUDE_3
NUMBER 		Numeric value for the latitude of the tagging location at third tagging interaction.
LONGITUDE_3
NUMBER 		Numeric value the the longitude of the tagging location at third tagging interaction.
STAT_ZONE_ID_3
NUMBER 		Code to indciate State Zone at third tagging interaction
COUNTRY_ID_3
VARCHAR2 		Code to indicate Country at third tagging interaction
STATE_ID_3
VARCHAR2 		Code to indicate state at third tagging interaction
WATER_BODY_ID_3
NUMBER 		Code to Indicate waterbody of where tagging took place at third tagging interaction
PLACE_ID_3
VARCHAR2 		Code to indicate place of wheer tagging took place at third tagging interaction
GEAR_ID_3
VARCHAR2 		Code for gear used to catch the animal at third tagging interaction.
BAIT_TYPE_3
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction.
METHOD_ID_3
NUMBER 		Code To indicate tagging methodology Used at third tagging interaction
SAMPLE_ID_3
NUMBER 		Code to indicate Sampling Methodology at third tagging interaction
CAPTAIN_AGENCY_3
VARCHAR2 		Code to indicate agency which assigned angler code for boat captain at third tagging interaction.
CAPTAIN_ID_3
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction.
TAGGER_INITIALS_3
VARCHAR2 		Initials Of Taggers at third tagging interaction.
TAGGER_TYPE_3
VARCHAR2 		Indicates Type Of Tagger at third tagging interaction.
TAGGER_AFFILIATION_3
VARCHAR2 		Code Of Agency that is affiliated With The Tagger at third tagging interaction.
VESSEL_AGENCY_3
VARCHAR2 		Agency For Vessel Code at third tagging interaction.
VESSEL_ID_3
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction.
PHYSICAL_DATA_ID_3
NUMBER 		Physical Data Identification Number at third tagging interaction
NOTES_3
NUMBER 		Any Other Notes On Tagging at third tagging interaction
FIGHT_HOURS_3
NUMBER 		Number Of Hours Spent FIghting/Landings Fish at third tagging interaction
FIGHT_MINUTES_3
NUMBER 		Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction
ANGLER_AGENCY_3
VARCHAR2 		Agency That Has Angler Code list at third tagging interaction
ANGLER_ID_3
NUMBER 		Angler Code at third tagging interaction .
DATE_ENTERED_3
DATE 		The date the data was entered at third tagging interaction.
AGENCY_ID_4
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction
TAG_ID_4
VARCHAR2 		Tagnumber at fourth tagging interaction
EVENT_ID_4
NUMBER 		Code to Indicate Tagging Event at fourth tagging interaction
TAG_DATE_4
VARCHAR2 		Date animal was released or recaptured t fourth tagging interaction.
NEXT_TAG_AGENCY_4
VARCHAR2 		Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction
NEXT_TAG_ID_4
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction
INTERACTION_ORDER_4
NUMBER 		Number denoting the order of the interaction at fourth tagging interaction.
LENGTH_4
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction.
LENGTH_UNIT_4
VARCHAR2 		Units for Length Measurement at fourth tagging interaction.
LENGTH_TYPE_4
VARCHAR2 		Code to determine The Type Of Length Measurement taken at fourth tagging interaction.
LENGTH_DETERMINATION_4
VARCHAR2 		Code To Indicate How Length Was determined at fourth tagging interaction
WEIGHT_4
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction.
WEIGHT_UNIT_4
VARCHAR2 		Units for Weight Measurement t fourth tagging interaction.
WEIGHT_TYPE_4
VARCHAR2 		Code For Type Of Weight Measurement at fourth tagging interaction.
WEIGHT_DETERMINATION_4
VARCHAR2 		Code For How Weight Was Determined at fourth tagging interaction.
LATITUDE_4
NUMBER 		Numeric value for the latitude of the tagging location at fourth tagging interaction.
LONGITUDE_4
NUMBER 		Numeric value the the longitude of the tagging location at fourth tagging interaction.
STAT_ZONE_ID_4
NUMBER 		Code to indciate State Zone at fourth tagging interaction
COUNTRY_ID_4
VARCHAR2 		Code to indicate Country at fourth tagging interaction
STATE_ID_4
VARCHAR2 		Code to indicate state at fourth tagging interaction
WATER_BODY_ID_4
NUMBER 		Code to Indicate waterbody of where tagging took place at fourth tagging interaction
PLACE_ID_4
VARCHAR2 		Code to indicate place of wheer tagging took place at fourth tagging interaction
GEAR_ID_4
VARCHAR2 		Code for gear used to catch the animal at fourth tagging interaction.
BAIT_TYPE_4
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction.
METHOD_ID_4
NUMBER 		Code To indicate tagging methodology Used at fourth tagging interaction
SAMPLE_ID_4
NUMBER 		Code to indicate Sampling Methodology at fourth tagging interaction
CAPTAIN_AGENCY_4
VARCHAR2 		Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction.
CAPTAIN_ID_4
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction.
TAGGER_INITIALS_4
VARCHAR2 		Initials Of Taggers at fourth tagging interaction.
TAGGER_TYPE_4
VARCHAR2 		Indicates Type Of Tagger at fourth tagging interaction.
TAGGER_AFFILIATION_4
VARCHAR2 		Code Of Agency that is affiliated With The Tagger at fourth tagging interaction.
VESSEL_AGENCY_4
VARCHAR2 		Agency For Vessel Code at fourth tagging interaction.
VESSEL_ID_4
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction.
PHYSICAL_DATA_ID_4
NUMBER 		Physical Data Identification Number at fourth tagging interaction
NOTES_4
NUMBER 		Any Other Notes On Tagging at fourth tagging interaction
FIGHT_HOURS_4
NUMBER 		Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction
FIGHT_MINUTES_4
NUMBER 		Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction
ANGLER_AGENCY_4
VARCHAR2 		Agency That Has Angler Code list at fourth tagging interaction
ANGLER_ID_4
NUMBER 		Angler Code at fourth tagging interaction .
DATE_ENTERED_4
DATE 		The date the data was entered at fourth tagging interaction.
AGENCY_ID_5
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction
TAG_ID_5
VARCHAR2 		Tagnumber at fifth tagging interaction
EVENT_ID_5
NUMBER 		Code to Indicate Tagging Event at fifth tagging interaction
TAG_DATE_5
VARCHAR2 		Date animal was released or recaptured t fifth tagging interaction.
NEXT_TAG_AGENCY_5
VARCHAR2 		Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction
NEXT_TAG_ID_5
VARCHAR2 		Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction
INTERACTION_ORDER_5
NUMBER 		Number denoting the order of the interaction at fifth tagging interaction.
LENGTH_5
NUMBER 		Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction.
LENGTH_UNIT_5
VARCHAR2 		Units for Length Measurement at fifth tagging interaction.
LENGTH_TYPE_5
VARCHAR2 		Code to determine The Type Of Length Measurement taken at fifth tagging interaction.
LENGTH_DETERMINATION_5
VARCHAR2 		Code To Indicate How Length Was determined at fifth tagging interaction
WEIGHT_5
NUMBER 		Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction.
WEIGHT_UNIT_5
VARCHAR2 		Units for Weight Measurement t fifth tagging interaction.
WEIGHT_TYPE_5
VARCHAR2 		Code For Type Of Weight Measurement at fifth tagging interaction.
WEIGHT_DETERMINATION_5
VARCHAR2 		Code For How Weight Was Determined at fifth tagging interaction.
LATITUDE_5
NUMBER 		Numeric value for the latitude of the tagging location at fifth tagging interaction.
LONGITUDE_5
NUMBER 		Numeric value the the longitude of the tagging location at fifth tagging interaction.
STAT_ZONE_ID_5
NUMBER 		Code to indciate State Zone at fifth tagging interaction
COUNTRY_ID_5
VARCHAR2 		Code to indicate Country at fifth tagging interaction
STATE_ID_5
VARCHAR2 		Code to indicate state at fifth tagging interaction
WATER_BODY_ID_5
NUMBER 		Code to Indicate waterbody of where tagging took place at fifth tagging interaction
PLACE_ID_5
VARCHAR2 		Code to indicate place of wheer tagging took place at fifth tagging interaction
GEAR_ID_5
VARCHAR2 		Code for gear used to catch the animal at fifth tagging interaction.
BAIT_TYPE_5
VARCHAR2 		Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction.
METHOD_ID_5
NUMBER 		Code To indicate tagging methodology Used at fifth tagging interaction
SAMPLE_ID_5
NUMBER 		Code to indicate Sampling Methodology at fifth tagging interaction
CAPTAIN_AGENCY_5
VARCHAR2 		Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction.
CAPTAIN_ID_5
NUMBER 		Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction.
TAGGER_INITIALS_5
VARCHAR2 		Initials Of Taggers at fifth tagging interaction.
TAGGER_TYPE_5
VARCHAR2 		Indicates Type Of Tagger at fifth tagging interaction.
TAGGER_AFFILIATION_5
VARCHAR2 		Code Of Agency that is affiliated With The Tagger at fifth tagging interaction.
VESSEL_AGENCY_5
VARCHAR2 		Agency For Vessel Code at fifth tagging interaction.
VESSEL_ID_5
NUMBER 		Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction.
PHYSICAL_DATA_ID_5
NUMBER 		Physical Data Identification Number at fifth tagging interaction
NOTES_5
NUMBER 		Any Other Notes On Tagging at fifth tagging interaction
FIGHT_HOURS_5
NUMBER 		Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction
FIGHT_MINUTES_5
NUMBER 		Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction
ANGLER_AGENCY_5
VARCHAR2 		Agency That Has Angler Code list at fifth tagging interaction
ANGLER_ID_5
NUMBER 		Angler Code at fifth tagging interaction .
DATE_ENTERED_5
DATE 		The date the data was entered at fifth tagging interaction.

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: View: ICCAT_V
Short Name: ICCAT_V
Status: Completed
Abstract:

View Of Data That is used for ICCAT Report
Notes:

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

Entity Information

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

View Of Data That is used for ICCAT Report

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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_1 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (tag1) at first tagging interaction
100
 TAG_ID_1 VARCHAR2 Tagnumber at first tagging interaction
100
 EVENT_ID_1 NUMBER Code to Indicate Tagging Event at first tagging interaction
100
 TAG_DATE_1 VARCHAR2 Date animal was released or recaptured t first tagging interaction.
100
 NEXT_TAG_AGENCY_1 VARCHAR2 Code For Agency That Issued the next tag (second tag) on this record at first tagging interaction
100
 NEXT_TAG_ID_1 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (nexttag) at first tagging interaction
100
 INTERACTION_ORDER_1 NUMBER Number denoting the order of the interaction at first tagging interaction.
100
 LENGTH_1 NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at first tagging interaction.
100
 LENGTH_UNIT_1 VARCHAR2 Units for Length Measurement at first tagging interaction.
100
 LENGTH_TYPE_1 VARCHAR2 Code to determine The Type Of Length Measurement taken at first tagging interaction.
100
 LENGTH_DETERMINATION_1 VARCHAR2 Code To Indicate How Length Was determined at first tagging interaction
100
 WEIGHT_1 NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet at first tagging interaction.
100
 WEIGHT_UNIT_1 VARCHAR2 Units for Weight Measurement t first tagging interaction.
100
 WEIGHT_TYPE_1 VARCHAR2 Code For Type Of Weight Measurement at first tagging interaction.
100
 WEIGHT_DETERMINATION_1 VARCHAR2 Code For How Weight Was Determined at first tagging interaction.
100
 LATITUDE_1 NUMBER Numeric value for the latitude of the tagging location at first tagging interaction.
100
 LONGITUDE_1 NUMBER Numeric value the the longitude of the tagging location at first tagging interaction.
100
 STAT_ZONE_ID_1 NUMBER Code to indciate State Zone at first tagging interaction
100
 COUNTRY_ID_1 VARCHAR2 Code to indicate Country at first tagging interaction
100
 STATE_ID_1 VARCHAR2 Code to indicate state at first tagging interaction
100
 WATER_BODY_ID_1 NUMBER Code to Indicate waterbody of where tagging took place at first tagging interaction
100
 PLACE_ID_1 VARCHAR2 Code to indicate place of wheer tagging took place at first tagging interaction
100
 GEAR_ID_1 VARCHAR2 Code for gear used to catch the animal at first tagging interaction.
100
 BAIT_TYPE_1 VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at first tagging interaction.
100
 METHOD_ID_1 NUMBER Code To indicate tagging methodology Used at first tagging interaction
100
 SAMPLE_ID_1 NUMBER Code to indicate Sampling Methodology at first tagging interaction
100
 CAPTAIN_AGENCY_1 VARCHAR2 Code to indicate agency which assigned angler code for boat captain at first tagging interaction.
100
 CAPTAIN_ID_1 NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at first tagging interaction.
100
 TAGGER_INITIALS_1 VARCHAR2 Initials Of Taggers at first tagging interaction.
100
 TAGGER_TYPE_1 VARCHAR2 Indicates Type Of Tagger at first tagging interaction.
100
 TAGGER_AFFILIATION_1 VARCHAR2 Code Of Agency that is affiliated With The Tagger at first tagging interaction.
100
 VESSEL_AGENCY_1 VARCHAR2 Agency For Vessel Code at first tagging interaction.
100
 VESSEL_ID_1 NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal at first tagging interaction.
100
 PHYSICAL_DATA_ID_1 NUMBER Physical Data Identification Number at first tagging interaction
100
 NOTES_1 NUMBER Any Other Notes On Tagging at first tagging interaction
100
 FIGHT_HOURS_1 NUMBER Number Of Hours Spent FIghting/Landings Fish at first tagging interaction
100
 FIGHT_MINUTES_1 NUMBER Number Of Minutes (up to 59) spent FIghting/Landings Fish at first tagging interaction
100
 ANGLER_AGENCY_1 VARCHAR2 Agency That Has Angler Code list at first tagging interaction
100
 ANGLER_ID_1 NUMBER Angler Code at first tagging interaction .
100
 DATE_ENTERED_1 DATE The date the data was entered at first tagging interaction.
100
 AGENCY_ID_2 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction
100
 TAG_ID_2 VARCHAR2 Tagnumber at second tagging interaction
100
 EVENT_ID_2 NUMBER Code to Indicate Tagging Event at second tagging interaction
100
 TAG_DATE_2 VARCHAR2 Date animal was released or recaptured t second tagging interaction.
100
 NEXT_TAG_AGENCY_2 VARCHAR2 Code For Agency That Issued the next tag (second tag) on this record at second tagging interaction
100
 NEXT_TAG_ID_2 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (nexttag) at second tagging interaction
100
 INTERACTION_ORDER_2 NUMBER Number denoting the order of the interaction at second tagging interaction.
100
 LENGTH_2 NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at second tagging interaction.
100
 LENGTH_UNIT_2 VARCHAR2 Units for Length Measurement at second tagging interaction.
100
 LENGTH_TYPE_2 VARCHAR2 Code to determine The Type Of Length Measurement taken at second tagging interaction.
100
 LENGTH_DETERMINATION_2 VARCHAR2 Code To Indicate How Length Was determined at second tagging interaction
100
 WEIGHT_2 NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet at second tagging interaction.
100
 WEIGHT_UNIT_2 VARCHAR2 Units for Weight Measurement t second tagging interaction.
100
 WEIGHT_TYPE_2 VARCHAR2 Code For Type Of Weight Measurement at second tagging interaction.
100
 WEIGHT_DETERMINATION_2 VARCHAR2 Code For How Weight Was Determined at second tagging interaction.
100
 LATITUDE_2 NUMBER Numeric value for the latitude of the tagging location at second tagging interaction.
100
 LONGITUDE_2 NUMBER Numeric value the the longitude of the tagging location at second tagging interaction.
100
 STAT_ZONE_ID_2 NUMBER Code to indciate State Zone at second tagging interaction
100
 COUNTRY_ID_2 VARCHAR2 Code to indicate Country at second tagging interaction
100
 STATE_ID_2 VARCHAR2 Code to indicate state at second tagging interaction
100
 WATER_BODY_ID_2 NUMBER Code to Indicate waterbody of where tagging took place at second tagging interaction
100
 PLACE_ID_2 VARCHAR2 Code to indicate place of wheer tagging took place at second tagging interaction
100
 GEAR_ID_2 VARCHAR2 Code for gear used to catch the animal at second tagging interaction.
100
 BAIT_TYPE_2 VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at second tagging interaction.
100
 METHOD_ID_2 NUMBER Code To indicate tagging methodology Used at second tagging interaction
100
 SAMPLE_ID_2 NUMBER Code to indicate Sampling Methodology at second tagging interaction
100
 CAPTAIN_AGENCY_2 VARCHAR2 Code to indicate agency which assigned angler code for boat captain at second tagging interaction.
100
 CAPTAIN_ID_2 NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at second tagging interaction.
100
 TAGGER_INITIALS_2 VARCHAR2 Initials Of Taggers at second tagging interaction.
100
 TAGGER_TYPE_2 VARCHAR2 Indicates Type Of Tagger at second tagging interaction.
100
 TAGGER_AFFILIATION_2 VARCHAR2 Code Of Agency that is affiliated With The Tagger at second tagging interaction.
100
 VESSEL_AGENCY_2 VARCHAR2 Agency For Vessel Code at second tagging interaction.
100
 VESSEL_ID_2 NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal at second tagging interaction.
100
 PHYSICAL_DATA_ID_2 NUMBER Physical Data Identification Number at second tagging interaction
100
 NOTES_2 NUMBER Any Other Notes On Tagging at second tagging interaction
100
 FIGHT_HOURS_2 NUMBER Number Of Hours Spent FIghting/Landings Fish at second tagging interaction
100
 FIGHT_MINUTES_2 NUMBER Number Of Minutes (up to 59) spent FIghting/Landings Fish at second tagging interaction
100
 ANGLER_AGENCY_2 VARCHAR2 Agency That Has Angler Code list at second tagging interaction
100
 ANGLER_ID_2 NUMBER Angler Code at second tagging interaction .
100
 DATE_ENTERED_2 DATE The date the data was entered at second tagging interaction.
100
 AGENCY_ID_3 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction
100
 TAG_ID_3 VARCHAR2 Tagnumber at third tagging interaction
100
 EVENT_ID_3 NUMBER Code to Indicate Tagging Event at third tagging interaction
100
 TAG_DATE_3 VARCHAR2 Date animal was released or recaptured t third tagging interaction.
100
 NEXT_TAG_AGENCY_3 VARCHAR2 Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction
100
 NEXT_TAG_ID_3 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (nexttag) at third tagging interaction
100
 INTERACTION_ORDER_3 NUMBER Number denoting the order of the interaction at third tagging interaction.
100
 LENGTH_3 NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at third tagging interaction.
100
 LENGTH_UNIT_3 VARCHAR2 Units for Length Measurement at third tagging interaction.
100
 LENGTH_TYPE_3 VARCHAR2 Code to determine The Type Of Length Measurement taken at third tagging interaction.
100
 LENGTH_DETERMINATION_3 VARCHAR2 Code To Indicate How Length Was determined at third tagging interaction
100
 WEIGHT_3 NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet at third tagging interaction.
100
 WEIGHT_UNIT_3 VARCHAR2 Units for Weight Measurement t third tagging interaction.
100
 WEIGHT_TYPE_3 VARCHAR2 Code For Type Of Weight Measurement at third tagging interaction.
100
 WEIGHT_DETERMINATION_3 VARCHAR2 Code For How Weight Was Determined at third tagging interaction.
100
 LATITUDE_3 NUMBER Numeric value for the latitude of the tagging location at third tagging interaction.
100
 LONGITUDE_3 NUMBER Numeric value the the longitude of the tagging location at third tagging interaction.
100
 STAT_ZONE_ID_3 NUMBER Code to indciate State Zone at third tagging interaction
100
 COUNTRY_ID_3 VARCHAR2 Code to indicate Country at third tagging interaction
100
 STATE_ID_3 VARCHAR2 Code to indicate state at third tagging interaction
100
 WATER_BODY_ID_3 NUMBER Code to Indicate waterbody of where tagging took place at third tagging interaction
100
 PLACE_ID_3 VARCHAR2 Code to indicate place of wheer tagging took place at third tagging interaction
100
 GEAR_ID_3 VARCHAR2 Code for gear used to catch the animal at third tagging interaction.
100
 BAIT_TYPE_3 VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at third tagging interaction.
100
 METHOD_ID_3 NUMBER Code To indicate tagging methodology Used at third tagging interaction
100
 SAMPLE_ID_3 NUMBER Code to indicate Sampling Methodology at third tagging interaction
100
 CAPTAIN_AGENCY_3 VARCHAR2 Code to indicate agency which assigned angler code for boat captain at third tagging interaction.
100
 CAPTAIN_ID_3 NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at third tagging interaction.
100
 TAGGER_INITIALS_3 VARCHAR2 Initials Of Taggers at third tagging interaction.
100
 TAGGER_TYPE_3 VARCHAR2 Indicates Type Of Tagger at third tagging interaction.
100
 TAGGER_AFFILIATION_3 VARCHAR2 Code Of Agency that is affiliated With The Tagger at third tagging interaction.
100
 VESSEL_AGENCY_3 VARCHAR2 Agency For Vessel Code at third tagging interaction.
100
 VESSEL_ID_3 NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal at third tagging interaction.
100
 PHYSICAL_DATA_ID_3 NUMBER Physical Data Identification Number at third tagging interaction
100
 NOTES_3 NUMBER Any Other Notes On Tagging at third tagging interaction
100
 FIGHT_HOURS_3 NUMBER Number Of Hours Spent FIghting/Landings Fish at third tagging interaction
100
 FIGHT_MINUTES_3 NUMBER Number Of Minutes (up to 59) spent FIghting/Landings Fish at third tagging interaction
100
 ANGLER_AGENCY_3 VARCHAR2 Agency That Has Angler Code list at third tagging interaction
100
 ANGLER_ID_3 NUMBER Angler Code at third tagging interaction .
100
 DATE_ENTERED_3 DATE The date the data was entered at third tagging interaction.
100
 AGENCY_ID_4 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction
100
 TAG_ID_4 VARCHAR2 Tagnumber at fourth tagging interaction
100
 EVENT_ID_4 NUMBER Code to Indicate Tagging Event at fourth tagging interaction
100
 TAG_DATE_4 VARCHAR2 Date animal was released or recaptured t fourth tagging interaction.
100
 NEXT_TAG_AGENCY_4 VARCHAR2 Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction
100
 NEXT_TAG_ID_4 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fourth tagging interaction
100
 INTERACTION_ORDER_4 NUMBER Number denoting the order of the interaction at fourth tagging interaction.
100
 LENGTH_4 NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fourth tagging interaction.
100
 LENGTH_UNIT_4 VARCHAR2 Units for Length Measurement at fourth tagging interaction.
100
 LENGTH_TYPE_4 VARCHAR2 Code to determine The Type Of Length Measurement taken at fourth tagging interaction.
100
 LENGTH_DETERMINATION_4 VARCHAR2 Code To Indicate How Length Was determined at fourth tagging interaction
100
 WEIGHT_4 NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fourth tagging interaction.
100
 WEIGHT_UNIT_4 VARCHAR2 Units for Weight Measurement t fourth tagging interaction.
100
 WEIGHT_TYPE_4 VARCHAR2 Code For Type Of Weight Measurement at fourth tagging interaction.
100
 WEIGHT_DETERMINATION_4 VARCHAR2 Code For How Weight Was Determined at fourth tagging interaction.
100
 LATITUDE_4 NUMBER Numeric value for the latitude of the tagging location at fourth tagging interaction.
100
 LONGITUDE_4 NUMBER Numeric value the the longitude of the tagging location at fourth tagging interaction.
100
 STAT_ZONE_ID_4 NUMBER Code to indciate State Zone at fourth tagging interaction
100
 COUNTRY_ID_4 VARCHAR2 Code to indicate Country at fourth tagging interaction
100
 STATE_ID_4 VARCHAR2 Code to indicate state at fourth tagging interaction
100
 WATER_BODY_ID_4 NUMBER Code to Indicate waterbody of where tagging took place at fourth tagging interaction
100
 PLACE_ID_4 VARCHAR2 Code to indicate place of wheer tagging took place at fourth tagging interaction
100
 GEAR_ID_4 VARCHAR2 Code for gear used to catch the animal at fourth tagging interaction.
100
 BAIT_TYPE_4 VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fourth tagging interaction.
100
 METHOD_ID_4 NUMBER Code To indicate tagging methodology Used at fourth tagging interaction
100
 SAMPLE_ID_4 NUMBER Code to indicate Sampling Methodology at fourth tagging interaction
100
 CAPTAIN_AGENCY_4 VARCHAR2 Code to indicate agency which assigned angler code for boat captain at fourth tagging interaction.
100
 CAPTAIN_ID_4 NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fourth tagging interaction.
100
 TAGGER_INITIALS_4 VARCHAR2 Initials Of Taggers at fourth tagging interaction.
100
 TAGGER_TYPE_4 VARCHAR2 Indicates Type Of Tagger at fourth tagging interaction.
100
 TAGGER_AFFILIATION_4 VARCHAR2 Code Of Agency that is affiliated With The Tagger at fourth tagging interaction.
100
 VESSEL_AGENCY_4 VARCHAR2 Agency For Vessel Code at fourth tagging interaction.
100
 VESSEL_ID_4 NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal at fourth tagging interaction.
100
 PHYSICAL_DATA_ID_4 NUMBER Physical Data Identification Number at fourth tagging interaction
100
 NOTES_4 NUMBER Any Other Notes On Tagging at fourth tagging interaction
100
 FIGHT_HOURS_4 NUMBER Number Of Hours Spent FIghting/Landings Fish at fourth tagging interaction
100
 FIGHT_MINUTES_4 NUMBER Number Of Minutes (up to 59) spent FIghting/Landings Fish at fourth tagging interaction
100
 ANGLER_AGENCY_4 VARCHAR2 Agency That Has Angler Code list at fourth tagging interaction
100
 ANGLER_ID_4 NUMBER Angler Code at fourth tagging interaction .
100
 DATE_ENTERED_4 DATE The date the data was entered at fourth tagging interaction.
100
 AGENCY_ID_5 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction
100
 TAG_ID_5 VARCHAR2 Tagnumber at fifth tagging interaction
100
 EVENT_ID_5 NUMBER Code to Indicate Tagging Event at fifth tagging interaction
100
 TAG_DATE_5 VARCHAR2 Date animal was released or recaptured t fifth tagging interaction.
100
 NEXT_TAG_AGENCY_5 VARCHAR2 Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction
100
 NEXT_TAG_ID_5 VARCHAR2 Code to Indicate Tagging agency of identifying tag on animal (nexttag) at fifth tagging interaction
100
 INTERACTION_ORDER_5 NUMBER Number denoting the order of the interaction at fifth tagging interaction.
100
 LENGTH_5 NUMBER Length of animal tagged based on the lengthunit, lengthtype, and lengthdet at fifth tagging interaction.
100
 LENGTH_UNIT_5 VARCHAR2 Units for Length Measurement at fifth tagging interaction.
100
 LENGTH_TYPE_5 VARCHAR2 Code to determine The Type Of Length Measurement taken at fifth tagging interaction.
100
 LENGTH_DETERMINATION_5 VARCHAR2 Code To Indicate How Length Was determined at fifth tagging interaction
100
 WEIGHT_5 NUMBER Weight of an animal tagged, based upon weightunit, weighttype and weightdet at fifth tagging interaction.
100
 WEIGHT_UNIT_5 VARCHAR2 Units for Weight Measurement t fifth tagging interaction.
100
 WEIGHT_TYPE_5 VARCHAR2 Code For Type Of Weight Measurement at fifth tagging interaction.
100
 WEIGHT_DETERMINATION_5 VARCHAR2 Code For How Weight Was Determined at fifth tagging interaction.
100
 LATITUDE_5 NUMBER Numeric value for the latitude of the tagging location at fifth tagging interaction.
100
 LONGITUDE_5 NUMBER Numeric value the the longitude of the tagging location at fifth tagging interaction.
100
 STAT_ZONE_ID_5 NUMBER Code to indciate State Zone at fifth tagging interaction
100
 COUNTRY_ID_5 VARCHAR2 Code to indicate Country at fifth tagging interaction
100
 STATE_ID_5 VARCHAR2 Code to indicate state at fifth tagging interaction
100
 WATER_BODY_ID_5 NUMBER Code to Indicate waterbody of where tagging took place at fifth tagging interaction
100
 PLACE_ID_5 VARCHAR2 Code to indicate place of wheer tagging took place at fifth tagging interaction
100
 GEAR_ID_5 VARCHAR2 Code for gear used to catch the animal at fifth tagging interaction.
100
 BAIT_TYPE_5 VARCHAR2 Code for bait used: (A)rtificial, (L)ive, (D)ead, (U)nknown at fifth tagging interaction.
100
 METHOD_ID_5 NUMBER Code To indicate tagging methodology Used at fifth tagging interaction
100
 SAMPLE_ID_5 NUMBER Code to indicate Sampling Methodology at fifth tagging interaction
100
 CAPTAIN_AGENCY_5 VARCHAR2 Code to indicate agency which assigned angler code for boat captain at fifth tagging interaction.
100
 CAPTAIN_ID_5 NUMBER Unique numeric code assigned to an individual captain. Must be greater than zero or -99999 at fifth tagging interaction.
100
 TAGGER_INITIALS_5 VARCHAR2 Initials Of Taggers at fifth tagging interaction.
100
 TAGGER_TYPE_5 VARCHAR2 Indicates Type Of Tagger at fifth tagging interaction.
100
 TAGGER_AFFILIATION_5 VARCHAR2 Code Of Agency that is affiliated With The Tagger at fifth tagging interaction.
100
 VESSEL_AGENCY_5 VARCHAR2 Agency For Vessel Code at fifth tagging interaction.
100
 VESSEL_ID_5 NUMBER Agency supplied code identifying the vessel involved in the release or recapture of the animal at fifth tagging interaction.
100
 PHYSICAL_DATA_ID_5 NUMBER Physical Data Identification Number at fifth tagging interaction
100
 NOTES_5 NUMBER Any Other Notes On Tagging at fifth tagging interaction
100
 FIGHT_HOURS_5 NUMBER Number Of Hours Spent FIghting/Landings Fish at fifth tagging interaction
100
 FIGHT_MINUTES_5 NUMBER Number Of Minutes (up to 59) spent FIghting/Landings Fish at fifth tagging interaction
100
 ANGLER_AGENCY_5 VARCHAR2 Agency That Has Angler Code list at fifth tagging interaction
100
 ANGLER_ID_5 NUMBER Angler Code at fifth tagging interaction .
100
 DATE_ENTERED_5 DATE The date the data was entered at fifth tagging interaction.

Attribute Details

ANIMAL_ID

CC ID: 26514
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: 26643
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: 26687
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_1

CC ID: 26713
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) at first tagging interaction
General Data Type: VARCHAR2

TAG_ID_1

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

Tagnumber at first tagging interaction
General Data Type: VARCHAR2

EVENT_ID_1

CC ID: 26712
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code to Indicate Tagging Event at first tagging interaction
General Data Type: NUMBER

TAG_DATE_1

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

Date animal was released or recaptured t first tagging interaction.
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_1

CC ID: 26571
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 at first tagging interaction
General Data Type: VARCHAR2

NEXT_TAG_ID_1

CC ID: 26606
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) at first tagging interaction
General Data Type: VARCHAR2

INTERACTION_ORDER_1

CC ID: 26685
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 at first tagging interaction.
General Data Type: NUMBER

LENGTH_1

CC ID: 26579
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 at first tagging interaction.
General Data Type: NUMBER

LENGTH_UNIT_1

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

Units for Length Measurement at first tagging interaction.
General Data Type: VARCHAR2

LENGTH_TYPE_1

CC ID: 26519
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 at first tagging interaction.
General Data Type: VARCHAR2

LENGTH_DETERMINATION_1

CC ID: 26548
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 at first tagging interaction
General Data Type: VARCHAR2

WEIGHT_1

CC ID: 26537
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 at first tagging interaction.
General Data Type: NUMBER

WEIGHT_UNIT_1

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

Units for Weight Measurement t first tagging interaction.
General Data Type: VARCHAR2

WEIGHT_TYPE_1

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

Code For Type Of Weight Measurement at first tagging interaction.
General Data Type: VARCHAR2

WEIGHT_DETERMINATION_1

CC ID: 26662
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For How Weight Was Determined at first tagging interaction.
General Data Type: VARCHAR2

LATITUDE_1

CC ID: 26599
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 at first tagging interaction.
General Data Type: NUMBER

LONGITUDE_1

CC ID: 26700
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 at first tagging interaction.
General Data Type: NUMBER

STAT_ZONE_ID_1

CC ID: 26611
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 at first tagging interaction
General Data Type: NUMBER

COUNTRY_ID_1

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

Code to indicate Country at first tagging interaction
General Data Type: VARCHAR2

STATE_ID_1

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

Code to indicate state at first tagging interaction
General Data Type: VARCHAR2

WATER_BODY_ID_1

CC ID: 26698
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 at first tagging interaction
General Data Type: NUMBER

PLACE_ID_1

CC ID: 26598
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 place at first tagging interaction
General Data Type: VARCHAR2

GEAR_ID_1

CC ID: 26540
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 at first tagging interaction.
General Data Type: VARCHAR2

BAIT_TYPE_1

CC ID: 26517
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 at first tagging interaction.
General Data Type: VARCHAR2

METHOD_ID_1

CC ID: 26645
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 at first tagging interaction
General Data Type: NUMBER

SAMPLE_ID_1

CC ID: 26596
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 at first tagging interaction
General Data Type: NUMBER

CAPTAIN_AGENCY_1

CC ID: 26676
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 at first tagging interaction.
General Data Type: VARCHAR2

CAPTAIN_ID_1

CC ID: 26675
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 at first tagging interaction.
General Data Type: NUMBER

TAGGER_INITIALS_1

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

Initials Of Taggers at first tagging interaction.
General Data Type: VARCHAR2

TAGGER_TYPE_1

CC ID: 26595
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates Type Of Tagger at first tagging interaction.
General Data Type: VARCHAR2

TAGGER_AFFILIATION_1

CC ID: 26640
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 at first tagging interaction.
General Data Type: VARCHAR2

VESSEL_AGENCY_1

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

Agency For Vessel Code at first tagging interaction.
General Data Type: VARCHAR2

VESSEL_ID_1

CC ID: 26646
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 at first tagging interaction.
General Data Type: NUMBER

PHYSICAL_DATA_ID_1

CC ID: 26657
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 at first tagging interaction
General Data Type: NUMBER

NOTES_1

CC ID: 26600
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 at first tagging interaction
General Data Type: NUMBER

FIGHT_HOURS_1

CC ID: 26546
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 at first tagging interaction
General Data Type: NUMBER

FIGHT_MINUTES_1

CC ID: 26695
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 at first tagging interaction
General Data Type: NUMBER

ANGLER_AGENCY_1

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

Agency That Has Angler Code list at first tagging interaction
General Data Type: VARCHAR2

ANGLER_ID_1

CC ID: 26620
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Angler Code at first tagging interaction .
General Data Type: NUMBER

DATE_ENTERED_1

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

The date the data was entered at first tagging interaction.
General Data Type: DATE

AGENCY_ID_2

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

Code to Indicate Tagging agency of identifying tag on animal (tag1) at second tagging interaction
General Data Type: VARCHAR2

TAG_ID_2

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

Tagnumber at second tagging interaction
General Data Type: VARCHAR2

EVENT_ID_2

CC ID: 26672
Seq. Order: 46
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code to Indicate Tagging Event at second tagging interaction
General Data Type: NUMBER

TAG_DATE_2

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

Date animal was released or recaptured t second tagging interaction.
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_2

CC ID: 26706
Seq. Order: 48
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 at second tagging interaction
General Data Type: VARCHAR2

NEXT_TAG_ID_2

CC ID: 26617
Seq. Order: 49
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) at second tagging interaction
General Data Type: VARCHAR2

INTERACTION_ORDER_2

CC ID: 26568
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number denoting the order of the interaction at second tagging interaction.
General Data Type: NUMBER

LENGTH_2

CC ID: 26522
Seq. Order: 51
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 at second tagging interaction.
General Data Type: NUMBER

LENGTH_UNIT_2

CC ID: 26689
Seq. Order: 52
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Length Measurement at second tagging interaction.
General Data Type: VARCHAR2

LENGTH_TYPE_2

CC ID: 26552
Seq. Order: 53
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to determine The Type Of Length Measurement taken at second tagging interaction.
General Data Type: VARCHAR2

LENGTH_DETERMINATION_2

CC ID: 26656
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code To Indicate How Length Was determined at second tagging interaction
General Data Type: VARCHAR2

WEIGHT_2

CC ID: 26591
Seq. Order: 55
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 at second tagging interaction.
General Data Type: NUMBER

WEIGHT_UNIT_2

CC ID: 26545
Seq. Order: 56
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Weight Measurement t second tagging interaction.
General Data Type: VARCHAR2

WEIGHT_TYPE_2

CC ID: 26697
Seq. Order: 57
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For Type Of Weight Measurement at second tagging interaction.
General Data Type: VARCHAR2

WEIGHT_DETERMINATION_2

CC ID: 26593
Seq. Order: 58
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For How Weight Was Determined at second tagging interaction.
General Data Type: VARCHAR2

LATITUDE_2

CC ID: 26525
Seq. Order: 59
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 at second tagging interaction.
General Data Type: NUMBER

LONGITUDE_2

CC ID: 26688
Seq. Order: 60
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 at second tagging interaction.
General Data Type: NUMBER

STAT_ZONE_ID_2

CC ID: 26583
Seq. Order: 61
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Code to indciate State Zone at second tagging interaction
General Data Type: NUMBER

COUNTRY_ID_2

CC ID: 26574
Seq. Order: 62
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Country at second tagging interaction
General Data Type: VARCHAR2

STATE_ID_2

CC ID: 26680
Seq. Order: 63
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate state at second tagging interaction
General Data Type: VARCHAR2

WATER_BODY_ID_2

CC ID: 26566
Seq. Order: 64
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 at second tagging interaction
General Data Type: NUMBER

PLACE_ID_2

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

Code to indicate place of wheer tagging took place at second tagging interaction
General Data Type: VARCHAR2

GEAR_ID_2

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

Code for gear used to catch the animal at second tagging interaction.
General Data Type: VARCHAR2

BAIT_TYPE_2

CC ID: 26551
Seq. Order: 67
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 at second tagging interaction.
General Data Type: VARCHAR2

METHOD_ID_2

CC ID: 26515
Seq. Order: 68
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 at second tagging interaction
General Data Type: NUMBER

SAMPLE_ID_2

CC ID: 26609
Seq. Order: 69
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code to indicate Sampling Methodology at second tagging interaction
General Data Type: NUMBER

CAPTAIN_AGENCY_2

CC ID: 26535
Seq. Order: 70
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 at second tagging interaction.
General Data Type: VARCHAR2

CAPTAIN_ID_2

CC ID: 26567
Seq. Order: 71
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 at second tagging interaction.
General Data Type: NUMBER

TAGGER_INITIALS_2

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

Initials Of Taggers at second tagging interaction.
General Data Type: VARCHAR2

TAGGER_TYPE_2

CC ID: 26653
Seq. Order: 73
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates Type Of Tagger at second tagging interaction.
General Data Type: VARCHAR2

TAGGER_AFFILIATION_2

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

Code Of Agency that is affiliated With The Tagger at second tagging interaction.
General Data Type: VARCHAR2

VESSEL_AGENCY_2

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

Agency For Vessel Code at second tagging interaction.
General Data Type: VARCHAR2

VESSEL_ID_2

CC ID: 26648
Seq. Order: 76
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 at second tagging interaction.
General Data Type: NUMBER

PHYSICAL_DATA_ID_2

CC ID: 26547
Seq. Order: 77
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Physical Data Identification Number at second tagging interaction
General Data Type: NUMBER

NOTES_2

CC ID: 26682
Seq. Order: 78
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Any Other Notes On Tagging at second tagging interaction
General Data Type: NUMBER

FIGHT_HOURS_2

CC ID: 26558
Seq. Order: 79
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 at second tagging interaction
General Data Type: NUMBER

FIGHT_MINUTES_2

CC ID: 26667
Seq. Order: 80
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 at second tagging interaction
General Data Type: NUMBER

ANGLER_AGENCY_2

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

Agency That Has Angler Code list at second tagging interaction
General Data Type: VARCHAR2

ANGLER_ID_2

CC ID: 26553
Seq. Order: 82
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Angler Code at second tagging interaction .
General Data Type: NUMBER

DATE_ENTERED_2

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

The date the data was entered at second tagging interaction.
General Data Type: DATE

AGENCY_ID_3

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

Code to Indicate Tagging agency of identifying tag on animal (tag1) at third tagging interaction
General Data Type: VARCHAR2

TAG_ID_3

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

Tagnumber at third tagging interaction
General Data Type: VARCHAR2

EVENT_ID_3

CC ID: 26518
Seq. Order: 86
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code to Indicate Tagging Event at third tagging interaction
General Data Type: NUMBER

TAG_DATE_3

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

Date animal was released or recaptured t third tagging interaction.
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_3

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

Code For Agency That Issued the next tag (third tag) on this record at third tagging interaction
General Data Type: VARCHAR2

NEXT_TAG_ID_3

CC ID: 26565
Seq. Order: 89
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) at third tagging interaction
General Data Type: VARCHAR2

INTERACTION_ORDER_3

CC ID: 26708
Seq. Order: 90
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number denoting the order of the interaction at third tagging interaction.
General Data Type: NUMBER

LENGTH_3

CC ID: 26705
Seq. Order: 91
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 at third tagging interaction.
General Data Type: NUMBER

LENGTH_UNIT_3

CC ID: 26644
Seq. Order: 92
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Length Measurement at third tagging interaction.
General Data Type: VARCHAR2

LENGTH_TYPE_3

CC ID: 26589
Seq. Order: 93
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to determine The Type Of Length Measurement taken at third tagging interaction.
General Data Type: VARCHAR2

LENGTH_DETERMINATION_3

CC ID: 26679
Seq. Order: 94
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code To Indicate How Length Was determined at third tagging interaction
General Data Type: VARCHAR2

WEIGHT_3

CC ID: 26527
Seq. Order: 95
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 at third tagging interaction.
General Data Type: NUMBER

WEIGHT_UNIT_3

CC ID: 26632
Seq. Order: 96
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Weight Measurement t third tagging interaction.
General Data Type: VARCHAR2

WEIGHT_TYPE_3

CC ID: 26678
Seq. Order: 97
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For Type Of Weight Measurement at third tagging interaction.
General Data Type: VARCHAR2

WEIGHT_DETERMINATION_3

CC ID: 26557
Seq. Order: 98
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For How Weight Was Determined at third tagging interaction.
General Data Type: VARCHAR2

LATITUDE_3

CC ID: 26664
Seq. Order: 99
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 at third tagging interaction.
General Data Type: NUMBER

LONGITUDE_3

CC ID: 26669
Seq. Order: 100
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 at third tagging interaction.
General Data Type: NUMBER

STAT_ZONE_ID_3

CC ID: 26601
Seq. Order: 101
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Code to indciate State Zone at third tagging interaction
General Data Type: NUMBER

COUNTRY_ID_3

CC ID: 26562
Seq. Order: 102
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Country at third tagging interaction
General Data Type: VARCHAR2

STATE_ID_3

CC ID: 26634
Seq. Order: 103
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate state at third tagging interaction
General Data Type: VARCHAR2

WATER_BODY_ID_3

CC ID: 26520
Seq. Order: 104
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 at third tagging interaction
General Data Type: NUMBER

PLACE_ID_3

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

Code to indicate place of wheer tagging took place at third tagging interaction
General Data Type: VARCHAR2

GEAR_ID_3

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

Code for gear used to catch the animal at third tagging interaction.
General Data Type: VARCHAR2

BAIT_TYPE_3

CC ID: 26513
Seq. Order: 107
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 at third tagging interaction.
General Data Type: VARCHAR2

METHOD_ID_3

CC ID: 26521
Seq. Order: 108
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 at third tagging interaction
General Data Type: NUMBER

SAMPLE_ID_3

CC ID: 26516
Seq. Order: 109
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code to indicate Sampling Methodology at third tagging interaction
General Data Type: NUMBER

CAPTAIN_AGENCY_3

CC ID: 26588
Seq. Order: 110
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 at third tagging interaction.
General Data Type: VARCHAR2

CAPTAIN_ID_3

CC ID: 26550
Seq. Order: 111
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 at third tagging interaction.
General Data Type: NUMBER

TAGGER_INITIALS_3

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

Initials Of Taggers at third tagging interaction.
General Data Type: VARCHAR2

TAGGER_TYPE_3

CC ID: 26560
Seq. Order: 113
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates Type Of Tagger at third tagging interaction.
General Data Type: VARCHAR2

TAGGER_AFFILIATION_3

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

Code Of Agency that is affiliated With The Tagger at third tagging interaction.
General Data Type: VARCHAR2

VESSEL_AGENCY_3

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

Agency For Vessel Code at third tagging interaction.
General Data Type: VARCHAR2

VESSEL_ID_3

CC ID: 26526
Seq. Order: 116
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 at third tagging interaction.
General Data Type: NUMBER

PHYSICAL_DATA_ID_3

CC ID: 26613
Seq. Order: 117
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Physical Data Identification Number at third tagging interaction
General Data Type: NUMBER

NOTES_3

CC ID: 26671
Seq. Order: 118
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Any Other Notes On Tagging at third tagging interaction
General Data Type: NUMBER

FIGHT_HOURS_3

CC ID: 26549
Seq. Order: 119
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 at third tagging interaction
General Data Type: NUMBER

FIGHT_MINUTES_3

CC ID: 26582
Seq. Order: 120
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 at third tagging interaction
General Data Type: NUMBER

ANGLER_AGENCY_3

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

Agency That Has Angler Code list at third tagging interaction
General Data Type: VARCHAR2

ANGLER_ID_3

CC ID: 26604
Seq. Order: 122
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Angler Code at third tagging interaction .
General Data Type: NUMBER

DATE_ENTERED_3

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

The date the data was entered at third tagging interaction.
General Data Type: DATE

AGENCY_ID_4

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

Code to Indicate Tagging agency of identifying tag on animal (tag1) at fourth tagging interaction
General Data Type: VARCHAR2

TAG_ID_4

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

Tagnumber at fourth tagging interaction
General Data Type: VARCHAR2

EVENT_ID_4

CC ID: 26544
Seq. Order: 126
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code to Indicate Tagging Event at fourth tagging interaction
General Data Type: NUMBER

TAG_DATE_4

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

Date animal was released or recaptured t fourth tagging interaction.
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_4

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

Code For Agency That Issued the next tag (fourth tag) on this record at fourth tagging interaction
General Data Type: VARCHAR2

NEXT_TAG_ID_4

CC ID: 26536
Seq. Order: 129
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) at fourth tagging interaction
General Data Type: VARCHAR2

INTERACTION_ORDER_4

CC ID: 26668
Seq. Order: 130
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number denoting the order of the interaction at fourth tagging interaction.
General Data Type: NUMBER

LENGTH_4

CC ID: 26686
Seq. Order: 131
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 at fourth tagging interaction.
General Data Type: NUMBER

LENGTH_UNIT_4

CC ID: 26575
Seq. Order: 132
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Length Measurement at fourth tagging interaction.
General Data Type: VARCHAR2

LENGTH_TYPE_4

CC ID: 26578
Seq. Order: 133
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to determine The Type Of Length Measurement taken at fourth tagging interaction.
General Data Type: VARCHAR2

LENGTH_DETERMINATION_4

CC ID: 26554
Seq. Order: 134
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code To Indicate How Length Was determined at fourth tagging interaction
General Data Type: VARCHAR2

WEIGHT_4

CC ID: 26615
Seq. Order: 135
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 at fourth tagging interaction.
General Data Type: NUMBER

WEIGHT_UNIT_4

CC ID: 26586
Seq. Order: 136
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Weight Measurement t fourth tagging interaction.
General Data Type: VARCHAR2

WEIGHT_TYPE_4

CC ID: 26633
Seq. Order: 137
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For Type Of Weight Measurement at fourth tagging interaction.
General Data Type: VARCHAR2

WEIGHT_DETERMINATION_4

CC ID: 26532
Seq. Order: 138
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For How Weight Was Determined at fourth tagging interaction.
General Data Type: VARCHAR2

LATITUDE_4

CC ID: 26592
Seq. Order: 139
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 at fourth tagging interaction.
General Data Type: NUMBER

LONGITUDE_4

CC ID: 26623
Seq. Order: 140
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 at fourth tagging interaction.
General Data Type: NUMBER

STAT_ZONE_ID_4

CC ID: 26649
Seq. Order: 141
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Code to indciate State Zone at fourth tagging interaction
General Data Type: NUMBER

COUNTRY_ID_4

CC ID: 26659
Seq. Order: 142
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Country at fourth tagging interaction
General Data Type: VARCHAR2

STATE_ID_4

CC ID: 26647
Seq. Order: 143
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate state at fourth tagging interaction
General Data Type: VARCHAR2

WATER_BODY_ID_4

CC ID: 26564
Seq. Order: 144
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 at fourth tagging interaction
General Data Type: NUMBER

PLACE_ID_4

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

Code to indicate place of wheer tagging took place at fourth tagging interaction
General Data Type: VARCHAR2

GEAR_ID_4

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

Code for gear used to catch the animal at fourth tagging interaction.
General Data Type: VARCHAR2

BAIT_TYPE_4

CC ID: 26631
Seq. Order: 147
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 at fourth tagging interaction.
General Data Type: VARCHAR2

METHOD_ID_4

CC ID: 26654
Seq. Order: 148
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 at fourth tagging interaction
General Data Type: NUMBER

SAMPLE_ID_4

CC ID: 26539
Seq. Order: 149
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code to indicate Sampling Methodology at fourth tagging interaction
General Data Type: NUMBER

CAPTAIN_AGENCY_4

CC ID: 26614
Seq. Order: 150
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 at fourth tagging interaction.
General Data Type: VARCHAR2

CAPTAIN_ID_4

CC ID: 26663
Seq. Order: 151
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 at fourth tagging interaction.
General Data Type: NUMBER

TAGGER_INITIALS_4

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

Initials Of Taggers at fourth tagging interaction.
General Data Type: VARCHAR2

TAGGER_TYPE_4

CC ID: 26608
Seq. Order: 153
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates Type Of Tagger at fourth tagging interaction.
General Data Type: VARCHAR2

TAGGER_AFFILIATION_4

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

Code Of Agency that is affiliated With The Tagger at fourth tagging interaction.
General Data Type: VARCHAR2

VESSEL_AGENCY_4

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

Agency For Vessel Code at fourth tagging interaction.
General Data Type: VARCHAR2

VESSEL_ID_4

CC ID: 26594
Seq. Order: 156
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 at fourth tagging interaction.
General Data Type: NUMBER

PHYSICAL_DATA_ID_4

CC ID: 26602
Seq. Order: 157
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Physical Data Identification Number at fourth tagging interaction
General Data Type: NUMBER

NOTES_4

CC ID: 26628
Seq. Order: 158
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Any Other Notes On Tagging at fourth tagging interaction
General Data Type: NUMBER

FIGHT_HOURS_4

CC ID: 26563
Seq. Order: 159
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 at fourth tagging interaction
General Data Type: NUMBER

FIGHT_MINUTES_4

CC ID: 26690
Seq. Order: 160
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 at fourth tagging interaction
General Data Type: NUMBER

ANGLER_AGENCY_4

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

Agency That Has Angler Code list at fourth tagging interaction
General Data Type: VARCHAR2

ANGLER_ID_4

CC ID: 26638
Seq. Order: 162
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Angler Code at fourth tagging interaction .
General Data Type: NUMBER

DATE_ENTERED_4

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

The date the data was entered at fourth tagging interaction.
General Data Type: DATE

AGENCY_ID_5

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

Code to Indicate Tagging agency of identifying tag on animal (tag1) at fifth tagging interaction
General Data Type: VARCHAR2

TAG_ID_5

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

Tagnumber at fifth tagging interaction
General Data Type: VARCHAR2

EVENT_ID_5

CC ID: 26707
Seq. Order: 166
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Code to Indicate Tagging Event at fifth tagging interaction
General Data Type: NUMBER

TAG_DATE_5

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

Date animal was released or recaptured t fifth tagging interaction.
General Data Type: VARCHAR2

NEXT_TAG_AGENCY_5

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

Code For Agency That Issued the next tag (fifth tag) on this record at fifth tagging interaction
General Data Type: VARCHAR2

NEXT_TAG_ID_5

CC ID: 26572
Seq. Order: 169
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) at fifth tagging interaction
General Data Type: VARCHAR2

INTERACTION_ORDER_5

CC ID: 26694
Seq. Order: 170
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Number denoting the order of the interaction at fifth tagging interaction.
General Data Type: NUMBER

LENGTH_5

CC ID: 26701
Seq. Order: 171
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 at fifth tagging interaction.
General Data Type: NUMBER

LENGTH_UNIT_5

CC ID: 26605
Seq. Order: 172
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Length Measurement at fifth tagging interaction.
General Data Type: VARCHAR2

LENGTH_TYPE_5

CC ID: 26576
Seq. Order: 173
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code to determine The Type Of Length Measurement taken at fifth tagging interaction.
General Data Type: VARCHAR2

LENGTH_DETERMINATION_5

CC ID: 26661
Seq. Order: 174
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code To Indicate How Length Was determined at fifth tagging interaction
General Data Type: VARCHAR2

WEIGHT_5

CC ID: 26651
Seq. Order: 175
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 at fifth tagging interaction.
General Data Type: NUMBER

WEIGHT_UNIT_5

CC ID: 26655
Seq. Order: 176
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Units for Weight Measurement t fifth tagging interaction.
General Data Type: VARCHAR2

WEIGHT_TYPE_5

CC ID: 26590
Seq. Order: 177
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For Type Of Weight Measurement at fifth tagging interaction.
General Data Type: VARCHAR2

WEIGHT_DETERMINATION_5

CC ID: 26585
Seq. Order: 178
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code For How Weight Was Determined at fifth tagging interaction.
General Data Type: VARCHAR2

LATITUDE_5

CC ID: 26541
Seq. Order: 179
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 at fifth tagging interaction.
General Data Type: NUMBER

LONGITUDE_5

CC ID: 26534
Seq. Order: 180
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 at fifth tagging interaction.
General Data Type: NUMBER

STAT_ZONE_ID_5

CC ID: 26636
Seq. Order: 181
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Code to indciate State Zone at fifth tagging interaction
General Data Type: NUMBER

COUNTRY_ID_5

CC ID: 26616
Seq. Order: 182
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate Country at fifth tagging interaction
General Data Type: VARCHAR2

STATE_ID_5

CC ID: 26524
Seq. Order: 183
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Code to indicate state at fifth tagging interaction
General Data Type: VARCHAR2

WATER_BODY_ID_5

CC ID: 26691
Seq. Order: 184
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 at fifth tagging interaction
General Data Type: NUMBER

PLACE_ID_5

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

Code to indicate place of wheer tagging took place at fifth tagging interaction
General Data Type: VARCHAR2

GEAR_ID_5

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

Code for gear used to catch the animal at fifth tagging interaction.
General Data Type: VARCHAR2

BAIT_TYPE_5

CC ID: 26559
Seq. Order: 187
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 at fifth tagging interaction.
General Data Type: VARCHAR2

METHOD_ID_5

CC ID: 26666
Seq. Order: 188
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 at fifth tagging interaction
General Data Type: NUMBER

SAMPLE_ID_5

CC ID: 26531
Seq. Order: 189
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Code to indicate Sampling Methodology at fifth tagging interaction
General Data Type: NUMBER

CAPTAIN_AGENCY_5

CC ID: 26670
Seq. Order: 190
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 at fifth tagging interaction.
General Data Type: VARCHAR2

CAPTAIN_ID_5

CC ID: 26702
Seq. Order: 191
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 at fifth tagging interaction.
General Data Type: NUMBER

TAGGER_INITIALS_5

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

Initials Of Taggers at fifth tagging interaction.
General Data Type: VARCHAR2

TAGGER_TYPE_5

CC ID: 26677
Seq. Order: 193
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates Type Of Tagger at fifth tagging interaction.
General Data Type: VARCHAR2

TAGGER_AFFILIATION_5

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

Code Of Agency that is affiliated With The Tagger at fifth tagging interaction.
General Data Type: VARCHAR2

VESSEL_AGENCY_5

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

Agency For Vessel Code at fifth tagging interaction.
General Data Type: VARCHAR2

VESSEL_ID_5

CC ID: 26619
Seq. Order: 196
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 at fifth tagging interaction.
General Data Type: NUMBER

PHYSICAL_DATA_ID_5

CC ID: 26573
Seq. Order: 197
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Physical Data Identification Number at fifth tagging interaction
General Data Type: NUMBER

NOTES_5

CC ID: 26543
Seq. Order: 198
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Any Other Notes On Tagging at fifth tagging interaction
General Data Type: NUMBER

FIGHT_HOURS_5

CC ID: 26711
Seq. Order: 199
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 at fifth tagging interaction
General Data Type: NUMBER

FIGHT_MINUTES_5

CC ID: 26569
Seq. Order: 200
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 at fifth tagging interaction
General Data Type: NUMBER

ANGLER_AGENCY_5

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

Agency That Has Angler Code list at fifth tagging interaction
General Data Type: VARCHAR2

ANGLER_ID_5

CC ID: 26570
Seq. Order: 202
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Angler Code at fifth tagging interaction .
General Data Type: NUMBER

DATE_ENTERED_5

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

The date the data was entered at fifth tagging interaction.
General Data Type: DATE

Catalog Details

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