Slide Menu
Jump to Section...
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 

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